MysqliDb::startTransaction PHP Method

startTransaction() public method

Begin a transaction
public startTransaction ( )
    public function startTransaction()
    {
        $this->mysqli()->autocommit(false);
        $this->_transaction_in_progress = true;
        register_shutdown_function(array($this, "_transaction_status_check"));
    }

Usage Example

コード例 #1
0
/**
 * @description Modifica una sucursal
 * @param $sucursal
 */
function updateSucursal($sucursal)
{
    $db = new MysqliDb();
    $db->startTransaction();
    $sucursal_decoded = checkSucursal(json_decode($sucursal));
    $db->where('sucursal_id', $sucursal_decoded->sucursal_id);
    $data = array('nombre' => $sucursal_decoded->nombre, 'direccion' => $sucursal_decoded->direccion, 'telefono' => $sucursal_decoded->telefono);
    $result = $db->update('sucursales', $data);
    if ($result) {
        $db->commit();
        echo json_encode($result);
    } else {
        $db->rollback();
        echo json_encode(-1);
    }
}
All Usage Examples Of MysqliDb::startTransaction