PHPize Online / SQLize Online  /  SQLtest Online

<?php $db = $mysqli; //#Create a table $db->query("CREATE temporary TABLE user (id int auto_increment primary key, username varchar(50), email varchar(50), password varchar(255), token varchar(255), isadmin enum('0','1'), date_time date)"); # populate it with sample data $sql = "INSERT INTO user (username) VALUES (?)"; $stmt = prepared_query($db, $sql, ['scletter']); echo "Affected rows: $stmt->affected_rows\n"; echo "Last insert id: $db->insert_id\n"; # Getting one row $id = 1; $sql = "SELECT * FROM tmp_mysqli_helper_test WHERE id=?"; $row = prepared_select($db, $sql, [$id])->fetch_assoc(); echo "{$row['id']}: {$row['username']}\n"; //# Update Email //$id = 1; //$email = 'steven.w.letter@gmail'; //$sql = "UPDATE user SET email=? WHERE id=?"; //$affected_rows = prepared_query($db, $sql, [$email, $id])->affected_rows; //echo "Affected rows: $affected_rows\n"; //# Update admin //$id = 1; //$isadmin = 1; //$sql = "UPDATE user SET isadmin=? WHERE id=?"; //$affected_rows = prepared_query($db, $sql, [$isadmin, $id])->affected_rows; //echo "Affected rows: $affected_rows\n"; function prepared_query($db, $sql, $params, $types = "") { $types = $types ?: str_repeat("s", count($params)); $stmt = $db->prepare($sql); $stmt->bind_param($types, ...$params); $stmt->execute(); return $stmt; } function prepared_select($db, $sql, $params = [], $types = "") { return prepared_query($mysqli, $sql, $params, $types)->get_result(); }