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;
}
