Search Script

[aftabn10]

I was hoping to create a search script where a user can search for a mobile phone on my website. I know how to write the query but the problem being is that i would like the user to be able to type in e.g. Nokia and it will display all nokia phones or if the user types in 6230 then it would display the phone.

Please could any1 help.

The following is the tables i have;
CREATE TABLE my_phones (
manufacturer varchar(20) NOT NULL default '',
phone_id int(4) unsigned NOT NULL auto_increment,
manufacturer_id int(3) unsigned NOT NULL default '0',
phone_name varchar(60) NOT NULL default '',
price decimal(6,2) NOT NULL default '0.00',
weight varchar(60) default NULL,
dimensions varchar(255) default NULL,
image_name varchar(30) default NULL,
network varchar(50) NOT NULL default '',
introduced varchar(20) NOT NULL default '',
STATUS varchar(15) NOT NULL default '',
TYPE varchar(50) NOT NULL default '',
size varchar(40) NOT NULL default '',
ringtones varchar(75) NOT NULL default '',
vibration varchar(20) NOT NULL default '',
data varchar(75) NOT NULL default '',
phonebook varchar(40) NOT NULL default '',
call_records varchar(50) NOT NULL default '',
messaging varchar(75) NOT NULL default '',
Bluetooth varchar(10) NOT NULL default '',
CAMERA varchar(100) NOT NULL default '',
USB varchar(30) NOT NULL default '',
other varchar(100) NOT NULL default '',
other2 varchar(35) NOT NULL default '',
other3 varchar(35) NOT NULL default '',
other4 varchar(35) NOT NULL default '',
other5 varchar(35) NOT NULL default '',
infrared_port varchar(30) NOT NULL default '',
games varchar(100) NOT NULL default '',
colors varchar(75) NOT NULL default '',
PRIMARY KEY (phone_id),

The results should display;

phone_name, image_name (image itself, along with a link to the actual phone) and the price.

Any help would be appreciated.

[leatherback]

Hm.. If you do know how to write the query.. Where is your trouble hiding? Could you be a bit more specific?

Furthermore: I assume you need to store yes/no for a lot of fields: To save space you can propbabnly better use binary type fields for all the yes/no. For weight use a short integer (Just store the number)
J.

[aftabn10]

Well the trouble im having is that i can search either for phone names or manufacturers on their own? But how could i allow the user to search for either?

[leatherback]

It is much easier for us to help you with this, if you show us what you have done so far.

in general:

$query = "select * from TABLE where ((colum1 = ".$somevalue.") or (colum1 = ".$somevalue."))";

[aftabn10]

<? 
//This is only displayed if they have submitted the form 
if ($searching =="yes") 
{ 
echo "<h2>Results</h2><p>"; 

//If they did not enter a search term we give them an error 
if ($find == "") 
{ 
echo "<p>You forgot to enter a search term"; 
exit; 
} 

// Otherwise we connect to our Database 
mysql_connect("host", "user", "pass") or die(mysql_error()); 
mysql_select_db("dbname") or die(mysql_error()); 

// We preform a bit of filtering 
$find = strtoupper($find); 
$find = strip_tags($find); 
$find = trim ($find); 

//Now we search for our search term, in the field the user specified 
$data = mysql_query("SELECT * FROM my_phones WHERE upper($field) LIKE'%$find%'"); 

//And we display the results 
while($result = mysql_fetch_array( $data )) 
{  

echo $result['phone_name']; 
echo "<br><br>"; 
echo "<a href=\"../../view_{$result['manufacturer']}.php?pid={$row['phone_id']}\"></a><img src=\"../../uploads/{$row['manufacturer']}/{$row['image_name']}"; 
echo "<br>"; 
} 

//This counts the number or results - and if there wasn't any it gives them a little message explaining that 
$anymatches=mysql_num_rows($data); 
if ($anymatches == 0) 
{ 
echo "Sorry, but we can not find an entry to match your query<br><br>"; 
} 

//And we remind them what they searched for 
echo "<b>Searched For:</b> " .$find; 
} 
?>
<h2>Search</h2> 
<form name="search" method="post" action="<?=$PHP_SELF?>">
Search for: <input type="text" name="find" /> in 
<Select NAME="field">
<Option VALUE="phone_name">Phone Name</option>
<Option VALUE="manufacturer">Manufacturer</option>
</Select>
<input type="hidden" name="searching" value="yes" />
<input type="submit" name="search" value="Search" />
</form> 

This is my website that i have created for my university project. This is an example of how i want the phones to be displayed.

http://www.sacranie-mobiles.co.uk/

[leatherback]

Hm.. There is so much icky in this code, I am not sure where to start..
Anyway.. You have them specify where to search.. So how do you see this happening? you have them search a specific field, but in fact you search the whole database? What is the sense?

<?
//This is only displayed if they have submitted the form
if ($searching =="yes")
{
echo "<h2>Results</h2>";

// First retrieve them from the POST array. If register_globals is on, switch if OFF
$find = $_POST['find'];
$field = $_POST['field'];

//If they did not enter a search term we give them an error
if ($find == "")
  {
  echo "<p>You forgot to enter a search term</p>"; //You need to END the P
  }
else
  {
  // Otherwise we connect to our Database
  mysql_connect("host", "user", "pass") or die(mysql_error()); 
  mysql_select_db("dbname") or die(mysql_error());

  // We preform a bit of filtering
  $find = strtoupper($find);
  $find = strip_tags($find);
  $find = trim ($find);

  //Now we search for our search term, in the field the user specified
  $data = mysql_query("SELECT * FROM my_phones WHERE upper($field)   LIKE'%$find%'"); // Please note that it is ALWAYS a bad idea to use the same name for a form field as your database columns. 

// Alternative query: "SELECT * FROM my_phones WHERE ((manufacturer  LIKE'%$find%'") or (phone_name LIKE'%$find%'"))
  //This counts the number or results - and if there wasn't any it gives them a little message explaining that
  $anymatches=mysql_num_rows($data);
  if ($anymatches == 0)
  {
  echo "Sorry, but we can not find an entry to match your query<br /><br />";  // you are probably better of removind the double breaks, and adding <p></p> around this. Use CSS classes subsequently to format the layout
  }
else
  {
  //And we display the results 
  while($result = mysql_fetch_array( $data ))
    {  

    echo $result['phone_name'];
    echo "<br /><br />";
    echo "<a href=\"../../view_{$result['manufacturer']}.php?pid={$row['phone_id']}\"></a><img src=\"../../uploads/{$row['manufacturer']}/{$row['image_name']}";
   echo "<br />";
   }
  //And we remind them what they searched for
  echo "<b>Searched For:</b> " .$find;
  }
}
?>
<h2>Search</h2>
<form name="search" method="post" action="<?=$PHP_SELF?>">
Search for: <input type="text" name="find" /> in
<Select NAME="field">
<Option VALUE="phone_name">Phone Name</option>
<Option VALUE="manufacturer">Manufacturer</option>
</Select>
<input type="hidden" name="searching" value="yes" />
<input type="submit" name="search" value="Search" />
</form>

[aftabn10]

well this doesnt have to be the script i have to use,

i would like the script to search my database (my_phones) and pick out;

phone_name,
image_name (image itself)

the problem i am having is getting the script to display the picture as currently i have a page for each network e.g. if you click on Nokia it will use the following query;

$query  = "SELECT *
           FROM my_phones
		   WHERE manufacturer_id = '1'
		   ORDER BY phone_id DESC
           LIMIT $offset, $rowsPerPage";
$result = mysql_query($query) or die('Error, query failed');

// print the student info in table
echo '<table border="0" width="535" cellspacing="0" cellpadding="0"  align="center">
<tr>  

</tr>';

$i = 1;

while ($row = mysql_fetch_array ($result, MYSQL_ASSOC)) {

// Display each record.
echo "<td><table border=\"0\" width=\"0\" class=\"main2\">
	<td width=\"34\" align=\"left\"><a href=\"view_nokia.php?pid={$row['phone_id']}\"></a><img src=\"uploads/nokia/{$row['image_name']}\"</td>
	<td width=\"110\" align=\"left\"><a href=\"view_nokia.php?pid={$row['phone_id']}\"><font color=\"black\">{$row['phone_name']}</a></font><br>
	<br><align=\"left\"><font color=\"FF1900\">" . stripslashes($row['STATUS']) . "</font><br>
	" . stripslashes($row['TYPE']) . "<br><br><br><br><br><br></td>
	</td></table></td>\n";
if (($i++ % 3) == false) { 
              echo "</tr><tr></tr>\n"; 
		}
} 
echo '</table>';

the problem i'm having with the search script is displaying the phones. Currently all images for phones are stored in an uploads folder and then subfolders for each network.

Hope that makes sense.

Currently i can display the phone name and a blank image?

Is their a simpler query i could use? (sorry to trouble)

[leatherback]

OK,
Do you want to stick with one page per company? -I'd say no, as this messes with adding new phones:

Make this dynamic instead:
manufacturer_id = '1'

manufacturer_id = '$manufacturer'

Which would force you to dynamicize this too:
view_nokia.php?pid={$row['phone_id']

to
view.php?pid=$row['phone_id']&manufacturer=$manufacturer

If you store the path-name with the image, or have an array somewhere linking manufacturer to image-folder you can use that to display the specific folder.

Subsequently, you can load drop-downs / links for differen manufacturers from your database, and always have all links to all companies