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 Users(
userID int PRIMARY KEY NOT NULL AUTO_INCREMENT,
userName varchar(50),
email varchar(50) NOT NULL UNIQUE,
age int CHECK(age > 0)
);
DESCRIBE Users;
INSERT INTO Users(userName, email, age) VALUES
('Alice', 'alice@yahoo.com', 20),
('Joseph', 'joseph@gmail.com', 23),
('Fred', 'freddy@gmail.com', 32),
('Walter', 'walter@hotmail.com', 35),
('Sarah', 'sarah@gmail.com', 21);
SELECT * FROM Users;
SELECT * FROM Users WHERE Users.email LIKE '%@gmail.com';
<?php
$query = "SELECT * FROM Users WHERE Users.email LIKE '%@gmail.com'";
$users = [];
$time = date("g");
$x = htmlspecialchars("<br>");
echo "$time, $x\n";
// Run query using mysqli
$result = $mysqli->query($query);
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
$userID = $row["userID"];
$username = $row["userName"];
$email = $row["email"];
$age = $row["age"];
echo "userID: $userID, username: $username, email: $email, age: $age\n";
array_push($users, $username);
}
} else {
echo "0 results";
}
?>
<?php
foreach ($users as $user) {
echo "$user\n";
}
?>