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

Problem with Subscreen
Dear Experts ,
I am facing a problem with the subscreens. My senario is as follows :

How do i use vars in an array
Hiya peeps!

How do I use a var in an array. You will see $id but it isnt working.

ClientScript.RegisterClientScriptBlock Issue
This is what I haveview plaincopy to clipboardprint?Protected Sub posrback_Click(ByVal sender As Obj

Help with setcookie()
Merry Xmas to those on this foruum
Older guy here with some experience but not allot so please be

article site help remaining text
Hi all hope you will be fine
I am creating a article site in this site i want to put some text on

Prevent PHP mail( ) from appending hostname to from address
Hey guys,

I want to be able to send texts to phones via email (since each phone has their own

Hotlinking Picasa as the image folder of a website
Hi there PHP freaks, I would like to create a private album in Picasa to use it as the image folder

parse error
On my local machine I keep getting parse error for my footer. When I put it online, it doesn't show

ORA-00932: inconsistent datatypes: expected - got CLOB
SO : windows xp
database : XE

there is a table (transito) with two fields of clob

php calculate
this code echoes correctly the sum but the inserted result is 0??
Code: <?php
$TotalNum