pdo prepare multiple queries

Solutions on MaxInterview for pdo prepare multiple queries by the best coders in the world

Search
showing results for - "pdo prepare multiple queries"
Adelia
30 Apr 2017
1<?php
2
3
4
5try {
6
7        $db = new Database(); //Create a new object of type Database establishing a connection to the MySQL database
8
9
10        $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)");
11
12        $query->execute(array( /* your values*/ ));
13
14
15        $lastId = $db->lastInsertId(); // fetch last insert id, after success.
16
17
18        $order = $db->prepare("SELECT * FROM `orders` WHERE `ID`=?");
19        $order->bindValue(1, $lastId);
20        $order->execute();
21        //Fetch your records and display.
22
23
24}
25catch (PDOException $e) {
26        echo "Error : " . $e->getMessage();
27
28}
29
30?>
31
source
similar questions
php pdo last insert idphp mysql select data pdophp mysqli connect to two databases pdofetch multiple rows in phpphp my sql prepare bind param with multiple statementsphp query pdophp pdo howto columns from tablehow to insert multiple json data into mysql database in phpphp pdo random multiple insert queryphp pdo multiple insertphp pdo has resultphp pdo prepare doesn 27t workupdate number in sql pdo php not workingphp pdo transactionget the number of affected rows in php using pdo update statementphp pdo check if update query successfulsql row count php pdophp pdo check if record exists before insertphp pdo sql server connectpdo preparephp update multiple columnsphp execute 2 queries
queries leading to this page
pdo prepared statement multiple insertpdo multiple queriespdo prepare multiple queries