<?php require_once 'model/client_details_info_access.php'; require_once 'controller/dbconfig.php'; //Create a container object which will hold complete information required to display the complete order page $container = new stdClass(); //Establish mysqli connection $mysqli_connection = new mysqli(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_DATABASE); if ($mysqli_connection->connect_errno) { echo "Failed to connect to MySQL: (" . $mysqli_connection->connect_errno . ") " . $mysqli_connection->connect_error; $container->show_failure_message = true; return $container; } //Set auto-commit to FALSE explicitly if (!$mysqli_connection->autocommit(FALSE)) { return; } $access = new ClientFormDetailsAccess($mysqli_connection); $access->getClientDetails();
public function load_all_client_form_details() { //Create a container object which will hold complete information required to display the complete order page $container = new stdClass(); //Establish mysqli connection $mysqli_connection = new mysqli(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_DATABASE); if ($mysqli_connection->connect_errno) { $container->show_failure_message = true; $container->error_message = "Failed to connect to MySQL: (" . $mysqli_connection->connect_errno . ") " . $mysqli_connection->connect_error; return $container; } $client_form_details_array = array(); $access = new ClientFormDetailsAccess($mysqli_connection); $client_form_details_array = $access->load_all_client_form_details(); //Validate whether order loading is successful or not. if ($access->m_status == false) { $container->show_failure_message = true; $container->error_message = "No Record found"; //Close the connection $mysqli_connection->close(); return $container; } $container->success = true; foreach ($client_form_details_array as $row) { // $json = json_decode($row['form_json_data'],true); // $json['id'] = $row['id']; // $json['status'] = $row['status']; // $json['timestamp'] = $row['timestamp']; $container->client_form_details_array[] = $row; } return $container; }
public function create_client_form_details($client_form_details) { //Create a container object which will hold complete information required to display the complete order page $container = new stdClass(); //Establish mysqli connection $mysqli_connection = new mysqli(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_DATABASE); if ($mysqli_connection->connect_errno) { echo "Failed to connect to MySQL: (" . $mysqli_connection->connect_errno . ") " . $mysqli_connection->connect_error; $container->show_failure_message = true; return $container; } //Set auto-commit to FALSE explicitly if (!$mysqli_connection->autocommit(FALSE)) { return; } $client_form_details_do = new ClientFormDetailsDO(); $client_form_details_do->m_client_id = $client_form_details->client_id; $client_form_details_do->m_form_json_data = $client_form_details->form_json_data; $client_form_details_do->m_timestamp = $client_form_details->timestamp; $client_form_details_do->m_status = $client_form_details->client_status; $access = new ClientFormDetailsAccess($mysqli_connection); $success = $access->create_client_form_details($client_form_details_do); //Validate whether order loading is successful or not. if ($success == false) { $container->show_failure_message = true; //Close the connection $mysqli_connection->close(); return $container; } if (!$mysqli_connection->commit()) { $container->show_failure_message = true; $container->failure_message = "Sorry for the Inconvenience. We are unable to cancel this Order."; $mysqli_connection->close(); return $container; } $container->success = true; return $container; }