Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function send_order_message(){
- $_dns = 'mysql:host=localhost;dbname='.$this->_APP_HOSTING['mysql_database'];
- $_local_connection =
- new PDO($_dns, $this->_APP_HOSTING['mysql_user'], $this->_APP_HOSTING['mysql_password_dec'],
- array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'utf8'")
- );
- $_local_connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- $takeaway_messages_url=$this->_APP_HOSTING["mysql_prefix"]."_order_notes";
- $statement = $_local_connection->prepare("
- INSERT INTO $takeaway_messages_url (
- `order_id`,
- `message`,
- `time`
- ) VALUES (
- :order_id,
- :message,
- :time
- )");
- $insert_array=array(
- ':order_id' => $this->_request_holder['params']["order_id"],
- ':message' => $this->_request_holder['params']["message"],
- ':time' => time(),
- //':staff_id' => $user_details["id"],
- );
- $statement->execute($insert_array);
- // return $statement->errorInfo();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement