You can’t have two simultaneous queries because mysqli uses unbuffered queries by default (for prepared statements; it’s the opposite for vanilla mysql_query). You can either fetch the first one into an array and loop through that, or tell mysqli to buffer the queries (using $stmt->store_result()). See here for details.
The first thing to do would probably be to replace every mysql_* function call with its equivalent mysqli_*, at least if you are willing to use the procedural API — which would be the easier way, considering you already have some code based on the MySQL API, which is a procedural one. To help with … Read more
Never display connection errors manually! MySQLi will generate a warning if it is unable to open the connection to MySQL. This warning tells you all you need to know including the error code, error message, and the place in the code where it happened. Checking for the error manually will not give you any more … Read more
Please read the user notes for this method: http://php.net/manual/en/mysqli-stmt.get-result.php It requires the mysqlnd driver… If it isn’t installed on your webspace you will have to work with bind_result() & fetch()!
Well, you could argue with the object oriented aspect, the prepared statements, the fact that it becomes a standard, etc. But I know that most of the time, convincing somebody works better with a killer feature. So there it is: A really nice thing with PDO is you can fetch the data, injecting it automatically … Read more
Some time ago I managed to sort this matter out. As it was pointed out in the other answer, mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT); is a correct way to tell mysqli to throw exceptions. Just make sure you don’t wrap every query in a try-catch. This is a very common misconception that as soon as you started … Read more
The following are tried, tested and proven methods to check if a row exists. (Some of which I use myself, or have used in the past). Edit: I made an previous error in my syntax where I used mysqli_query() twice. Please consult the revision(s). I.e.: if (!mysqli_query($con,$query)) which should have simply read as if (!$query). … Read more
Does it have to die Quite contrary, it shouldn’t or die() ever. PHP is a language of bad heredity. Very bad heredity. And or die() with error message is one of the worst rudiments: die throws the error message out, revealing some system internals to the potential attacker such error message confuses casual users, because … Read more
No, you can’t use mysql and mysqli together. They are separate APIs and the resources they create are incompatible with one another. There is a mysqli_close, though.
TL;DR Always have mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT); in your mysqli connection code. It will let MySQL tell you what the actual problem is, be it with query, server, database or whatever. Always replace every PHP variable in the SQL query with a question mark, and execute the query using prepared statement. It will help to avoid … Read more