par
cyci60 » 19 déc. 2019, 12:07
Bonjour, je voudrais afficher que les villes déjà consultées par l'internaute uniquement dans sa session.
Merci d'avance pour votre aide.
if(isset($_POST['submit_form'])) {
$search_city_form = $_POST['search_city_form'];
if(empty($search_city_form)) {
$message = '<p>Veuillez remplir le champ !</p>';
}
else {
$result = $mysqli->query('SELECT city_id, city_name FROM city WHERE city_name = "' . $search_city_form . '"');
$row = $result->fetch_array();
$city_id = $row['city_id'];
$city_name = $row['city_name'];
$city[$city_id] = $city_name;
if(!isset($city_name)) {
$message = '<p class="error">Veuillez rentrer les villes comme Los Angeles, Paris, Londres ou Sydney!</p>';
}
else {
$mysqli->query('INSERT INTO user_search (user_city, user_name) VALUES("' . $search_city_form . '" , "' . $user_name . '")');
$result = $mysqli->query('SELECT user_id, user_city, user_name FROM user_search');
while($row = $result->fetch_array()) {
$user_id = $row['user_id'];
$user_city = $row['user_city'];
$user_name = $row['user_name'];
$cities[$user_id] = $user_city;
$cities[$user_id] = $user_name;
}
}
}
}
Bonjour, je voudrais afficher que les villes déjà consultées par l'internaute uniquement dans sa session.
Merci d'avance pour votre aide.
[PHP]
if(isset($_POST['submit_form'])) {
$search_city_form = $_POST['search_city_form'];
if(empty($search_city_form)) {
$message = '<p>Veuillez remplir le champ !</p>';
}
else {
$result = $mysqli->query('SELECT city_id, city_name FROM city WHERE city_name = "' . $search_city_form . '"');
$row = $result->fetch_array();
$city_id = $row['city_id'];
$city_name = $row['city_name'];
$city[$city_id] = $city_name;
if(!isset($city_name)) {
$message = '<p class="error">Veuillez rentrer les villes comme Los Angeles, Paris, Londres ou Sydney!</p>';
}
else {
$mysqli->query('INSERT INTO user_search (user_city, user_name) VALUES("' . $search_city_form . '" , "' . $user_name . '")');
$result = $mysqli->query('SELECT user_id, user_city, user_name FROM user_search');
while($row = $result->fetch_array()) {
$user_id = $row['user_id'];
$user_city = $row['user_city'];
$user_name = $row['user_name'];
$cities[$user_id] = $user_city;
$cities[$user_id] = $user_name;
}
}
}
}
[/PHP]