PHP CRUD Operations with MySQL - Create, Read, Update, Delete

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: