johnworf wrote:What does that mean in english please?
But it is English 😃
What you are doing now is running SQL statements in a loop. This means that without a query cache, the same SQL statement would have to be re-compiled and then executed. It would be better if it could be compiled once, and then executed multiple times with different values substituted.
For example, using the PDO extension, and assuming $dbh is our PDO object (i.e., database handle object), we might write:
$stmt = $dbh->prepare("UPDATE $tbl_name SET Name=:Name, Email=:Email,
Restaurant=:Restaurant, Website=:Website, Description=:Description,
URL=:URL, Verify=:Verify, StateID=:StateID WHERE ID=:ID");
for ($i = 0; $i < $count; ++$i) {
$stmt->bindValue(':Name', $Name[$i], PDO::PARAM_STR);
$stmt->bindValue(':Email', $Email[$i], PDO::PARAM_STR);
$stmt->bindValue(':Restaurant', $Restaurant[$i], PDO::PARAM_STR);
$stmt->bindValue(':Website', $Website[$i], PDO::PARAM_STR);
$stmt->bindValue(':Description', $Description[$i], PDO::PARAM_STR);
$stmt->bindValue(':URL', $URL[$i], PDO::PARAM_STR);
$stmt->bindValue(':Verify', $Verify[$i], PDO::PARAM_STR);
$stmt->bindValue(':StateID', $StateID[$i], PDO::PARAM_INT);
$stmt->bindValue(':ID', $ID[$i], PDO::PARAM_INT);
$stmt->execute();
}
