Table of Contents
ToggleCRUD in php
Here’s an example of full PHP code using mysqli_query()
for different queries like SELECT, INSERT, UPDATE, and DELETE:
1. Connecting to the Database
<?php // Database connection $conn = mysqli_connect("localhost", "username", "password", "database_name"); if (!$conn) { die("Connection failed: " . mysqli_connect_error()); } ?>
2. SELECT Query
<?php $id = $_GET['id']; // Assuming ID is passed via GET request // SELECT query $query = "SELECT * FROM table_name WHERE id = $id"; $result = mysqli_query($conn, $query); if (mysqli_num_rows($result) > 0) { // Output data for each row while($row = mysqli_fetch_assoc($result)) { echo "Name: " . $row["name"] . " - Email: " . $row["email"] . "<br>"; } } else { echo "0 results"; } ?>
3. INSERT Query
<?php $name = "John Doe"; $email = "john@example.com"; // INSERT query $query = "INSERT INTO table_name (name, email) VALUES ('$name', '$email')"; if (mysqli_query($conn, $query)) { echo "New record created successfully"; } else { echo "Error: " . $query . "<br>" . mysqli_error($conn); } ?>
4. UPDATE Query
<?php $id = 1; // Example ID $name = "John Updated"; $email = "john_updated@example.com"; // UPDATE query $query = "UPDATE table_name SET name='$name', email='$email' WHERE id=$id"; if (mysqli_query($conn, $query)) { echo "Record updated successfully"; } else { echo "Error updating record: " . mysqli_error($conn); } ?>
5. DELETE Query
<?php $id = 1; // Example ID // DELETE query $query = "DELETE FROM table_name WHERE id=$id"; if (mysqli_query($conn, $query)) { echo "Record deleted successfully"; } else { echo "Error deleting record: " . mysqli_error($conn); } ?>
6. Closing the Database Connection
<?php // Close the connection mysqli_close($conn); ?>
Notes:
- This code directly uses
mysqli_query()
, but for security (e.g., preventing SQL injection), consider using prepared statements (mysqli_stmt_prepare()
). - Make sure to replace
"username"
,"password"
, and"database_name"
with your actual database credentials.