public static function insertUser($email, $password, $first_name, $last_name, $phone_nbr, $facebook_id, $twitter_id, $google_id, $tumblr_id, $instagram_id, $img_url, $img_file_path) { if ((!is_string($email) || strlen($email) <= 0) && (!is_string($facebook_id) || strlen($facebook_id) <= 0)) { return MyUtil::fnOk(false, "email or facebook id must be valid - email:{$email}, fb:{$facebook_ids}", null); } $stm = "INSERT INTO " . self::$table_name . "(email,password,first_name,last_name,phone_nbr,facebook_id," . "twitter_id,google_id,tumblr_id,instagram_id,img_url,img_file_path,updated_ts) VALUES (" . "nullIf('" . MyUtil::nvl($email, "") . "', ''), " . "nullIf('" . MyUtil::nvl(MyUtil::myCrypt($password), "") . "', ''), " . "nullIf('" . MyUtil::nvl($first_name, "") . "', ''), " . "nullIf('" . MyUtil::nvl($last_name, "") . "', ''), " . "nullIf('" . MyUtil::nvl($phone_nbr, "") . "', ''), " . "nullIf('" . MyUtil::nvl($facebook_id, "") . "', ''), " . "nullIf('" . MyUtil::nvl($twitter_id, "") . "', ''), " . "nullIf('" . MyUtil::nvl($google_id, "") . "', ''), " . "nullIf('" . MyUtil::nvl($tumblr_id, "") . "', ''), " . "nullIf('" . MyUtil::nvl($instagram_id, "") . "', ''), " . "nullIf('" . MyUtil::nvl($img_url, "") . "', ''), " . "nullIf('" . MyUtil::nvl($img_file_path, "") . "', ''), " . "CURRENT_TIMESTAMP " . ")"; $result = ConnDB::query_db($stm); if (!$result) { return MyUtil::fnOk(false, "SQL Error", null); } return MyUtil::fnOk(true, "User Inserted", $result); }