php mysql

1/9

php简洁操作mysql数据库的类

具体如下：

?php

/**

*Databaseclass

*

*@version:2.2

*@revised:27may2022

*

**/

classDatabase{

var$host;

var$name;

var$user;

var$pass;

var$prefix;

var$linkId;

functionDatabase($mysql){

foreach($mysqlas$k=$v){

$this-$k=$v;

}

if(strlen($this-prefix)0substr($this-prefix,-1)!=="_")

2/9

$prefix.="_";

$this-prefix=$prefix;

}

functiongetLastID(){

$id=mysql_fetch_row(mysql_query("SELECTLAST_INSERT_ID()",

$this-linkId));

return$id[0];

}

functiongetPossibleValues($tableA,$whereA){

if(gettype($tableA)=="array"){

$table="";

foreach($tableAas$t){

$table.=$this-prefix.$t.",";

}

$table=substr($table,0,-2);

}else$table=$this-prefix.$tableA;

if(gettype($whereA)!="array"){

$whereA=array($whereA);

}

$return=array();

foreach($whereAas$where){

$sql=mysql_query("SHOWCOLUMNSFROM".$table."LIKE

3/9

'%".$where."%'");

while($arr=mysql_fetch_array($sql)){

if(strpos($arr['Type'],'enum')===0){

$vals=substr($arr['Type'],5,-1);

}else{

$vals=substr($arr['Type'],4,-1);

}

$vals=str_replace("'","",$vals);

$vals=explode(",",$vals);

$i=1;

foreach($valsas$val){

$return[$arr['Field']][$i++]=$val;

}

$return[$arr['Field']]['default']=$arr['Default'];

if($arr['Null']!="NO")$return[$arr['Field']][0]=NULL;

}

}

return$return;

}

functionconnect(){

$this-linkId=mysql_connect($this-host,$this-user,$this-pass);

if(!$this-linkId){

4/9

returnfalse;

}

if(mysql_select_db($this-name,$this-linkId))returntrue;

mysql_close($this-linkId);

returnfalse;

}

functionrunSelect($tables,$where="1",$fieldsA="*",$order=

false,$limit=false,$offset=false,$group=false){

if(gettype($tables)=="array"){

$table="";

foreach($tablesas$t){

$table.=$this-prefix.$t.",";

}

$table=substr($table,0,-2);

}else$table=$this-prefix.$tables;

if(gettype($fieldsA)=="array"){

$fields="";

$keys=array_keys($fieldsA);

if($keys[0]!='0'){

foreach($keysas$key){

$fields.=$key.'AS'.$fieldsA[$key].',';

}

5/9

}else{

foreach($fieldsAas$field){

$fields.=$field.',';

}

}

$fields=substr($fields,0,-2);

}else$fields=$fieldsA;

$query="SELECT".$fields."FROM".$table."WHERE".$where.

($order!==false?"ORDERBY".$order:($group!==false?"GROUP

BY".$group:"")).

($limit!==false?"LIMIT".$limit:"").

($offset!==false?"OFFSET".$offset:"");

returnmysql_query($query,$this-linkId);

}

functionrunUpdate($table,$valuesA,$where="1"){

if(gettype($valuesA)=="array"){

$fields="";

$values="";

$keys=array_keys($valuesA);

foreach($keysas$key){

if($valuesA[$key]!==NULL)

$values.="`".$key."`='".str_replace("'",''',$valuesA[$key])."',";

6/9

else

$values.=$key."=NULL,";

}

$fields=substr($fields,0,-1);

$values=substr($values,0,-1);

}else$values=$valuesA;

$query="UPDATE".$this-prefix.$table."SET".$values."WHERE

".$where;

if(mysql_query($query,

$this-linkId))

returnmysql_affected_rows($this-linkId);

returnfalse;

}

functionrunDelete($table,$where="1"){

if(mysql_query("DELETEFROM".$this-prefix.$table."WHERE

".$where,$this-linkId))

returnmysql_affected_rows($this-linkId);

returnfalse;

}

functionrunInsert($table,$valuesA,$onDuplicate=NULL){

if(gettype($valuesA)=="array"){

$fields="";

7/9

$values="";

$keys=array_keys($valuesA);

foreach($keysas$key){

$fields.="`".$key."`,";

$values.=($valuesA[$key]===NULL?"NULL,":"'".str_replace("'",''',

$valuesA[$key])."',");

}

$fields=substr($fields,0,-2);

$values=substr($values,0,-2);

}

$onDup="";

if($onDuplicate!=NULL){

$onDup="ONDUPLICATEKEYUPDATE";

if(gettype($onDuplicate)=="array"){

$keys=array_keys($onDuplicate);

foreach($keysas$key){

$onDup.=

'`'.$key.'`='.($onDuplicate[$key]===NULL?"NULL,":"'".str_replace("'",''',

$onDuplicate[$key])."',");

}

$onDup=substr($onDup,0,-2);

}else$onDup.=$onDuplicate;

8/9

}

$query="INSERTINTO

".$this-prefix.$table.($fields!==NULL?"(".$fields.")":"").

"VALUES(".$values.")".$onDup;

if(mysql_query($query,$this-linkId))

returnmysql_affected_rows($this-linkId);

returnfalse;

}

functiongetCells($table){

$query="SHOWCOLUMNSFROM`".$table."`";

$fields=mysql_query($query,$this-linkId)ordie('hej');

return$fields;

}

functiontranslateCellName($cellName){

$sql=$this-runSelect("mysql_cell_translation","mysql_name=

'".$cellName."'");

$row=mysql_fetch_assoc($sql);

return$row['human_name']?$row['human_name']:'span

class="faded"['.$cellName.']/span';

}

functiongetError(){

returnmysql_error($this-linkId);

9/9

}

functionclose()

{

mysql_close($this-linkId);

}

}

?

更多信息请查看IT技术专栏