<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
</head>
<body>
<?php
try{
$dsn = "mysql:dbname=mydb;host=localhost";
$pdo = new PDO($dsn,"root","123");
}
catch(PDOException $e)
{
echo "连接出错".$e->getMessage();
}
$sql = "select * from Info";
$stmt = $pdo->prepare($sql);
$stmt->execute();
while($row = $stmt->fetch())
{
print_r($row);
echo "<br>";
}
//PDO预处理
//写好SQL语句
$sql = "insert into Info values(?,?,?,?,?)";
//把SQL语句放在服务器上等待执行
$stmt = $pdo->prepare($sql);
//将SQL语句中的?绑定上参数
$stmt->bindParam(1,$code);
$stmt->bindParam(2,$name);
$stmt->bindParam(3,$sex);
$stmt->bindParam(4,$nation);
$stmt->bindParam(5,$birthday);
//给参数赋值
$code = "p11";
$name = "王五";
$sex = true;
$nation = "n001";
$birthday = "1989-2-3";
//执行
$stmt->execute();
//执行
$stmt -> execute(array("p111", '赵六', false, 'n002', '1989-3-4')); */
//$sql = "insert into Info values(:code, :name, :sex, :nation, :birthday)";
//$stmt = $pdo->prepare($sql);
$stmt->bindParam("code", $code, PDO::PARAM_STR);
$stmt->bindParam("name", $name, PDO::PARAM_STR);
$stmt->bindParam("sex", $sex, PDO::PARAM_STR);
$stmt->bindParam("nation", $nation, PDO::PARAM_STR);
$stmt->bindParam("birthday", $birthday, PDO::PARAM_STR);
$code = "p112";
$name = "王五";
$sex = true;
$nation = "n001";
$birthday = "1989-2-3";
$stmt->execute();*/
//$stmt->execute(array("code"=>"p020","name"=>"随便","sex"=>true,"nation"=>"n003","birthday"=>"1988-5-6"));
?>
</body>
</html>
