Download Php crud operations using pdo database connection and more Study notes Computer science in PDF only on Docsity!
Setting Up PDO for CRUD Operations in PHP
Below is a detailed step by step guide to creating a PHP CRUD (Create, Read, Update, Delete) application using PDO (PHP Data Objects). I will make the example comprehensive, with clear explanations, code snippets, and suggestions.
- Introduction
CRUD operations are the four basic functions that define the manipulation of data in a database.
Create (Insert)Read (Select)UpdateDelete
In this guide, we will build a simple PHP application that performs these operations on a users table in a database. We will use PDO to connect to the database and execute queries securely.
- Create Database and Table
Before starting with PHP, ensure you have a MySQL database and a table set up for storing data. Here is a simple SQL script to create a database and a users table.
Create the database CREATE DATABASE IF NOT EXISTS crud example; Switch to the new database USE crud example; Create the users table CREATE TABLE IF NOT EXISTS users ( id INT(11) AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100) NOT NULL, email VARCHAR(100) NOT NULL UNIQUE, age INT(3) NOT NULL );
- Connecting to the Database Using PDO
In the PHP script, we need to establish a PDO connection to the database.
php // Database configuration $host = "localhost"; $dbname = "crud_example"; $username = "root"; // Your database username
// Execute the statement $stmt->execute(); echo "User added successfully!"; } catch (PDOException $e) { echo "Error: ". $e->getMessage(); } } ?>
- Reading (Select) Operation
To display all users from the users table, we will use the SELECT query.
query($sql); if ($stmt->rowCount() > 0) { echo "
ID Name Email Age Action "; while ($row = $stmt- >fetch(PDO::FETCH_ASSOC)) { echo " ". $row['id']. " ". $row['name']. " ". $row['email']. " ". $row['age']. " Edit Delete "; } echo ""; } else { echo "No records found!"; } } catch (PDOException $e) { echo "Error: ". $e->getMessage(); } ?>
id = :id"; $updateStmt = $pdo- >prepare($updateSql); $updateStmt->bindParam(':name', $name); $updateStmt->bindParam(':email', $email); $updateStmt->bindParam(':age', $age); $updateStmt->bindParam(':id', $id); $updateStmt->execute(); echo "User updated successfully!"; } } ?>
- Deleting (Delete) Operation
The delete operation will simply remove the user record from the database.
prepare($sql); $stmt->bindParam(':id', $id); $stmt->execute(); echo "User deleted successfully!"; } catch (PDOException $e) { echo "Error: ". $e->getMessage(); } } ?>
- Final Application Structure
You can now combine all these parts into a fully functional PHP CRUD application with the following structure.
index.php Display the list of users and offer links for updating or deleting.
security.
