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