public function getSender($conversation_id)
{
$query = "SELECT sender FROM conversation_reply WHERE conversationId = '{$conversation_id}'";
$senderId = Database::getResultSetAsArray($query);
for ($row = 0; $row < count($senderId); $row++) {
return $senderId[$row]['sender'];
}
}
public function resetPassword($old, $new, $confirmNew)
{
if (strcmp($new, $confirmNew) === 0) {
$query = "SELECT password, salt FROM users WHERE username = '******'USERNAME'] . "'";
$arrayValues = parent::getResultSetAsArray($query);
for ($row = 0; $row < count($arrayValues); $row++) {
$db_password = $arrayValues[$row]['password'];
$db_salt = $arrayValues[$row]['salt'];
}
$hashedOld = $this->hashPassword($old, $db_salt);
if (strcmp($hashedOld, $db_password) === 0) {
$newSalt = $this->generateSalt($new, $_SESSION['USERNAME']);
$newHashedPass = $this->hashPassword($new, $newSalt);
$updatePass = "******" . $_SESSION['USERNAME'] . "'";
parent::executeSqlQuery($updatePass);
echo "Password changed successfully";
} else {
echo "your old pass is wrong! please retype it";
}
} else {
echo "confirmation failed";
}
}
public function searchSpecific($get)
{
$typeOfDeal = $get['type'];
$rooms = $get['rooms'];
$baths = $get['baths'];
$max_price = $get['price'];
$kindOfPlace = $get['place'];
$query = "SELECT * FROM dwellings INNER JOIN apartment_images \n ON dwellings.dwelling_Id = apartment_images.dwelling_Id\n WHERE \n\t \t\t\t rangeType = '{$typeOfDeal}' AND \n\t \t\t\t no_of_rooms \t = '{$rooms}' \t AND \n\t \t\t\t no_of_bathrooms = '{$baths}'\t AND\n\t \t\t\t price \t\t\t < '{$max_price}' AND\n\t \t\t\t type = '{$kindOfPlace}'";
return parent::getResultSetAsArray($query);
}
