PDO抽象层处理数据库

来源：互联网发布：淘宝友邦电器城假货编辑：程序博客网时间：2024/05/24 06:50

<?php$dsn = 'mysql:host=127.0.0.1;port=3306;dbname=php';$username = 'root';$password = '123456';$driver_options = array(PDO::MYSQL_ATTR_INIT_COMMAND=> 'SET NAMES UTF8',);$pdo = new PDO($dsn, $username, $password, $driver_options);// var_dump($pdo);$sql = "show databases";$result = $pdo->query($sql);//PDOStatement// var_dump($result);// $list = $result->fetchAll();// $list = $result->fetchAll(PDO::FETCH_ASSOC);$list = $result->fetchAll(PDO::FETCH_NUM);echo '<pre>';var_dump($list);

<?php$dsn = 'mysql:host=127.0.0.1;port=3306;dbname=php';$username = 'root';$password = '123456';$driver_options = array(PDO::MYSQL_ATTR_INIT_COMMAND=> 'SET NAMES UTF8',);$pdo = new PDO($dsn, $username, $password, $driver_options);// $sql = "show database";// if (!$result = $pdo->query($sql)) {// var_dump($pdo->errorInfo());// echo '<br>';// var_dump($pdo->errorCode());// }// var_dump($result);// $sql = "insert into team values (null, '拜仁'), (NULL, '皇马')";$sql = "update team set t_name='拜仁' where t_id=9";if (false === $row_count = $pdo->exec($sql)) {//执行失败} else {echo $row_count;}// echo $pdo->lastInsertID();

<?php$dsn = 'mysql:host=127.0.0.1;port=3306;dbname=php';$username = 'root';$password = '123456';$driver_options = array(PDO::MYSQL_ATTR_INIT_COMMAND=> 'SET NAMES UTF8',);$pdo = new PDO($dsn, $username, $password, $driver_options);// $sql1 = "insert into team values (null, '国安')";// $sql2 = "insert into team values (null, '绿地')";// $sql3 = "insert into team values (null, '恒大')";// $sql4 = "insert into team values (null, '建业')";// $sql5 = "insert into team values (null, '鲁能')";// $sql6 = "insert into team values (null, '申花')";//预编译// $sql = "insert into team values (null, ?)";$sql = "insert into team values (null, :team_name)";$stmt = $pdo->prepare($sql);//绑定// $stmt->bindValue(1, '国安');// $stmt->bindValue(':team_name', '国安');// //zhixing// $result = $stmt->execute();// var_dump($result);$data_list = array(array('name'=>'国安'),array('name'=>'绿地'),array('name'=>'恒大'),array('name'=>'建业'),array('name'=>'鲁能'),array('name'=>'申花'),);foreach($data_list as $row) {//绑定// $stmt->bindValue(1, '国安');$stmt->bindValue(':team_name', $row['name']);//zhixing$result = $stmt->execute();var_dump($result);}

1 0