Questions tagged as 'mysql'

Tagged questions
1
answer

Create json array from php + mysql

I have the following code, but it does not show it to me as a json array, how can I modify it so that it is an array type array= [{"nombre":"jesus"}] etc etc. $result = mysqli_query($connect, "SELECT * FROM 'transacciones' WHERE 'Userc...
asked by 25.08.2017 / 00:27
1
answer

How to create a Trigger in mysql with WHERE

I have a problem, it turns out that I am learning to create Trigger in mysql but I can not find the way I need it. I have this table, which is filled with records every day with more frequency in the mornings. I need to create a Trig...
asked by 16.08.2017 / 15:46
1
answer

Optimize Mysql Database?

I have a TABLE called "Data" which I filled with information brought from a CSV file (Generated from a third-party system). the database has multiple columns with Codes that are not numeric. This is just a small example Table Data Easil...
asked by 24.08.2017 / 04:33
1
answer

insert values in a table with a select

How do I insert values in the database? This is a query, it relates several tables, but I need that data to be stored in the MySQL database This is the table I'm doing in PHP echo '<table id="TablaColor" border="1" width="100%">...
asked by 11.08.2017 / 19:43
1
answer

How to save the data of a Multiple SELECT in a single field of my Database?

I have a multiple select and when I save the data in my database it does it separately, and I want it to save the selected data in a single field. How can I do it?    <select multiple="multiple" size="7" name="dias[]"> <option v...
asked by 08.08.2017 / 22:56
1
answer

How to call names in php from a database?

Good afternoon friends I have this code in HTML (it's just part of the whole code) and even with a database, I would like to know how to say "Monica", "uzziel", "Andres" could bring the names that I have registered in my database. A if I have...
asked by 07.08.2017 / 23:53
1
answer

ajax.reload () DOES NOT work

I am working on a project for the institute but I can not make it through ajax the DataTable is reloaded after inserting the record in the DB and in the console this error is generated: Uncaught TypeError: Cannot read property 'ajax' of undefi...
asked by 22.09.2017 / 01:15
2
answers

Problem with ORDER BY [ASC | DESC]

Good afternoon, I have a problem with the ORDER BY that I can not understand why it does not work, and it's probably stupid, but I can not find the stupidity. I have this query: SELECT * FROM webla_solicitudinfo ORDER BY 'IDSolicitud' AS...
asked by 21.09.2017 / 15:49
2
answers

How to use AJAX in a form?

Good afternoon, I think the title is badly expressed, I'll edit it when I think of a more precise question. Basically I explain my problem: I have a web page with an information request form. The action of the form is redirected to...
asked by 21.09.2017 / 17:52
1
answer

PHP can not read variable sent from a POST

I'm doing POST from angular to a file in PHP but the data that is sent is not being recognized in the file PHP , I have already tried several ways but I still can not read the parameter "op" in file PHP . The...
asked by 26.07.2017 / 17:29