PHPMySQL 中 pdo文件的增删改查

 <?php
 //PDO类的增删改查
 try {

     $pdo = new PDO("mysql:host=localhost;dbname=ooo","root","root");
     //print_r($pdo);

     /*foreach ($pdo->query('select user_name,user_id,email from dsc_admin_user') as $v) {
         print_r($v['user_name'].'~~~~~~~~~~~~~~~~~'.$v['email']);
         echo "<br>";
     }*/

     /*$sql = "insert into dsc_admin_user (user_name,email) values ('sui','[e-mail]')";*/
     /*$user_name = "kkkkkk";
     $sql = "update dsc_admin_user set user_name = '$user_name' where user_id = '41'";*/
     $user_id = 41;
     $sql = "delete from dsc_admin_user where user_id = '$user_id'";
     if($pdo->query($sql)){
         echo 'success';
     }else{
         echo 'shiba';
     }

 } catch (PDOException $e) {

     echo "error".$e->getMessage()."<br/>";
     die();

 }

 ?>