php pdo encapsulation class implements mysql data addition, deletion, checking and modification-PHP Tutorial-php.cn

define('DSN', 'mysql:host=127.0.0.1;dbname=baozhong_tour'); //Constant of database address + database name
define('DB_USERNAME ', 'root'); //Database username
define('DB_USERPWD', ''); //Database password
?>
/**
* @author shuimugan
* @version 0.2
* @return PDOStatement
*/
function getConn() {
try {
$db = new PDO(DSN, DB_USERNAME, DB_USERPWD); //Create a pdo object and pass in the database parameter information
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // Set database error information
$db->query('set names utf8;'); //Set encoding to utf8
return $db;
}
catch (PDOException $e) {
echo 'Data processing error, please contact Website administrator!';
print_r($e);//Super detailed error message, this sentence must be commented after going online!
return false;
}
}
/**
* @author shuimugan
* @version 0.2
* @param String $tablename table name, type is string
* @param Array $column_name column name, the format of the array is required
* @param String $condition condition, such as 'where name=? and pws=?' or 'name like?'
* @param Array $condition_value The data corresponding to the condition, the type is required to be an array, such as 'name=? and pws=?',
* @return Array returns an Result set array format
* @example $column_name=array('*');
$condition_value=array('1');
$limit='limit 0,10';
$res=easy_select('user', $column_name, 'where id=? ', $condition_value,$limit);
*/
function easy_select( $tablename,$column_name,$condition,$condition_value,$limit) {
try {
$db=getConn();
$sql='select ';//Initialize sql statement
foreach ($column_name as $col_name) {
//Dynamicly append column names into sql statements
if($col_name=='*'){
$sql.='*';
break;
}
if($col_name==end($column_name))
{
$sql.=$col_name." ";//If it is the last one, the statement does not splice comma
}else {
$sql.=$col_name.", ";//Splice column name + comma
}
}
$sql.="from ".$tablename." ";//Splicing table name
$sql.=$condition.' ';//Splicing conditional statement
if(strlen($limit)>0){
$sql.=$limit;//Splice the limit statement
}
$db = new PDO(DSN, DB_USERNAME, DB_USERPWD);//Create a pdo object and pass in the database parameter information
$db->setAttribute(PDO:: ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);//Set database error information
$db->query('set names utf8;');//Set encoding to utf8
$stmt = $db->prepare($sql) ;
$i=1;//Start counting, calculate the number of?
$j=count($condition_value);
for (; $i <= $j; ) {
$stmt->bindParam($i , $condition_value[$i-1]);//Bind parameters
$i++;
}
//Query
$stmt->setFetchMode(PDO::FETCH_ASSOC);//Set to get data through fields
$stmt ->execute();
//Get data
return $stmt->fetchAll();
//return $stmt->rowCount();
} catch (PDOException $e) {
return false;
echo 'Data processing error, please contact the website administrator!';
print_r($e);//Super detailed error message, this sentence must be commented after going online!
}
}
/**
* @author shuimugan
* @version 0.2
* @param String $tablename table name, type is string
* @param Array $column_name column name, the format of the array is required
* @param String $condition condition, such as 'where name=? and pws=?' or 'name like?'
* @param Array $condition_value The data corresponding to the condition, the type is required to be an array, such as 'name=? and pws=?',
* @return int returns the record Number of items
* @example $column_name=array('*');
$condition_value=array('1');
$limit='limit 0,10';
$res=easy_selectCount('user', $column_name , 'where id=? ', $condition_value,$limit);
*/
function easy_selectCount($tablename,$column_name,$condition,$condition_value,$limit) {
try {
$db=getConn();
$sql='select ';//Initialize sql statement
foreach ($column_name as $col_name) {
//Dynamicly append column names into sql statements
if($col_name=='*'){
$sql.='*';
break;
}
if($col_name==end($ column_name))
{
$sql.=$col_name." ";//If it belongs to the last one, the statement does not splice the comma
}else {
$sql.=$col_name.", ";//Splice the column name + comma
}
}
$sql.="from ".$tablename." ";//Splicing table name
$sql.=$condition.' ';//Splicing conditional statement
if(strlen($limit)> 0){
$sql.=$limit;//Splicing limit statement
}
;
$db = new PDO(DSN, DB_USERNAME, DB_USERPWD);//Create a pdo object and pass in the database parameter information
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);//Set the database Error message
$db->query('set names utf8;');//Set encoding to utf8
$stmt = $db->prepare($sql);
$i=1;//Start counting, Calculate the number of
$j=count($condition_value);
for (; $i <= $j; ) {
$stmt->bindParam($i, $condition_value[$i-1]);/ / Bind parameters
$i++;
}
// Query
//$stmt->setFetchMode(PDO::FETCH_ASSOC);//Set to get data through fields
$stmt->execute();
// Get data
return $stmt->rowCount();
} catch (PDOException $e) {
return false;
echo 'Data processing error, please contact the website administrator!';
print_r($e);// Super detailed error message, you must comment this sentence after going online!
}
}
/**
* @author shuimugan
* @version 0.2
* @param String $tablename table name, type is string
* @param Array $column_name column name, the format of the array is required
* @param Array $column_value corresponding data, requirements The format of the array
* @return int returns the last incremented id
* @example $column_name=array('pwd','ip','name');
$column_value=array('1246','11.11.11.11 ','Zhang San');
echo easy_insert('user',$column_name,$column_value);
*/
function easy_insert($tablename,$column_name,$column_value) {
try {
$db=getConn( );
$sql='INSERT INTO ';//Initialize sql statement
$sql.=$tablename.' (';//Splice table name
foreach ($column_name as $col_name) {
//Dynamicly append column name Enter the sql statement
if($col_name==end($column_name))
{
$sql.=$col_name." )";//If it is the last one, splice the right bracket
}else {
$sql.=$ col_name.", ";//Splicing column name + comma
}
}
$sql.=' VALUES (';//Splicing $condition_value statement
for ($i=0; $i < count($column_name) ; $i++) {//Splicing question marks?
if ($i==count($column_name)-1) {
$sql.='?) ;';
}else {
$sql.='?,' ;
}
}
$db = new PDO(DSN, DB_USERNAME, DB_USERPWD);//Create a pdo object and pass in the database parameter information
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);/ /Set database error information
$db->query('set names utf8;');//Set encoding to utf8
$stmt = $db->prepare($sql);
for ($i=1; $i <= count($column_name); $i++) {//Splicing question marks?
$stmt->bindParam($i, $column_value[$i-1]);
}
// Query
// echo $sql;
$stmt->setFetchMode(PDO::FETCH_ASSOC);//Set to get data through fields
$stmt->execute();
//Get data
return $db->lastInsertId() ;
} catch (PDOException $e) {
return false;
echo 'Data processing error, please contact the website administrator!';
print_r($e);//Super detailed error message, this sentence must be commented after going online Words!
}
}
/**
* @author shuimugan
* @version 0.2
* @param String $tablename table name, type is string
* @param Array $column_name column name, the format of the array is required
* @param Array $column_value corresponding data, requirements The format of the array
* @param String $condition corresponds to the where statement string such as 'where id=?'
* @param Array $condition_value corresponds to where The data type of the question mark behind is required to be an array
* @return int Returns the affected data Number of rows
* @example $column_name=array('pwd','ip','name');
$column_value=array('123456','127.152.123.132','Zhang San');
$condition_value= array('1');
easy_update('user',$column_name,$column_value,'where id=?',$condition_value,null);
*/
function easy_update($tablename,$column_name,$column_value,$condition,$condition_value,$limit) {
try {
$db=getConn();
$sql='UPDATE ';//Initialize the sql statement
$sql.=$tablename.' SET ';//Splice the table name
foreach ($column_name as $col_name) {
//Dynamicly append the column name into the sql statement
if($col_name==end($column_name))
{
$sql.=$col_name." = ? ";//If it belongs to the last
}else {
$sql.=$col_name." = ?, " ;//Splicing column name + comma
}
}
$sql.=$condition;//Splicing conditional statement
if(strlen($limit)>0){
$sql.=$limit;//Splicing limit Statement
}
$db = new PDO(DSN, DB_USERNAME, DB_USERPWD);//Create a pdo object and pass in the database parameter information
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);//Set Database error message
$db->query('set names utf8;');//Set encoding to utf8
$stmt = $db->prepare($sql);//Prepare statement
$i=1;
$total=count($column_name)+count($condition_value);
for (;$i <= count($column_name);) {
$stmt->bindParam($i, $column_value[$i- 1]);//Bind the data parameter corresponding to the column name
$i++;
}
$j=1;
for (;$i <= $total;) {
$stmt->bindParam($i, $condition_value[$j-1]);//The data parameters corresponding to the binding conditions
$i++;
$j++;
}
//Query
$stmt->setFetchMode(PDO::FETCH_ASSOC);//Set to get data through fields
$stmt->execute();
//Get data
return $stmt->rowCount() ;
} catch (PDOException $e) {
return false;
echo 'Data processing error, please contact the website administrator!';
print_r($e);//Super detailed error message, this sentence must be commented after going online Words!
}
}
/**
* @author shuimugan
* @version 0.2
* @param String $tablename table name
* @param String $condition conditions such as 'where id= ?'
* @param Array $condition_value The value corresponding to the condition is the value corresponding to ?
* @param String $limit limit statement such as 'limit 0,1'
* @return int Returns the number of affected results
* @example $condition_value=array('83');
echo easy_delete('user', 'where id =?', $condition_value, null);
*/
function easy_delete($tablename,$condition,$condition_value,$limit) {
try {
$db=getConn();
$sql='DELETE FROM ';//Initialize sql statement
$sql.=$tablename.' ';//Splice table name
$sql.=$condition;//Splice conditional statement
if(strlen($limit)>0){
$sql.=$limit;//Splice the limit statement
}
$db = new PDO(DSN, DB_USERNAME, DB_USERPWD);//Create a pdo object and pass in the database parameter information
$db->setAttribute(PDO:: ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);//Set database error information
$db->query('set names utf8;');//Set encoding to utf8
$stmt = $db->prepare($sql) ;//Prepare statement
for ($i=1;$i <= count($condition_value);) {
$stmt->bindParam($i, $condition_value[$i-1]);//Bind Data parameters corresponding to certain conditions
$i++;
}
// Query
$stmt->setFetchMode(PDO::FETCH_ASSOC);//Set to obtain data through fields
$stmt->execute();
// Get Data
return $stmt->rowCount();
} catch (PDOException $e) {
return false;
echo 'Data processing error, please contact the website administrator!';
print_r($e);//Super Detailed error message, you must comment this sentence after going online!
}
}
?>

Copy the code

Php8, I'm coming too

Learn website layout in 30 minutes

Shangguan Oracle Beginner to Proficient Video Tutorial

Your first line of UNI-APP code

Flutter from scratch to app launch

Brother Lian New Linux Video Tutorial

AXURE 9 Video Tutorial (Suitable for Product Manager Interactive Product Design UI)

Zero Basic Proficiency PS Video Tutorial

16 day UI video tutorial to get you started

PS Techniques and Slicing Techniques Video Tutorial

Alibaba Cloud Environment Construction and Project Launch Video Tutorial

Overview of Computer Networks - Basic Knowledge that Programmers Must Master

Essential Tutorial for Programmers - HTTP Protocol Explanation

Websocket Video Tutorial

php pdo encapsulation class implements mysql data addition, deletion, checking and modification