Myself Shri

PDO - Create Read Update Delete|

(CRUD)

DB Connect
PDO Insert
PDO Update
PDO Read

// DB Connect (db.php)

<?php
date_default_timezone_set('Asia/Kolkata');
$today = date("Y-m-d H:i:s");
$servername = "localhost";

$username = "root";
$password = "";
$dbname = "database";
try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    // set the PDO error mode to exception
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    }
catch(PDOException $e)
    {
    echo $sql . "<br>" . $e->getMessage();
    echo "connection failed"; exit;
    }

?>

// Insert

<?php
include 'db.php';
if(isset($_POST['register']))
{
    $sql = $conn->prepare("INSERT into users (`firstname`,`lastname`) VALUES(:fname,:lname)");
    $check=$sql->execute(array(':fname'=>$_POST['firstname'],':lname'=>$_POST['lastname']));

    if($check){echo "Successfully Inserted";}
}
?>

// Update

<?php
include 'db.php';
if(isset($_POST['register']))
{
    $sql = $conn->prepare("UPDATE `users` SET `firstname`=:fname,`lastname`=:lname WHERE `firstname`=:frname");
    $check=$sql->execute(array(':fname'=>$_POST['firstname'],':lname'=>$_POST['lastname'],':frname'=>$_POST['frname']));

    if($check){echo "Successfully Updated";}
}
?>

// Read (Fetching)

<?php
include('db.php');
//Multiple Row Fetching
$query = "SELECT * FROM users";
$exe = $conn->prepare($query);
$exe->execute();
$info = $exe->fetchAll(PDO::FETCH_ASSOC);
$array = array();

foreach($info as $info_data)
{
    $first_name = $info_data['first_name'];
}

//Single Row Fetching
$query = "SELECT * FROM users";
$exe = $conn->prepare($query);
$exe->execute();
$info = $exe->fetch(PDO::FETCH_ASSOC);
$array = array();
$first_name = $info['first_name'];
?>