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