封装:
<?php
class mysqlSql{//封装函数
public $db;
public function __construct($dbname){//构造函数
$this->db = new PDO("mysql:host=localhost;dbname=".$dbname,'root','root');//数据库连接
}
public function zengjia($table,$title,$body){//数据库增加
$time=time();//当前时间
$sql = "INSERT INTO ".$table .' (id,title,body,create_time)'." VALUES (null,'$title','$body',$time)";
$db = $this->db;
$row = $db->query($sql);
return $row;
}
public function shanchu($table,$id){//数据库删除
$sql = "DELETE FROM ".$table." WHERE id=".$id;
$db = $this->db;
$row = $db->exec($sql);
return $row;
}
public function gengxin($table,$title,$body,$id){//数据库更新
$time=time();//当前时间
$sql = "UPDATE ".$table." SET title='$title',body='$body',update_time=$time wher