PHP PDO CRUD Example: Example code to implement CRUD operations with PDO

Recommend this page to a friend!

Download .zip

Info

Example

View files (8)

Download .zip

Reputation

Support forum

Blog (1)

Links

Last Updated		Ratings				Unique User Downloads		Download Rankings
2024-01-28 (5 days ago)		Not yet rated by the users				Total: 89 This week: 89		All time: 9,911 This week: 1

Version		License		PHP version		Categories
`tutorial-php-pdo-cru` 1.0.0		The PHP License		5		PHP 5, Databases, Design Patterns, Gl...

Description

Author

Channaveer Hakari

This package provides examples of code to implement CRUD operations with PDO.

It provides a script that creates a PDO object to connect to a MySQL database using parameters retrieved from a configuration script.

Other scripts can use the PDO object to perform CRUD operations like:

- Create a new table record

- Retrieve all records of a table

- Retrieve a table record that matches a condition

- Update a table record that matches a condition with new field values

- Delete a table record that matches a condition

Channaveer Hakari

Performance

Level

Name:	Channaveer Hakari `<contact>`
Classes:	8 packages by Channaveer Hakari
Country:	India

Level 1

Innovation award

Nominee: 2x

Example


<?php

require_once './db.php';

try {

    $userQuery = $pdo->prepare("

        INSERT INTO `users`

            (`first_name`, `last_name`, `email`, `password`)

        VALUES

            (:first_name, :last_name, :email, :password)

    ");

    $user = $userQuery->execute([

        ':first_name'   => 'Channaveer',

        ':last_name'    => 'Hakari',

        ':email'        => 'someemail@gmail.com',

        /** For the sake of demonstration I am using MD5, using hash for more secure */

        ':password'     => md5('password')

    ]);



    if (!$user) {

        throw new Exception('Error in adding user details');

    }



    $lastInsertedIs = $pdo->lastInsertId();

} catch (Exception $e) {

    /** Handle all your errors here */

    exit($e->getMessage());

}

Details

PHP PDO CRUD Operations Demo

This is a plain PHP PDO CRUD demo. All the CRUD operations reside in (create.php, read*.php, update.php & delete.php files)

For more details on the same use this link https://stackcoder.in/posts/why-and-how-to-use-php-pdo-with-crud-examples

To read more articles on PHP / LARAVEL use this link https://stackcoder.in

Files

File	Role	Description
`create.php`	Example	Example script
`db.php`	Aux.	PDO database object creation script
`delete.php`	Example	Example script
`init.php`	Conf.	Configuration script
`README.md`	Doc.	Documentation
`read_all.php`	Example	Example script
`read_by_condition.php`	Example	Example script
`update.php`	Example	Example script