26讲 自定义mysql_class 类

<?php
/*mysql_class
*
*/
class mysql_class{

     private $hoat;
     private $name;
     private $pass;
    private $table;

     function __construct($host,$name,$pass){
      $this->host=$host;
      $this->name=$name;
      $this->pass=$pass;
      $this->table=$table;
     $this->connect();



     }


function connect(){

     $link=mysql_connect($this->host,$this->name,$this->pass) or die(mysql_error());

     //echo "链接成功";
     mysql_select_db($this->table,$link)or die("没有该数据库：".$this->table);

}

}


$db= new mysql_class("localhost","root","","php100job_db");


?>

http://bbs.php100.com/read-htm-tid-30897.html

http://bbs.php100.com/read-htm-tid-27313.html 第十三章
http://bbs.php100.com/read-htm-tid-27312.html 第十二章
http://bbs.php100.com/read-htm-tid-27311.html 第十一章
http://bbs.php100.com/read.php?tid=27318&page=1&toread=1#tpc 第十章
http://bbs.php100.com/read-htm-tid-27309.html 第九章
http://bbs.php100.com/read.php?tid=27308 第八章
http://bbs.php100.com/read.php?tid=27307 第七章
http://bbs.php100.com/read.php?tid=27233&page=1&toread=1#tpc  第六章
[http://bbs.php100.com/read.php?tid=27231&page=1&toread=1#tpc 第5章
http://bbs.php100.com/read.php?tid=27222&page=1&toread=1#tpc 第四章
http://bbs.php100.com/read-htm-tid-27219.html  第3章
http://bbs.php100.com/read-htm-tid-27216.html[/url] 第2章

还需要扩充

在此基础上进行慢慢的扩展就OK了啥~~

自定义table还是参数传入?

你慢慢的再看张老师的视频讲课，里面有.

http://bbs.php100.com/read-htm-tid-27313.html 第十三章
http://bbs.php100.com/read-htm-tid-27312.html 第十二章
http://bbs.php100.com/read-htm-tid-27311.html 第十一章
http://bbs.php100.com/read.php?tid=27318&page=1&toread=1#tpc 第十章
http://bbs.php100.com/read-htm-tid-27309.html 第九章
http://bbs.php100.com/read.php?tid=27308 第八章
http://bbs.php100.com/read.php?tid=27307 第七章
http://bbs.php100.com/read.php?tid=27233&page=1&toread=1#tpc  第六章
[http://bbs.php100.com/read.php?tid=27231&page=1&toread=1#tpc 第5章
http://bbs.php100.com/read.php?tid=27222&page=1&toread=1#tpc 第四章
http://bbs.php100.com/read-htm-tid-27219.html  第3章
http://bbs.php100.com/read-htm-tid-27216.html[/url] 第2章







class mysql{
                    //类成员设定
    var $db_name = "my_blog";//数据库
    var $table_name;//表
    var $table_id;//自动增加字段，一般为id
    
    function __construct(){//构造函数，目前没有特殊作用
    }
    
    function set_table($table_name){//设定要操作的表名以及id字段
    $this->table_name=$table_name;
    $this->table_id=$table_name."_id";    
    }
    
    function array_del_key($array,$del){//删除数组中指定键的值
    foreach ($array as $key=>$value){
    if("$key"!="$del"){
        $b[$key] = $value;
    }
   }
   return $b;
}

   function upload($photo){//上传图片的方法
       $uploaddir = '../upload/';
    $piece = explode('.',$photo['name']);
    $uploadfile = $uploaddir . md5($piece[0]).'.'.$piece[1];
    $result = move_uploaded_file($photo['tmp_name'], $uploadfile);
    if(!$result){
        return false;
    }
    list($width_orig, $height_orig) = getimagesize($uploadfile);
    if ($width_orig!=61||$height_orig!=61) {
    $image_p = imagecreatetruecolor(61, 61);
    if($piece[1]=="jpg"||$piece[1]=="jpeg"){
    $image = imagecreatefromjpeg($uploadfile);
    imagecopyresampled($image_p, $image, 0, 0, 0, 0, 61, 61, $width_orig, $height_orig);
    imagejpeg($image_p,$uploadfile);
    }else if($piece[1]=="gif"){
    $image = imagecreatefromgif($uploadfile);
    imagecopyresampled($image_p, $image, 0, 0, 0, 0, 61, 61, $width_orig, $height_orig);
    imagegif($image_p,$uploadfile);
    }
    }
    return basename($uploadfile);    
}
    function redirect($target,$param=""){//重定向,第一个参数是php文件的文件名，第二个参数为网址传参，默认为空，如“id=1"
        if(!$param){
        $to_go = "http://".$_SERVER['HTTP_HOST'].PHPATH."/".$target."."."php";
        }else{
        $to_go = "http://".$_SERVER['HTTP_HOST'].PHPATH."/".$target."."."php?".$param;    
        }
        header("location:$to_go");
    }
        
    function insert($data,$mysql_funtion=""){//插入数据操作，第一个参数为表单提交的与表字段匹配的数据数组，第二个参数为对表中时间字段进行操作的函数数组写法
    foreach($data as $key=>$value){                                                                                                                //$mysql_function=array('login_time'=>'now()','reg_time'=>'now()')
          $column.=$key.",";
         $column_value.="\"".$value."\"".",";        
    }
    $column=substr($column,0,-1);
    $column_value=substr($column_value,0,-1);
    if($mysql_funtion){
    foreach($mysql_funtion as $key=>$value){
        $column2.=",".$key;
        $column_value2.=",".$value;
    }  
    }
    $sql="INSERT INTO ".$this->db_name.".".$this->table_name."(".$column.$column2.")".
    "VALUES (".$column_value.$column_value2.");";
    mysql_query($sql);
    return mysql_insert_id();
    }
    
    function delete($id){//删除指定ID的记录
        if(is_array($id)){
        foreach ($id as $value){
        $sql="DELETE FROM `$this->db_name`.`$this->table_name` WHERE `$this->table_name`.`$this->table_id` ='$value'";
        mysql_query($sql);
        }
        }else{
        $sql="DELETE FROM `$this->db_name`.`$this->table_name` WHERE `$this->table_name`.`$this->table_id` ='$id'";
        mysql_query($sql);
        }    
    }
    
        function deletearray($contion){//按条件删除，$contion=array('column1'=>'','column2'=>'')
        $sql="DELETE FROM `$this->db_name`.`$this->table_name` WHERE $contion";
        mysql_query($sql);  
    }
    
    function update($id,$column,$column_value){//更新指定id的记录
        $sql="UPDATE ".$this->db_name.".".$this->table_name." SET ".$column." = "."\"$column_value\""." WHERE ".$this->table_name."."."$this->table_id"." = ".$id.";";
        mysql_query($sql);      
    }
    
    function update_sum($id,$column,$column_value){//对指点id字段进行数学累加
        $sql="UPDATE ".$this->db_name.".".$this->table_name." SET ".$column." = ".$column."+".$column_value." WHERE `".$this->table_name."`."."`$this->table_id`"." = ".$id.";";
        mysql_query($sql);
    }
    
    function update_mysql_fuc($id,$column,$mysql_function){//用mysql函数进行字段更新
        foreach($mysql_function as $key=>$value){
        $column_value = $value;
    }  
        $sql="UPDATE ".$this->db_name.".".$this->table_name." SET ".$column." = ".$column_value." WHERE ".$this->table_name.".".$this->table_id." = ".$id.";";
        mysql_query($sql);
    }
    
    function update_array($id,$array="",$mysql_function=""){//复杂条件与mysql函数的更新，array表示更新条件写法$array=array('$column'=>"",....),mysql函数数组同insert操作写法
    if($array){
        foreach ($array as $key=>$value){
        $column_to_value.="`".$key."`="."'".$value."',";
    }
    }
    if($mysql_function){
        foreach($mysql_function as $key=>$value){
        $column_to_value.="`".$key."`="."".$value.",";
    }  
    }
        $column_to_value=substr($column_to_value,0,strlen($column_to_value)-1);
        $sql="UPDATE `$this->db_name`.`$this->table_name` SET $column_to_value WHERE `$this->table_name`.`$this->table_id` ='$id';";
        mysql_query($sql);            
    }
    
    function select($column,$column_value,$order="",$start="",$end=""){读取操作，参数依次为字段，字段值，排序，分页起始，分页结束，其中排序参数为一个字符串如"order by id desc"
       $sql="SELECT * FROM `".$this->table_name."` WHERE `".$this->table_name."`.`".$column."` = "."\"$column_value\"";
       if($order){
           $sql.=" ".$order;
       }
    if($start&&$end){
           $sql.=" LIMIT $start , ".$end;
       }
       $result = mysql_query($sql);
       $num = mysql_num_rows($result);
    if($num>0){
       for($i;$i<$num;$i++){
    $result_array[] = mysql_fetch_array($result,MYSQL_ASSOC);
       }
       return $result_array;
       }else {
       return false;
       }
   }
  
   function selectarray($array,$order="",$start="",$end=""){//多条件查询，$array写法同上
       if(count($array)=="1"){
       foreach($array as $key=>$value){
       $contion .= " ".$this->table_name.".".$key."=\"".$value."\"";    
       }
       }elseif(count($array)>1){
       foreach($array as $key=>$value){
       $contion .= " ".$this->table_name.".".$key."=\"".$value."\" and";    
       }    
    $contion=substr($contion,0,strlen($contion)-4);
       }
      
      $sql="SELECT * FROM ".$this->table_name." WHERE ".$contion;
      if($order){
          $sql.=" ".$order;
      }
       if($start&&$end){
           $sql.=" LIMIT $start , ".$end;
       }
       $result = mysql_query($sql);
       $num = mysql_num_rows($result);
    if($num>0){
       for($i;$i<$num;$i++){
    $result_array[] = mysql_fetch_array($result,MYSQL_ASSOC);
       }
       return $result_array;
       }else {
       return false;
       }
   }
  
       function selectall($order="",$start="",$end=""){//查询所有数据
       $sql="SELECT * FROM ".$this->table_name;
       if($order){
           $sql.=" ".$order;
       }
       if($start&&$end){
           $sql.=" LIMIT $start , ".$end;
       }
       $result = mysql_query($sql);
       $num = mysql_num_rows($result);
    if($num>0){
       for($i;$i<$num;$i++){
    $result_array[] = mysql_fetch_array($result,MYSQL_ASSOC);
       }
       return $result_array;
       }else {
       return false;
       }
   }
  
   function selectmax($column,$condition_column,$contion_value){//查询一个表中某个字段的最大值，参数依次为，字段，条件字段，条件字段值
   $sql = "SELECT max( $column ) as max FROM `$this->table_name` WHERE $condition_column = $contion_value";
   mysql_query($sql);
   $result=mysql_fetch_array(mysql_query($sql));
   return $result['max'];    
   }
  
   function query($sql){//原生sql语句查询
       $result = mysql_query($sql);
       $num = mysql_num_rows($result);
       if($num>0){
       for($i;$i<$num;$i++){
    $result_array[] = mysql_fetch_array($result,MYSQL_ASSOC);
       }
       return $result_array;
       }else {
           return false;
       }
   }
  
   function query_result_num($sql){//返回sql语句的影响函数，影响语句请参考PHP手册
       $result = mysql_query($sql);
       return $num = mysql_num_rows($result);
   }
  
   function html_back(){//js返回
    echo "<script>window.history.back();</script>";
   }
      
   function table_fields(){//返回与数据库表字段对应的$_POST数组，在insert操作之前使用
       $re=mysql_query("SELECT * FROM `$this->table_name`");
    $i=0;
    while(@mysql_field_name($re,$i)){
    if(trim($_POST[mysql_field_name($re,$i)]!="")){
        if(mysql_field_name($re,$i)=="user_pwd"){
    $data[mysql_field_name($re,$i)] = md5($_POST[mysql_field_name($re,$i)]);
        }else{
    $data[mysql_field_name($re,$i)] = $_POST[mysql_field_name($re,$i)];        
        }
    }
    $i++;
    }
    return $data;
  }
}


http://bbs.php100.com/read-htm-tid-27313.html 第十三章
http://bbs.php100.com/read-htm-tid-27312.html 第十二章
http://bbs.php100.com/read-htm-tid-27311.html 第十一章
http://bbs.php100.com/read.php?tid=27318&page=1&toread=1#tpc 第十章
http://bbs.php100.com/read-htm-tid-27309.html 第九章
http://bbs.php100.com/read.php?tid=27308 第八章
http://bbs.php100.com/read.php?tid=27307 第七章
http://bbs.php100.com/read.php?tid=27233&page=1&toread=1#tpc  第六章
[http://bbs.php100.com/read.php?tid=27231&page=1&toread=1#tpc 第5章
http://bbs.php100.com/read.php?tid=27222&page=1&toread=1#tpc 第四章
http://bbs.php100.com/read-htm-tid-27219.html  第3章
http://bbs.php100.com/read-htm-tid-27216.html[/url] 第2章

<?php    
if (!isset($SAJAX_INCLUDED)) {

    /*  
     * 定义全局变量,并初始化
     *
     */
    $GLOBALS['sajax_version'] = '0.12';    
    $GLOBALS['sajax_debug_mode'] = 0;
    $GLOBALS['sajax_export_list'] = array();
    $GLOBALS['sajax_request_type'] = 'GET';
    $GLOBALS['sajax_remote_uri'] = '';
    $GLOBALS['sajax_failure_redirect'] = '';
    
    /*
     * 开始代码
     *
     */
    
    //
    // 初始化AJAX
    //
    function sajax_init() {
    }
    
    //
    // 返回脚本的URI路径
    //
    function sajax_get_my_uri() {
        return $_SERVER["REQUEST_URI"];
    }
    $sajax_remote_uri = sajax_get_my_uri();

谢啦

=700) window.open('http://bbs.php100.com/read.php?tid=28141&page=1&toread=1#tpc');" onload="if(this.offsetWidth>'700')this.width='700';if(this.offsetHeight>'700')this.height='700';" >

  * 开始代码
     *
     */
    
    //
    // 初始化AJAX
    //
    function sajax_init() {
    }
    
    //
    // 返回脚本的URI路径
    //
    function sajax_get_my_uri() {
        return $_SERVER["REQUEST_URI"];
    }
    $sajax_remote_uri = sajax_get_my_uri();

自定义table还是参数传入?

高手是怎么炼成的？付网

26讲 自定义mysql_class 类

      

26讲 自定义mysql_class 类

不错 看看