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
$data = array(
array("name" => "John", "age" => 20),
array("name" => "Alice", "age"=> 35)
);
function parseData($username, $age) {
static $ctr = 0;
$sentence = "$username -> $age\n";
$ctr++;
echo "$ctr\n";
return ($sentence);
}
foreach ($data as $user) {
$username = $user["name"];
$age = $user["age"];
$sentence = parseData($username, $age);
echo $sentence;
}
setcookie("username", $data[0]["name"], time() + 60);
echo $_COOKIE["username"];
$client = $_SERVER["HTTP_USER_AGENT"];
echo "Client Browser: $client";
?>