[RESOLVED] Image search

LesSjo

I am looking for some samples of coding to create an image search that clients can use to narrow the results of the images we currently have on our site. Any ideas?

djjjozsi

Lets list them into database, (filename and folder names placed into two fields in the database)

and create a search form, with a passed $_POST["search_query"] value,

and search that from the database.

$word=mysql_real_escape_string($_POST["search_query"]);
$sql="SELECT * FROM images WHERE filename LIKE '%.$word.%'";

and the results make az img src with the folder name and image's name too.

try to start somewhere, and we could help.

LesSjo;10890278 wrote:
I am looking for some samples of coding to create an image search that clients can use to narrow the results of the images we currently have on our site. Any ideas?

LesSjo

I am in the process of getting the database up with the info you suggested. Question... If I were to set decriptors for each image (i.e. rose, red, floral, etc...) how would I go about tying each term to various images of a rose?

thanks in advance.

johanafm

The easiest way is probably to add a new column to the image table containing ALL the tags for each image. Then have a look at "MATCH AGAINST" with which you can do things like:
SELECT * FROM image MATCH (tags) AGAINST ('+red +flower -rose' IN BOOLEAN MODE)

SELECT * FROM image MATCH (tags) AGAINST ('"red flower"' IN BOOLEAN MODE)

LesSjo

I am starting with a very basic search at this point to get it up and running. I can get the information - by phrase - but when I try to put the link into the img src it errors out. What am I doing wrong?

while ($i = mysql_fetch_array($result)) { 
$ImageID = $i["ImageID"]; 
$ImageName = $i["ImageName"]; 
$Folder = $i["Folder"]; 
$Tags = $i["Tags"]; 
$Link = $i["Link"]; 
echo "
<tr> 
<td>$ImageID</td> 
<td>$ImageName</td> 
<td>$Folder</td> 
<td>$Tags</td></tr> 
<tr><td colspan=4><img src="$Link"></td> 
</tr>"; 
} //End while loop

Thanks

djjjozsi

copy a source code of how that appears in the browser.

don't you need to put the $Folder valur in the srec in the image ?

bye

LesSjo

Simple error. Once I took the quotation marks off of the img scr line, the search worked.

djjjozsi

lets escape all " when you echo that:

like this:

echo "
<tr>
<td>$ImageID</td>
<td>$ImageName</td>
<td>$Folder</td>
<td>$Tags</td></tr>
<tr><td colspan=4><img src=\"$Link\"></td>
</tr>";

LesSjo;10890668 wrote:
Simple error. Once I took the quotation marks off of the img scr line, the search worked.