1 <?php 2 //PDO类的增删改查 3 try { 4 5 $pdo = new PDO("mysql:host=localhost;dbname=ooo","root","root"); 6 //print_r($pdo); 7 8 /*foreach ($pdo->query('select user_name,user_id,email from dsc_admin_user') as $v) { 9 print_r($v['user_name'].'~~~~~~~~~~~~~~~~~'.$v['email']); 10 echo "<br>"; 11 }*/ 12 13 /*$sql = "insert into dsc_admin_user (user_name,email) values ('sui','28456049@qq.com')";*/ 14 /*$user_name = "kkkkkk"; 15 $sql = "update dsc_admin_user set user_name = '$user_name' where user_id = '41'";*/ 16 $user_id = 41; 17 $sql = "delete from dsc_admin_user where user_id = '$user_id'"; 18 if($pdo->query($sql)){ 19 echo 'success'; 20 }else{ 21 echo 'shiba'; 22 } 23 24 25 } catch (PDOException $e) { 26 27 echo "error".$e->getMessage()."<br/>"; 28 die(); 29 30 } 31 32 33 34 35 36 37 38 39 40 ?>
