数据库操作原函数定制数据库操作手脚架，类

1. [代码]db.php    

 PDO::ERRMODE_WARNING))or die(print_r($pdo->errorInfo(),true));
?>

2. [代码]db.function.php    

0)+tail
	switch($method)
	{
		case "insert": //db($table,$field,$value) insert into $table ($fields) values ($values)
			$sql="insert into {$table} {$field} values {$value}";break; 
		case "update": //db($table,field,$value) update $table set ($fields) values ($values) where ($where)
			$sql="update {$table} set {$field} values {$value} {$tail}";break;  
		case "select": //db($table,$field,$where) select ($fields) from $table where ($where)
			$sql="select {$field} from {$table} {$tail}";break;  
		case "count": //db($table,$where) select count(*) from $table where ($where)
			$sql="select count(*) from {$table} {$tail}";break;  
		case "delete": //db($table,$where) delete from $table where ($where)
			$sql="delete from {$table} $tail";break;  
		default: // db($table,$method,$where) $method=(count(*),max/min/avg/($field)) $method="count(*)" select count(*) from $table where id<10
			$sql="select {$method} ({$field}) from {$table} {$tial}";break; //you can change sql to $sql="select {$method} from {$table} $tail"  to get more free
	}

	$db=$pdo->prepare($sql);
	$db->execute();

	switch($return)
	{
		case "id":$return=$db->lastInsertId;break; //返回最后影响id
		case "rows":$return=$db->rowCount();break; //返回影响行数
		case "row":$return=$db->fetch();break;  //返回行记录
		case "allrow":$return=$db->fetchAll();break;  //返回所有行记录
		default:break;		
	}
	var_dump($sql); //you can change it to $return['sql']=$sql;
	var_dump($return);
	return
		$return;
}
/*用例
$array=db("user","select","username",'',"userid<10","allrow");
print_r($array);

	it is short for:
$sql="select usrname from user where userid<10";
$db=$pdo->prepare($sql);
$db->execute();
return $db->fetchAll();

*/

//简洁独立函数

function insert($table,$field='',$value='',$return=''){return db($table,"insert",$field,$value,'',$return);}  //db->insert($table,$field,$value,$return)
function update($table,$field='',$value='',$where='',$return='') {return db($table,"update",$field,$value,$where,$return);}
//function countRows($table,$field='*',$where='',$return='rows') {return db($table,'count',$field,'',$where,$return);} 跟php count()冲突
function select($table,$field='',$where='',$return='') {return db($table,"select",$field,'',$where,$return);}  //db->select($table,$field,$where='')
function delete($table,$where,$return='') {return db($table,"delete",'','',$where,$return);}  //db->delete($table,$where)
function execute($sql,$return='') {return db('','','','','',$return,$sql);}  //$db->prepare($sql,$return)

$array=select('user','username','userid<10','allrow');
var_dump($array);
?>

3. [代码]db.class.php  

table=$table;
		$this->field=$field;
		$this->value=$value;
		$this->return=$return;
		$this->where=$where;
		$this->sql=$sql;	
	}
	
	function insert($table,$field='',$value='',$return=''){$db($table,"insert",$field,$value,'',$return);}  //$db->insert($table,$field,$value,$return)
	function update($table,$filed='',$value='',$where,$return='') {$db($table,"update",'',$value,$return);}
	function select($table,$filed='',$where='',$return='') {$db($table,"select",'',$value,$return);}  //$db->select($table,$field,$where='')
	function count($table,$where='',$return='') {$db($table,"count",','$value,$return);}  //$db->count($table,$field,$where='')
	function delete($table,$where,$return='') {$db($table,"delete",'',$value,$return);}  //$db->delete($table,$where)
	function prepare($sql,$return='') {$db('','','','','',$return,$sql);}  //$db->prepare($sql,$return)
}

/*$metadb=new db($pdo);
$array=db("user","select","name",'',"userid<10","allrow");
print_r($array);
*/
*/

?>

4. [代码]user.function.php  

天意阿里巴巴企业商务

主要分类如下:供求商机(trade leades) 产品展示(product) 企业名录(companies) 会员商务助手(MY trade office)前台功能介绍:1、网页首页显示有精品推荐,商业机会分类列表,最新供求信息,网站动态,最新企业等;2、商业机会栏目功能有：二级分类,已经带有详细分类的数据库,后台可以更改增加操作;3、展厅展品栏目功能:二级分类,已经带有详细分类的数据库,

下载