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

explode() function problem maybe
Hi I'm having trouble searching my database. When I type two words in the search field it only searc

search function
HI guys,

if anyone could point us in the right direction of how to do this, or provide some t

Php - mysql select?
hi, i have this code:

Code: <?php
session_start();
// dBase file
include &quo

Create a form of 2 numbers input and find the greatest.
Hi, everybody.

I have a homework in my training of php, which ask you to make a form that ask

Form a inline view based on the results of the previous query?
Hi Experts,
Can we form a inline view on the results of a previous query (another inline view)?

Best PHP Documentation generator
Hello guys!

I would like to hear from you what is the best PHP documentation generator. Perso

Validation
Hello

I know this is a really vag question.

I need to have a input field on a form th

please hep to get values from a table row
can anyone tel me how I can select and get data from one row by pressing an Edit button in that row

header redirect problems? please help
Ok i am making a site that generates youtube thumbnails and i am generating an image that displays 1

Concatenate two strings ???
I have string one $string1 and another $string2.

How to concatenate (add) both of them $str