Questions tagged as 'mysqli'

Tagged questions
1
answer

Display records in a select based on the id of another select

I have a system to sanction administrative personnel. I recently solved the problem that changing a select called article would change the description in a textarea. Now I have the following question: I added to the system the possibi...
asked by 31.01.2017 / 22:06
2
answers

doubt queries mysqli vs poo queries prepared

I have been working with the mysqli driver for several months but a question has arisen more than a question is a doubt, I would like to obtain opinions from experts on this topic. The thing is that whenever I consult the bd either to insert o...
asked by 24.08.2018 / 15:48
2
answers

Problem when deleting with php in a mysqli database

I am making a form in which you can already save perfectly in the mysqli database, and I already get the data in an html. Now what I want is to erase with a button. The thing is that it deletes, but always the last record, and not which one...
asked by 25.10.2016 / 23:49
1
answer

Error in showing index of series of videos from the database?

   I have an error in displaying the results correctly Errors, the problem I'm presenting I get the id_series of the serial table and using the id related, it shows me the data from the chapters table until it is perfect....
asked by 07.09.2017 / 17:54
1
answer

Doubts about an update using prepared statements

$username=$_POST["username"]; $email=$_POST["email"]; $sex=$_POST["sex"]; $description=$_POST["description"]; $infoVisivility=$_POST["infoVisivility"]; The thing is that I collect the above data from a form for the user to...
asked by 28.08.2018 / 05:18
2
answers

Where to use $ stmt-close () & $ stmt-free_result () - MySQLi PHP?

When there is more than one query in the same file shows errors, I solve everything by $stmt->close(); I have the doubt of what is the correct way to use it, how many close() should be used. The $stmt->free_result()...
asked by 21.10.2017 / 06:35
3
answers

How can I know how many times a data is repeated in an sql query?

Good afternoon I want to know how to get the number of times that a type of data is repeated and take it to a table with php at the moment I have the following code but I do not know how to extract the number of times that a data is repeated in...
asked by 23.09.2016 / 22:35
2
answers

INNER JOIN 1 primary field to several foreign fields in the same table

I request your help to improve an SQL query. There are times when I have a table I want to relate several foreign fields to a primary field of another table, but the problem is that there is more than 1 field with a foreign key. Something...
asked by 12.10.2018 / 21:12
2
answers

Problem when updating records in the database

The code returns the values that are registered in the database, but at the time of modifying the data and pressing the save button, the changes are not executed. RecordDelegations.php <? $conect = new mysqli("localhost", "mpadioce_ho...
asked by 06.09.2018 / 10:27
1
answer

Apply a WHERE to my SQL statement in a selective and total SUM

guys I have the following conflict: I have the following SQL statement SELECT SUM(monto) AS 'total', SUM(CASE WHEN status_pago = 'PENDIENTE' THEN 1 ELSE 0 END) AS 'pendiente', SUM(CASE WHEN status_pago = 'APROBADO' THEN 1 ELSE 0 E...
asked by 10.10.2018 / 04:43