Просмотр поста

<?php

define('_IN_JOHNCMS', 1);
$textl = 'qidirish';
$headmod = 'usersearch';
require_once('incfiles/core.php');
require('incfiles/head.php');


echo '<div class="phdr" style="text-align: center"><b>Yangi do\'stlar topish</b></div>';
if (isset($_POST['submit']))
    {
$davlat = isset($_POST['davlat']) ? mb_substr(functions::checkin(trim($_POST['davlat'])), 0, 50) : null;
$shahar = isset($_POST['shahar']) ? mb_substr(functions::checkin(trim($_POST['shahar'])), 0, 50) : null;
$result = mysql_query("SELECT * FROM board_ads WHERE davlat LIKE '%$davlat%' AND shahar LIKE '%$shahar%'");

while ($row = mysql_fetch_array($result))
{
echo'<div class="menu">'.$row['name'].' - '.$row['time'].'</div>';
}

}else{


echo'<form action="qidir.php" method="post">';
echo'<p><h3>Давлат:</h3>' .
'<select name="davlat">' .
'<option value="uzb" >O`zbekiston</option>' .
'<option value="rus" >Rossiya</option>' .
'<option value="taj" >Tojikiston</option>' .
'<option value="kaz" >Qozog\'iston</option>' .
'<option value="qir" >Qirg\'iziston</option>' .
'</select></p>';
echo'<p>Шахар:</p>';
echo'<p><input type="text" name="shahar" value="Tashkent"></p>';
echo'<input type="submit" value="Qidirish" name="submit" /></form>';

}



require('incfiles/end.php');