// Database connection details
$host = `localhost`;
$username = `your_username`;
$password = `your_password`;
$database = `your_database`;
// Create a connection to the database
$conn = new mysqli($host, $username, $password, $database);
// Check the connection
if ($conn->connect_error) {
die(`Connection failed: ` . $conn->connect_error);
}
// CREATE - Insert a new record
if (isset($_POST['create'])) {
$name = $_POST['name'];
$email = $_POST['email'];
$sql = `INSERT INTO users (name, email) VALUES ('$name', '$email')`;
if ($conn->query($sql) === TRUE) {
echo `New record created successfully!`;
} else {
echo `Error: ` . $sql . `
` . $conn->error;
}
}
// READ - Retrieve and display records
$result = $conn->query(`SELECT * FROM users`);
if ($result->num_rows > 0) {
echo `

Users

`;
echo `

`;
while ($row = $result->fetch_assoc()) {
echo `
• ` . $row['name'] . ` - ` . $row['email'] . `
`;
}
echo `

`;
} else {
echo `No users found.`;
}
// UPDATE - Update an existing record
if (isset($_POST['update'])) {
$id = $_POST['id'];
$newName = $_POST['newName'];
$newEmail = $_POST['newEmail'];
$sql = `UPDATE users SET name='$newName', email='$newEmail' WHERE id=$id`;
if ($conn->query($sql) === TRUE) {
echo `Record updated successfully!`;
} else {
echo `Error: ` . $sql . `
` . $conn->error;
}
}
// DELETE - Delete a record
if (isset($_POST['delete'])) {
$id = $_POST['id'];
$sql = `DELETE FROM users WHERE id=$id`;
if ($conn->query($sql) === TRUE) {
echo `Record deleted successfully!`;
} else {
echo `Error: ` . $sql . `
` . $conn->error;
}
}
// Close the database connection
$conn->close();
?>

Create a New User

Name:
Email:

Update User

User ID:
New Name:
New Email:

Delete User

User ID: