php实战第二天

1.我的留言板上写上了%20add方法

[php] %20function%20add(){ 
   %20//添加后返回%20影响条数,如果大于0就说明添加成功  
   %20if($this->db->data($_POST)->add()>0){ 
       %20echo%20"添加成功"; 
       %20// %20echo%20"<script>location.reload()</script>";//防止刷新后的表单的重复提交  
       %20Header("HTTP/1.1%20303%20See%20Other"); 
       %20Header("Location:%20");  %20//转向到根目录  
       %20exit; 
         
   %20}else%20{ 
       %20die($this->db->error());//添加失败输出错误信息  
   %20}    
} 

  function%20add(){
   //添加后返回%20影响条数,如果大于0就说明添加成功
   if($this->db->data($_POST)->add()>0){
    echo%20"添加成功";
    // echo%20"<script>location.reload()</script>";//防止刷新后的表单的重复提交
    Header("HTTP/1.1%20303%20See%20Other");
    Header("Location:%20");  %20//转向到根目录
    exit;
    
   }else%20{
    die($this->db->error());//添加失败输出错误信息
   } 
  }对应提交表单

[html] %20<div%20class="center"> 
   %20<form%20action="?m=index&a=add"%20method="post"> 
       %20<table%20border=0> 
                       %20<tr> 
                           %20<td>用户名</td> 
                           %20<td><input%20type="text"%20name="userName"%20value="admin"></td> 
                       %20</tr> 
                       %20<tr> 
                           %20<td>留言内容</td> 
                           %20<td><textarea%20rows="3"%20cols="20"%20name="content">aaaaa</textarea></td> 
                       %20</tr> 
                       %20<tr> 
                           %20<td>电子邮箱</td> 
                           %20<td>email:<input%20type="text"%20name="email"%20value="admin@admin.com"></td> 
                       %20</tr> 
                       %20<tr> 
                           %20<td></td> 
                           %20<td><input%20type="submit"%20name="submit"%20value="留言"></td> 
                       %20</tr> 
       %20</table> 
             
                   %20<input%20type="hidden"%20name="action"%20value="add"> 
               %20</form> 
           %20</div> 
</div> 

<div%20class="center">
 <form%20action="?m=index&a=add"%20method="post">
   <table%20border=0>
                       %20<tr>
                           %20<td>用户名</td>
                           %20<td><input%20type="text"%20name="userName"%20value="admin"></td>
                       %20</tr>
                       %20<tr>
                           %20<td>留言内容</td>
                           %20<td><textarea%20rows="3"%20cols="20"%20name="content">aaaaa</textarea></td>
                       %20</tr>
                       %20<tr>
                           %20<td>电子邮箱</td>
                           %20<td>email:<input%20type="text"%20name="email"%20value="admin@admin.com"></td>
                       %20</tr>
                       %20<tr>
                           %20<td></td>
                           %20<td><input%20type="submit"%20name="submit"%20value="留言"></td>
                       %20</tr>
  </table>
           
                   %20<input%20type="hidden"%20name="action"%20value="add">
               %20</form>
   </div>
</div>

2.修改了MYSQL操作类%20使%20data%20自动处理传递过来的数据,对比是否存在字段,不存在不添加.

[php] %20<?php 
//%20+----------------------------------------------------------------------  
//%20|MySQL操作类  
//%20+----------------------------------------------------------------------  
//%20|@微凉%20QQ:496928838  
//%20+----------------------------------------------------------------------  
class%20MySQL{ 
     
   %20private%20$db_mysql_hostname; 
   %20private%20$db_mysql_username; 
   %20private%20$db_mysql_password; 
   %20private%20$db_mysql_database; 
   %20private%20$db_mysql_port; 
   %20private%20$db_mysql_charset; 
     
   %20private%20$query_list%20=%20array(); 
     
   %20//查询次数  
   %20public%20$query_count%20=%200; 
   %20//查询开始时间  
   %20public%20$query_start_time; 
     
   %20//当前查询ID  
   %20protected%20$queryID; 
   %20//当前连接  
   %20protected%20$conn; 
   %20//%20事务指令数  
   %20protected%20$transTimes%20=%200; 
   %20//%20返回或者影响记录数  
   %20protected%20$numRows   %20=%200; 
   %20//%20错误信息  
   %20protected%20$error     %20=%20''; 
     
   %20public%20function%20__construct($hostname_or_conf,$username,$password,$database,$port%20=%20'3306',$char%20=%20'utf8'){ 
       %20if(is_array($hostname_or_conf)){ 
           %20$this->db_mysql_hostname%20=%20$hostname_or_conf['hostname']; 
           %20$this->db_mysql_username%20=%20$hostname_or_conf['username']; 
           %20$this->db_mysql_password%20=%20$hostname_or_conf['password']; 
           %20$this->db_mysql_database%20=%20$hostname_or_conf['database']; 
           %20$this->db_mysql_port%20=%20isset($hostname_or_conf['port'])?$hostname_or_conf['port']:'3306'; 
           %20$this->db_mysql_charset%20=%20isset($hostname_or_conf['charset'])?$hostname_or_conf['charset']:'utf8'; 
             
       %20}elseif(!empty($hostname_or_conf)||!empty($username)||!empty($password)||!empty($database)) 
       %20{ 
            %20$this->db_mysql_hostname%20=%20$hostname_or_conf; 
            %20$this->db_mysql_username%20=%20$username; 
            %20$this->db_mysql_password%20=%20$password; 
            %20$this->db_mysql_database%20=%20$database; 
            %20$this->db_mysql_port%20=%20$port; 
            %20$this->db_mysql_charset%20=%20$char; 
              
       %20}else{ 
           %20die('configuration%20error.'); 
       %20} 
       %20$this->connect(); 
   %20} 
     
   %20private%20function%20connect(){ 
       %20$server%20=%20$this->db_mysql_hostname.':'.$this->db_mysql_port; 
       %20$this->conn%20=%20mysql_connect($server,$this->db_mysql_username,$this->db_mysql_password,true)%20or%20die('Connect%20MySQL%20DB%20error!'); 
       %20mysql_select_db($this->db_mysql_database,$this->conn)%20or%20die('select%20db%20error!'); 
       %20mysql_query("set%20names%20"%20.%20$this->db_mysql_charset,%20$this->conn); 
   %20} 
   %20/**
    %20+----------------------------------------------------------
    %20*%20设置数据对象值
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*table,where,order,limit,data,field,join,group,having
    %20+----------------------------------------------------------
    %20*/ 
   %20public%20function%20table($table){ 
       %20$this->query_list['table']%20=%20$table; 
       %20return%20$this; 
   %20} 
     
   %20public%20function%20where($where){ 
       %20$this->query_list['where']%20=%20$where; 
       %20return%20$this; 
   %20} 
     
   %20public%20function%20order($order){ 
       %20$this->query_list['order']%20=%20$order; 
       %20return%20$this; 
   %20} 
     
   %20public%20function%20limit($offset,$length){ 
       %20if(!isset($length)){ 
           %20$length%20=%20$offset; 
           %20$offset%20=%200; 
       %20} 
       %20$this->query_list['limit']%20=%20'limit%20'.$offset.','.$length; 
       %20return%20$this; 
   %20} 
     
   %20public%20function%20data($data){ 
       %20//读取数据表字段,然后处理表单数据  
       %20$dataList%20=%20$this->getFields($this->query_list['table']); 
       %20$arr=array(); 
       %20foreach%20($dataList%20as%20$key=>$value)%20{ 
           %20if%20(array_key_exists%20($key,$data)%20)%20{ 
               %20$arr[$key]=$data[$key]; 
           %20} 
             
       %20} 
       %20//var_dump($arr);  
       %20/*
       %20if(is_object($data)){
           %20$data  %20=  %20get_object_vars($data);
       %20}elseif%20(is_string($data)){
           %20parse_str($data,$data);
       %20}elseif(!is_array($data)){
           %20//Log:DATA_TYPE_INVALID
       %20}
       %20*/ 
       %20$this->query_list['data']%20=%20$arr; 
       %20return%20$this; 
   %20} 
   %20public%20function%20field($fields){ 
       %20$this->query_list['fields']%20=%20$fields; 
       %20return%20$this; 
   %20} 
   %20public%20function%20join($join){ 
       %20$this->query_list['join']%20=%20$join; 
       %20return%20$this; 
   %20} 
   %20public%20function%20group($group){ 
       %20$this->query_list['group']%20=%20$group; 
       %20return%20$this; 
   %20} 
   %20public%20function%20having($having){ 
       %20$this->query_list['having']%20=%20$having; 
       %20return%20$this; 
   %20} 
   %20/**
    %20+----------------------------------------------------------
    %20*%20查询
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*%20@param 
    %20+----------------------------------------------------------
    %20*/ 
   %20public%20function%20select(){ 
       %20$select_sql%20=%20'select%20'; 
       %20$fields%20=%20isset($this->query_list['fields'])?$this->query_list['fields']:'*'; 
       %20$select_sql.=$fields; 
       %20$select_sql.=%20'%20from%20`'.$this->query_list['table'].'`%20'; 
         
       %20isset($this->query_list['join'])?($select_sql.=$this->query_list['join']):''; 
       %20isset($this->query_list['where'])?($select_sql.='%20where%20'.$this->query_list['where']):''; 
       %20isset($this->query_list['group'])?($select_sql.='%20group%20by'.$this->query_list['group']):''; 
       %20isset($this->query_list['having'])?($select_sql.='%20mysql%20having%20'.$this->query_list['having']):''; 
       %20isset($this->query_list['order'])?($select_sql.='%20order%20by%20'.$this->query_list['order']):''; 
       %20isset($this->query_list['limit'])?($select_sql.='%20'.$this->query_list['limit']):''; 
         
       %20return%20$this->query($select_sql); 
   %20} 
   %20/**
    %20+----------------------------------------------------------
    %20*%20增加
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*%20@param 
    %20+----------------------------------------------------------
    %20*/ 
   %20public%20function%20add(){ 
       %20$add_sql%20=%20'insert%20into%20`'.$this->query_list['table'].'`%20('; 
         
       %20$data%20=%20$this->query_list['data']; 
       %20$value%20=%20$field%20=%20''; 
       %20foreach($data%20as%20$k=>$v){ 
           %20$field%20.=%20'`'.$k.'`,'; 
           %20if(is_numeric($v)) 
               %20$value%20.=%20$v.','; 
           %20else 
               %20$value%20.=%20'/''.$v.'/','; 
       %20} 
       %20$add_sql%20.=%20rtrim($field,',').')%20values%20('.rtrim($value,',').')'; 
 
   %20// %20echo%20'add_sql'.$add_sql;  
       %20return%20$this->execute($add_sql); 
   %20} 
   %20/**
    %20+----------------------------------------------------------
    %20*%20删除
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*%20@param 
    %20+----------------------------------------------------------
    %20*/ 
   %20public%20function%20delete(){ 
       %20$del_sql%20=%20'delete%20from%20`'.$this->query_list['table'].'`%20where%20'.$this->query_list['where']; 
         
       %20if(isset($this->query_list['order'])) 
           %20$del_sql%20.=%20'order%20by%20'.$this->query_list['order']; 
       %20if(isset($this->query_list['limit'])) 
           %20$del_sql%20.=%20'%20'.$this->query_list['limit']; 
             
       %20return%20$this->execute($del_sql); 
         
   %20} 
   %20/**
    %20+----------------------------------------------------------
    %20*%20更新
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*%20@param 
    %20+----------------------------------------------------------
    %20*/ 
   %20public%20function%20update(){ 
       %20$update_sql%20=%20'update%20`'.$this->query_list['table'].'`%20set%20'; 
       %20$data%20=%20$this->query_list['data']; 
         
       %20foreach($data%20as%20$k=>$v){ 
           %20if(is_numeric($v)) 
               %20$update_sql%20.=%20'`'.$k.'`%20='.$v.','; 
           %20else 
               %20$update_sql%20.=%20'`'.$k.'`%20=/''.$v.'/','; 
       %20} 
       %20$update_sql%20=%20rtrim($update_sql,','); 
       %20if(isset($this->query_list['where'])) 
           %20$update_sql%20.=%20'%20where%20'.$this->query_list['where']; 
       %20if(isset($this->query_list['order'])) 
           %20$update_sql%20.=%20'%20order%20by%20'.$this->query_list['order']; 
       %20if(isset($this->query_list['limit'])) 
           %20$update_sql%20.=%20'%20'.$this->query_list['limit']; 
         
       %20return%20$this->execute($update_sql); 
         
   %20} 
    %20/**
    %20+----------------------------------------------------------
    %20*%20执行查询%20返回数据集
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*%20@param%20string%20$sql %20sql指令
    %20*/ 
   %20public%20function%20query($sql)%20{ 
       %20if%20(%20!$this->conn%20)%20return%20false; 
       %20$this->queryStr%20=%20$sql; 
       %20//释放前次的查询结果  
       %20if%20(%20$this->queryID%20)%20{   %20$this->free();   %20} 
         
       %20$this->query_start_time%20=%20microtime(true); 
         
       %20$this->queryID%20=%20mysql_query($sql,%20$this->conn); 
       %20$this->query_count++; 
       %20if%20(%20false%20===%20$this->queryID%20)%20{ 
           %20$this->error(); 
           %20return%20false; 
       %20}%20else%20{ 
           %20$this->numRows%20=%20mysql_num_rows($this->queryID); 
           %20return%20$this->getAll(); 
       %20} 
   %20} 
   %20/**
    %20+----------------------------------------------------------
    %20*%20执行语句
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*%20@param%20string%20$sql %20sql指令
    %20+----------------------------------------------------------
    %20*/ 
   %20public%20function%20execute($sql)%20{ 
       %20if%20(%20!$this->conn%20)%20return%20false; 
       %20$this->queryStr%20=%20$sql; 
       %20//释放前次的查询结果  
       %20if%20(%20$this->queryID%20)%20{   %20$this->free();   %20} 
         
       %20$this->query_start_time%20=%20microtime(true); 
         
       %20$result%20=  %20mysql_query($sql,%20$this->conn)%20; 
       %20$this->query_count++; 
       %20if%20(%20false%20===%20$result)%20{ 
           %20$this->error(); 
           %20return%20false; 
       %20}%20else%20{ 
           %20$this->numRows%20=%20mysql_affected_rows($this->conn); 
           %20return%20$this->numRows; 
       %20} 
   %20} 
   %20/**
    %20+----------------------------------------------------------
    %20*%20获得所有的查询数据
    %20+----------------------------------------------------------
    %20*%20@access%20private
    %20+----------------------------------------------------------
    %20*%20@return%20array
    %20*/ 
   %20private%20function%20getAll()%20{ 
       %20//返回数据集  
       %20$result%20=%20array(); 
       %20if($this->numRows%20>0)%20{ 
           %20while($row%20=%20mysql_fetch_assoc($this->queryID)){ 
               %20$result[]  %20=  %20$row; 
           %20} 
           %20mysql_data_seek($this->queryID,0); 
       %20} 
       %20return%20$result; 
   %20} 
   %20/**
    %20+----------------------------------------------------------
    %20*%20取得数据表的字段信息
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*/ 
   %20public%20function%20getFields($tableName)%20{ 
       %20$result%20=  %20$this->query('SHOW%20COLUMNS%20FROM%20`'.$tableName.'`'); 
       %20$info  %20=  %20array(); 
       %20if($result)%20{ 
           %20foreach%20($result%20as%20$key%20=>%20$val)%20{ 
               %20$info[$val['Field']]%20=%20array( 
                   %20'name'   %20=>%20$val['Field'], 
                   %20'type'   %20=>%20$val['Type'], 
                   %20'notnull'%20=>%20(bool)%20($val['Null']%20===%20''),%20//%20not%20null%20is%20empty,%20null%20is%20yes  
                   %20'default'%20=>%20$val['Default'], 
                   %20'primary'%20=>%20(strtolower($val['Key'])%20==%20'pri'), 
                   %20'autoinc'%20=>%20(strtolower($val['Extra'])%20==%20'auto_increment'), 
               %20); 
           %20} 
       %20} 
       %20return%20$info; 
   %20} 
   %20/**
    %20+----------------------------------------------------------
    %20*%20取得数据库的表信息
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*/ 
   %20public%20function%20getTables($dbName='')%20{ 
       %20if(!empty($dbName))%20{ 
          %20$sql   %20=%20'SHOW%20TABLES%20FROM%20'.$dbName; 
       %20}else{ 
          %20$sql   %20=%20'SHOW%20TABLES%20'; 
       %20} 
       %20$result%20=  %20$this->query($sql); 
       %20$info  %20=  %20array(); 
       %20foreach%20($result%20as%20$key%20=>%20$val)%20{ 
           %20$info[$key]%20=%20current($val); 
       %20} 
       %20return%20$info; 
   %20} 
 
   %20/**
    %20+----------------------------------------------------------
    %20*%20最后次操作的ID
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*%20@param 
    %20+----------------------------------------------------------
    %20*/ 
    %20public%20function%20last_insert_id(){ 
       %20return%20mysql_insert_id($this->conn); 
   %20} 
   %20/**
    %20*%20执行一条带有结果集计数的
    %20*/ 
   %20public%20function%20count($sql){ 
       %20return%20$this->execute($sql); 
   %20} 
   %20/**
    %20+----------------------------------------------------------
    %20*%20启动事务
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*%20@return%20void
    %20+----------------------------------------------------------
    %20*/ 
   %20public%20function%20startTrans()%20{ 
       %20if%20($this->transTimes%20==%200)%20{ 
           %20mysql_query('START%20TRANSACTION',%20$this->conn); 
       %20} 
       %20$this->transTimes++; 
       %20return%20; 
   %20} 
 
   %20/**
    %20+----------------------------------------------------------
    %20*%20提交事务
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*%20@return%20boolen
    %20+----------------------------------------------------------
    %20*/ 
   %20public%20function%20commit() 
   %20{ 
       %20if%20($this->transTimes%20>%200)%20{ 
           %20$result%20=%20mysql_query('COMMIT',%20$this->conn); 
           %20$this->transTimes%20=%200; 
           %20if(!$result){ 
               %20throw%20new%20Exception($this->error()); 
           %20} 
       %20} 
       %20return%20true; 
   %20} 
 
   %20/**
    %20+----------------------------------------------------------
    %20*%20事务回滚
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*%20@return%20boolen
    %20+----------------------------------------------------------
    %20*/ 
   %20public%20function%20rollback() 
   %20{ 
       %20if%20($this->transTimes%20>%200)%20{ 
           %20$result%20=%20mysql_query('ROLLBACK',%20$this->conn); 
           %20$this->transTimes%20=%200; 
           %20if(!$result){ 
               %20throw%20new%20Exception($this->error()); 
           %20} 
       %20} 
       %20return%20true; 
   %20} 
   %20/**
    %20+----------------------------------------------------------
    %20*%20错误信息
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*%20@param 
    %20+----------------------------------------------------------
    %20*/ 
    %20public%20function%20error()%20{ 
       %20$this->error%20=%20mysql_error($this->conn); 
       %20if(''%20!=%20$this->queryStr){ 
           %20$this->error%20.=%20"/n%20[%20SQL语句%20]%20:%20".$this->queryStr; 
       %20} 
       %20return%20$this->error; 
   %20} 
   %20/**
    %20+----------------------------------------------------------
    %20*%20释放查询结果
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*/ 
   %20public%20function%20free()%20{ 
       %20@mysql_free_result($this->queryID); 
       %20$this->queryID%20=%200; 
       %20$this->query_list%20=%20null; 
   %20} 
   %20/**
    %20+----------------------------------------------------------
    %20*%20关闭连接
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*%20@param 
    %20+----------------------------------------------------------
    %20*/ 
   %20function%20close(){ 
       %20if%20($this->conn%20&&%20!mysql_close($this->conn)){ 
           %20throw%20new%20Exception($this->error()); 
       %20} 
       %20$this->conn%20=%200; 
       %20$this->query_count%20=%200; 
   %20} 
   %20/**
    %20+----------------------------------------------------------
    %20*%20析构方法
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*/ 
   %20function%20__destruct(){ 
        %20$this->close(); 
   %20} 
} 

<?php
//%20+----------------------------------------------------------------------
//%20|MySQL操作类
//%20+----------------------------------------------------------------------
//%20|@微凉%20QQ:496928838
//%20+----------------------------------------------------------------------
class%20MySQL{
 
 private%20$db_mysql_hostname;
 private%20$db_mysql_username;
 private%20$db_mysql_password;
 private%20$db_mysql_database;
 private%20$db_mysql_port;
 private%20$db_mysql_charset;
 
 private%20$query_list%20=%20array();
 
 //查询次数
 public%20$query_count%20=%200;
 //查询开始时间
 public%20$query_start_time;
 
 //当前查询ID
 protected%20$queryID;
 //当前连接
 protected%20$conn;
 //%20事务指令数
 protected%20$transTimes%20=%200;
 //%20返回或者影响记录数
   %20protected%20$numRows   %20=%200;
   %20//%20错误信息
   %20protected%20$error     %20=%20'';
 
 public%20function%20__construct($hostname_or_conf,$username,$password,$database,$port%20=%20'3306',$char%20=%20'utf8'){
  if(is_array($hostname_or_conf)){
   $this->db_mysql_hostname%20=%20$hostname_or_conf['hostname'];
   $this->db_mysql_username%20=%20$hostname_or_conf['username'];
   $this->db_mysql_password%20=%20$hostname_or_conf['password'];
   $this->db_mysql_database%20=%20$hostname_or_conf['database'];
   $this->db_mysql_port%20=%20isset($hostname_or_conf['port'])?$hostname_or_conf['port']:'3306';
   $this->db_mysql_charset%20=%20isset($hostname_or_conf['charset'])?$hostname_or_conf['charset']:'utf8';
   
  }elseif(!empty($hostname_or_conf)||!empty($username)||!empty($password)||!empty($database))
  {
   %20$this->db_mysql_hostname%20=%20$hostname_or_conf;
  %20  %20$this->db_mysql_username%20=%20$username;
  %20  %20$this->db_mysql_password%20=%20$password;
 %20  %20$this->db_mysql_database%20=%20$database;
   %20$this->db_mysql_port%20=%20$port;
   %20$this->db_mysql_charset%20=%20$char;
   
  }else{
   die('configuration%20error.');
  }
     %20 $this->connect();
   %20}
 
 private%20function%20connect(){
  $server%20=%20$this->db_mysql_hostname.':'.$this->db_mysql_port;
  $this->conn%20=%20mysql_connect($server,$this->db_mysql_username,$this->db_mysql_password,true)%20or%20die('Connect%20MySQL%20DB%20error!');
  mysql_select_db($this->db_mysql_database,$this->conn)%20or%20die('select%20db%20error!');
  mysql_query("set%20names%20"%20.%20$this->db_mysql_charset,%20$this->conn);
 }
 /**
    %20+----------------------------------------------------------
    %20*%20设置数据对象值
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*table,where,order,limit,data,field,join,group,having
    %20+----------------------------------------------------------
    %20*/
 public%20function%20table($table){
  $this->query_list['table']%20=%20$table;
  return%20$this;
 }
 
 public%20function%20where($where){
  $this->query_list['where']%20=%20$where;
  return%20$this;
 }
 
 public%20function%20order($order){
  $this->query_list['order']%20=%20$order;
  return%20$this;
 }
 
 public%20function%20limit($offset,$length){
  if(!isset($length)){
   $length%20=%20$offset;
   $offset%20=%200;
  }
  $this->query_list['limit']%20=%20'limit%20'.$offset.','.$length;
  return%20$this;
 }
 
 public%20function%20data($data){
  //读取数据表字段,然后处理表单数据
  $dataList%20=%20$this->getFields($this->query_list['table']);
  $arr=array();
  foreach%20($dataList%20as%20$key=>$value)%20{
   if%20(array_key_exists%20($key,$data)%20)%20{
    $arr[$key]=$data[$key];
   }
   
  }
  //var_dump($arr);
  /*
  if(is_object($data)){
   $data  %20=  %20get_object_vars($data);
  }elseif%20(is_string($data)){
   parse_str($data,$data);
  }elseif(!is_array($data)){
   //Log:DATA_TYPE_INVALID
  }
  */
  $this->query_list['data']%20=%20$arr;
  return%20$this;
 }
 public%20function%20field($fields){
  $this->query_list['fields']%20=%20$fields;
  return%20$this;
 }
 public%20function%20join($join){
  $this->query_list['join']%20=%20$join;
  return%20$this;
 }
 public%20function%20group($group){
  $this->query_list['group']%20=%20$group;
  return%20$this;
 }
 public%20function%20having($having){
  $this->query_list['having']%20=%20$having;
  return%20$this;
 }
 /**
    %20+----------------------------------------------------------
    %20*%20查询
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*%20@param
    %20+----------------------------------------------------------
    %20*/
 public%20function%20select(){
  $select_sql%20=%20'select%20';
  $fields%20=%20isset($this->query_list['fields'])?$this->query_list['fields']:'*';
  $select_sql.=$fields;
  $select_sql.=%20'%20from%20`'.$this->query_list['table'].'`%20';
  
  isset($this->query_list['join'])?($select_sql.=$this->query_list['join']):'';
  isset($this->query_list['where'])?($select_sql.='%20where%20'.$this->query_list['where']):'';
  isset($this->query_list['group'])?($select_sql.='%20group%20by'.$this->query_list['group']):'';
  isset($this->query_list['having'])?($select_sql.='%20mysql%20having%20'.$this->query_list['having']):'';
  isset($this->query_list['order'])?($select_sql.='%20order%20by%20'.$this->query_list['order']):'';
  isset($this->query_list['limit'])?($select_sql.='%20'.$this->query_list['limit']):'';
  
  return%20$this->query($select_sql);
 }
 /**
    %20+----------------------------------------------------------
    %20*%20增加
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*%20@param
    %20+----------------------------------------------------------
    %20*/
 public%20function%20add(){
  $add_sql%20=%20'insert%20into%20`'.$this->query_list['table'].'`%20(';
  
  $data%20=%20$this->query_list['data'];
  $value%20=%20$field%20=%20'';
  foreach($data%20as%20$k=>$v){
   $field%20.=%20'`'.$k.'`,';
   if(is_numeric($v))
    $value%20.=%20$v.',';
   else
    $value%20.=%20'/''.$v.'/',';
  }
  $add_sql%20.=%20rtrim($field,',').')%20values%20('.rtrim($value,',').')';

 // echo%20'add_sql'.$add_sql;
  return%20$this->execute($add_sql);
 }
 /**
    %20+----------------------------------------------------------
    %20*%20删除
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*%20@param
    %20+----------------------------------------------------------
    %20*/
 public%20function%20delete(){
  $del_sql%20=%20'delete%20from%20`'.$this->query_list['table'].'`%20where%20'.$this->query_list['where'];
  
  if(isset($this->query_list['order']))
   $del_sql%20.=%20'order%20by%20'.$this->query_list['order'];
  if(isset($this->query_list['limit']))
   $del_sql%20.=%20'%20'.$this->query_list['limit'];
   
  return%20$this->execute($del_sql);
  
 }
 /**
    %20+----------------------------------------------------------
    %20*%20更新
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*%20@param
    %20+----------------------------------------------------------
    %20*/
 public%20function%20update(){
  $update_sql%20=%20'update%20`'.$this->query_list['table'].'`%20set%20';
  $data%20=%20$this->query_list['data'];
  
  foreach($data%20as%20$k=>$v){
   if(is_numeric($v))
    $update_sql%20.=%20'`'.$k.'`%20='.$v.',';
   else
    $update_sql%20.=%20'`'.$k.'`%20=/''.$v.'/',';
  }
  $update_sql%20=%20rtrim($update_sql,',');
  if(isset($this->query_list['where']))
   $update_sql%20.=%20'%20where%20'.$this->query_list['where'];
  if(isset($this->query_list['order']))
   $update_sql%20.=%20'%20order%20by%20'.$this->query_list['order'];
  if(isset($this->query_list['limit']))
   $update_sql%20.=%20'%20'.$this->query_list['limit'];
  
  return%20$this->execute($update_sql);
  
 }
 %20/**
    %20+----------------------------------------------------------
    %20*%20执行查询%20返回数据集
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*%20@param%20string%20$sql %20sql指令
    %20*/
   %20public%20function%20query($sql)%20{
       %20if%20(%20!$this->conn%20)%20return%20false;
       %20$this->queryStr%20=%20$sql;
       %20//释放前次的查询结果
       %20if%20(%20$this->queryID%20)%20{   %20$this->free();   %20}
       
       %20$this->query_start_time%20=%20microtime(true);
       
       %20$this->queryID%20=%20mysql_query($sql,%20$this->conn);
       %20$this->query_count++;
       %20if%20(%20false%20===%20$this->queryID%20)%20{
           %20$this->error();
           %20return%20false;
       %20}%20else%20{
           %20$this->numRows%20=%20mysql_num_rows($this->queryID);
           %20return%20$this->getAll();
       %20}
   %20}
 /**
    %20+----------------------------------------------------------
    %20*%20执行语句
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*%20@param%20string%20$sql %20sql指令
    %20+----------------------------------------------------------
    %20*/
   %20public%20function%20execute($sql)%20{
       %20if%20(%20!$this->conn%20)%20return%20false;
       %20$this->queryStr%20=%20$sql;
       %20//释放前次的查询结果
       %20if%20(%20$this->queryID%20)%20{   %20$this->free();   %20}
       
       %20$this->query_start_time%20=%20microtime(true);
       
       %20$result%20=  %20mysql_query($sql,%20$this->conn)%20;
       %20$this->query_count++;
       %20if%20(%20false%20===%20$result)%20{
           %20$this->error();
           %20return%20false;
       %20}%20else%20{
           %20$this->numRows%20=%20mysql_affected_rows($this->conn);
           %20return%20$this->numRows;
       %20}
   %20}
 /**
    %20+----------------------------------------------------------
    %20*%20获得所有的查询数据
    %20+----------------------------------------------------------
    %20*%20@access%20private
    %20+----------------------------------------------------------
    %20*%20@return%20array
    %20*/
   %20private%20function%20getAll()%20{
       %20//返回数据集
       %20$result%20=%20array();
       %20if($this->numRows%20>0)%20{
           %20while($row%20=%20mysql_fetch_assoc($this->queryID)){
               %20$result[]  %20=  %20$row;
           %20}
           %20mysql_data_seek($this->queryID,0);
       %20}
       %20return%20$result;
   %20}
 /**
    %20+----------------------------------------------------------
    %20*%20取得数据表的字段信息
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*/
   %20public%20function%20getFields($tableName)%20{
       %20$result%20=  %20$this->query('SHOW%20COLUMNS%20FROM%20`'.$tableName.'`');
       %20$info  %20=  %20array();
       %20if($result)%20{
           %20foreach%20($result%20as%20$key%20=>%20$val)%20{
               %20$info[$val['Field']]%20=%20array(
                   %20'name'   %20=>%20$val['Field'],
                   %20'type'   %20=>%20$val['Type'],
                   %20'notnull'%20=>%20(bool)%20($val['Null']%20===%20''),%20//%20not%20null%20is%20empty,%20null%20is%20yes
                   %20'default'%20=>%20$val['Default'],
                   %20'primary'%20=>%20(strtolower($val['Key'])%20==%20'pri'),
                   %20'autoinc'%20=>%20(strtolower($val['Extra'])%20==%20'auto_increment'),
               %20);
           %20}
       %20}
       %20return%20$info;
   %20}
 /**
    %20+----------------------------------------------------------
    %20*%20取得数据库的表信息
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*/
   %20public%20function%20getTables($dbName='')%20{
       %20if(!empty($dbName))%20{
          %20$sql   %20=%20'SHOW%20TABLES%20FROM%20'.$dbName;
       %20}else{
          %20$sql   %20=%20'SHOW%20TABLES%20';
       %20}
       %20$result%20=  %20$this->query($sql);
       %20$info  %20=  %20array();
       %20foreach%20($result%20as%20$key%20=>%20$val)%20{
           %20$info[$key]%20=%20current($val);
       %20}
       %20return%20$info;
   %20}

 /**
    %20+----------------------------------------------------------
    %20*%20最后次操作的ID
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*%20@param
    %20+----------------------------------------------------------
    %20*/
 %20public%20function%20last_insert_id(){
       %20return%20mysql_insert_id($this->conn);
   %20}
   %20/**
    %20*%20执行一条带有结果集计数的
    %20*/
   %20public%20function%20count($sql){
       %20return%20$this->execute($sql);
   %20}
 /**
    %20+----------------------------------------------------------
    %20*%20启动事务
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*%20@return%20void
    %20+----------------------------------------------------------
    %20*/
   %20public%20function%20startTrans()%20{
       %20if%20($this->transTimes%20==%200)%20{
           %20mysql_query('START%20TRANSACTION',%20$this->conn);
       %20}
       %20$this->transTimes++;
       %20return%20;
   %20}

   %20/**
    %20+----------------------------------------------------------
    %20*%20提交事务
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*%20@return%20boolen
    %20+----------------------------------------------------------
    %20*/
   %20public%20function%20commit()
   %20{
       %20if%20($this->transTimes%20>%200)%20{
           %20$result%20=%20mysql_query('COMMIT',%20$this->conn);
           %20$this->transTimes%20=%200;
           %20if(!$result){
               %20throw%20new%20Exception($this->error());
           %20}
       %20}
       %20return%20true;
   %20}

   %20/**
    %20+----------------------------------------------------------
    %20*%20事务回滚
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*%20@return%20boolen
    %20+----------------------------------------------------------
    %20*/
   %20public%20function%20rollback()
   %20{
       %20if%20($this->transTimes%20>%200)%20{
           %20$result%20=%20mysql_query('ROLLBACK',%20$this->conn);
           %20$this->transTimes%20=%200;
           %20if(!$result){
               %20throw%20new%20Exception($this->error());
           %20}
       %20}
       %20return%20true;
   %20}
 /**
    %20+----------------------------------------------------------
    %20*%20错误信息
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*%20@param
    %20+----------------------------------------------------------
    %20*/
 %20public%20function%20error()%20{
       %20$this->error%20=%20mysql_error($this->conn);
       %20if(''%20!=%20$this->queryStr){
           %20$this->error%20.=%20"/n%20[%20SQL语句%20]%20:%20".$this->queryStr;
       %20}
       %20return%20$this->error;
   %20}
 /**
    %20+----------------------------------------------------------
    %20*%20释放查询结果
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*/
   %20public%20function%20free()%20{
       %20@mysql_free_result($this->queryID);
       %20$this->queryID%20=%200;
       %20$this->query_list%20=%20null;
   %20}
   %20/**
    %20+----------------------------------------------------------
    %20*%20关闭连接
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*%20@param
    %20+----------------------------------------------------------
    %20*/
 function%20close(){
  if%20($this->conn%20&&%20!mysql_close($this->conn)){
           %20throw%20new%20Exception($this->error());
       %20}
       %20$this->conn%20=%200;
       %20$this->query_count%20=%200;
 }
 /**
    %20+----------------------------------------------------------
    %20*%20析构方法
    %20+----------------------------------------------------------
    %20*%20@access%20public
    %20+----------------------------------------------------------
    %20*/
 function%20__destruct(){
  %20$this->close();
 }
}
3.我学会了浏览器重定向

用HTTP头信息
PHP里的header()函数的作用就是向浏览器发出由HTTP协议规定的本来应该通过WEB服务器的控制指令，例如声明返回信息的类型("Context-type:%20xxx/xxx")，页面的属性("No%20cache",%20"Expire")等等。
用HTTP头信息重定向到另外一个页面的方法如下：

[php] %20<?php 
Header("HTTP/1.1%20303%20See%20Other"); 
Header("Location:%20$url");  %20//注意Location:%20后面有一个空格  
exit; 
} 
?> 

<?php
Header("HTTP/1.1%20303%20See%20Other");
Header("Location:%20$url");  %20//注意Location:%20后面有一个空格
exit;
}
?>用脚本来实现
举例如下：
[javascript]%20<?php 
$url="http://localhost/"; 
echo%20"<!--<SCRIPT%20LANGUAGE="JavaScript">"; 
echo%20"location.href=’$url’"; 
echo%20"</SCRIPT>-->"; 
?> 

<?php
$url="http://localhost/";
echo%20"<!--<SCRIPT%20LANGUAGE="JavaScript">";
echo%20"location.href=’$url’";
echo%20"</SCRIPT>-->";
?>