/*創建數據庫*/CREATE DATABASE IF NOT EXISTS `test`;/*選擇數據庫*/USE `test`;/*創建表*/CREATE TABLE IF NOT EXISTS `user` (  name varchar(50),  age int);/*插入測試數據*/INSERT INTO `user` (name, age) VALUES('harry', 20), ('tony', 23), ('harry', 24);

<?php$host = 'localhost';$database = 'test';$username = 'root';$password = 'root';$selectName = 'harry';//要查找的用戶名，一般是用戶輸入的信息$connection = mysql_connect($host, $username, $password);//連接到數據庫mysql_query("set names 'utf8'");//編碼轉化if (!$connection) {  die("could not connect to the database./n" . mysql_error());//診斷連接錯誤}$selectedDb = mysql_select_db($database);//選擇數據庫if (!$selectedDb) {  die("could not to the database/n" . mysql_error());}$selectName = mysql_real_escape_string($selectName);//防止SQL注入$query = "select * from user where name = '$selectName'";//構建查詢語句$result = mysql_query($query);//執行查詢if (!$result) {  die("could not to the database/n" . mysql_error());}while ($row = mysql_fetch_row($result)) {  //取出結果并顯示  $name = $row[0];  $age = $row[1];  echo "Name: $name ";  echo "Age: $age ";  echo "/n";}

<?php$host = 'localhost';$database = 'test';$username = 'root';$password = 'root';$selectName = 'harry';//要查找的用戶名，一般是用戶輸入的信息$pdo = new PDO("mysql:host=$host;dbname=$database", $username, $password);//創建一個pdo對象$pdo->exec("set names 'utf8'");$sql = "select * from user where name = ?";$stmt = $pdo->prepare($sql);$rs = $stmt->execute(array($selectName));if ($rs) {  // PDO::FETCH_ASSOC 關聯數組形式  // PDO::FETCH_NUM 數字索引數組形式  while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {    $name = $row['name'];    $age = $row['age'];    echo "Name: $name ";    echo "Age: $age ";    echo "/n";  }}$pdo = null;//關閉連接