pcskys_windows7loader 一个基于PDO的数据库操作类新 一个PDO事务实例

复制代码 代码如下:

function hrSelect($debug, $mode, $table, $fields="*", $sqlwhere="", $orderby="id desc"){
global $pdo;
if($debug){
if($mode == 2){
echo "ｓｅｌｅｃｔ count(*) from $table where 1=1 $sqlwhere order by $orderby";
}elseif($mode == 1){
echo "ｓｅｌｅｃｔ $fields from $table where 1=1 $sqlwhere";
}else{
echo "ｓｅｌｅｃｔ $fields from $table where 1=1 $sqlwhere order by $orderby";
}
exit;
}else{
if($mode == 2){
$rs = $pdo->query("ｓｅｌｅｃｔ count(*) from $table where 1=1 $sqlwhere order by $orderby");
$return = $rs->fetchColumn();
}elseif($mode == 1){
$rs = $pdo->query("ｓｅｌｅｃｔ $fields from $table where 1=1 $sqlwhere");
$return = $rs->fetch();
}else{
$rs = $pdo->query("ｓｅｌｅｃｔ $fields from $table where 1=1 $sqlwhere order by $orderby");
$return = $rs->fetchAll();
}
return $return;
}
}

function hrInsert($debug, $mode, $table, $fields, $values){
global $pdo;
if($debug){
echo "ｉｎｓｅｒｔ into $table ($fields) values ($values)";
exit;
}else{
if($mode == 2){
$return = $pdo->lastInsertId("ｉｎｓｅｒｔ into $table ($fields) values ($values)");
}elseif($mode == 1){
$return = $pdo->ｅｘｅｃ("ｉｎｓｅｒｔ into $table ($fields) values ($values)");
}else{
$pdo->query("ｉｎｓｅｒｔ into $table ($fields) values ($values)");
exit;
}
return $return;
}
}

function hrUpdate($debug, $mode, $table, $set, $sqlwhere=""){
global $pdo;
if($debug){
echo "ｕｐｄａｔｅ $table set $set where 1=1 $sqlwhere";
exit;
}else{
if($mode==1){
$return = $pdo->ｅｘｅｃ("ｕｐｄａｔｅ $table set $set where 1=1 $sqlwhere");
}else{
$pdo->query("ｕｐｄａｔｅ $table set $set where 1=1 $sqlwhere");
exit;
}
return $return;
}
}

function hrDelete($debug, $mode, $table, $sqlwhere=""){
global $pdo;
if($debug){
echo "ｄｅｌｅｔｅ from $table where 1=1 $sqlwhere";
exit;
}else{
if($mode == 1){
$return = $pdo->ｅｘｅｃ("ｄｅｌｅｔｅ from $table where 1=1 $sqlwhere");
}else{
$pdo->query("ｄｅｌｅｔｅ from $table where 1=1 $sqlwhere");
exit;
}
return $return;
}
}
?>

复制代码 代码如下:

try{
$pdo->beginTransaction();
hrInsert(0,1,"class","name,parentid","'god',0"); //可以正常执行
hrInsert(0,0,0,"tb_searchlog","userid,code","4"); //出错
$pdo->commit();
}catch(Exception $e){
$pdo->rollBack();
echo "Failed: " . $e->getMessage();
}

以上就介绍了pcskys_windows7loader 一个基于PDO的数据库操作类新 一个PDO事务实例，包括了pcskys_windows7loader方面的内容，希望对PHP教程有兴趣的朋友有所帮助。