Search Centre using below criteria
|
District |
[insert_php]
$con = mysql_connect(“localhost”,”parth”,”ftp2015,,,”);
if (!$con)
{
die(‘Could not connect: ‘ . mysql_error());
}
mysql_select_db(“parth_admin”, $con);
$query = “SELECT DISTINCT (
District
) AS District, ID
FROM `District_Master`”;
$comments = mysql_query($query);
//$var=array();
//$did=array();
echo’
|
‘;
echo’
Tehsil |
|
‘;
}
echo’
City |
|
“;
}
[/insert_php]
Address |
|
|
[insert_php]
if(isset($_POST[‘search1’]))
{
$selected_Dist = $_POST[‘Dist’];
$selected_Teh = $_POST[‘Teh’];
$selected_City = $_POST[‘City1’];
$selected_add = $_POST[‘address’];
//echo “District— $selected_Dist “;
//echo “Tehsil — $selected_Teh “;
//echo “City-$selected_City”;
$querySearch=”
SELECT * FROM `ITGK_List` WHERE City='”.$selected_City.”‘ and Address like ‘%’ ‘” .$selected_add. “‘ ‘%'”;
$commentsSearch = mysql_query($querySearch);
echo ”
Center Name |
District |
Tehsil |
City |
$City
Address |
“;
while($rowSearch = mysql_fetch_array($commentsSearch , MYSQL_ASSOC))
{
$cname = htmlspecialchars($rowSearch[‘Name’],ENT_QUOTES);
$District= htmlspecialchars($rowSearch [‘District’],ENT_QUOTES);
$tehsil= htmlspecialchars($rowSearch[‘Tehsil’],ENT_QUOTES);
$City= htmlspecialchars($rowSearch[‘City’],ENT_QUOTES);
$address= htmlspecialchars($rowSearch[‘Address’],ENT_QUOTES);
echo ”
$cname |
$District |
$tehsil |
$City |
$address |
“;
}
echo”
“;
}
mysql_close($con);
[/insert_php]