Questions tagged as 'mysqli'

Tagged questions
1
answer

capture variable in a mysql trigger

Good evening really thank you for your time, I tell you  I have an expense table with several fields like idgasto, vendor, client, total and one more detail_gasto that has fields idgasto, idproduct until everything is fine, but the application i...
asked by 05.07.2017 / 08:10
1
answer

Doubt with collation of mysql

I am putting together a part of the page where I will show brief "news" that will be loaded by the administrators of the page. I am using the MySQL database and I have some doubts about the "collation" and the possibility that I can save the com...
asked by 01.07.2017 / 00:42
2
answers

Problems with the UTF-8 encoding in mysql

I have problems with the character encoding with the ñ and tildes, the page is in utf-8 and the table and the DB in utf-8_general_ci but it happens as in the following image. Any solution? $ connection = new mysqli ($ host, $ userdb, $...
asked by 17.06.2017 / 21:24
3
answers

Access Denied mysql

This error appears: Warning: mysqli_connect () [function.mysqli-connect]: (28000/1045): Access denied for user 'root' @ 'localhost' (using password: YES) This is the code: ?php $server = "localhost"; $user = "root"; $pass = ""; $db =...
asked by 25.06.2017 / 00:09
1
answer

Why is this SQL statement giving NON-Object error in PHP?

I have the following table called Orders : Ordenes: id_orden = entero id_producto = entero Example of records: id_orden - id_producto 1 - 2 1 - 3 1 - 14 1 - 7 I would like to get all the id_producto...
asked by 23.05.2017 / 22:05
1
answer

Warning: mysqli_query () expects parameter 1 to be mysqli, null given in /home1/j8f5w8o7/nepe.smeext-carding.com/pieces/inc.php on line 26

I have 2 problems that appear at the beginning of my site, and they are the following: Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home1/j8f5w8o7/nepe.smeext-carding.com/pieces/inc.php on line 26 Warning: mysqli_...
asked by 30.05.2017 / 08:57
2
answers

Search records in a database using PHP and MySql

For a school project I was asked to make a page where I can search for specific records in a database inside a hosting, it turns out that when trying to make the query I always throw this error: Warning: mysqli_fetch_array() expects parameter...
asked by 30.05.2017 / 14:29
2
answers

how to build two queries to the same table in one

I have this table with these two queries but I can not find a way to show the two queries in one The final result should look like this:     
asked by 27.05.2017 / 02:05
1
answer

Connection to database works, but I can not enter [closed]

I have the following problem with my system:    Connects to the database, but does not enter the system. the user query returns the wrong user despite showing the same   results that the database. Conexion.php <?php $file = 'co...
asked by 21.04.2017 / 14:08
1
answer

Error in PHP when starting session

Good morning, I'm doing a login and I've been researching and improving it since the previous one I had was not very effective to say. Code: <?php //Conectamos a la base de datos require('/conexion.php'); //Obtenemos los datos d...
asked by 25.04.2017 / 15:35