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)"); $query = "SELECT VERSION() as version;"; // Run query using mysqli $db1 = $mysqli->query($query); $version = $db1->fetch_object(); printf('DB version (mysqli): %s ' . PHP_EOL, $version->version); # 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 user 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; # Getting one row $id = 1; $sql = "SELECT * FROM user WHERE id=?"; $row = prepared_select($db, $sql, [$id])->fetch_assoc(); echo "{$row['id']}: {$row['username']}: {$row['email']}: {$row['isadmin']}: {$row['password']}: {$row['date_time']}\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($db, $sql, $params, $types)->get_result(); }