pcskys_windows7loader A new database operation class based on PDO A PDO transaction instance

Copy code The code is as follows:

/*
* Author: Hu Rui
* Date: 2011/03/19
* Email: hooray0905@foxmail.com
*
* 20110319
* Common database operations, such as: add, delete, modify, query, obtain single record, multiple records, return the latest inserted record id, return the number of operation record rows, etc.
* 20110630
* Overall modification method, merge some parameters
* Standard code, one There is only 1 return statement in the method
*/
/*
Parameter description
int $debug Whether to enable debugging, if enabled, the sql statement will be output
int $mode 0 Returns an array
1 Returns a single record
2 Returns the number of rows
string $table Database table
string $fields Database fields to be queried, allowed to be empty, the default is to find all
string $sqlwhere Query conditions, allowed to be empty
string $orderby Sorting, allowed to be empty, the default is id reverse order
*/
function hrSelect ($debug, $mode, $table, $fields="*", $sqlwhere="", $orderby="id desc"){
global $pdo;
if($debug){
if($mode = = 2){
echo "select count(*) from $table where 1=1 $sqlwhere order by $orderby";
}elseif($mode == 1){
echo "select $fields from $table where 1= 1 $sqlwhere";
}else{
echo "select $fields from $table where 1=1 $sqlwhere order by $orderby";
}
exit;
}else{
if($mode == 2){
$rs = $pdo->query("select count(*) from $table where 1=1 $sqlwhere order by $orderby");
$return = $rs->fetchColumn();
}elseif($ mode == 1){
$rs = $pdo->query("select $fields from $table where 1=1 $sqlwhere");
$return = $rs->fetch();
}else{
$rs = $pdo->query("select $fields from $table where 1=1 $sqlwhere order by $orderby");
$return = $rs->fetchAll();
}
return $return ;
}
}
/*
Parameter description
int $debug Whether to enable debugging, if it is enabled, the sql statement will be output
int $mode 0 Default insert, no return information
1 Return the number of execution entries
2 Return the id of the last inserted record
string $table database table
string $fields fields that need to be inserted into the database
string $values ​​information that needs to be inserted into the database, must correspond to $fields one-to-one
*/
function hrInsert($debug, $mode, $table, $fields , $values){
global $pdo;
if($debug){
echo "insert into $table ($fields) values ​​($values)";
exit;
}else{
if($mode == 2 ){
$return = $pdo->lastInsertId("insert into $table ($fields) values ​​($values)");
}elseif($mode == 1){
$return = $pdo-> exec("insert into $table ($fields) values ​​($values)");
}else{
$pdo->query("insert into $table ($fields) values ​​($values)");
exit ;
}
return $return;
}
}
/*
Parameter description
int $debug Whether to enable debugging, if enabled, the sql statement will be output
int $mode 0 Default update, no return information
1 Return the number of execution entries
string $table database table
string $set fields and contents that need to be updated, format: a='abc',b=2,c='2010-10-10 10:10:10'
string $sqlwhere modify conditions, allowed to be Empty
*/
function hrUpdate($debug, $mode, $table, $set, $sqlwhere=""){
global $pdo;
if($debug){
echo "update $table set $set where 1 =1 $sqlwhere";
exit;
}else{
if($mode==1){
$return = $pdo->exec("update $table set $set where 1=1 $sqlwhere");
}else{
$pdo->query("update $table set $set where 1=1 $sqlwhere");
exit;
}
return $return;
}
}
/*
Parameter description
int $debug Whether to enable debugging, if enabled, the sql statement will be output
int $mode 0 Default delete, no return information
1 Return the number of execution entries
string $table Database table
string $sqlwhere Delete conditions, allowed to be empty
*/
function hrDelete ($debug, $mode, $table, $sqlwhere=""){
global $pdo;
if($debug){
echo "delete from $table where 1=1 $sqlwhere";
exit;
}else {
if($mode == 1){
$return = $pdo->exec("delete from $table where 1=1 $sqlwhere");
}else{
$pdo->query("delete from $table where 1=1 $sqlwhere");
exit;
}
return $return;
}
}
?>

Copy the code The code is as follows:

/*
Note that the database operation table type must be InnoDB, other types do not support transactions
PDO transaction mechanism
$pdo->beginTransaction(); --Start transaction
$pdo ->commit(); --End the transaction
$pdo->rollBack(); --Rollback operation
Example, use try/catch to wrap the db operation. When the db operation within the transaction is interrupted, the rollback operation will be executed. Roll and throw an exception message.
*/
try{
$pdo->beginTransaction();
hrInsert(0,1,"class","name,parentid","'god',0"); //Can be executed normally
hrInsert( 0,0,0,"tb_searchlog","userid,code","4"); //Error
$pdo->commit();
}catch(Exception $e){
$pdo->rollBack ();
echo "Failed: " . $e->getMessage();
}

The above introduces pcskys_windows7loader, a new database operation class based on PDO and a PDO transaction instance, including the content of pcskys_windows7loader. I hope it will be helpful to friends who are interested in PHP tutorials.