redis mysql 封装_使用redis的zset与mysql实现分页

{

private static$instance= NULL;

private$objMysql;

private$charset ="utf8";

private$username ="www.huchen.net";

private$password ="www. huchen.net"; private$port =3306;

private$database ='test';

private$host ='127.0.0.1';

private$table ='board';

private$sql;

/*** 构造方法 初始化mysql对象* JJWXCMysqlDemo constructor.* @param $config*/private function__construct($config)

{

if(!empty($config['host'])){

$this->host =$config['host'];

}

if(!empty($config['username'])){

$this->username =$config['username'];

}

if(!empty($config['password'])){

$this->password =$config['password'];

}

if(!empty($config['port'])){

$this->port =$config['port'];

}

if(!empty($config['charset'])){

$this->charset =$config['charset'];

}

if(!empty($config['database'])){

$this->database =$config['database'];

}

$this->objMysql = newmysqli($this->host,$this->username,$this->password,$this->database,$this->port);

if($this->objMysql->connect_error){

die("连接失败: ".mysqli_connect_error());

}

mysqli_set_charset($this->objMysql,"utf8");

}

/*** 单例模式* @param $config* @return JJWXCMysqlDemo|null*/public static functiongetInstance($config){

if(self::$instance== NULL){

self::$instance= new self($config);

}

return self::$instance;

}

/*** 添加数据* @param $data* @return bool|int|string 成功返回id*/public functionadd(array$data)

{

if(!is_array($data))

{

return false;

}

$fieldStr ='';

$valueStr ='';

foreach($dataas$key =>$value)

{

if(isset($value))

{

$fieldStr .="`".addslashes($key)."`,";

$valueStr .="'".addslashes($value)."',";

}

}

$fieldStr =rtrim($fieldStr,",");

$valueStr =rtrim($valueStr,",");

$this->sql ="INSERT INTO{$this->table} ({$fieldStr})VALUES({$valueStr})";

if($this->objMysql->query($this->sql))

{

returnmysqli_insert_id($this->objMysql);

}else{

returnmysqli_errno($this->objMysql);

}

}

/*** 更新数据* @param $data* @param $where //条件* @return bool|int 成功返回收影响行数*/public functionupdate($data,$where)

{

if(!is_array($data))

{

return false;

}

$field ="";

foreach($dataas$k=>$v){

$field .="`".addslashes($k)."`='".addslashes($v)."',";

}

$field =rtrim($field,",");

$this->sql ="UPDATE{$this->table} SET{$field}";

if(!empty($where))

{

$this->sql .=" WHERE ".$where;

}

if($this->objMysql->query($this->sql))

{

returnmysqli_affected_rows($this->objMysql);

}else{

returnmysqli_errno($this->objMysql);

}

}

/*** 删除数据* @param $where //条件* @return bool|int 成功返回收影响行数*/public functiondel($where)

{

if(empty($where))

{

return false;

}

$this->sql ="DELETE FROM{$this->table} WHERE".$where;

if($this->query())

{

returnmysqli_affected_rows($this->link);

}else{

returnmysqli_errno($this->objMysql);

}

}

}