Despite the code example in the docs, perhaps the better method would be something like this: if ($mysqli->multi_query(…)) { do { // fetch results if (!$mysqli->more_results()) { break; } if (!$mysqli->next_result()) { // report error break; } } while (true); }
Support for this was introduced in PHP 5.3. For versions before this, PDO and – god forbid – the mysql extension are the only options. To quote the manual: Unlike the mysql extension, mysqli does not provide a separate function for opening persistent connections. To open a persistent connection you must prepend p: to the … Read more
Your loop can be optimized by pulling the prepare and bind_param statements out of the loop. $value = null; $mysqli->autocommit(FALSE); $sql = “INSERT INTO temp (`fund_id`) VALUES (?)”; $stmt = $mysqli->prepare($sql); $stmt->bind_param(‘i’, $value); foreach ($pdata as $value) { $stmt->execute(); } $mysqli->commit(); You have turned off autocommit with your autocommit(FALSE) line and therefore don’t need to … Read more
The design of the mysql_query function is such that you’ve got to be careful to escape each and every bit of data you’re injecting into it, and if you miss even one your entire application can be destroyed by an automatic SQL vulnerability exploit tool. Both mysqli and PDO support placeholders which are required to … Read more
Found the problem. when I did this: echo strlen($hash) it printed 90, which is strange because there were definitely no spaces at the end when I printed out the success/failure message, and the field has a varchar length of 255 I added this line: $hash = substr( $hash, 0, 60 ); And now it works … Read more
It’s the same: $mysqli->query(“SET NAMES ‘utf8′”); From the manual: This is the preferred way to change the charset. Using mysqli::query() to execute SET NAMES .. is not recommended. $mysqli->set_charset(“utf8”); is just enough, let the mysqli db driver do the thing for you.
The MySQL extension is very slightly faster than MySQLi in most benchmarks I’ve seen reported. The difference is so slight, however, that this should probably not be your criterion for deciding between the two. Other factors dwarf the difference in performance between mysql and mysqli. Using mod_php or FastCGI, a bytecode cache like APC, or … Read more
After calling the execute() method on the Prepared Statement, the id of the insert row will be in the insert_id attribute. $pstm->execute(); $pstm->insert_id;
The variable $stmt is an object of the mysqli_stmt class. This class has a method called fetch() which returns a boolean (true/false). It is used only in conjunction with bind_result() $stmt = $conn->prepare(‘SELECT myCol, myOtherCol FROM myTable WHERE dt=?’); $stmt->bind_param(“s”, $date); $stmt->execute(); // The columns in SQL will be bound to the PHP variables $stmt->bind_result($variable1, … Read more
When you execute a statement through mysqli, the results are not actually in PHP until you fetch them — the results are held by the DB engine. So the mysqli_stmt object has no way to know how many results there are immediately after execution. Modify your code like so: $stmt->execute(); $stmt->store_result(); // pull results into … Read more