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
// Assume $pdo is already defined and connected
// Step 1: Create the table
$createTableSQL = "CREATE TABLE IF NOT EXISTS users (
id INT AUTO_INCREMENT PRIMARY KEY,
firstname VARCHAR(50) NOT NULL,
lastname VARCHAR(50) NOT NULL,
email VARCHAR(100),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)";
try {
$pdo->exec($createTableSQL);
echo "Table created successfully.<br>";
} catch (PDOException $e) {
die("Table creation failed: " . $e->getMessage());
}
// Step 2: Insert data
$insertSQL = "INSERT INTO users (firstname, lastname, email) VALUES (:firstname, :lastname, :email)";
$stmt = $pdo->prepare($insertSQL);
$stmt->execute([
':firstname' => 'Jane',
':lastname' => 'Smith',
':email' => 'jane.smith@example.com'
]);
echo "User inserted successfully.";
?>