PHP rollback() function (with example)

Hi there,

I'd like to share my own experience using the rollback() function in PHP. In my recent project, I was working on a booking system for a hotel website. When a customer made a reservation, I needed to ensure that the room availability and user bookings were updated simultaneously.

To achieve this, I implemented a transaction with rollback() to handle potential errors. Here's a glimpse of how I incorporated it into my code:

php
// Initiate the transaction

$db->beginTransaction();



try {

    // Update room availability

    $db->query("UPDATE rooms SET availability = availability - 1 WHERE room_id = :room_id");



    // Add a booking for the user

    $db->query("INSERT INTO bookings (user_id, room_id, check_in_date, check_out_date) VALUES (:user_id, :room_id, :check_in, :check_out)");



    // If everything succeeded, commit the changes

    $db->commit();

    

    echo "Transaction successful! Room booked.";

} catch (Exception $e) {

    // In case of an error, rollback the changes

    $db->rollback();

    

    echo "Sorry, the booking process failed. Please try again later.";

}

Related Topics

• PHP refresh() function (with example)
• PHP debug() function (with example)
• PHP reap_async_query() function (with example)
• PHP thread_id() function (with example)
• PHP affected_rows() function (with example)
• PHP poll() function (with example)
• PHP fetch_field() function (with example)
• PHP get_connection_stats() function (with example)
• PHP real_connect() function (with example)
• PHP thread_safe() function (with example)

Hey there,

I've used the rollback() function in PHP for database transactions, so hopefully, I can shed some light on it for you. The rollback() function is used to undo changes made to the database within a transaction if an error occurs or if you explicitly decide to roll back the changes.

Let me explain with an example to make it clearer. Suppose you have a scenario where you update the inventory and order status tables in your database within a transaction. Here's how you can use rollback() to handle potential errors:

php
// Begin the transaction

$db->beginTransaction();



try {

    // Perform your database operations here, like updating the inventory and order status

    

    // If all is successful, commit the changes

    $db->commit();

    

    echo "Transaction successful!";

} catch (Exception $e) {

    // If an error occurs, rollback the changes

    $db->rollback();

    

    echo "Transaction failed: " . $e->getMessage();

}

Hey folks,

I've had my fair share of experience with the rollback() function in PHP, and I must say it saved me from some tricky situations. It's a handy feature when dealing with database transactions.

To give you a personal example, I was working on a web application where users could buy and sell items. Whenever a user made a purchase, the system would deduct the item from the inventory and update the user's balance accordingly. I needed to ensure that both actions were performed correctly or not at all.

In this particular case, I implemented a transaction using the rollback() function to handle errors gracefully. Here's a snippet of how I used it:

php
$db->beginTransaction();



try {

    // Update the inventory

    $db->query("UPDATE inventory SET quantity = quantity - 1 WHERE item_id = :item_id");



    // Update the user's balance

    $db->query("UPDATE users SET balance = balance - :price WHERE user_id = :user_id");



    // If everything went smoothly, commit the changes

    $db->commit();

    

    echo "Transaction successful!";

} catch (Exception $e) {

    // If any error occurred, rollback changes

    $db->rollback();

    

    echo "Transaction failed. Please try again later.";

}

More Topics Related to PHP

• What are the recommended PHP versions for different operating systems?
• Can I install PHP without root/administrator access?
• How can I verify the integrity of the PHP installation files?
• Are there any specific considerations when installing PHP on a shared hosting environment?
• Is it possible to install PHP alongside other programming languages like Python or Ruby?

More Topics Related to Usage

• Can I install PHP without root/administrator access?
• How can I install PECL extensions on a Unix system using the pecl command?
• How do I declare a union type in PHP?
• class - What does the variable $this mean in PHP?
• What is the purposes symbol @ in PHP $variable at blade laravel 5?

More Topics Related to Updates

• How can I ensure PHP installations remain up to date with the latest security patches and bug fixes?
• How can I manage and update installed PECL extensions?
• How do I handle errors related to database transactions or concurrency in PHP?
• What are some common challenges faced by PHP developers in their day-to-day work?
• PHP rollback() function (with example)