PDO执行SQL语句

来源：互联网发布：java除法取整编辑：程序博客网时间：2024/05/01 07:42

<!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>Pdo执行sql语句</title>
</head>

<body>

<?php
 header("content-type:text/html;charset:utf-8");
 $dbms='mysql';
 $dbName='msphp';
 $host='localhost';
 $user='root';
 $pwd='a3141592654';
 $dsn="$dbms:host=$host;dbname=$dbName"; //此处的host与dbname必须小写，否侧连接数据库失败(在执行SQL语句时)。

 try{
 $pdo=new PDO($dsn,$user,$pwd);
 echo "PDO连接数据库成功 ";


 //exec()方法，在执行delete，insert，update时影响行数，select不受影响。
 /*$sql=$pdo->exec("delete from tb_book where id=8");
 echo "删除成功，影响条数为：".$sql." ";*/
 //print_r($pdo->errorInfo());


 //query()方法
 /*$sql=$pdo->query("select * from tb_book");
 foreach($sql as $info)
 {
 echo $info[id]." ";
 echo $info[bookname]." ";
 echo $info[issuDate]." ";
 echo $info[price]." ";
 echo $info[maker]." ";
 echo $info[publisher]." ";
 }*/
 //print_r($pdo->errorInfo());

 //预处理语句prepare()方法和execute()方法
 $sql=$pdo->prepare("select * from tb_book");
 $sql->execute();
 //while($info=$sql->fetch(PDO::FETCH_ASSOC)) //可替换foreach
 foreach($sql as $info)
 {
 echo $info[id]." ";
 echo $info[bookname]." ";
 echo $info[issuDate]." ";
 echo $info[price]." ";
 echo $info[maker]." ";
 echo $info[publisher]." ";
 }
 //print_r($pdo->errorInfo());


 }
 catch(Exception $e){
 echo $e->getMessage()." ";
 }
?>
</body>
</html>

阅读全文

0 0