一个懒人专用文章归档神器，如果你不能成为压路机的一部分，那么你就只能成为道路的一部分 Bala~bala~

PHP数据库操作&分页类

php 懒人 1275℃ 0评论

MySQL数据库操作类第一种

<?php
class mysql {

private $db_host; //数据库主机
 private $db_user; //数据库登陆名
 private $db_pwd; //数据库登陆密码
 private $db_name; //数据库名
 private $db_charset; //数据库字符编码
 private $db_pconn; //长连接标识位
 private $debug; //调试开启
 private $conn; //数据库连接标识
 private $msg = ""; //数据库操纵信息

// private $sql = ""; //待执行的SQL语句

public function __construct($db_host, $db_user, $db_pwd, $db_name, $db_chaeset = 'utf8', $db_pconn = false, $debug = false) {
 $this->db_host = $db_host;
 $this->db_user = $db_user;
 $this->db_pwd = $db_pwd;
 $this->db_name = $db_name;
 $this->db_charset = $db_chaeset;
 $this->db_pconn = $db_pconn;
 $this->result = '';
 $this->debug = $debug;
 $this->initConnect();
 }

public function initConnect() {
 if ($this->db_pconn) {
 $this->conn = @mysql_pconnect($this->db_host, $this->db_user, $this->db_pwd);
 } else {
 $this->conn = @mysql_connect($this->db_host, $this->db_user, $this->db_pwd);
 }
 if ($this->conn) {
 $this->query("SET NAMES " . $this->db_charset);
 } else {
 $this->msg = "数据库连接出错，错误编号：" . mysql_errno() . "错误原因：" . mysql_error();
 }
 $this->selectDb($this->db_name);
 }

public function selectDb($dbname) {
 if ($dbname == "") {
 $this->db_name = $dbname;
 }
 if (!mysql_select_db($this->db_name, $this->conn)) {
 $this->msg = "数据库不可用";
 }
 }

public function query($sql, $debug = false) {
 if (!$debug) {
 $this->result = @mysql_query($sql, $this->conn);
 } else {

}
 if ($this->result == false) {
 $this->msg = "sql执行出错，错误编号：" . mysql_errno() . "错误原因：" . mysql_error();
 }
 // var_dump($this->result);
 }

public function select($tableName, $columnName = "*", $where = "") {
 $sql = "SELECT " . $columnName . " FROM " . $tableName;
 $sql .= $where ? " WHERE " . $where : null;
 $this->query($sql);
 }

public function findAll($tableName) {
 $sql = "SELECT * FROM $tableName";
 $this->query($sql);
 }

public function insert($tableName, $column = array()) {
 $columnName = "";
 $columnValue = "";
 foreach ($column as $key => $value) {
 $columnName .= $key . ",";
 $columnValue .= "'" . $value . "',";
 }
 $columnName = substr($columnName, 0, strlen($columnName) - 1);
 $columnValue = substr($columnValue, 0, strlen($columnValue) - 1);
 $sql = "INSERT INTO $tableName($columnName) VALUES($columnValue)";
 $this->query($sql);
 if($this->result){
 $this->msg = "数据插入成功。新插入的id为：" . mysql_insert_id($this->conn);
 }
 }

public function update($tableName, $column = array(), $where = "") {
 $updateValue = "";
 foreach ($column as $key => $value) {
 $updateValue .= $key . "='" . $value . "',";
 }
 $updateValue = substr($updateValue, 0, strlen($updateValue) - 1);
 $sql = "UPDATE $tableName SET $updateValue";
 $sql .= $where ? " WHERE $where" : null;
 $this->query($sql);
 if($this->result){
 $this->msg = "数据更新成功。受影响行数：" . mysql_affected_rows($this->conn);
 }
 }

public function delete($tableName, $where = ""){
 $sql = "DELETE FROM $tableName";
 $sql .= $where ? " WHERE $where" : null;
 $this->query($sql);
 if($this->result){
 $this->msg = "数据删除成功。受影响行数：" . mysql_affected_rows($this->conn);
 }
 }

public function fetchArray($result_type = MYSQL_BOTH){
 $resultArray = array();
 $i = 0;
 while($result = mysql_fetch_array($this->result, $result_type)){
 $resultArray[$i] = $result;
 $i++;
 }
 return $resultArray;
 }

// public function fetchObject(){
 // return mysql_fetch_object($this->result);
 // }

public function printMessage(){
 return $this->msg;
 }

public function freeResult(){
 @mysql_free_result($this->result);
 }

public function __destruct() {
 if(!empty($this->result)){
 $this->freeResult();
 }
 mysql_close($this->conn);
 }
 }
 ?>

MySQL数据库操作类第二种

<?php
class mysql {
 private $db_host; //数据库主机
 private $db_user; //数据库用户名
 private $db_pwd; //数据库用户名密码
 private $db_database; //数据库名
 private $conn; //数据库连接标识;
 private $result; //执行query命令的结果资源标识
 private $sql; //sql执行语句
 private $row; //返回的条目数
 private $coding; //数据库编码，GBK,UTF8,gb2312
 private $bulletin = true; //是否开启错误记录
 private $show_error = true; //测试阶段，显示所有错误,具有安全隐患,默认关闭
 private $is_error = false; //发现错误是否立即终止,默认true,建议不启用，因为当有问题时用户什么也看不到是很苦恼的

/*构造函数*/
 public function __construct($db_host, $db_user, $db_pwd, $db_database, $conn, $coding) {
 $this->db_host = $db_host;
 $this->db_user = $db_user;
 $this->db_pwd = $db_pwd;
 $this->db_database = $db_database;
 $this->conn = $conn;
 $this->coding = $coding;
 $this->connect();
 }

/*数据库连接*/
 public function connect() {
 if ($this->conn == "pconn") {
 //永久链接
 $this->conn = mysql_pconnect($this->db_host, $this->db_user, $this->db_pwd);
 } else {
 //即使链接
 $this->conn = mysql_connect($this->db_host, $this->db_user, $this->db_pwd);
 }

if (!mysql_select_db($this->db_database, $this->conn)) {
 if ($this->show_error) {
 $this->show_error("数据库不可用：", $this->db_database);
 }
 }
 mysql_query("SET NAMES $this->coding");
 }

/*数据库执行语句，可执行查询添加修改删除等任何sql语句*/
 public function query($sql) {
 if ($sql == "") {
 $this->show_error("SQL语句错误：", "SQL查询语句为空");
 }
 $this->sql = $sql;

$result = mysql_query($this->sql, $this->conn);

if (!$result) {
 //调试中使用，sql语句出错时会自动打印出来
 if ($this->show_error) {
 $this->show_error("错误SQL语句：", $this->sql);
 }
 } else {
 $this->result = $result;
 }
 return $this->result;
 }

/*创建添加新的数据库*/
 public function create_database($database_name) {
 $database = $database_name;
 $sqlDatabase = 'create database ' . $database;
 $this->query($sqlDatabase);
 }

/*查询服务器所有数据库*/
 //将系统数据库与用户数据库分开，更直观的显示？
 public function show_databases() {
 $this->query("show databases");
 echo "现有数据库：" . $amount = $this->db_num_rows($rs);
 echo "<br />";
 $i = 1;
 while ($row = $this->fetch_array($rs)) {
 echo "$i $row[Database]";
 echo "<br />";
 $i++;
 }
 }

//以数组形式返回主机中所有数据库名
 public function databases() {
 $rsPtr = mysql_list_dbs($this->conn);
 $i = 0;
 $cnt = mysql_num_rows($rsPtr);
 while ($i < $cnt) {
 $rs[] = mysql_db_name($rsPtr, $i);
 $i++;
 }
 return $rs;
 }

/*查询数据库下所有的表*/
 public function show_tables($database_name) {
 $this->query("show tables");
 echo "现有数据库：" . $amount = $this->db_num_rows($rs);
 echo "<br />";
 $i = 1;
 while ($row = $this->fetch_array($rs)) {
 $columnName = "Tables_in_" . $database_name;
 echo "$i $row[$columnName]";
 echo "<br />";
 $i++;
 }
 }

/*
 mysql_fetch_row() array $row[0],$row[1],$row[2]
 mysql_fetch_array() array $row[0] 或 $row[id]
 mysql_fetch_assoc() array 用$row->content 字段大小写敏感
 mysql_fetch_object() object 用$row[id],$row[content] 字段大小写敏感
 */

/*取得结果数据*/
 public function mysql_result_li() {
 return mysql_result($str);
 }

/*取得记录集,获取数组-索引和关联,使用$row['content'] */
 public function fetch_array() {
 return mysql_fetch_array($this->result);
 }

//获取关联数组,使用$row['字段名']
 public function fetch_assoc() {
 return mysql_fetch_assoc($this->result);
 }

//获取数字索引数组,使用$row[0],$row[1],$row[2]
 public function fetch_row() {
 return mysql_fetch_row($this->result);
 }

//获取对象数组,使用$row->content
 public function fetch_Object() {
 return mysql_fetch_object($this->result);
 }

//简化查询select
 public function findall($table) {
 $this->query("SELECT * FROM $table");
 }

//简化查询select
 public function select($table, $columnName = "*", $condition = '', $debug = '') {
 $condition = $condition ? ' Where ' . $condition : NULL;
 if ($debug) {
 echo "SELECT $columnName FROM $table $condition";
 } else {
 $this->query("SELECT $columnName FROM $table $condition");
 }
 }

//简化删除del
 public function delete($table, $condition, $url = '') {
 if ($this->query("DELETE FROM $table WHERE $condition")) {
 if (!empty ($url))
 $this->Get_admin_msg($url, '删除成功！');
 }
 }

//简化插入insert
 public function insert($table, $columnName, $value, $url = '') {
 if ($this->query("INSERT INTO $table ($columnName) VALUES ($value)")) {
 if (!empty ($url))
 $this->Get_admin_msg($url, '添加成功！');
 }
 }

//简化修改update
 public function update($table, $mod_content, $condition, $url = '') {
 //echo "UPDATE $table SET $mod_content WHERE $condition"; exit();
 if ($this->query("UPDATE $table SET $mod_content WHERE $condition")) {
 if (!empty ($url))
 $this->Get_admin_msg($url);
 }
 }

/*取得上一步 INSERT 操作产生的 ID*/
 public function insert_id() {
 return mysql_insert_id();
 }

//指向确定的一条数据记录
 public function db_data_seek($id) {
 if ($id > 0) {
 $id = $id -1;
 }
 if (!@ mysql_data_seek($this->result, $id)) {
 $this->show_error("SQL语句有误：", "指定的数据为空");
 }
 return $this->result;
 }

// 根据select查询结果计算结果集条数
 public function db_num_rows() {
 if ($this->result == null) {
 if ($this->show_error) {
 $this->show_error("SQL语句错误", "暂时为空，没有任何内容！");
 }
 } else {
 return mysql_num_rows($this->result);
 }
 }

// 根据insert,update,delete执行结果取得影响行数
 public function db_affected_rows() {
 return mysql_affected_rows();
 }

//输出显示sql语句
 public function show_error($message = "", $sql = "") {
 if (!$sql) {
 echo "<font color='red'>" . $message . "</font>";
 echo "<br />";
 } else {
 echo "<fieldset>";
 echo "<legend>错误信息提示:</legend><br />";
 echo "<div style='font-size:14px; clear:both; font-family:Verdana, Arial, Helvetica, sans-serif;'>";
 echo "<div style='height:20px; background:#000000; border:1px #000000 solid'>";
 echo "<font color='white'>错误号：12142</font>";
 echo "</div><br />";
 echo "错误原因：" . mysql_error() . "<br /><br />";
 echo "<div style='height:20px; background:#FF0000; border:1px #FF0000 solid'>";
 echo "<font color='white'>" . $message . "</font>";
 echo "</div>";
 echo "<font color='red'><pre>" . $sql . "</pre></font>";
 $ip = $this->getip();
 if ($this->bulletin) {
 $time = date("Y-m-d H:i:s");
 $message = $message . "/r/n$this->sql" . "/r/n客户IP:$ip" . "/r/n时间 :$time" . "/r/n/r/n";

$server_date = date("Y-m-d");
 $filename = $server_date . ".txt";
 $file_path = "error/" . $filename;
 $error_content = $message;
 //$error_content="错误的数据库，不可以链接";
 $file = "error"; //设置文件保存目录

//建立文件夹
 if (!file_exists($file)) {
 if (!mkdir($file, 0777)) {
 //默认的 mode 是 0777，意味着最大可能的访问权
 die("upload files directory does not exist and creation failed");
 }
 }

//建立txt日期文件
 if (!file_exists($file_path)) {

//echo "建立日期文件";
 fopen($file_path, "w+");

//首先要确定文件存在并且可写
 if (is_writable($file_path)) {
 //使用添加模式打开$filename，文件指针将会在文件的开头
 if (!$handle = fopen($file_path, 'a')) {
 echo "不能打开文件 $filename";
 exit;
 }

//将$somecontent写入到我们打开的文件中。
 if (!fwrite($handle, $error_content)) {
 echo "不能写入到文件 $filename";
 exit;
 }

//echo "文件 $filename 写入成功";

echo "——错误记录被保存!";

//关闭文件
 fclose($handle);
 } else {
 echo "文件 $filename 不可写";
 }

} else {
 //首先要确定文件存在并且可写
 if (is_writable($file_path)) {
 //使用添加模式打开$filename，文件指针将会在文件的开头
 if (!$handle = fopen($file_path, 'a')) {
 echo "不能打开文件 $filename";
 exit;
 }

//将$somecontent写入到我们打开的文件中。
 if (!fwrite($handle, $error_content)) {
 echo "不能写入到文件 $filename";
 exit;
 }

//echo "文件 $filename 写入成功";
 echo "——错误记录被保存!";

//关闭文件
 fclose($handle);
 } else {
 echo "文件 $filename 不可写";
 }
 }

}
 echo "<br />";
 if ($this->is_error) {
 exit;
 }
 }
 echo "</div>";
 echo "</fieldset>";

echo "<br />";
 }

//释放结果集
 public function free() {
 @ mysql_free_result($this->result);
 }

//数据库选择
 public function select_db($db_database) {
 return mysql_select_db($db_database);
 }

//查询字段数量
 public function num_fields($table_name) {
 //return mysql_num_fields($this->result);
 $this->query("select * from $table_name");
 echo "<br />";
 echo "字段数：" . $total = mysql_num_fields($this->result);
 echo "<pre>";
 for ($i = 0; $i < $total; $i++) {
 print_r(mysql_fetch_field($this->result, $i));
 }
 echo "</pre>";
 echo "<br />";
 }

//取得 MySQL 服务器信息
 public function mysql_server($num = '') {
 switch ($num) {
 case 1 :
 return mysql_get_server_info(); //MySQL 服务器信息
 break;

case 2 :
 return mysql_get_host_info(); //取得 MySQL 主机信息
 break;

case 3 :
 return mysql_get_client_info(); //取得 MySQL 客户端信息
 break;

case 4 :
 return mysql_get_proto_info(); //取得 MySQL 协议信息
 break;

default :
 return mysql_get_client_info(); //默认取得mysql版本信息
 }
 }

//析构函数，自动关闭数据库,垃圾回收机制
 public function __destruct() {
 if (!empty ($this->result)) {
 $this->free();
 }
 mysql_close($this->conn);
 } //function __destruct();

/*获得客户端真实的IP地址*/
 function getip() {
 if (getenv("HTTP_CLIENT_IP") && strcasecmp(getenv("HTTP_CLIENT_IP"), "unknown")) {
 $ip = getenv("HTTP_CLIENT_IP");
 } else
 if (getenv("HTTP_X_FORWARDED_FOR") && strcasecmp(getenv("HTTP_X_FORWARDED_FOR"), "unknown")) {
 $ip = getenv("HTTP_X_FORWARDED_FOR");
 } else
 if (getenv("REMOTE_ADDR") && strcasecmp(getenv("REMOTE_ADDR"), "unknown")) {
 $ip = getenv("REMOTE_ADDR");
 } else
 if (isset ($_SERVER['REMOTE_ADDR']) && $_SERVER['REMOTE_ADDR'] && strcasecmp($_SERVER['REMOTE_ADDR'], "unknown")) {
 $ip = $_SERVER['REMOTE_ADDR'];
 } else {
 $ip = "unknown";
 }
 return ($ip);
 }
 function inject_check($sql_str) { //防止注入
 $check = eregi('select|insert|update|delete|/'|///*|/*|/././/|/.//|union|into|load_file|outfile', $sql_str);
 if ($check) {
 echo "输入非法注入内容！";
 exit ();
 } else {
 return $sql_str;
 }
 }
 function checkurl() { //检查来路
 if (preg_replace("/https?:////([^/://]+).*/i", "//1", $_SERVER['HTTP_REFERER']) !== preg_replace("/([^/:]+).*/", "//1", $_SERVER['HTTP_HOST'])) {
 header("Location: http://www.kebeke.com");
 exit();
 }
 }

}
?>

分页类

<?php
/*
 * Created on 2007-6-8
 * Programmer : Alan , Msn - haowubai@hotmail.com
 * php100.com Develop a project PHP - MySQL - Apache
 * Window - Preferences - PHPeclipse - PHP - Code Templates
 */
//为了避免重复包含文件而造成错误，加了判断函数是否存在的条件：
$page = $_GET[page];
if(!function_exists(pageft)){
//定义函数pageft(),三个参数的含义为：
//$totle：信息总数；
//$displaypg：每页显示信息数，这里设置为默认是20；
//$url：分页导航中的链接，除了加入不同的查询信息“page”外的部分都与这个URL相同。
//　　　默认值本该设为本页URL（即$_SERVER["REQUEST_URI"]），但设置默认值的右边只能为常量，所以该默认值设为空字符串，在函数内部再设置为本页URL。
function pageft($totle,$displaypg=20,$url=''){

//定义几个全局变量：
 //$page：当前页码；
 //$firstcount：（数据库）查询的起始项；
 //$pagenav：页面导航条代码，函数内部并没有将它输出；
 //$_SERVER：读取本页URL“$_SERVER["REQUEST_URI"]”所必须。
 global $page,$firstcount,$pagenav,$_SERVER;
 
 //为使函数外部可以访问这里的“$displaypg”，将它也设为全局变量。注意一个变量重新定义为全局变量后，原值被覆盖，所以这里给它重新赋值。
 $GLOBALS["displaypg"]=$displaypg;
 
 if(!$page) $page=1;
 
 //如果$url使用默认，即空值，则赋值为本页URL：
 if(!$url){ $url=$_SERVER["REQUEST_URI"];}
 
 //URL分析：
 $parse_url=parse_url($url);
 $url_query=$parse_url["query"]; //单独取出URL的查询字串
 if($url_query){
 //因为URL中可能包含了页码信息，我们要把它去掉，以便加入新的页码信息。
 //这里用到了正则表达式，请参考“PHP中的正规表达式”
 $url_query=ereg_replace("(^|&)page=$page","",$url_query);
 
 //将处理后的URL的查询字串替换原来的URL的查询字串：
 $url=str_replace($parse_url["query"],$url_query,$url);
 
 //在URL后加page查询信息，但待赋值：
 if($url_query) $url.="&page"; else $url.="page";
 }else {
 $url.="?page";
 }
 
 //页码计算：
 $lastpg=ceil($totle/$displaypg); //最后页，也是总页数
 $page=min($lastpg,$page);
 $prepg=$page-1; //上一页
 $nextpg=($page==$lastpg ? 0 : $page+1); //下一页
 $firstcount=($page-1)*$displaypg;
 
 //开始分页导航条代码：
 $pagenav="显示第 <B>".($totle?($firstcount+1):0)."</B>-<B>".min($firstcount+$displaypg,$totle)."</B> 条记录，共 $totle 条记录";
 
 //如果只有一页则跳出函数：
 if($lastpg<=1) return false;
 
 $pagenav.=" <a href="$url=1" mce_href="$url=1">首页</a> ";
 if($prepg) $pagenav.=" <a href="$url=$prepg" mce_href="$url=$prepg">前页</a> "; else $pagenav.=" 前页 ";
 if($nextpg) $pagenav.=" <a href="$url=$nextpg" mce_href="$url=$nextpg">后页</a> "; else $pagenav.=" 后页 ";
 $pagenav.=" <a href="$url=$lastpg" mce_href="$url=$lastpg">尾页</a> ";
 
 //下拉跳转列表，循环列出所有页码：
 $pagenav.="　到第 <select name='topage' size='1' onchange='window.location=/"$url=/"+this.value'>/n";
 for($i=1;$i<=$lastpg;$i++){
 if($i==$page) $pagenav.="<option value='$i' selected>$i</option>/n";
 else $pagenav.="<option value='$i'>$i</option>/n"; 
 }
 $pagenav.="</select> 页，共 $lastpg 页";
}
}
?>

转载请注明：懒人档案室 » PHP数据库操作&分页类

喜欢 (0)
发表我的评论
取消评论
表情

Hi，您需要填写昵称和邮箱！

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址