parallels desktop 7 a database operation class based on PDO

Baidu later decided to use PDO. As for why it chose PDO, I won’t go into details here. You can understand it yourself by going to Baidu.
Since we want to change, we basically need to have a commonly used database operation class, which is the so-called addition, deletion, modification, query, etc. I spent the whole night tinkering around and roughly came up with a prototype. The following is the code. I hope you can give it. Comment.

Copy code 如 Code as follows: & lt;? PHP /*

Author: Hu Rui

Date: 2011/03/19
Email: hooray0905@foxmail.com
20110319
Common database operations, such as : Add, delete, modify and query, obtain a single record or multiple records, return the latest inserted record id, return the number of operation record rows, etc.
*/
/*
Parameter description
int $debug Whether to enable debugging, if it is enabled, the sql statement will be output
int $getcount Whether to count, the return value is the number of rows
int $getrow Whether to return a single record
string $table database table
string $fields The 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, $getcount, $getrow, $table, $fields="*", $sqlwhere="", $orderby="id desc"){
global $pdo;
if($debug){
if($getcount){
echo "select count(*) from $table where 1=1 $sqlwhere order by $orderby" ;
}else{
echo "select $fields from $table where 1=1 $sqlwhere order by $orderby";
}
exit;
}else{
if($getcount){
$rs = $pdo-> ;query("select count(*) from $table where 1=1 $sqlwhere order by $orderby");
return $rs->fetchColumn();
}elseif($getrow){
$rs = $pdo ->query("select $fields from $table where 1=1 $sqlwhere order by $orderby");
return $rs->fetch();
}else{
$rs = $pdo->query ("select $fields from $table where 1=1 $sqlwhere order by $orderby");
return $rs->fetchAll();
}
}
}
/*
Parameter description
int Whether $debug is enabled Debugging, if enabled, the sql statement will be output.
int $execrow will return the number of execution entries if it is enabled.
int $lastinsertid will return the last inserted record id if it is enabled.
string $table database table.
string $fields fields that need to be inserted into the database.
string $values ​​that need to be inserted. Database information must correspond to $fields one-to-one
*/
function hrInsert($debug, $execrow, $lastinsertid, $table, $fields, $values){
global $pdo;
if($debug){
echo "insert into $table ($fields) values ​​($values)";
exit;
}elseif($execrow){
return $pdo->exec("insert into $table ($fields) values ​​($values )");
}elseif($lastinsertid){
return $pdo->lastInsertId("insert into $table ($fields) values ​​($values)");
}else{
$pdo->query( "insert into $table ($fields) values ​​($values)");
}
}
/*
Parameter description
int $debug Whether to enable debugging, if enabled, output sql statements
int $execrow Whether to enable execution and return entries Number
string $table Database table
string $set Fields and content 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, $execrow, $table, $set, $sqlwhere=""){
global $pdo;
if($debug){
echo "update $table set $ set where 1=1 $sqlwhere";
exit;
}elseif($execrow){
return $pdo->exec("update $table set $set where 1=1 $sqlwhere");
}else{
$pdo->query("update $table set $set where 1=1 $sqlwhere");
}
}
/*
Parameter description
int $debug Whether to enable debugging, if it is enabled, the sql statement will be output
int $execrow Whether to enable returning the number of execution entries
string $table database table
string $sqlwhere deletion condition, allowed to be empty
*/
function hrDelete($debug, $execrow, $table, $sqlwhere=""){
global $pdo;
if($debug){
echo "delete from $table where 1=1 $sqlwhere";
exit;
}elseif($execrow){
return $pdo->exec("delete from $table where 1= 1 $sqlwhere");
}else{
$pdo->query("delete from $table where 1=1 $sqlwhere");
}
}
?>


The parameters are well written. Clearly, if anyone needs it and doesn’t know how to use it, just ask me directly.
The above introduces parallels desktop 7, a database operation class based on PDO, including the content of parallels desktop 7. I hope it will be helpful to friends who are interested in PHP tutorials.