Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
CREATE TABLE new_messages (
id INT AUTO_INCREMENT,
message VARCHAR(100),
username VARCHAR(100),
PRIMARY KEY (id)
);
INSERT INTO new_messages (message, username) VALUES
('hi', 'Amad'),
('sup', 'Bashir'),
('stuff', 'Amad'),
('really', 'Bashir'),
('not really', 'Amad'),
('cool', 'Bashir'),
('see ya', 'Amad'),
('out', 'Bashir');
<?php
// $mysqli is already declared as a working database connection by this sandbox
$session = (object) [
'username' => 'Bashir'
];
$sql = <<<SQL
SELECT *
FROM new_messages
WHERE username=?
SQL;
var_export(
(fn($obj) => [
'total' => $obj->num_rows,
'data' => $obj->fetch_all(MYSQLI_ASSOC)
])($mysqli->execute_query($sql, [$session->username]))
);