PHP mysqli query foreach

Question

this little script will not update the database after update from mysql to MySQLi.

include $dirlib . 'dbo.php';
if(!empty($_GET['list_vid'])) {
foreach ($_GET['list_vid'] as $position => $item) {
        $query  = mysqli_query($sql[] = "UPDATE $dbmov SET sort = '$position' WHERE id = $item");
        $result = mysqli_query($GLOBALS["___mysqli_ston"], $query);

err('sorting videos'));

what's this? `$dbmov` – Danyal Sandeelo May 27 '19 at 10:20 — Danyal Sandeelo, May 27 '19 at 10:20
and what's the value of `$_GET['list_vid']`? – Danyal Sandeelo May 27 '19 at 10:21 — Danyal Sandeelo, May 27 '19 at 10:21

score 1 · Accepted Answer · answered May 27 '19 at 10:21

Run a prepared statement instead, that you can execute multiple times over. Its simpler, and safer.

Your current issue is that you were executing an array the first time around, and an object the second time around - doesn't quite work like that.

$query = "UPDATE $dbmov SET sort = ? WHERE id = ?";
$stmt = $GLOBALS["___mysqli_ston"]->prepare($query);
$stmt->bind_param("ss", $position, $item);
foreach ($_GET['list_vid'] as $position => $item) {
    $stmt->execute();
}  
$stmt->close();

PHP mysqli query foreach

1 Answers1