Realize self-worth PHP transaction processing data implementation code

WBOY
Release: 2016-07-29 08:42:39
Original
1039 people have browsed it

Copy the code The code is as follows:


public function insertUser ($userArray){
foreach ($userArray as $key => $value) {
@$field .= "$key,";
@ $content .= "'$value',";
}
$field = ereg_replace(',$', '', $field);
$content = ereg_replace(',$', '', $content);
$db = db_connect(); //Connect to the database
$db->autocommit(FALSE); //Set to non-automatic commit - transaction processing
$sql1 = "INSERT INTO t_user (".$field.") VALUES (".$content.")";
$result1 = $db->query($sql1);
$sql2 = "INSERT INTO t_userpost (f_username) VALUES ('".$userArray['f_username']. "')";
$result2 = $db->query($sql2);
if ($result1 && $result2) {
$db->commit(); //All successful, submit the execution results
echo 'Submit';
} else {
$db->rollback(); //If any error occurs, roll back and cancel the execution result
echo 'Rollback';
}
$db->close();
}

The above introduces the PHP transaction processing data implementation code for realizing self-worth, including the content of realizing self-worth. I hope it will be helpful to friends who are interested in PHP tutorials.

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template