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