<?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;
?>
本文转自 xcf007 51CTO博客，原文链接：http://blog.51cto.com/xcf007/111399，如需转载请自行联系原作者
