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
<?php
$db = "CREATE DATABASE Mydb";
if($db){
echo "DATABASE CREATED SUCCESSFULLY";
}
else{
echo "Failed to create a daatabase";
}
$createTableQuery = "CREATE TABLE IF NOT EXISTS students (
id INT AUTO_INCREMENT PRIMARY KEY,
stuID VARCHAR(10) UNIQUE NOT NULL,
name VARCHAR(100) NOT NULL
)";
if($createTableQuery){
echo "success";
}
$sql = "SELECT id, name, email FROM students";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
while ($row = mysqli_fetch_assoc($result)) {
echo "ID: " . $row["id"] . " - Name: " . $row["name"] . " - Email: " . $row["email"] . "<br>";
}
} else {
echo "No records found!";
}
?>