Pdo prepare multiple queries

<?php



try {

        $db = new Database(); //Create a new object of type Database establishing a connection to the MySQL database


        $query = $db->prepare("INSERT INTO orders (order_type`, `item`, `amount`, `price`, `price_btc`, `status`, `timestamp`, `placed_by`, `secret`, `first_name`, `last_name`, `address_1`, `address_2`, `city`, `zip_code`, `country`, `state`, `phone_number`) VALUES(:order_type, :item, :amount, :price, :price_btc, :status, :timestamp, :placed_by, :secret, :first_name, :last_name, :address_1, :address_2, :city, :zip_code, :country, :state, :phone_number)");

        $query->execute(array( /* your values*/ ));


        $lastId = $db->lastInsertId(); // fetch last insert id, after success.


        $order = $db->prepare("SELECT * FROM `orders` WHERE `ID`=?");
        $order->bindValue(1, $lastId);
        $order->execute();
        //Fetch your records and display.


}
catch (PDOException $e) {
        echo "Error : " . $e->getMessage();

}

?>

Source: stackoverflow.com

Similar codes

2 votes177 views3 answers
How to share a helper globally laravel
PHP Laravel
1 vote154 views2 answers
Fillable vs guarded laravel
PHP
25 votes146 views10 answers
Bootstrap
PHP
0 vote108 views1 answer
Refresh laravel model
PHP
1 vote170 views3 answers
Make model factory and controller laravel
PHP Laravel
0 vote167 views4 answers
How to redirect to another page after login in laravel
PHP Laravel
7 votes274 views5 answers
Codeigniter count rows
PHP CodeIgniter
1 vote158 views2 answers
Smarty php
PHP
0 vote195 views1 answer
Codeigniter 3 Get future date recocords - upcoming records from database
PHP CodeIgniter
1 vote166 views2 answers
Allowed memory size of 1610612736 bytes exhausted (tried to allocate 4096 bytes) in phar://D:/Program Files/Composer - PHP/composer.phar/src/Composer/DependencyResolver/Solver.php on line 223
PHP