php curd操作封装第二版

最新推荐文章于 2021-03-12 19:58:19 发布

许泽武

最新推荐文章于 2021-03-12 19:58:19 发布

阅读量305

点赞数

分类专栏： php

本文链接：https://blog.csdn.net/weixin_39009993/article/details/81209666

版权

php 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

比第一版少了九行代码

<?php
$dsn = "mysql:host=localhost;dbname=test";
$db = new PDO($dsn, 'root', 'root');
$array = ['name'=>'nnn'];
$database = 'test';	
$insert=function($array){
	$database=$GLOBALS['database'];
	$i=0;
	foreach($array as $k=>$v){
		$i==0?$kk=$k:$kk.=','.$k;
		$i==0?$vv="'$v'":$vv.=",'$v'";
		$i++;
	}
	$GLOBALS['db']->exec("INSERT INTO $database($kk) values ($vv)");
};
$delete=function($array='',$column_name='',$database){
	if(!$array){
		$GLOBALS['db']->exec("delete from $database");
	}else{
		$GLOBALS['db']->exec("delete  from $database where $array");
	}
};
$update=function($array,$column_name='',$database){
	$i=0;
	foreach($array as $k=>$v){
		$i==0?$arr="$k='$v'":$arr.=",$k='$v'";
		$i++;			
	}
	if(!$column_name){
		$GLOBALS['db']->exec("update $database set $arr");
	}else{
		$GLOBALS['db']->exec("update $database set $arr where $column_name");
	}	
};
$select=function($array,$column_name,$database){
	if(!$array){
		$res=$GLOBALS['db']->query("select $column_name from $database");
	}else{
		$res=$GLOBALS['db']->query("select $column_name from $database where $array");
	}	
	return $res;
};
function i($array){
	$i=0;
	foreach($array as $k=>$v){
		$i==0?$arr="$k='$v'":$arr.=" and $k='$v'";
		$i++;			
	}
	return $arr;
}	
function curd($operate,$array='',$column_name=''){ 
	if($operate != $GLOBALS['update'] && is_array($array)){
		$array=i($array);
	}
	if(is_array($column_name)){
		$column_name=i($column_name);
	}
	return $operate($array,$column_name,$GLOBALS['database']);
}