php【基础学习二十】PDO

来源：互联网发布：coc武神升级数据编辑：程序博客网时间：2024/04/30 16:50

具体参考：http://blog.csdn.net/leo115/article/details/7538983

明天再来自己写，先写个标题

PDO对象初始化PDO __construct( string dsn [, string username [, string password [, array driver_options]]] );         dsn数据库连接信息如“mysql:host=localhost;dbname=库名”driver_options：//配置选项

PDO对象成员方法1 ) query($sql);  //用于执行查询SQL语句。返回PDOStatement对象2 ) exec($sql);  //用于执行增、删、改操作，返回影响行数；3 ) setAttribute(); //设置一个"数据库连接对象"属性。         4 ) fetchAll();//解析数据

<?php//$mysqli = new mysqli("localhost","user","password","dbname");try{//1.$pdo = new PDO("mysql:host=localhost;dbname=hyerp","root","");//2.$pdo = new PDO("uri:mysqlPdo.ini","root","");//3.$pdo = new PDO("mysqlpdo","root","");$pdo = new PDO("mysqlpdo","root","");$pdo->setAttribute(PDO::ATTR_AUTOCOMMIT,0);}catch(PDOException $e){die("数据库连接失败".$e->getMessage());}echo $pdo->getAttribute(PDO::ATTR_AUTOCOMMIT );//print_r($pdo);

<?php//1.连接数据库try{$pdo = new PDO("mysql:host=localhost;dbname=jikexueyuan","root","");}catch(PDOException $e){die("数据库连接失败".$e->getMessage());}//2.执行query(查询)返回的是一个预处理对象$sql = "select * from stu";$stmt = $pdo->query($sql);$list = $stmt->fetchAll(PDO::FETCH_ASSOC);//3.解析数据（一次把所有的数据解析完）foreach($list as $val){echo $val['id']."-------".$val['name']."<br>";}//4.释放资源$stmt = null;$pdo = null;

<?php//1.连接数据库try{$pdo = new PDO("mysql:host=localhost;dbname=jikexueyuan","root","");}catch(PDOException $e){die("数据库连接失败".$e->getMessage());}//这是一种快捷的方法/* $sql = "select * from stu";foreach($pdo->query($sql) as $val){echo $val['id']."-----".$val['name']."<br>";} *///$sql = "insert into stu values(null,'oracle','w',44)";//$sql = "delete from stu where id=11";$sql = "update stu set name='js' where id=3";$res = $pdo->exec($sql);if($res){echo "success";}

0 0