function getSearchResults($searchTxt, $searchTermComboVal) { if (hasNotSensitiveCharacters($searchTxt)) { if ($searchTermComboVal == "All Terms") { $searchResults = allSearch($searchTxt); return $searchResults; } else { $tableArray = array("user_profile_details", "user_profile_details", "user_profile_details", "user_profile_details", "user_profile_details", "user_profile_details", "user_profile_details"); $columnArray = array("first_name", "last_name", "username", "email", "country", "contact_number", "gender"); $comboValuesArray = array("First Name", "Last Name", "Username", "Email", "Country", "Contact Number", "Gender"); $counter = 0; foreach ($comboValuesArray as $comboValue) { if ($searchTermComboVal == $comboValue) { $searchResults = singleSearch($tableArray[$counter], $columnArray[$counter], $searchTxt); return $searchResults; } $counter++; } return null; } } }
function sendMail($email) { if (hasNotSensitiveCharacters($email)) { $userLoginDetails = getLoginDetails($email); if (isset($userLoginDetails)) { $usernameToSent = $userLoginDetails['username']; $pwToSent = $userLoginDetails['password']; $pwToSent = decodeString($pwToSent); $subject = "Your Login Details"; $message = "Here are your login details <br><br> Username : "******"<br> Password :"******"<br>"; $from = "*****@*****.**"; $headers = "From: {$from}"; // P.S php.ini file should be modified according to use mail function - // More reference on configuring the php,ini file - http://www.w3schools.com/php/php_ref_mail.asp mail($email, $subject, $message, $headers); $_SESSION['forgotPW'] = "An email has sent. <br>Check your email inbox"; redirect_to("home"); return "<font color=green>An email has sent.Redirecting to home page....</font>"; } } else { return "<font color=red>Email has Invalid characters</font>"; } }
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 addUser($username, $email, $firstname, $lastname, $gender, $address1, $address2, $country, $contactnumber, $password) { if (hasNotSensitiveCharacters($username)) { if (hasNotSensitiveCharacters($email)) { if (hasNotSensitiveCharacters($firstname)) { if (hasNotSensitiveCharacters($lastname)) { if (hasNotSensitiveCharacters($gender)) { if (hasNotSensitiveCharacters($address1)) { if (hasNotSensitiveCharacters($address2)) { if (hasNotSensitiveCharacters($country)) { if (hasNotSensitiveCharacters($contactnumber)) { if (hasNotSensitiveCharacters($password)) { if ($gender != "Select a gender" && $country != "Select a country") { if (!(isUserExistsByUsername($username) || isUserExistsByEmail($email))) { if (isNonFetchQuerySuccess("INSERT INTO user_profile_details (username, first_name, last_name,gender,address_line1,country,email,address_line2,picture_file_path,contact_number) VALUES ('{$username}', '{$firstname}','{$lastname}' , '{$gender}' , '{$address1}', '{$country}', '{$email}', '{$address2}', '', '{$contactnumber}')")) { $password = encodeString($password); if (isAdminAlreadyExists($username)) { isNonFetchQuerySuccess("INSERT INTO user_login (username, password , status) VALUES ('{$username}', '{$password}', 'NORMAL USER')"); } else { isNonFetchQuerySuccess("INSERT INTO user_login (username, password , status) VALUES ('{$username}', '{$password}', 'ADMIN USER')"); } $_SESSION['firstSignIn'] = "Successfully signed up! <br> Now you can login here"; redirect_to("home"); } else { return "Registration Failed"; } } else { if (isUserExistsByUsername($username)) { return "Username is not available"; } else { if (isUserExistsByEmail($email)) { return "Email already exists"; } } } } } else { return "Password has Invalid characters"; } } else { return "Contact number has Invalid characters"; } } else { return "Country has Invalid characters"; } } else { return "Address Line 2 has Invalid characters"; } } else { return "Address Line 1 has Invalid characters"; } } else { return "Gender has Invalid characters"; } } else { return "Last name has Invalid characters"; } } else { return "First name has Invalid characters"; } } else { return "Email has Invalid characters"; } } else { return "Username has Invalid characters"; } }
function updateUserPassWord($username, $currentPassword, $newPassword) { if (hasNotSensitiveCharacters($currentPassword)) { if (hasNotSensitiveCharacters($newPassword)) { $currentPassword = encodeString($currentPassword); $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) { $newPassword = encodeString($newPassword); isNonFetchQuerySuccess("UPDATE user_login SET password = '******' WHERE username = '******' "); return "<font color=green>Password is changed successfully</font>"; } else { return "<font color=red>Invalid current password</font>"; } } } else { return "<font color=red>Invalid new password</font>"; } } else { return "<font color=red>Invalid current password</font>"; } }