db = mysqlidb::getInstance(); $this->db = new MysqlidbModel(); } function add($data){ //列名数组 $cols=array(); //列值数组 $vals=array(); foreach($data as $key=>$val){ $cols[]="`".$key."`"; $vals[]="'".$val."'"; } //$cols=array(0=>'`titlekey`',1=>'`contentkey`'); // //$vals=array(0=>"'titleval'",1=>"'contentval'"); // //用","将数组每个元素重新拼接起来 $str_cols=implode(',',$cols); //$str_cols= `titlekey`,`contentkey` $str_vals=implode(',',$vals); //$str_vals= 'titleval','contentval' //执行插入数据 $sql="insert into ".$this->tablename."($str_cols) values($str_vals);"; return $this->db->insert($sql ); } function update($data,$where){ $wherestr = ''; if(!empty($where)){ $wherestr .=' where '.$where; } $par_array=array(); foreach($data as $key=>$val){ $par_array[]="`".$key."`="."'".$val."'"; } //用","将修改列和列值的数组里每个元素重新拼接起来 $param=implode(',',$par_array); $sql = "update ".$this->tablename." set ".$param." ".$wherestr." "; return $this->db->query($sql); } function get_lists($where, $limit=''){ $wherestr = ''; if(!empty($where)){ $wherestr .=' where '.$where; } $sql = 'select * from '.$this->tablename.$wherestr . $limit; // echo $sql; return $this->db->select($sql); } function get_sum($where){ $wherestr = ''; if(!empty($where)){ $wherestr .=' where '.$where; } $sql = "select count(*) as sum from ".$this->tablename.$wherestr; $data = $this->db->get_row($sql); return $data['sum']; } function get_one($where){ $wherestr = ''; if(!empty($where)){ $wherestr .=' where '.$where; } $sql = "select * from ".$this->tablename.$wherestr; //var_dump($sql);exit; $data = $this->db->get_row($sql); return $data; } function del($where){ $wherestr = ''; if(!empty($where)){ $wherestr .=' where '.$where; } $sql = "delete from ".$this->tablename.$wherestr; //echo $sql;exit; $flag = $this->db->query($sql); return $flag; } }