Construisez un site Web

Adjust PHP code:

I am running a Dating website. The current code filter menbesr by:

-gender

-sexual interest

-country and city

-new or older

I want to add age range filter. I need someone to edit the code below. I will add $agemin and $agemax in the current database and i will adjust by myself the form.

Thanks.

// Filter

$filter = $db->query("SELECT * FROM filters WHERE user_id='".$user->id."'");

$num_rows = $filter->num_rows;

if($num_rows >= 1) {

$filter = $filter->fetch_object();

} else {

$filter = new stdClass();

$filter->sexual_preference = 3;

$filter->sexual_orientation = 1;

$filter->country = 'All Countries';

$filter->city = '';

$filter->order_by = 4;

}

// Create / Update Filter

if(isset($_POST['filter'])) {

$sexual_preference = $_POST['sexual_preference'];

$sexual_orientation = $_POST['sexual_orientation'];

$country = $_POST['country'];

$order_by = $_POST['order_by'];

$city = $_POST['city'];

if($num_rows == 0) {

$db->query("INSERT INTO filters (user_id,sexual_preference,country,order_by,city,sexual_orientation) VALUES ('".$user->id."','".$sexual_preference."','".$country."','".$order_by."','".$city."','".$sexual_orientation."')");

header('Location: '.$system->getDomain().'/people');

exit;

} else {

$db->query("UPDATE filters SET sexual_preference='".$sexual_preference."',country='".$country."',order_by='".$order_by."',city='".$city."',sexual_orientation='".$sexual_orientation."' WHERE user_id='".$user->id."'");

header('Location: '.$system->getDomain().'/people');

exit;

}

}

// Format Query

switch ($filter->sexual_preference) {

case 1:

$gender = 'WHERE gender=\'Male\'';

break;

case 2:

$gender = 'WHERE gender=\'Female\'';

break;

case 3:

$gender = 'WHERE gender IS NOT NULL';

break;

default:

$gender = 'WHERE gender IS NOT NULL';

break;

}

switch ($filter->sexual_orientation) {

case 1:

$sexual_orientation = 'AND sexual_interest=\'1\'';

break;

case 2:

$sexual_orientation = 'AND sexual_interest=\'2\'';

break;

case 3:

$sexual_orientation = 'AND sexual_interest=\'3\'';

break;

case 4:

$sexual_orientation = 'AND sexual_interest=\'4\'';

break;

default:

$sexual_orientation = 'AND country LIKE \'%'.$filter->sexual_orientation.'%\'';

break;

}

switch ($filter->country) {

case 'All Countries':

$country = 'AND country IS NOT NULL';

break;

default:

$country = 'AND country LIKE \'%'.$filter->country.'%\'';

break;

}

$city = 'AND city LIKE \'%'.$filter->city.'%\'';

switch ($filter->order_by) {

case 1:

$order = 'ORDER BY id DESC';

break;

case 2:

$order = 'ORDER BY id ASC';

break;

case 3:

$order = 'ORDER BY last_active DESC';

break;

case 4:

$order = 'ORDER BY RAND()';

break;

default:

$order = 'ORDER BY RAND()';

break;

}

if(!isset($_POST['search'])) {

$query = '';

$people = "SELECT * FROM users $gender $sexual_orientation $country $me $city AND id != ".$user->id." $order";

} else {

$query = ucfirst(strtolower($system->secureField($_POST['query'])));

$people = "SELECT * FROM users WHERE full_name LIKE '%".$query."%' AND id != ".$user->id."";

}

MySQL PHP

Nº del proyecto: #9847581

Sobre el proyecto