function getDBConnection()
{
global $mysqli;
Logger::logEntry(__FILE__, __FUNCTION__);
if ($mysqli == null) {
$mysqli = new mysqli(TMConfig::$mysqlHost, TMConfig::$mysqlUser, TMConfig::$mysqlPassword, TMConfig::$mysqlDatabase);
if ($mysqli->connect_error > 0) {
die('Connect Error(' . $mysqli->connect_errno . ') ' . $mysqli->connect_error);
}
}
Logger::logMsg(__FILE__, __FUNCTION__, "host is - " + TMConfig::$mysqlHost);
Logger::logExit(__FILE__, __FUNCTION__, true);
return $mysqli;
}
/**
* createUser
* creates a user entry in the database
*
* @param type $userDetails
* @return type uid
*/
public static function createUser($uname, $password, $email, $fname, $lname, $phone, $addr1, $addr2, $city, $state, $zip, $vToken)
{
Logger::logEntry(__FILE__, __FUNCTION__);
// This method assumes all the data validation has been done at
// higher layers
// register new user
$db = getDBConnection();
$qstr = "INSERT INTO USERS ";
$qstr .= "(USERNAME, PASSWD, EMAIL, USERLASTNAME, USERFIRSTNAME, PHONE, ";
$qstr .= "ADDRESSLINE1, ADDRESSLINE2, CITY, STATE, POSTALCODE, ACTIVATIONCODE";
$qstr .= ") VALUES (";
$qstr .= "'{$uname}', '{$password}', '{$email}', '{$lname}', '{$fname}', '{$phone}', '{$addr1}', '{$addr2}', '{$city}', '{$state}', '{$zip}', '{$vToken}'";
$qstr .= ")";
$rs = $db->query($qstr);
if ($rs !== TRUE) {
// TODO throw exception
// echo "Error: " . $rs->error;
}
}
