DaniWeb Forum Index > Web Development > PHP

search from database

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Aug 2008

Posts: 141

Reputation: sarithak is an unknown quantity at this point

Solved Threads: 6

sarithak

Offline

Junior Poster

search from database

Dec 1st, 2008

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..

My best wishes ... from my soul ... for everyone!
Keep Smiling....Never Depress

•

Join Date: Sep 2007

Posts: 1,329

Reputation: cwarn23 has a spectacular aura about

Solved Threads: 126

cwarn23

Offline

Nearly a Posting Virtuoso

Re: search from database

Dec 1st, 2008

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:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?
//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>
<?
//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>

Try not to bump 10 year old threads as it can be really annoying.
Like php then read my website at http://syntax.cwarn23.net/
Star-Trek-Atlantis - now that's what I call a movie ^_^
My favourite PC. - MacGyver Fan
Bad english note: dis-iz-2b4u

•

Join Date: Dec 2008

Posts: 94

Reputation: sikka_varun is an unknown quantity at this point

Solved Threads: 11

sikka_varun sikka_varun is offline

Offline

Junior Poster in Training

Re: search from database

Dec 3rd, 2008

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...

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?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>
<?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>