contoh pdo

<?php
//contoh simple pdo
$server='localhost';
$user='gunawan';
$password='ya4i8ib2';
$dbname='gun_learning';

$dsn = 'mysql:dbname='.$dbname.';host='.$server;
//default data
$return=[
    'raw'=>NULL,
    'draw'=>0,
    'recordsTotal'=>0,
    'recordsFiltered'=>0,
    'data'=>[]
];


try {
    $dbh = new PDO($dsn, $user, $password);
    $dbh->setAttribute(PDO::ATTR_EMULATE_PREPARES,false);
    //harus dimasukkan
    $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
    //harus dimasukkan untuk keluar error

    //total semua
    $sql="select count(*) c  from `gun_products`";
    $raw[]=$sql;
    $stmt = $dbh->prepare($sql);
    if (!$stmt) {
        $raw[]=$dbh->errorInfo();
    }else{
        $stmt->execute();
        $row = $stmt->fetch(PDO::FETCH_ASSOC);
        $return['recordsTotal']=$row['c'];
    }


    $sql="select nama,nama_ori,price,category,quantity,'tombol' btn
    from `gun_products`
    limit ?,?";
    $stmt2 = $dbh->prepare($sql);
    if (!$stmt2) {
        echo "\nPDO::errorInfo():\n<pre>";
        print_r($dbh->errorInfo());
        echo "</pre>";
    }else{
        $stmt2->bindValue(1, $_POST['start']??0);
        $stmt2->bindValue(2, $_POST['length']??10);

        $stmt2->execute();
        $data=[];
        while ($row = $stmt2->fetch(PDO::FETCH_ASSOC)) {
           $row2=[];
           foreach($row as $vals)
           {
               $row2[]=$vals;
           }
           $data[]=$row2;
        }
        $return['data']=$data;
        //echo "</ol>";

    }

} catch (PDOException $e) {
    echo 'Connection failed: ' . $e->getMessage();
}

$return['raw']=$raw;

echo json_encode($return);