//数据库的连接配置
define("HOST","localhost");
define("USER","root");
define("PASS","");
define("DBNAME","lamp138");
//自定义一个单表信息操作类
class Model
{
public $link;
public $tableName;
public $pk = "id";
/**
* 构造方法实现数据库的链接,并初始化表名
*/
public function __construct($tableName)
{
$this->link = @mysqli_connect(HOST,USER,PASS,DBNAME) or die("数据库连接失败!");
mysqli_set_charset($this->link,"utf8");
$this->tableName = $tableName;
}
//获取所有信息的方法
public function findAll()
{
$sql = "select * from {$this->tableName}";
$result = mysqli_query($this->link,$sql);
//解析
$list = mysqli_fetch_all($result,MYSQLI_ASSOC);
mysqli_free_result($result);
return $list;
}
//获取指定的单条信息的方法
public function find($id)
{
$sql = "select * from {$this->tableName} where {$this->pk}={$id}";
$result = mysqli_query($this->link,$sql);
//解析
$list = mysqli_fetch_assoc($result);
mysqli_free_result($result);
return $list;
}
//执行删除
public function del($id)
{
$sql = "delete from {$this->tableName} where {$this->pk}={$id}";
mysqli_query($this->link,$sql);
//返回影响的行数。
return mysqli_affected_rows($this->link);
}
//析构方法,关闭数据库连接
public function __destruct()
{
if(!empty($this->link)){
mysqli_close($this->link);
}
}
}
阅读(355) | 评论(0) | 转发(0) |