Display search result

Posted on 16th Feb 2014 07:03 pm by admin

Hi!

I have a SQL database with information about albums and track (music).

This is where the user inputs a search term(entersearch.php): Code: <form name="form" action="displaysearchalbum.php" method="get">
<input type="text" name="getsearch" />
<input type="submit" name="Submit" value="search album" />
</form>
<br />
<h2>Search for track</h2>
<form name="form" action="displaysearchtrack.php" method="get">
<input type="text" name="getsearch2" />
<input type="submit" name="submit2" value="search track" />
</form>
And this is where the search result is displayed with links to a pages with more information about the album the user is interested in.

Code: <?php

// Get the search variable from URL
$var = @$_GET['getsearch'] ;
$trimmed = trim($var); //trim whitespace from the stored variable

// rows to return
$limit=20;

// check for an empty string and display a message.
if ($trimmed == "")
{
echo "<p>Please enter a search...</p>";
exit;
}

// check for a search parameter
if (!isset($var))
{
echo "<p>We dont seem to have a search parameter!</p>";
exit;
}

//connect to your database
mysql_connect("xxx","xxx","xxx"); //(host, username, password)

//specify database
mysql_select_db("xxx") or die("Unable to select database"); //select which database we're using

// Build SQL Query
$result = mysql_query("SELECT albumid, albumname FROM album WHERE albumname like '%$trimmed%'");
//$query = "SELECT albumname FROM album WHERE albumname='$trimmed'";

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

echo '<a href="albuminfo.php?albumid=' . $row[0] . '">' . $row[1] . '</a>';
echo "<p></p>";
}

?>
My problem is that I don't know how to transfer the information from displaysearchalbum.php to albuminfo.php about which album the information is going to be displayed. Preferably I would have a variable in albuminfo.php which contains the albumid in interest. I am a novice in php but think that the code I have so far written is working. Any ideas about necessary changes in the code I wrote or what kind of code I need for albuminfo.php would be helpful. I have not yet written any code for albuminfo.php because I am not quite sure how to.

Your Answer:

Login to answer

Other forums

"From field" in PHP email form
I used a wizard to create a PHP email form. I was able to customize it with the exception of the Fr

How can I get my program to read a larger array ??
Hi:

I have this program that reads from an array to do calculations. The array are just t

Display data returned from Ajaxservices!!
I have a question about displaying results using ajax. I have part of the code below.
$.ajax({

preg_replace question
Hello!!

I hope someone can help me with preg_replace.

I load two tables from an extern

BAPI BBP_INB_DELIVERY_CREATE - material number missing in delivery
Hi Experts,

I was able to successfully create an Inbound delivery with reference to a PO

Linkage between two scripts
Okay say I have this for a link in a script:

Code: <li><a href="#&q

Refining of search Criteria
Dear Friends

I need a help, I have a search page which of cars related, which has different s

newbie question about multiple queries
hi everyone,
I'm sorry to ask such a basic question, but I'm young and trying to learn php on my

highlighting search terms
well, I started this in the regular PHP section, but it no longer fits there. Suffice it to say, I'm

Selecting an "empty" date formated field
How do you select an "empty" date field? I've tried the few ways I can think.
SQL> select