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'";
?> 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.
