本文整理汇总了PHP中mysqli_commit函数的典型用法代码示例。如果您正苦于以下问题：PHP mysqli_commit函数的具体用法？PHP mysqli_commit怎么用？PHP mysqli_commit使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了mysqli_commit函数的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: salvarProduto
public function salvarProduto($produto, $preco)
{
$codigo = $produto->getCodigo();
$nome = $produto->getNome();
$descricao = $produto->getDescricao();
$imagem = $produto->getUrlImagem();
$compra = $preco->getCompra();
$venda = $preco->getVenda();
$revenda = $preco->getReVenda();
/*
* conecta o banco de dados
*/
$con = new JqsConnectionFactory();
$link = $con->conectar();
$query = "INSERT INTO tb_produtos (codigo_produto, nome_produto, descricao_produto, url_imagem) \n\t\tvalues('{$codigo}', '{$nome}', '{$descricao}', '{$imagem}')";
$query2 = "INSERT INTO tb_precos (preco_compra, preco_venda, preco_revenda, id_produto_preco) \n\t\tvalues('{$compra}', '{$venda}', '{$revenda}', last_insert_id() )";
try {
mysqli_autocommit($link, FALSE);
mysqli_query($link, $query) or die(mysqli_error($link) . "Produto");
mysqli_query($link, $query2) or die(mysqli_error($link) . "Preço");
mysqli_commit($link);
mysqli_autocommit($link, TRUE);
} catch (Exception $e) {
mysqli_rollback($link);
echo $e;
}
}
开发者ID:jaquesoliveira，项目名称:preciata-gh，代码行数:27，代码来源:ProdutoDao.php
示例2: sql_transaction
function sql_transaction($status = 'begin')
{
switch ($status) {
case 'begin':
$result = @mysqli_autocommit($this->db_connect_id, false);
$this->transaction = true;
break;
case 'commit':
$result = @mysqli_commit($this->db_connect_id);
@mysqli_autocommit($this->db_connect_id, true);
$this->transaction = false;
if (!$result) {
@mysqli_rollback($this->db_connect_id);
@mysqli_autocommit($this->db_connect_id, true);
}
break;
case 'rollback':
$result = @mysqli_rollback($this->db_connect_id);
@mysqli_autocommit($this->db_connect_id, true);
$this->transaction = false;
break;
default:
$result = true;
}
return $result;
}
开发者ID:kidwellj，项目名称:scuttle，代码行数:26，代码来源:mysqli.php
示例3: _commit
/**
* DB transaction commit
* this method is private
* @return boolean
*/
function _commit()
{
$connection = $this->_getConnection('master');
mysqli_commit($connection);
$this->setQueryLog(array('query' => 'COMMIT'));
return true;
}
开发者ID:rhymix，项目名称:rhymix，代码行数:12，代码来源:DBMysqli_innodb.class.php
示例4: commit
public function commit()
{
if (!\mysqli_commit($this->connection)) {
throw new \Exception('Could not start Transaction: ' . \mysqli_error($this->connection));
}
return true;
}
开发者ID:webcraftmedia，项目名称:system，代码行数:7，代码来源:ConnectionMYS.php
示例5: updateInformation
function updateInformation($sql, $conn)
{
global $gpa, $degree, $school, $graduationDate, $resumeID, $additionalInfomation, $status, $resumeUserID;
try {
// Connect to database
if ($sql == "create") {
$userCreateSQL = "INSERT INTO Resume_Post (gpa,degree,school,graduationDate,resumeID,additionalInfomation,userID,status) VALUES (?,?,?,STR_TO_DATE( ? , '%Y-%m-%d'),?,?,?,?)";
$stmt = $conn->prepare($userCreateSQL);
$stmt->bind_param('ssssssss', $gpa, $degree, $school, $graduationDate, $resumeID, $additionalInfomation, $resumeUserID, $status);
} else {
$userUpdateSQL = "UPDATE Resume_Post SET gpa= ? , degree= ? , school= ?, graduationDate = STR_TO_DATE( ? , '%Y-%m-%d'), resumeID= ?, additionalInfomation= ?, status= ? WHERE resumeID= ? AND userID= ? ";
$stmt = $conn->prepare($userUpdateSQL);
$stmt->bind_param('sssssssss', $gpa, $degree, $school, $graduationDate, $resumeID, $additionalInfomation, $status, $resumeID, $resumeUserID);
}
//$sql = "UPDATE Resume_Post SET gpa= 3.96 , degree= 'bachelor' , school= 'UT', graduationDate = STR_TO_DATE( '2015-12-12' , '%Y-%m-%d'), resumeID= 2, additionalInfomation= 'No much', status= 1 WHERE resumeID= 2 AND userID= 'meng.da'";
//$conn->query($sql);
// Execute and Check Errors
$stmt->execute();
$err = $stmt->error;
if ($err) {
$conn->rollback();
$error_msg = "Some unknown database error occurred. Please inform database administrator with these error messages.<br>\nError message : " . $err . "<br>";
echo $error_msg;
return 0;
} else {
// Commit transaction
mysqli_commit($conn);
return 1;
}
} catch (mysqli_sql_exception $e) {
echo $e->__toString();
}
}
开发者ID:dm37537，项目名称:Career-Matcher，代码行数:33，代码来源:Resume.php
示例6: insertItems
public function insertItems(Items $items)
{
$con = self::openConnection();
$affected = 0;
mysqli_begin_transaction($con);
$stm = mysqli_stmt_init($con);
$sql = "INSERT INTO category VALUES (?, ?, ?)";
mysqli_stmt_prepare($stm, $sql);
foreach ($items->getItems() as $item) {
$code = $item->getCode();
$name = $item->getName();
$parent = $item->getParent() == null ? null : $item->getParent()->getCode();
mysqli_stmt_bind_param($stm, 'sss', $code, $name, $parent);
mysqli_stmt_execute($stm);
if (mysqli_affected_rows($con) == 1) {
$affected++;
}
}
if ($affected > 0) {
mysqli_commit($con);
} else {
mysqli_rollback($con);
}
return $affected;
}
开发者ID:Voww，项目名称:PHP_test_tasks，代码行数:25，代码来源:CategoryDAO.php
示例7: insertItems
public function insertItems(Items $items)
{
$con = self::openConnection();
$affected = 0;
mysqli_begin_transaction($con);
$stm = mysqli_stmt_init($con);
$sql = "INSERT INTO product VALUES (?, ?, ?, ?, ?, ?, ?, ?)";
mysqli_stmt_prepare($stm, $sql);
foreach ($items->getItems() as $item) {
$code = $item->getCode();
$articul = $item->getArticul();
$name = $item->getName();
$bmuID = $item->getBasicMeasurementUnit() == null ? null : $item->getBasicMeasurementUnit()->getId();
$price = $item->getPrice();
$curID = $item->getCurrency() == null ? null : $item->getCurrency()->getId();
$muID = $item->getMeasurementUnit() == null ? null : $item->getMeasurementUnit()->getId();
$parent = $item->getParent() == null ? null : $item->getParent()->getCode();
mysqli_stmt_bind_param($stm, 'sssdddds', $code, $articul, $name, $bmuID, $price, $curID, $muID, $parent);
mysqli_stmt_execute($stm);
if (mysqli_affected_rows($con) == 1) {
$affected++;
}
}
if ($affected > 0) {
mysqli_commit($con);
} else {
mysqli_rollback($con);
}
return $affected;
}
开发者ID:Voww，项目名称:PHP_test_tasks，代码行数:30，代码来源:ProductDAO.php
示例8: commit
public function commit()
{
if (phpversion() < '5.5.0') {
mysqli_autocommit($this->connection, TRUE);
}
// return mysqli_autocommit($this->connection, TRUE);
mysqli_commit($this->connection);
}
开发者ID:songfarm-david，项目名称:Songfarm，代码行数:8，代码来源:database.php
示例9: commit
public function commit()
{
if (mysqli_commit($this->connection)) {
mysqli_autocommit($this->connection, $this->autoCommit = true);
} else {
throw new Sabel_Db_Exception_Driver(mysql_error($this->connection));
}
}
开发者ID:reoring，项目名称:sabel，代码行数:8，代码来源:Driver.php
示例10: commit
public function commit()
{
if (mysqli_commit($this->conn)) {
mysqli_autocommit($this->conn, true);
} else {
throw new server_except('cannot commit transaction');
}
}
开发者ID:xpd1437，项目名称:swap，代码行数:8，代码来源:mysql_rdb.php
示例11: Commit
public function Commit()
{
if ($this->in_transazione) {
return mysqli_commit($this->conn);
} else {
return 0;
}
}
开发者ID:AlbertoArdu，项目名称:DistributedProgrammingExercises，代码行数:8，代码来源:ClassDB.php
示例12: commit
public function commit()
{
parent::commit();
if (!mysqli_commit($this->link)) {
$this->set_driver_error(null, PDO::ERRMODE_EXCEPTION, 'commit');
}
$this->setAttribute(PDO::ATTR_AUTOCOMMIT, 1);
return true;
}
开发者ID:Deepab23，项目名称:clinic，代码行数:9，代码来源:mysqli.php
示例13: commit
static function commit($con)
{
try {
$v = mysqli_commit($con);
if (!$v) {
throw new Exception("Error commit to database.");
}
} catch (Exception $e) {
REDLog::writeErrLog($e->getMessage());
}
}
开发者ID:Taruca，项目名称:lib，代码行数:11，代码来源:DatabaseManager.php
示例14: encerraTransacao
public function encerraTransacao($lErro)
{
$this->lTransacao = false;
if ($lErro) {
$lRetorno = mysqli_rollback($this->conn);
} else {
$lRetorno = mysqli_commit($this->conn);
}
$this->fecharConexao();
return $lRetorno;
}
开发者ID:ricardosander，项目名称:petshop，代码行数:11，代码来源:MySQL.php
示例15: query
function query($query, &$output)
{
$output = array();
$result = @mysqli_query($this->link, $query);
if (!$result) {
return FALSE;
}
if ($result !== TRUE) {
while ($row = mysqli_fetch_array($result)) {
$output[] = $row;
}
}
mysqli_commit($this->link);
return $output;
}
开发者ID:robertbanh，项目名称:mrmilestone，代码行数:15，代码来源:db.php
示例16: update
function update($columns, $values, $condition)
{
global $dbtable, $dbconn;
$query = "UPDATE " . $dbtable . " SET " . $columns . "=" . $values . " WHERE " . $condition . ";";
$op = mysqli_query($dbconn, $query);
if (!$op || $op === false) {
echo mysqli_error($dbconn) . "<br>";
var_dump($query);
echo "<br>";
var_dump($op);
echo "<br>";
return false;
}
mysqli_commit($dbconn);
return true;
}
开发者ID:JacquesFernandes，项目名称:code-dump，代码行数:16，代码来源:db.php
示例17: dbNewMessage
public function dbNewMessage($email, $name, $website, $message)
{
$email = mysqli_real_escape_string($this->link, $email);
$name = mysqli_real_escape_string($this->link, $name);
$website = mysqli_real_escape_string($this->link, $website);
$message = mysqli_real_escape_string($this->link, $message);
mysqli_autocommit($this->link, FALSE);
$query = "INSERT INTO CONTACT(pk_contact,name,email,website,message) \n\t\t\t\t VALUES('NULL','{$name}','{$email}','{$website}','{$message}')";
mysqli_query($this->link, $query);
if (mysqli_errno($this->link)) {
return -1;
} else {
mysqli_commit($this->link);
return 1;
}
}
开发者ID:a5216652166，项目名称:w2ssolutions，代码行数:16，代码来源:db.php
示例18: commandDataBase
function commandDataBase($sql)
{
$conn = new mysqli($this->servername, $this->username, $this->password, $this->dbname);
if ($conn->connect_error) {
die('Connection failed: ' . $conn->connect_error);
}
mysqli_autocommit($conn, FALSE);
if ($conn->query($sql) === TRUE) {
mysqli_commit($conn);
return true;
} else {
mysqli_rollback($conn);
return false;
}
$conn->close();
}
开发者ID:schnurli13，项目名称:Storytelling，代码行数:16，代码来源:mysqlModule.php
示例19: updateRecord
function updateRecord($arrayValues, $table, $condition, $autoCommit = "yes")
{
include_once 'connection.php';
mysqli_autocommit($conn, false);
$table_value = "";
if (empty($arrayValues)) {
echo "Incomplete Parameters Passed";
die;
}
if (!is_array($arrayValues)) {
echo "Parameter Passed is not an Array";
return false;
}
foreach ($arrayValues as $ind => $v) {
//$table_value .= $ind . "= '" . $v . "',";
$firstChar = substr($v, 0, 1);
if ($firstChar == '(') {
$table_value .= $ind . "= " . $v . ",";
} else {
$table_value .= $ind . "= '" . $v . "',";
}
}
$table_value = substr($table_value, 0, -1);
try {
$sql = "UPDATE {$table} SET {$table_value} WHERE {$condition}";
//Check if inserted to table, if not rollback
mysqli_query($conn, $sql);
if (mysqli_errno($conn)) {
$errno = mysqli_errno($conn);
mysqli_rollback($conn);
return "error";
} else {
if ($autoCommit == "yes") {
mysqli_commit($conn);
return true;
} else {
return true;
}
}
} catch (Exception $e) {
mysqli_rollback($conn);
return "error";
}
}
开发者ID:jimmarv，项目名称:comparch，代码行数:44，代码来源:save_instructions.php
示例20: insert_store_data
function insert_store_data($city_name)
{
global $con;
//read the json file contents
$URL = 'http://api.walmartlabs.com/v1/stores?apiKey=7hbsnck6acm8sh2nr8w4m3pc&city=' . $city_name . '&format=json';
//$URL= 'http://api.walmartlabs.com/v1/stores?apiKey=7hbsnck6acm8sh2nr8w4m3pc&city=newark&format=json';
$jsonResult = file_get_contents($URL);
print_r($jsonResult);
//convert json object to php associative array
$result = json_decode($jsonResult, true);
//print_r($result);
//$iCount=count($result);
for ($i = 0; $i < sizeof($result); $i++) {
$s_no = mysqli_real_escape_string($result[$i]["no"]);
$name = mysqli_real_escape_string($result[$i]["name"]);
$country = mysqli_real_escape_string($result[$i]['country']);
$lat = mysqli_real_escape_string($result[$i]['coordinates'][0]);
$long = mysqli_real_escape_string($result[$i]['coordinates'][1]);
$address = mysqli_real_escape_string($result[$i]['streetAddress']);
$state = mysqli_real_escape_string($result[$i]['stateProvCode']);
$city = mysqli_real_escape_string($result[$i]['city']);
$zip = mysqli_real_escape_string($result[$i]['zip']);
$phone = mysqli_real_escape_string($result[$i]['phoneNumber']);
$sunday_open = mysqli_real_escape_string($result[$i]['sundayOpen']);
$timezones = mysqli_real_escape_string($result[$i]['timezone']);
print_r($s_no);
print_r($lat);
print_r($long);
print_r($zip);
print_r($phone);
//insert into mysql table
/*$sql = "INSERT INTO `stores` (s_no,name,country,lat,long,address,city,state_code,zip,phone,sunday_open,timezones)
VALUES('" . $s_no . "', '" . $name . "', '" . $country . "', '" . $lat . "','" . $long . "', '" . $address . "', '" . $city . "', '" . $state . "', '" . $zip . "', '" . $phone . "', '" . $sunday_open . "','" . $timezones . "')";*/
mysqli_query($con, "INSERT INTO `store2` (s_no,name,country,lat,long,address,city,state_code,zip,phone,sunday_open,timezones)\n VALUES('" . $s_no . "', '" . $name . "', '" . $country . "', '" . $lat . "','" . $long . "', '" . $address . "', '" . $city . "', '" . $state . "', '" . $zip . "', '" . $phone . "', '" . $sunday_open . "','" . $timezones . "')");
/* if(!mysqli_query($con,$sql))
{
die('Error : Databse not copied' . mysql_error());
}*/
mysqli_commit($con);
echo "Copied to database sucessfully";
sleep(3);
}
}
开发者ID:rohankar，项目名称:walmart-monitor，代码行数:43，代码来源:store_api_db.php
注：本文中的mysqli_commit函数示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。 |
客服电话
APP下载
官方微信
请发表评论