function doLogin($user_id, $user_pass)
{
$connect = getDatabaseConnection();
// See if the user is in the database
$query = sprintf("SELECT * from user_access where lower(user_id) = lower('%s') and user_pass = '******'", mysql_real_escape_string($user_id), mysql_real_escape_string($user_pass));
$result = mysql_query($query);
$num = mysql_num_rows($result);
if ($num > 0) {
// Generate a GUID
$result = mysql_query("select uuid() as unique_id");
$retVal = mysql_result($result, 0, "unique_id");
mysql_query("update user_access set user_session_uuid='" . $retVal . "', last_access_datetime=utc_timestamp()");
} else {
$retVal = null;
}
closeDatabaseConnection($connect);
return $retVal;
}
function doInsertSmtp($username, $password, $host, $port, $security)
{
# Open Database Connection.
$conDatabase = openDatabaseConnection();
# Get the data from database.
$query = "insert into smtpmail(host,port,security,username,password)" . " value('" . $host . "'," . $port . ",'" . $security . "','" . $username . "','" . $password . "')";
mysqli_query($conDatabase, $query);
# Close database connection.
closeDatabaseConnection($conDatabase);
}
session_start();
error_reporting(E_ERROR);
ini_set('display_errors', 1);
require_once "config/database.php";
function connectToDatabase()
{
$con = mysqli_connect($GLOBALS['DATABASE_SERVER_HOST'], $GLOBALS['DATABASE_SERVER_USERNAME'], $GLOBALS['DATABASE_SERVER_PASSWORD'], $GLOBALS['DATABASE_NAME']);
if (mysqli_connect_errno()) {
die("Failed to connect to MySQL: " . mysqli_connect_error());
}
return $con;
}
function closeDatabaseConnection($con)
{
mysqli_close($con);
}
function loadRoutes()
{
return Routes::getRoutes();
}
function runApp($con, $routes)
{
$config = array();
$app = new App($con, $config, $routes);
echo $app->run();
}
$con = connectToDatabase();
$routes = loadRoutes();
runApp($con, $routes);
closeDatabaseConnection($con);
