php对数据库的基本操作


<?php class sqldb { public $DB; DBNAME function conetdb() { $this->DB=new mysqli('localhost','$ACC','$PWD','$DBNAME','3306')or die("Erro from DB 0"); } function read_alldata_tab($tabname,$where='') { $tabname=SQLHEAD.$tabname; //echo $tabname; if($where=='') { $sql="SELECT *FROM ".$tabname; }else { $a=count($where); $keys=array_keys($where); for($b=0;$b<$a;$b++) { if($b!=$a-1) { $w.=$keys[$b]."="."'".$where[$keys[$b]]."' AND "; }else { $w.=$keys[$b]."="."'".$where[$keys[$b]]."' "; } } $sql="SELECT *FROM ".$tabname." WHERE ".$w; } $result=$this->DB->query($sql); if ($result->num_rows > 0) { $c=0; while($row = $result->fetch_assoc()) { $d[$c]=$row; $c++; } return $d; } } function add_data_tab($tabname,$arr) { $tabname=SQLHEAD.$tabname; $a=count($arr); $keys=array_keys($arr); for($b=0;$b<$a;$b++) { if($b!=$a-1) { $column.=$keys[$b].","; }else { $column.=$keys[$b]." "; } } for($b=0;$b<$a;$b++) { if($b!=$a-1) { $value.="'".$arr[$keys[$b]]."',"; }else { $value.="'".$arr[$keys[$b]]."' "; } } $sql="INSERT INTO ".$tabname."(".$column.") VALUES (".$value.")"; //echo $sql; return $result=$this->DB->query($sql); } function updata_tab($tabname,$where,$arr) { $tabname=SQLHEAD.$tabname; $a=count($arr); $keys=array_keys($arr); for($b=0;$b<$a;$b++) { if($b!=$a-1) { $column.=$keys[$b]."="."'".$arr[$keys[$b]]."',"; }else { $column.=$keys[$b]."="."'".$arr[$keys[$b]]."' "; } } $a=count($where); $keys=array_keys($where); for($b=0;$b<$a;$b++) { if($b!=$a-1) { $w.=$keys[$b]."="."'".$where[$keys[$b]]."' AND "; }else { $w.=$keys[$b]."="."'".$where[$keys[$b]]."' "; } } $sql="UPDATE ".$tabname." set ".$column." WHERE ".$w; //echo $sql; return $result=$this->DB->query($sql); } function del_tab($tabname,$where) { $tabname=SQLHEAD.$tabname; $a=count($where); $keys=array_keys($where); for($b=0;$b<$a;$b++) { if($b!=$a-1) { $w.=$keys[$b]."="."'".$where[$keys[$b]]."' AND "; }else { $w.=$keys[$b]."="."'".$where[$keys[$b]]."' "; } } $sql="DELETE FROM ".$tabname." WHERE ".$w; return $result=$this->DB->query($sql); } } $sqldb=new sqldb;//全站数据库对象 $sqldb->conetdb();//连接数据库 ?>
符攀飞 符攀飞
5 个月前
28

扫描下方二维码手机阅读文章

0