public function get_next_client_id() { //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); $next_id = $access->get_next_client_id(); //Validate whether order loading is successful or not. if ($access->m_status == false || $access->m_status_code == STATUS_FETCH_NO_DATA) { $container->show_failure_message = true; //Close the connection $mysqli_connection->close(); return $container; } $container->next_client_id = $next_id; return $container; }