Making a searchable database of images

Anon

I am making a site where I photographs can be submitted and searched for.
I figured this was how to do it:

User submits data : Image description, keywords, and the image itself.

The Image is uploaded and the description and keywords go into a database.
The Keywords are put in the database as text and would be stored exactly how they were entered.. i.e. a string of words 'Cat House Tree'

now I want to make the database searchable, so a user enters some keywords 'Dog Cat Mouse' and then the database searches for those words and prints a link to the image, and the images desription.

I know hw to do most of it, apart from how to make the keyword search work. Any tips? 🙂

Anon

Ah heck I figured it out by readin through PHPBB's search.php files 🙂

for anybody else interested here is the search script I made!


<head>
       <title>Search</title>
</HEAD>
<?php
// Set the variables for the database access:
$host = "localhost";
$user = "";
$password = "";
$dbname = "photo";
$tablename = "images";
//access database
$link = mysql_connect ($host, $user, $password);
$query = "SELECT country from $tablename ORDER BY country";
$result = mysql_db_query ($dbname, $query, $link);
//input request

print ("<form method=post action=\"$PHP_SELF\">");

print ("Country <select size=\"1\" name=\"country\">");
print ("<option>Any</option>\n");
while ($row = mysql_fetch_array ($result)) {
    print ("<option>$row[country]</option>\n");
}
print ("</select><br>Keywords <input type=text name=keys>");
print ("<br>Number of results <input type=text name=numresults> (Default = 10)");
print ("<br><input type=submit value=\"Search\" name=submit></form>");
print ("</select>");

if ($submit) {
// handle income from form

// make string into array
$keys = explode (" ", $keys);
// build a query
$q1 = ("SELECT * FROM $tablename WHERE");

if ($country == "Any") {
    $q2 = "1";
} else {
    $q2 = ("country = \"$country\"");
}

for ($n = 0; $n <count($keys); $n++) {
$line = each ($keys);
$q3 = "AND keywords LIKE '%$keys[$n]%'" . " " . $q3;
}

if (!$numresults) {
    $numresults = 10;
}

$q4 = ("LIMIT 0, $numresults");

$query2 = $q1 . " " . $q2 . " " . $q3 . " " . $q4;
print ("$query2");
$result2 = mysql_db_query ($dbname, $query2, $link);
while ($finals = mysql_fetch_array ($result2)) {
  print ("<a href=\"$finals[img]\">$finals[description]</a><br>");
}
}
mysql_close ($link);
?>
</body>