search from database

[sarithak]

hi frnds,
i am doing a project related to food items..
here i took different categories like restaurants,pubs,foodfestivals,hangouts...
and also i took diffrent tables for each category in database..
each table having area,rname...now i need to search what ever user typed in textbox(area,rname) from database.
plz give any suggestions asap..

[cwarn23]

This is only from the top of my head but if what you place in those 2 fields (area, rname) need to match percisely what are in those 2 columns within the mysql database then you could use something along the following:

<?
//mysql connections
if (isset($_POST['area']) && isset($_POST['rname']))
    {
    $result=mysql_query("SELECT * FROM `table` WHERE `area`='".$_POST['area']."' AND `rname`='".$_POST['rname']."'");
    echo "<table border=1 cellpadding=4 cellspacing=0><tr><td>area</td><td>rname</td><td>column3</td></tr>";
    while ($rowid=mysql_fetch_array($result))
        {
        //perform actions for earch row found
        echo "<tr><td>".$rowid['area']."</td>";
        echo "<td>".$rowid['rname']."</td>";
        echo "<td>".$rowid['column3']."</td></tr>";
        }
    echo "</table>";
    }
?>

<form method='post'>
area=<input type='text' name='area'><br>
rname=<input type='text' name='rname'><br>
<input type='submit' value='submit'>
</form>

[sikka_varun]

Hi...
What i suggest you is to create a category select box and its value should be the same as of your tablename.... (this is what you have done.. table for every category)

I hope too many php tags doesn't confuses you... Its just to display result in a better way...

<?php

if(isset($_POST['submit']))
{
	
	$sql="Select * from ".$_POST['category']." where area like '%".$_POST['area']."%' and rname like '%".$_POST['rname']."%' order by area asc";
	$result = mysql_query($sql);

?>
	<table border="1">
		<tr>
			<td colspan="2"> Search in table >> <?php echo $_POST['category']; ?></td>
		</tr>

<?php
	if(mysql_num_rows($query) > 0)
	{
		while($row = mysql_fetch_array($result))
		{
?>
		<tr>
			<td>$row['area'];</td>
			<td>$row['rname'];</td>
		</tr>
<?php
		
		}
	}
	else
	{
?>
		<tr>
			<td colspan="2">No entry found</td>
		</tr>
<?php

	}
?>

	</table>
<?php
}

?>



<form name="form_search" method="post" action="">
	Select Category <select name="category">
				<option value="restaurants">Restaurants</option>
				<option value="restaurants">Restaurants</option>
				<option value="restaurants">Restaurants</option>
				<option value="restaurants">Restaurants</option>
			</select>
	<br/>
	Area <input type="text" name="area" id="area" />
	<br />
	Rname <input type="text" name="rname" id-"rname" />
	<br />
	<input type="submit" value="search" name="submit">
</form>

[Bachu]

1; set $searchResult= array();

2; Check each tables and push all results to the array $searchResult, like below

$sql="SELECT   *  FROM    df_restaurent WHERE  (df_restaurent.Address  LIKE '%$query1%' )  GROUP BY RestaurentId ;";

                   $result=$this->db->query($sql);
                   $data=$this->db->fetchAll($result);
                   foreach($data as $dd)
                     {      
                 array_push($searchResult, array( "Page" => "RestaurentDetails", "RestaurentId"=>"$dd->RestaurentId" ));

                     }

3; At the end of cheking of all tables , return $searchResult