160331 

<!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
/*//定义数据源
$dsn = "mysql:dbname=tt;host=localhost";
//造PDO对象
$pdo = new PDO($dsn,"root","123");

//sql语句
$sql = "select * from info";

//准备执行sql语句
$ss = $pdo->prepare($sql);

//执行语句
if($ss->execute())
{
    //print_r($ss->fetch());    
    
    var_dump($ss->fetchColumn(1));
}
else
{
    echo "失败";
}*/

$pdo = new PDO("mysql:dbname=tt;host=localhost","root","123");

$sql = "insert into info value(?,?,?,?,?)";

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

/*//给sql语句分配变量
$sa->bindParam(1,$code);
$sa->bindParam(2,$name);
$sa->bindParam(3,$sex);
$sa->bindParam(4,$nation);
$sa->bindParam(5,$birthday);

//给变量赋值
$code = "p110";
$name = "啊";
$sex =true;
$nation = "n002";
$birthday ="1222-11-11";

//执行语句
$sa->execute();*/

//执行sql语句简便方法
$sa->execute(array("p111","按时","true","n002","1111-11-11"));






?>
</body>
</html>

 

posted @ 2016-03-31 22:01  呼哧呼哧  阅读(273)  评论(0)    收藏  举报