php pdo链接mysql数据库

<?

$pdo = new PDO('mysql:host=localhost;port=3336;dbname=TD_OA', 'root', 'myoa888');    

//$pdo = new PDO('mysql:host=localhost;port=3336;dbname=TD_OA', 'root', 'myoa888','array(PDO::ATTR_PERSISTENT => true)'); //持久连接

 

$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);   //错误的话抛出异常

$pdo->exec('set names gb2312');

$query="select user_id,uid,user_name from user";

$rs = $pdo -> query($query);

while($row = $rs -> fetch()){

//echo $row["user_id"]."<br>";

//print_r($row);

}

 $num=$rs->rowCount();

 echo $num."<br>";//查询个数

$rs1 = $pdo -> query($query);

$row1=$rs1->fetchAll();

 foreach ($row1 as $rs)

    {

          $id = $rs['user_id'];

   // echo $id."<br>";

         }

  // echo "<pre>";

//print_r($row1);

// echo "</pre>";

 $num1=$rs1->rowCount();

 echo $num1."<br>";//查询个数

 

 $rs2 = $pdo->query("SELECT user_name FROM user where user_id='admin'");//查询唯一的最后一个的某一列

 $col = $rs2->fetchColumn();

 echo $col."<br>";

  $query="select * from company_sun where company='".$zfjg."' and leibie_id='".$i."' and leibie='".$leibie."'";

  //echo $query."<br>";

  $res = $pdo->prepare($query);

  //$res->exec();

  $res->execute();

  $num_rows=$res->rowCount();//取数

 

 //修改

 $query3="update user set user_name='系统管理员' where user_id='admin'";

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

 $stmt->execute();    

 echo $stmt->rowCount()."<br>";   //返回影响的行数

 $query4="update user set user_name='系统管理员' where user_id='admin'";

  $stmt4 = $pdo->exec($query4); // 返回影响的行数了

 echo $stmt4."<br>";    

 

/*删除*/  

$sql = "DELETE FROM `user` WHERE `user_id` LIKE 'kevin_'"; //kevin%    

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

$stmt->execute();    

echo $stmt->rowCount()."<br>";//删除同修改

//新增

$pdo -> exec("insert into db_demo(name,content) values('title','content')");

echo "插入成功！";

echo $pdo -> lastinsertid();

/*添加*/  

//$sql = "INSERT INTO `user` SET `login`=:login AND `password`=:password";  

$sql = "INSERT INTO `user` (`login` ,`password`)VALUES (:login, :password)";

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

  $stmt->execute(array(':login'=>'kevin2',':password'=>''));    

echo $pdo->lastinsertid();

//新增

$sql = "INSERT INTO lailu (ip,times) VALUES ('".$iipp."', '". date('Y-m-d H:i:s')."')";  

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

$stmt->execute();  

echo $pdo->lastinsertid();  

 

?>

PDO::query() 主要是用于有记录结果返回的操作，特别是SELECT操作

PDO::exec() 主要是针对没有结果集合返回的操作，如INSERT、UPDATE等操作

PDO::lastInsertId() 返回上次插入操作，主键列类型是自增的最后的自增ID

PDOStatement::fetch() 是用来获取一条记录

PDOStatement::fetchAll() 是获取所有记录集到一个中