Questions tagged as 'mysql'

Tagged questions
0
answers

Are there differences between a linux / windows environment to program php + mysql? [closed]

I have a program that is in PHP installed in LINUX and I have to add some new things. I did not do it and I want to mount it in a testing environment on windows. With Xampp I raised the Apache server and MySql (I had some problems connecting...
asked by 09.09.2018 / 18:51
1
answer

AJAX with IF ELSE in response

Good I am using an AJAX so that the clients register in the web and now I have added a query to him to know if this user already has been registered, step to detail how or I am doing: AJAX <script> $(function(){...
asked by 07.09.2018 / 10:12
1
answer

Problem when inserting data with ajax

My problem in itself is not inserting data, given that these are done successfully, the problem is that when you insert a data, it is repeated 2.3 or even 4 times in the database, another thing is that when entering the page and doing it for the...
asked by 10.09.2018 / 17:44
0
answers

How to perform JSON searches created with MySQL

I have to do a lot of searches in a SQL table, so it occurred to me to do 1 single selected query and save it in a JSON like this: SELECT json_object('id', Id, 'nombre', nombre) FROM etiquetas What I do not know, is how to search inside tha...
asked by 14.09.2018 / 03:08
1
answer

Mysql, Sum with a condition

I am trying to add a time according to a condition but I can not find the way I would appreciate your collaboration. At the moment I have the following query SELECT u.src, u.accountcode, COUNT(*) AS cantidad, SUM(u.disposit...
asked by 13.09.2018 / 21:12
1
answer

MySQL Root Password

Hello when trying to change the password of root I am told that it does not meet the requirements and when I try to verify what the requirements are, it tells me that I must reset the password which I can not because of the previous problem....
asked by 14.09.2018 / 01:15
2
answers

Update a record in a Mysql table from a POST variable?

I am trying to update a record in a MySQL table, by means of a script called " prueba_envio_1.php " which selects the value of the first row of the table with heading waiting when you press the call next button, when you get this information...
asked by 03.10.2018 / 19:41
1
answer

How to enter data from an SQL query in a form already done in PHP?

In my case I have a form and several functions, but I have not been able to transfer information from a sql query to already defined text fields, I want to be able to have the id, call its respective information in each text field when pressing...
asked by 12.09.2018 / 02:17
1
answer

Detect that a record to be deleted does not exist in the SQL table (MySQL)

Thanks for helping me a lot. I have a simple doubt. I made a form that deletes records from a table, it works correctly, but I can not get an error message saying that the record does not exist, it simply says that I delete it (When that reco...
asked by 04.10.2018 / 16:15
2
answers

Does not return the AJAX response

Good I have a registration form in which they fill in the data and through AJAX I insert the data in the database. Until then it worked perfectly and I returned a response in notification mode with TOAST. But when putting in the file that als...
asked by 04.10.2018 / 09:00