PHPize Online / SQLize Online  /  SQLtest Online

<?php $db = $mysqli; // this service provides a predefined $mysqli variable while we are using $db for the connection #Create a temporary table $db->query("CREATE temporary TABLE tmp_mysqli_helper_test (id int auto_increment primary key, name varchar(9))"); # populate it with sample data $sql = "INSERT INTO tmp_mysqli_helper_test (name) VALUES (?),(?),(?)"; $db->execute_query($sql, ['Sam','Bob','Joe']); echo "Affected rows: $db->affected_rows\n"; echo "Last insert id: $db->insert_id\n"; # Getting rows in a loop $sql = "SELECT * FROM tmp_mysqli_helper_test WHERE id > ?"; $result = $db->execute_query($sql, [1]); while ($row = $result->fetch_assoc()) { echo "{$row['id']}: {$row['name']}\n"; } # Getting one row $id = 1; $sql = "SELECT * FROM tmp_mysqli_helper_test WHERE id=?"; $row = $db->execute_query($sql, [$id])->fetch_assoc(); echo "{$row['id']}: {$row['name']}\n"; # Update $id = 1; $new = 'Sue'; $sql = "UPDATE tmp_mysqli_helper_test SET name=? WHERE id=?"; $db->execute_query($sql, [$new, $id]); echo "Affected rows: $db->affected_rows\n"; # Getting array of rows $start = 0; $limit = 10; $sql = "SELECT * FROM tmp_mysqli_helper_test LIMIT ?,?"; $all = $db->execute_query($sql, [$start, $limit])->fetch_all(MYSQLI_ASSOC); foreach ($all as $row) { echo "{$row['id']}: {$row['name']}\n"; }