abstract：<?php$type = 'mysql';$host = '127.0.0.1';$dbname = 'testdb';$charset = 'utf8';$port = 3306;$user = 'root';$pass = 'root';$dsn = $type.':host='

<?php

$type = 'mysql';

$host = '127.0.0.1';

$dbname = 'testdb';

$charset = 'utf8';

$port = 3306;

$user = 'root';

$pass = 'root';

$dsn = $type.':host='.$host.';dbname='.$dbname.';$charset='.$charset;

try{

$pdo = new PDO($dsn,$user,$pass); //連接

echo '鏈接成功','<br/>';

//創(chuàng)建一個(gè)用戶 user001

$sql = "INSERT INTO xh_client_user (username,phone,pwd) VALUES (:username,:phone,:pwd)";

$stmt = $pdo -> prepare($sql);

$username = 'user001';

$phone = '13800138008';

$pwd = md5('1234567');

$stmt->bindParam(':username',$username,PDO::PARAM_STR,18);

$stmt->bindParam(':phone',$phone,PDO::PARAM_STR,11);

$stmt->bindParam(':pwd',$pwd,PDO::PARAM_STR,32);

if ($stmt->execute()) {

echo($stmt->rowcount()>0) ? '成功添加了'.$stmt->rowcount().'條記錄' : '沒有添加記錄', '<br/>';

} else {

echo print_r($stmt->errorinfo(),true), '<br/>';

}

//修改用戶 user001 的手機(jī)

$sql = "UPDATE xh_client_user SET phone = :phone WHERE username = :username";

$stmt = $pdo -> prepare($sql);

$username = 'user001';

$phone = '13800138019';

$stmt->bindParam(':phone',$phone,PDO::PARAM_STR,11);

$stmt->bindParam(':username',$username,PDO::PARAM_STR,18);

if ($stmt->execute()) {

echo($stmt->rowcount()>0) ? '成功更新了'.$stmt->rowcount().'條記錄' : '沒有更新記錄' , '<br/>';

} else {

echo print_r($stmt->errorinfo(),true);

}

//查詢用戶 user001 

$sql = "SELECT  * FROM  xh_client_user WHERE username = :username";

$stmt = $pdo -> prepare($sql);

$username = 'user001';

$stmt->bindParam(':username',$username,PDO::PARAM_STR,18);

if ($stmt->execute()) {

echo($stmt->rowcount()>0) ? '成功查詢了'.$stmt->rowcount().'條記錄，信息如下：' : '沒有查詢到記錄' , '<br/>';

$row = $stmt->fetch(PDO::FETCH_ASSOC);  

  print_r($row); 

  echo '<br/>';

} else {

echo print_r($stmt->errorinfo(),true);

}

  //刪除用戶 user001

  $sql = "DELETE FROM  xh_client_user WHERE username = :username";

$stmt = $pdo -> prepare($sql);

$username = 'user001';

$stmt->bindParam(':username',$username,PDO::PARAM_STR,18);

if ($stmt->execute()) {

echo($stmt->rowcount()>0) ? '成功刪除了'.$stmt->rowcount().'條記錄' : '沒有刪除記錄' , '<br/>';

} else {

echo print_r($stmt->errorinfo(),true);

}

$pdo = null; //斷開

echo '斷開mysql:',var_dump($pdo);

}catch(PDOException $e){

echo '鏈接失敗，原因：'. $e->getMessage();

}

Correcting teacher：查無此人Correction time：2019-02-27 09:07:49
Teacher's summary：完成的不錯(cuò)，代碼盡量整齊些，有點(diǎn)亂。繼續(xù)加油。