<?php
header("content-type:text/html;charset=utf8");
try{
$dsn = "mysql:host=127.0.0.1;port=3306;charset=utf8;dbname=pdo";
$pdo = new PDO($dsn,'root','root');
//查询
$sql = 'select * from wenzhang';
$res = $pdo->query($sql);
$data=$res->fetchAll(PDO::FETCH_ASSOC);
var_dump($data);
//添加
//$sql = "insert into wenzhang(id,title,zuozhe,content) values(9,'科幻','麦克','阿斯顿发送到发')";
//删除
//$sql='delete from wenzhang where id=6';
//修改
// $sql='update wenzhang set title="喜剧" where id=8';
// if($pdo->exec($sql)){
// echo 'ok';
// }else{
// echo 'no';
// }
} catch (PDOException $e) {
die ("Error!: " . $e->getMessage() . "<br/>");
}
?>
PHP:pdo连接数据库,pdo增删改查
最新推荐文章于 2024-06-27 15:08:50 发布