Answer the question
In order to leave comments, you need to log in
Incomprehensible work of the script. Why does mysqli_query() return an empty object?
Good afternoon.
I need your advice on how the script works.
$city = iconv('windows-1251', 'UTF-8', $_GET['city']);
$departament = iconv('windows-1251', 'UTF-8', $_GET['departament']);
$host = *************;
$user = *************;
$pass = *************;
$data_base = **********;
$connect = mysqli_connect($host,$user,$pass,$data_base) or die('Could not connect: ' . mysqli_error($connect));
$sql="SELECT * FROM 'имя таблицы' WHERE city = '".$city."'OR departament = '".$departament."'";
$result = mysqli_query($connect,$sql) or die("ERROR: ".mysqli_error($connect));
while($row = mysqli_fetch_array($result)){
echo<<<"OUTPUT_DATA"
<a href= $row[href] class="sj-j" data-r="34" data-c="9 ">
<em><b>$row[vacancy]</b></em>
<div></div>
<i>$row[city]</i>
</a>
OUTPUT_DATA;
}
mysqli_close($connect);
Answer the question
In order to leave comments, you need to log in
one.
2.
while($row = mysqli_fetch_array($result)){
$did[] = $row;
}
var_dump($did);
$mysqli = new mysqli($host, $user, $pass, $data_base);
$vacancies = $mysqli->prepare("SELECT * FROM 'имя таблицы' WHERE city = ? OR departament = ?");
if ($vacancies) {
$vacancies->bind_param('ss', $city, $departament);
$vacancies->execute();
$vacancies->store_result();
$countRows = $vacancies->num_rows;
if ($countRows != 0){
//на каждый столбец нужно забиндить по переменной, либо указывать в SELECT конкретные и биндить конкретные.
$vacancies->bind_result($href, $vacancy, $city_result, $departament_result);
while ($vacancies->fetch()) {
echo '<a href="' . $href . '" class="sj-j" data-r="34" data-c="9 ">
<em><b>' . $vacancy . '</b></em>
<div></div>
<i>' . $city_result . '</i>
</a>';
}
}
else{
echo 'По вашему запросу ничего не найдено';
}
}
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question