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;
$stmt = $mysqli->prepare($sql);
$stmt->execute([$session->username]);
$obj = $stmt->get_result();
$result = ['total' => $obj->num_rows];
foreach ($obj as $row) {
$result['data'][] = $row;
}
var_export($result);