<?php
header('content-type:text/html;charset=utf-8');
//PDO操作MySQL
//1)连接认证
$pdo=new PDO("mysql:host=localhost;port=3306;dbname=test","root","root");
//2)执行写操作
//增加
$sql="insert into demo values(null,'PDO','2016-7-8')";
/*
if($pdo->exec($sql)){
echo '添加成功';
echo '上次的插入的自增ID是'.$pdo->lastInsertId();
}else{
echo '错误编码是'.$pdo->errorCode();
echo '错误信息是'.$pdo->errorInfo()[2];
}
*/
//3)读操作
$sql="select * from demo";
$st=$pdo->query($sql); //PDOStatement类的对象
//var_dump($st);
//设置返回数组的形式
//$st->setFetchMode(PDO::FETCH_ASSOC);
//$arr=$st->fetch();
//$arr=$st->fetchAll(PDO::FETCH_ASSOC);
$str=$st->fetchColumn(2);
$str=$st->fetchColumn(1);
echo $str;
header('content-type:text/html;charset=utf-8');
//PDO操作MySQL
//1)连接认证
$pdo=new PDO("mysql:host=localhost;port=3306;dbname=test","root","root");
//2)执行写操作
//增加
$sql="insert into demo values(null,'PDO','2016-7-8')";
/*
if($pdo->exec($sql)){
echo '添加成功';
echo '上次的插入的自增ID是'.$pdo->lastInsertId();
}else{
echo '错误编码是'.$pdo->errorCode();
echo '错误信息是'.$pdo->errorInfo()[2];
}
*/
//3)读操作
$sql="select * from demo";
$st=$pdo->query($sql); //PDOStatement类的对象
//var_dump($st);
//设置返回数组的形式
//$st->setFetchMode(PDO::FETCH_ASSOC);
//$arr=$st->fetch();
//$arr=$st->fetchAll(PDO::FETCH_ASSOC);
$str=$st->fetchColumn(2);
$str=$st->fetchColumn(1);
echo $str;