Mysql sql文自動接合方法

<?php

/*      PHP    

    :YY  88354001  

    :www.zixue.it */



class Mysql{

            //  sql  

        public function autoExecute($data='',$table,$mode = "insert",$where = "where 1 limit 1"){        

            //insert   update           

            if(is_array($data)){

                //Update     

                if($mode == "update"){

                    $sql="update $table set ";

                    foreach($data as $key=>$val){

                        $sql.=$key ." = "."'$val'".',';

                    }

                    //      $sql updata $table set filed1 = value1,filed2=value2,filed3=values3,

                    $sql=substr(trim($sql),0,-1).' '.$where;

                     //  sql         ,      ','     $where  

                     return $this->query($sql);

                }

                    //insert      ,   insert

                    $sql = $mode . " into ".$table ." ( " . implode(',',array_keys($data));

                    $sql.=" ) value "."('".implode("','",array_values($data))."')";

                    return $this->query($sql);

            

            }else{

                    //delete      

                    //    delete  ,  $data     ,$table    delete $mode   where  

                    if($table = 'delete'){

                        $sql="delete from ".$data.' '.$mode;

                        $this->query($sql);

                        return $this->affected_rows();                    

                    }else{

                            return false;

                    }

            }

        }



        //query  

        public function query($sql){

            $res = mysql_query($sql);

            return $res;

        }

    }

        //+++++++++++++++    sql      +++++++++++++++++++//



        $mysql = new Mysql();

        //insert   

        $data=array(

            'username'=>'demo',

            'password'=>'admin'

        );

        $mysql->autoExecute($data,'user ');



        //updata   

        $where = "where id > 10;";

        $mysql->autoExecute($data,'user ','update',$where);

        

        //delete   

        $mysql->autoExecute('user ','delete',$where);