Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // init your db here
- // set all parameters that will be inserted here staticly
- $statement = $_local_connection->prepare("
- INSERT INTO $takeaway_ordersssss_url
- (
- `user_id`,
- `user_ip`,
- `order_price`,
- `tax`,
- `shipping_cost`,
- `total_price`,
- `date`,
- `total_discount`,
- `payment_memo`,
- `pay_pal_fee`,
- `payment_option`,
- `requested_date`,
- `requested_time`,
- `randomer`
- ) VALUES (
- :user_id,
- :user_ip,
- :order_price,
- :tax,
- :shipping_cost,
- :total_price,
- :date,
- :total_discount,
- :payment_memo,
- :pay_pal_fee,
- :payment_option,
- :requested_date,
- :requested_time,
- :randomer
- )
- ");
- $insert_array=array(
- ':user_id' => $user_details["id"],
- ':user_ip' => "$visitorip",
- ':order_price' => "",
- ':tax' => "$tax",
- ':shipping_cost' => "",
- ':total_price' => "$total_price",
- ':date' => time(),
- ':total_discount' => "$total_discount",
- ':payment_memo' => $this->_request_holder['params']["order_note"],
- ':pay_pal_fee' => "$pay_pal_fee",
- ':payment_option' => $this->_request_holder['params']["payment_option"],
- ':requested_date' => $this->_request_holder['params']["requested_date"],
- ':requested_time' => $this->_request_holder['params']["requested_time"],
- ':randomer' => $_SESSION["randomer"]
- );
- $statement->execute($insert_array);
- $order_id=$_local_connection->lastInsertId();
- $statement->closeCursor();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement