<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <title> Min Musik databas </title> <style type="text/css"> </style> </head> <body>
"; echo "";?>
"; echo "";while($row = mysql_fetch_array($result)) {
echo "";}echo "
| my musik databas v0.23 | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
<?php echo "My name is Sirius. | |||||||||||||||||
| Hello, fnord from ".$_SERVER['REMOTE_ADDR'].", you are using ".$_SERVER['HTTP_USER_AGENT']." | |||||||||||||||||
| My IP / hostname is: ".$_SERVER['TRANUILA']." | |||||||||||||||||
|
<form action="index.php" method="post"> search for: <input type="text" id="what" name="what" size="23" /> in <select name="where" id="where"> <option value="filename">filename</option> <option value="artist">artist</option> <option value="title">title</option> <option value="album">album</option> <option value="comment">comment</option> <option value="year">year</option> <option value="genre">genre</option> <option value="path">path</option> <option value="copyright">copyright</option> <option value="stereo">stereo</option> <option value="frequency">frequency</option> </select> <input type="submit" value="Go" /> </form> | |||||||||||||||||
|
<?php $db="musik"; $link = mysql_connect("localhost","hitchcook","map9brkl");
if (! $link) die("Couldn't connect to MySQL"); mysql_select_db($db , $link) or die("Couldn't open $db: ".mysql_error()); if (isset($_POST["what"])) { $what = $_POST["what"]; } else { $what="fnord"; } if (isset($_POST["where"])) { $where = $_POST["where"]; } else { $where="filename"; } $result=mysql_query( "SELECT * FROM musik where $where LIKE '%$what%'" ); $num=mysql_num_rows($result); echo "Searched for $what in $where. $num files found. | |||||||||||||||||
| id | filename | artist | title | album | comment | track | year | genre | path | filesize | copyright | layer | stereo | goodframes | badframes | frequency | playtime |
| ".$row["id"]." | ".$row["filename"]." | ".$row["artist"]." | ".$row["title"]." | ".$row["album"]." | ".$row["comment"]." | ".$row["track"]." | ".$row["year"]." | ".$row["genre"]." | ".$row["path"]." | ".$row["filesize"]." | ".$row["copyright"]." | ".$row["layer"]." | ".$row["stereo"]." | ".$row["goodframes"]." | ".$row["badframes"]." | ".$row["frequency"]." | ".$row["playtime"]." s |
";
mysql_close();
?>
</body>
</html>