Questions tagged as 'mysqli'

Tagged questions
0
answers

Problem when executing a SQL query by PHP

I am trying to add data with insert into select to a table from php but it is not paying attention to me. When I do a echo $consulta ; Show me this: INSERT INTO orden_requisitos SELECT NIA, COUNT(*) AS Total FROM alumnos_formacion inner...
asked by 13.06.2018 / 20:46
0
answers

Do not insert any record in my Mysqli-Php database

Could someone please help me identify what could be wrong with my code ?, I followed the syntax to insert records with Mysqli but I could not solve my problem: This is my connection to the BD: I have it in a folder (lib) config.php <?php...
asked by 12.06.2018 / 00:52
1
answer

mysql Queries INNER JOIN Doubt

I have 3 tables 2 of them will show the main content of the web my query is not giving me the expected results since I just started to use inner join for performance reasons in the consultations and to facilitate more the code of course, in orde...
asked by 07.06.2018 / 05:45
0
answers

How to install myqsl_xdevapi for php in W10?

I have searched everywhere but the more I search the more confused and I do not understand how to install everything necessary to use the mysql xdevapi in PHP, can someone guide me? I am reading this manual link and the download link I do n...
asked by 17.06.2018 / 08:27
1
answer

Record date in mysql table

I have this code, in which I take a date and I want to save it in a table and give it to the Sgte. error, I do not realize where it may be Problems in the selection:    You have an error in your SQL syntax; check the manual that correspond...
asked by 07.06.2018 / 15:29
0
answers

Notice: Undefined index: ORDER in C: \ xampp \ htdocs \ Form-Office \ modify.php on line 11

I have days with this error and I really do not know how to solve it, if someone knows you can modify my code or I'll pass the complete project so you can see where I got everything <html> <head> <title>Modificar.php</titl...
asked by 07.06.2018 / 16:27
1
answer

How to call a Mysqli connection in different functions?

I am migrating my web from mysql to mysqli, before I had a file called db.php which had this connection to the database: db.php <?php $dbhost = "localhost"; // El host $dbuser = "root"; // El usuario $dbpass = ""; // El Pass $db = "web";...
asked by 07.06.2018 / 16:44
0
answers

Problem with array returned by sql query

Good I have a problem I was comparing in my DB two tables with this code: SELECT nombre FROM ( SELECT nombre FROM control UNION ALL SELECT nombre FROM becados ) t GROUP BY nombre HAVING COUNT(*) > 1 But when you call it in php, you get i...
asked by 03.06.2018 / 05:07
2
answers

make a count with two tables

ok I already know the topic of the while and all that I know how to get everything from a table, Now what I want is the following: I have two tables one " friends " another " main " in this case I do not want to print anything, the table friend...
asked by 03.06.2018 / 05:58
0
answers

Products with related categories

Dear I have a little problem soon it's something simple but I can not find the solution I hope one of you can save me. I need to show products that have father and daughters categories and that when clicking on the father category I also show...
asked by 31.05.2018 / 19:55