1、链接数据库
<?php $dsn = "mysql:host=$db_server;port=$db_port;dbname=$db_name"; try { $conn = new PDO($dsn, $db_user, $db_password); $conn->query("set names utf8"); } catch (PDOException $ex) {
2,查询数据
//同时包含数字键和字符串键的数组,这是默认格式 $res->fetch(PDO::FETCH_BOTH); //有数字键的数组 $row = $res->fetch(PDO::FETCH_NUM); //有字符串键(列名)的数组 $row =$res->fetch(PDO::FETCH_ASSOC); //stdClass类的对象,列名作为属性名 $row = $res->fetch(PDO::FETCH_OBJ); //PDORow类的对象,列名作为属性名。属性在访问前不会填充 $row = $res->fetch(PDO::FETCH_LAZY);
3,修改数据
$inser_res = $mysql->exec("INSERT INTO user(name,age) VALUE ('foo',13)"); $update_res = $mysql->exec("UPDATE user SET age=18 WHERE name='foo'"); $delete_res = $mysql->exec("DELETE FROM user WHERE age=18");