数据库添加、修改、删除基础操作代码

css教程" type="text/css" rel="stylesheet" />

 
 

/**
 * 分页函数显示
 * date : 2008-12-6
 *
 * @param $page 当前页数
 * @param $num 每页显示数
 * @param $pagenum 分页总数
 * @param $totalnum 记录总数
 * 程序调用：showpage(当前页数,每页显示数,分页总数,记录总数);
 */
function showpage($page, $num, $pagenum, $totalnum) {
        $maxto = 5; //每次显示页数
        $nextpage = $page + 1;
        if ($nextpage > $pagenum) $nextpage = $pagenum;
        $for_end = ($pagenum > ($page + $maxto)) ? ($page +$maxto) : $pagenum;
        $for_begin = (($page - $maxto)>1) ? ($page - $maxto) : 1;
        echo " total: $totalnum ";  
        for ($i = $for_begin; $i <= $for_end; $i++) {
         if ($i != $page){
          echo "$i ";
         } else {
          echo "$i";
         }
        }
        echo "››... $pagenum";
        echo "";
}
/*网页特效提示框*/
function forward($msg, $methd='', $url = ''){
     $sstr = "";
     die($sstr);
}

?>

/**
 * ###################################################
 *
 * 数据库操作类
 * ###################################################
 */
 
class mysql {

 var $user,$pass,$host,$db;
 var $id,$data,$fields,$row,$row_num,$insertid,$version,$query_num=0;

 function mysql($host,$user,$pass,$db)
 {
  $this->host = $host;
  $this->pass = $pass;
  $this->user = $user;
  $this->db = $db;
  $this->dbconnect($this->host, $this->user, $this->pass);
  $this->selectdb($this->db);
  if($this->version() >'4.1')
  mysql_query("set names 'gbk'");
 }//初始化对象
 function dbconnect($host,$user,$pass)
 {
  $this->id = @ mysql_connect($host,$user,$pass) or
  sysmsg("连接数据库失败,可能是mysql数据库用户名或密码错误");
 }
 function selectdb($db)
 {
  @ mysql_select_db($db,$this->id) or sysmsg("未找到指定数据库");
 }

 function query($sql)
 {
  $query = @ mysql_query($sql,$this->id) or sysmsg("sql语句执行错误：$sql
".$this->geterror());
  $this->query_num();
  return $query;
 }

 function fetch_array($query)
 {
  $this->data = @mysql_fetch_array($query);
  return $this->data;
 }
 function query_num()
 {
  $this->query_num++;
 }
 function num_fields($query)
 {
  $this->fields = @mysql_num_fields($query);
  return $this->fields;
 }
 function fetch_row($query)
 {
  $this->row = @mysql_fetch_row($query);
  return $this->row;
 }

 function num_rows($query)
 {
  $this->row_num = @mysql_num_rows($query);
  return $this->row_num;
 }

 function insert_id()
 {
  $this->insertid = mysql_insert_id();
  return $this->insertid;
 }
 function version()
 {
  $this->version = mysql_get_server_info();
  return $this->version;
 }
 function fetch_one_array($sql)
 {
  $query = $this->query($sql);
  $this->data = $this->fetch_array($query);
  return $this->data;
 }
 function geterror()
 {
  return mysql_error();
 }
}
?>

-- phpmyadmin sql dump
-- version 3.1.2-rc1
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2009 年 04 月 15 日 09:22
-- 服务器版本: 5.0.67
-- php 版本: 5.2.6

set sql_mode="no_auto_value_on_zero";

/*!40101 set @old_character_set_client=@@character_set_client */;
/*!40101 set @old_character_set_results=@@character_set_results */;
/*!40101 set @old_collation_connection=@@collation_connection */;
/*!40101 set names utf8 */;

--
-- 数据库: `rc`
--

-- --------------------------------------------------------

--
-- 表的结构 `person`
--

create table if not exists `person` (
  `person_id` int(11) unsigned not null auto_increment,
  `login` varchar(25) not null,
  `pws` varchar(25) not null,
  `question` varchar(25) not null,
  `answer` varchar(25) not null,
  `addtime` timestamp not null default current_timestamp,
  primary key  (`person_id`)
) engine=innodb  default charset=gbk comment='人员表' auto_increment=13 ;

--
-- 导出表中的数据 `person`
--

insert into `person` (`person_id`, `login`, `pws`, `question`, `answer`, `addtime`) values
(1, 'huangxulei', '123456', 'whoareyou', 'iami', '2009-04-15 10:06:42'),
(3, 'lihuang', '123456', '123', 'www.111com.net', '2009-04-15 10:47:26'),
(4, '2222', '333', '3333', '33333', '2009-04-15 14:23:50'),
(8, '张红', '123456', 'whoareyou', '000', '2009-04-15 16:18:09'),
(9, '111', '111', '111', '111', '2009-04-15 16:26:07'),
(10, '111', '111', '111', '111', '2009-04-15 16:26:07'),
(11, '5555555555', '00000', '11100', '33333333', '2009-04-15 16:26:07');