PHP Database::Commit Examples

Programming Language: PHP

Class/Type: Database

Method/Function: Commit

Examples at hotexamples.com: 1

The PHP database commit command is used to save the changes made to a database after executing SQL queries or other database operations. When executed, all changes made during a database transaction are permanently saved, allowing other queries to access the updated data.

Example 1: Using the PDO Library

//Assuming a valid database connection has been established using $pdo
try {
  $pdo->beginTransaction();
  //Run some SQL queries
  $pdo->commit(); //Saves changes
} catch (PDOException $e) {
  $pdo->rollback(); //Undo all changes made
  echo "Error: " . $e->getMessage(); //Display a message to the user
}

In the example above, we use the PDO library to establish a database connection and execute some queries between the `beginTransaction()` and `commit()` methods. If any errors occur during the transaction, the `rollback()` method is used to undo all changes made.

Example 2: Using the mysqli Library

//Assuming a valid database connection has been established using $mysqli
$mysqli->autocommit(false); //Start a transaction
//Run some SQL query
//If errors occur, use $mysqli->rollback();
$mysqli->commit(); //Saves changes
$mysqli->autocommit(true); //End transaction

In this example, we use the mysqli library to execute a SQL query within a transaction. Before beginning the transaction, we disable autocommit mode with `$mysqli->autocommit(false)`. If no errors occur, we use `$mysqli->commit()` to save changes before re-enabling autocommit mode with `$mysqli->autocommit(true)`. In both examples, we use package libraries to access and manipulate databases in PHP. In the first example, we use the PDO library, while in the second example, we use the mysqli library. Both libraries allow us to connect to databases, execute queries, and handle transactions.

PHP Database::Commit - 1 examples found. These are the top rated real world PHP examples of Database::Commit from package testswarm extracted from open source projects. You can rate examples to help us improve the quality of examples.

Frequently Used Methods

Show Hide

query_insert(30)

Instance(30)

pDataConnect(30)

fetch(30)

Insert(30)

get_statistic_table(30)

commit(30)

obtain(30)

insert_id(30)

db(30)

connect(30)

select(30)

num_rows(30)

num_row(30)

close(30)

fetch_row(30)

update(30)

executeQuery(30)

execute(30)

fetchAll(30)

_instance(30)

resultset(30)

fetch_array(30)

sql2single(30)

fetch_object(30)

fetch_assoc(30)

sql2row(30)

sql2array(30)

prepare(30)

instance(30)

sql(30)

fetch_all_array(30)

get_course_table(30)

pexecute_first(30)

GetOne(30)

singleton(30)

pexecute(30)

single(30)

connection(30)

get(30)

getInstance(30)

store_result(30)

query(30)

exec(30)

query_update(30)

tDataConnect(30)

bind(30)

table(30)

getConnection(30)

get_main_table(30)

Database Class Documentation

Example #1

Show file

File: cronjobhandler.php Project: DomiStyle/Lightwork

// Get the cronjob
if (is_null($cronjob)) {
    $cronjobs = Lightwork::Cronjobs();
    // Get all cronjobs
    if (count($cronjobs) > 0) {
        Database::StartTransaction();
        // Start a new transaction to prevent query spam
        foreach ($cronjobs as $cronjob) {
            if (is_file(CRONJOB_DIR . $cronjob['path'] . '.php')) {
                execute($cronjob);
            } else {
                Lightwork::Log('Cronjob missing: ' . $cronjob['name']);
            }
            // ...if they exist.
        }
        Database::Commit();
        // Commit all the query timestamp updates
        Lightwork::Done(0, 'CRONJOBS_DONE');
        // We are done here, output proper exit code
    } else {
        Lightwork::Done(0, 'CRONJOBS_IDLE');
    }
    // No cronjobs were executed - we are idling
} else {
    if (isset($cronjob['status']) && isset($cronjob['message'])) {
        Lightwork::Done($cronjob['status'], $cronjob['message']);
    } else {
        if (is_file(CRONJOB_DIR . $cronjob['path'] . '.php')) {
            execute($cronjob);
            // Cronjob exists and we can execute it
            Lightwork::Done(0, 'CRONJOB_DONE');