maxdb_commit
maxdb::commit
(PECL maxdb >= 1.0)
maxdb_commit -- maxdb::commit — Commits the current transaction
Description
Procedural style
bool maxdb_commit
( resource
$link
)Object oriented style
bool maxdb::commit
( void
)
Commits the current transaction for the database connection specified by the
link
parameter.
Return Values
Returns TRUE
on success or FALSE
on failure.
Examples
Example #1 Object oriented style
<?php
$maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");
/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s\n", maxdb_connect_error());
exit();
}
/* set autocommit to off */
$maxdb->autocommit(FALSE);
maxdb_report (MAXDB_REPORT_OFF);
$maxdb->query("DROP TABLE mycustomer");
maxdb_report (MAXDB_REPORT_ERROR);
$maxdb->query("CREATE TABLE mycustomer LIKE hotel.customer");
/* Insert some values */
$maxdb->query("INSERT INTO mycustomer VALUES (3000,'Mrs','Jenny','Porter','10580','1340 N.Ash Street, #3')");
$maxdb->query("INSERT INTO mycustomer VALUES (3100,'Mr','Peter','Brown','48226','1001 34th Str., APT.3')");
/* commit transaction */
$maxdb->commit();
/* close connection */
$maxdb->close();
?>
Example #2 Procedural style
<?php
$link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");
/* check connection */
if (!$link) {
printf("Connect failed: %s\n", maxdb_connect_error());
exit();
}
/* set autocommit to off */
maxdb_autocommit($link, FALSE);
maxdb_report (MAXDB_REPORT_OFF);
maxdb_query($link,"DROP TABLE mycustomer");
maxdb_report (MAXDB_REPORT_ERROR);
maxdb_query($link, "CREATE TABLE mycustomer LIKE hotel.customer");
/* Insert some values */
maxdb_query($link, "INSERT INTO mycustomer VALUES (3000,'Mrs','Jenny','Porter','10580','1340 N.Ash Street, #3')");
maxdb_query($link, "INSERT INTO mycustomer VALUES (3100,'Mr','Peter','Brown','48226','1001 34th Str., APT.3')");
/* commit transaction */
maxdb_commit($link);
/* close connection */
maxdb_close($link);
?>
The above examples produces no output.
See Also
- maxdb_autocommit() - Turns on or off auto-commiting database modifications
- maxdb_rollback() - Rolls back current transaction
- PHP Руководство
- Функции по категориям
- Индекс функций
- Справочник функций
- Расширения для работы с базами данных
- Расширения для работы с базами данных отдельных производителей
- MaxDB
- maxdb_affected_rows
- maxdb_autocommit
- maxdb_bind_param
- maxdb_bind_result
- maxdb_change_user
- maxdb_character_set_name
- maxdb_client_encoding
- maxdb_close_long_data
- maxdb_close
- maxdb_commit
- maxdb_connect_errno
- maxdb_connect_error
- maxdb_connect
- maxdb_data_seek
- maxdb_debug
- maxdb_disable_reads_from_master
- maxdb_disable_rpl_parse
- maxdb_dump_debug_info
- maxdb_embedded_connect
- maxdb_enable_reads_from_master
- maxdb_enable_rpl_parse
- maxdb_errno
- maxdb_error
- maxdb_escape_string
- maxdb_execute
- maxdb_fetch_array
- maxdb_fetch_assoc
- maxdb_fetch_field_direct
- maxdb_fetch_field
- maxdb_fetch_fields
- maxdb_fetch_lengths
- maxdb_fetch_object
- maxdb_fetch_row
- maxdb_fetch
- maxdb_field_count
- maxdb_field_seek
- maxdb_field_tell
- maxdb_free_result
- maxdb_get_client_info
- maxdb_get_client_version
- maxdb_get_host_info
- maxdb_get_metadata
- maxdb_get_proto_info
- maxdb_get_server_info
- maxdb_get_server_version
- maxdb_info
- maxdb_init
- maxdb_insert_id
- maxdb_kill
- maxdb_master_query
- maxdb_more_results
- maxdb_multi_query
- maxdb_next_result
- maxdb_num_fields
- maxdb_num_rows
- maxdb_options
- maxdb_param_count
- maxdb_ping
- maxdb_prepare
- maxdb_query
- maxdb_real_connect
- maxdb_real_escape_string
- maxdb_real_query
- maxdb_report
- maxdb_rollback
- maxdb_rpl_parse_enabled
- maxdb_rpl_probe
- maxdb_rpl_query_type
- maxdb_select_db
- maxdb_send_long_data
- maxdb_send_query
- maxdb_server_end
- maxdb_server_init
- maxdb_set_opt
- maxdb_sqlstate
- maxdb_ssl_set
- maxdb_stat
- maxdb_stmt_affected_rows
- maxdb_stmt_bind_param
- maxdb_stmt_bind_result
- maxdb_stmt_close_long_data
- maxdb_stmt_close
- maxdb_stmt_data_seek
- maxdb_stmt_errno
- maxdb_stmt_error
- maxdb_stmt_execute
- maxdb_stmt_fetch
- maxdb_stmt_free_result
- maxdb_stmt_init
- maxdb_stmt_num_rows
- maxdb_stmt_param_count
- maxdb_stmt_prepare
- maxdb_stmt_reset
- maxdb_stmt_result_metadata
- maxdb_stmt_send_long_data
- maxdb_stmt_sqlstate
- maxdb_stmt_store_result
- maxdb_store_result
- maxdb_thread_id
- maxdb_thread_safe
- maxdb_use_result
- maxdb_warning_count
Коментарии
404 Not Found