<?php
$dsn = 'mysql:dbname=test;host=127.0.0.1';
try{
$dbh= new PDO($dsn, 'root', '123456');
} catch(PDOException $e){
echo "数据库连接失败:".$e->getMessage();
}
$dbh->exec( "set names gbk");
$count = $dbh->exec( "INSERT INTO student(name,age,major) values('张三',23,'工业设计')");
echo "插入".$count. "行记录";
$db = null;
?>
$dsn = 'mysql:dbname=test;host=127.0.0.1';
try{
$dbh= new PDO($dsn, 'root', '123456');
} catch(PDOException $e){
echo "数据库连接失败:".$e->getMessage();
}
$dbh->exec( "set names gbk");
$count = $dbh->exec( "INSERT INTO student(name,age,major) values('张三',23,'工业设计')");
echo "插入".$count. "行记录";
$db = null;
?>
测试用的表
<?php
$dsn = 'mysql:dbname=test;host=127.0.0.1';
try{
$dbh= new PDO($dsn, 'root', '123456');
} catch(PDOException $e){
echo "数据库连接失败:".$e->getMessage();
}
$dbh->exec( "set names gbk");
$rs=$dbh->query( "SELECT * FROM student");
while($row=$rs->fetch(PDO::FETCH_ASSOC)){
print_r($row);
}
$db = null;
?>
$dsn = 'mysql:dbname=test;host=127.0.0.1';
try{
$dbh= new PDO($dsn, 'root', '123456');
} catch(PDOException $e){
echo "数据库连接失败:".$e->getMessage();
}
$dbh->exec( "set names gbk");
$rs=$dbh->query( "SELECT * FROM student");
while($row=$rs->fetch(PDO::FETCH_ASSOC)){
print_r($row);
}
$db = null;
?>
本文转自 xcf007 51CTO博客,原文链接:http://blog.51cto.com/xcf007/111399,如需转载请自行联系原作者