Config.php

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "pdoexample";

try {
 $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
 $conn->exec("set names utf8");
}catch(PDOException $e){
    echo $e->getMessage();
}
?>


INSERT

<?php require_once("config.php");

 $str_name = "ทดสอบชื่อ1";
 $str_username = "username1";
 $str_password = md5("password1");

    $stmt = $conn->prepare("INSERT INTO users (u_name, u_username, u_password) VALUES (?, ?, ?)");
    $stmt->bindParam(1, $str_name);
    $stmt->bindParam(2, $str_username);
    $stmt->bindParam(3, $str_password);

if($stmt->execute()){
  $last_id = $conn->lastInsertId();
  echo "insert success last id : ".$last_id;
 }else{
  echo "insert fail !";
 }
?>



UPDATE


<?php require_once("config.php");

if(isset($_GET["id"])){

 $id = (int)$_GET["id"];
 $name = "testname2";
 $username = "testusername2";
 $password = "testpassword2";


 $stmt = $conn->prepare("UPDATE users SET u_name = ?, u_username = ?, u_password = ? WHERE u_id = ?");
 $stmt->bindParam(1, $name);
 $stmt->bindParam(2, $username);
 $stmt->bindParam(3, $password);
 $stmt->bindParam(4, $id);
 $result = $stmt->execute();

 if($result == true){
  echo "update success";
 }else{
  echo "update fail !";
 }

}else{
 echo "โปรดระบุไอดี";
}
?>



SELECT

<?php require_once("config.php");

if(isset($_GET["id"])){
   $id = (int)$_GET["id"];
   $stmt = $conn->prepare('SELECT u_id, u_name, u_username, u_password FROM users WHERE u_id = ?');
   $stmt->bindParam(1, $id);
   $stmt->execute();
   $result = $stmt->fetchAll();

    foreach ($result as $r){
     $id = $r['u_id'];
     $name = $r['u_name'];
     $username = $r['u_username'];
     $password = $r['u_password'];
   }
 echo $id,"<br>";
 echo $name."<br>";
 echo $username."<br>";
 echo $password."<br>";
}else{
 echo "โปรดระบุ id";
}

?>



DELETE


<?php require_once("config.php");

if(isset($_GET["id"])){

 $id = (int)$_GET["id"];
 $stmt = $conn->prepare("DELETE FROM users WHERE u_id= ?");
 $stmt->bindParam(1, $id);
 $result = $stmt->execute();

 if($result == true){
  echo "delete success";
 }else{
  echo "delete fail !";
 }

}else{
 echo "โปรดระบุไอดี";
}

?>