Avanceret søgning

Du kan forresten se pladearkivet her: http://sporge-jorgen.dk/pladearkiv/

- Jeg fandt frem til at lave en UNION til at søge i begge databaser.
- Jeg brugte stristr til at fremhæve resultater der matcher søgeordet.
- Ranking har jeg endnu ikke fået lavet.

Her er min midlertidige løsning:

$print .= "<form action=\"search.php\" method=\"post\">\n";
$print .= "<h1>Search</h1>\n";
$print .= "<p>Keyword:<br>\n";
$print .= "<input type=\"text\" name=\"keyword\" value=\"" . stripslashes($_REQUEST["keyword"]) . "\" size=\"20\" class=\"formText\"></p>\n";
$print .= "<p><input type=\"submit\" name=\"submit\" value=\"Search\" class=\"button\">\n";
$print .= "<input type=\"reset\" name=\"reset\" value=\"Reset\" class=\"button\"></p>\n";
$print .= "</form>\n";

if(!empty($_REQUEST["keyword"]))
{
    $print .= "<table>\n";
    $print .= "<tr><th>Artist</th><th>Title</th><th></th></tr>\n";

    $query = mysql_query("(SELECT id, artist, title FROM records_albums WHERE artist LIKE '%" . $_REQUEST["keyword"] . "%' OR title LIKE '%" . $_REQUEST["keyword"] . "%') UNION (SELECT album_id AS id, artist, title FROM records_tracks WHERE artist LIKE '%" . $_REQUEST["keyword"] . "%' OR title LIKE '%" . $_REQUEST["keyword"] . "%')") or die(mysql_error());

    if(mysql_num_rows($query) > 0)
    {
        while($row = mysql_fetch_assoc($query))
        {
            $bg = $q++ % 2 ? 'F0F0F0' : 'FFF';

            $row["artist"] = htmlentities(strtoupper($row["artist"]));
            $row["artist"] = eregi_replace("(.*)(" . htmlentities(strtoupper($_REQUEST["keyword"])) . ")(.*)", "\\1<span style=\"color: #03F;\">\\2</span>\\3", $row["artist"]);

            $row["title"] = htmlentities(strtoupper($row["title"]));
            $row["title"] = eregi_replace("(.*)(" . htmlentities(strtoupper($_REQUEST["keyword"])) . ")(.*)", "\\1<span style=\"color: #03F\">\\2</span>\\3", $row["title"]);

            $print .= "<tr style=\"background: #" . $bg . ";\"><td>" . $row["artist"] . "</td>";
            $print .= "<td>" . $row["title"] . "</td>";
            $print .= "<td><a href=\"index.php?data=album&amp;id=" . $row["id"] . "\" title=\"View album\" style=\"background: #" . $bg . ";\">&raquo;</a></td></tr>\n";
        }
    }
    else
    {
        $print .= "<tr><td colspan=\"\">No result.</td></tr>\n";
    }

    mysql_free_result($query);

    $print .= "</table>\n";
}

Jeg lukker. :)