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 (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
email VARCHAR(255) NOT NULL
);
<?php
use Carbon\Carbon;
define('STDIN',fopen("php://stdin","r"));
// Display menu and get user choice
echo "Select an option:\n";
echo "1. Create\n";
echo "2. Read\n";
echo "3. Update\n";
echo "4. Delete\n";
echo "Enter your choice: ";
$choice = trim(fgets(STDIN));
switch ($choice) {
case 1:
createRecord();
break;
case 2:
readRecords();
break;
case 3:
updateRecord();
break;
case 4:
deleteRecord();
break;
default:
echo "Invalid choice.\n";
break;
}
function createRecord() {
echo "Enter name: ";
$name = trim(fgets(STDIN));
echo "Enter email: ";
$email = trim(fgets(STDIN));
$sql = "INSERT INTO users (name, email) VALUES ('$name', '$email')";
if ($mysqli->query($sql) === TRUE) {
echo "Record inserted successfully.\n";
} else {
echo "Error: " . $sql . "\n" . $mysqli->error;
}
}
function readRecords() {
$sql = "SELECT id, name, email FROM users";
$result = $mysqli->query($sql);
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
echo "ID: " . $row["id"] . ", Name: " . $row["name"] . ", Email: " . $row["email"] . "\n";
}
} else {
echo "No records found.\n";
}
}
function updateRecord() {
echo "Enter ID of record to update: ";
$id = trim(fgets(STDIN));
echo "Enter new name: ";
$name = trim(fgets(STDIN));
echo "Enter new email: ";
$email = trim(fgets(STDIN));
$sql = "UPDATE users SET name='$name', email='$email' WHERE id=$id";
if ($mysqli->query($sql) === TRUE) {
echo "Record updated successfully.\n";
} else {
echo "Error updating record: " . $mysqli->error;
}
}
function deleteRecord() {
echo "Enter ID of record to delete: ";
$id = trim(fgets(STDIN));
$sql = "DELETE FROM users WHERE id = $id";
if ($mysqli->query($sql) === TRUE) {
echo "Record deleted successfully.\n";
} else {
echo "Error deleting record: " . $mysqli->error;
}
}