function getUsernameByEmail($email) { $query = "select * from user_profile_details WHERE email='{$email}' "; $result_set = mysql_query($query); if (isQuerySuccess($result_set)) { if (mysql_num_rows($result_set) == 1) { $userProfile = mysql_fetch_array($result_set); $username = $userProfile['username']; return $username; } else { return ""; } } }
function getCVPathByUsername($username) { $query = "select * from user_cv WHERE username='******' "; $result_set = mysql_query($query); if (isQuerySuccess($result_set)) { if (mysql_num_rows($result_set) == 1) { $userCV = mysql_fetch_array($result_set); $userCVPath = $userCV['cv_file_path']; return $userCVPath; } else { return null; } } }
function singleSearch($tableName, $searchTerm, $searchTxt) { $counter = 0; $allUsernamesWithDuplicates = array(); $result_set = mysql_query("select * from " . $tableName . " where " . $searchTerm . " ='{$searchTxt}'"); if (isQuerySuccess($result_set)) { if (mysql_num_rows($result_set) > 0) { while ($result = mysql_fetch_assoc($result_set)) { $allUsernamesWithDuplicates[$counter] = $result['username']; $counter++; } } } $allUsernamesWithNoDuplicates = array_unique($allUsernamesWithDuplicates); return $allUsernamesWithNoDuplicates; }
function getProjectsListByUsername($username) { $projectsArray = array(); $query = "select * from user_project WHERE username='******' "; $result_set = mysql_query($query); if (isQuerySuccess($result_set)) { $recordCount = 0; if (mysql_num_rows($result_set) > 0) { while ($row = mysql_fetch_array($result_set)) { $projectsArray[$recordCount] = $row; $recordCount = $recordCount + 1; } } } return $projectsArray; }
function getAllUsernames() { $result_set = mysql_query("select * from user_login where status='NORMAL USER'"); if (isQuerySuccess($result_set)) { if (mysql_num_rows($result_set) > 0) { $usernames = array(); $counter = 0; while ($result = mysql_fetch_assoc($result_set)) { $usernames[$counter] = $result['username']; $counter++; } return $usernames; } else { return null; } } }
function signIn($username, $password) { if (hasNotSensitiveCharacters($username)) { if (hasNotSensitiveCharacters($password)) { $password = encodeString($password); $query = "select * from user_login WHERE username='******' AND password='******'"; $result_set = mysql_query($query); if (isQuerySuccess($result_set)) { if (mysql_num_rows($result_set) == 1) { $userLogin = mysql_fetch_array($result_set); $_SESSION['username'] = $userLogin['username']; redirect_to("userHome"); return ""; } else { return "Invalid Login details"; } } } else { return "Password has invalid characters"; } } else { return "Username has invalid characters"; } }
function isAdminAlreadyExists($username) { $query = "select * from user_login WHERE status='ADMIN USER' "; $result_set = mysql_query($query); if (isQuerySuccess($result_set)) { if (mysql_num_rows($result_set) > 0) { return true; } else { return false; } } }
function hasPicUploadedOnce($username) { $response = false; $query = "select * from user_profile_details WHERE username='******' "; $result_set = mysql_query($query); if (isQuerySuccess($result_set)) { if (mysql_num_rows($result_set) == 1) { $userProfile = mysql_fetch_array($result_set); $userProfilePicPath = $userProfile["picture_file_path"]; if ($userProfilePicPath != "") { $response = true; } } } return $response; }