A small search engine with LIKE (mysql)

amelhedi

i m trying to creat a small search into a table

here is my summury of my code

//---Artist--

$motsArt = str_replace('%', '', $motsArt);
$motsArt = str_replace('_', '', $motsArt);
$motsArt = trim($motsArt);
if ($motsArt != '')
{
$WhrArt = " and Artist.ArtistNm LIKE '%".addslashes($motsArt)."%'";
// $WhrArt = " AND Artist.ArtistNm LIKE '%" . $motsArt . "%'";
$criteres = "?motsArt=".urlencode($motsArt);
}
else
{
$WhrArt = '';
$criteres = "?";
}
//--

// looking for answers

$LstSgQ = 'SELECT song.title, song.filesize , song.time, artist.artistnm, album.albumnm ';
$LstSgQ .= 'FROM rel, artist, album, song ';
$LstSgQ .= 'Where rel.albumid = album.albumid and rel.artistid = artist.artistid and rel.songid = song.songid';
$LstSgQ .= $WhrArt;
$LstSgQ .= ' ORDER BY title';

//-form for search
echo "<FORM METHOD=GET>\n";
echo "<B>Artist :</B>  ";
$motsArt = stripslashes(htmlspecialchars($motsArt));
echo "<INPUT TYPE='text' NAME='MotsArt' VALUE=\"".$motsArt."\">";
echo "  <INPUT TYPE='submit' VALUE='Go !'>";
echo "</FORM>\n";

/// end

i don t know what s wrong with it, well i reconize i m not very familiar with POST and GET, but with the litle i know it should work

If u have any question fill free to email me

thanx for your help and long life for phpbuilder.com

Anon

i have a code about small search engine that uses lIke .. mysql🙂 do u want?

amelhedi

yes plz send it

Anon

send you later

Anon

Can you put the thing online, please, so i can download it too ?

It would be really helpful, thanx in advance

hear from ya'🙂

drm

Anon

Email me... so that I can sent it to you.

Anon

when replying here you have my email adres already :-)

try it :-)

hear from you!

drm

Anon

Could you mail this code to me, it would be really nice.

tanks.

CSI

Anon

can u send to me too 🙂 tq

cdherold

Could someone just post the code? Sounds like everyone wants it ...

Anon

Gotta agree...I'd love it too!! : )

mgee2000

I think it's kind of rude of you to not post it like most other people do around here. That's what this forum is about. Don't answer questions of you don't want to share.

Thanks

Anon

Mike, I'd love to answer but I don't have one...that's why I'm asking.

If you don't wanna share, that's your business and if you're looking for something, just let me know and I'll see if I can help.

mgee2000

Sorry that wasn't directed to you. That was meant for Juney.

Lucas wrote:

Mike, I'd love to answer but I don't have one...that's why I'm asking.

If you don't wanna share, that's your business and if you're looking for something, just let me know and I'll see if I can help.

Anon

Hi all,

i have been puzzling around a little, and the principle of the LIKE search engine is something like this:

<?php
$field = "fieldname";
$table = "tablename";

$searchwords = split ( "[ ,]", $searchString );

$first = true;
foreach ( $searchwords as $word )
{
if ( $first )
{
$first = false;
$like .= " WHERE ";
}
elseif ( $andor == "or" )
$like .= " OR ";
else
$like .= " AND ";

$word = chop ( $word );
$like .= "$field LIKE '%$word%' ";
}

$query = "
SELECT *
FROM $table
$like";

$result = mysql_query ( $query );

while ( $row = mysql_fetch_row ( $result ) )
{
// format your results here ofcourse
print_r ( $row );
}
?>

using a following HTML form:

<form action="search.php" method="post">
Search words: <input type="text" name="searchString"><br>
<input type="radio" name="andor" value="or"> 1 or more of these words<br>
<input type="radio" name="andor" value="and">all words<br>
<input type="submit">
</form>

Anon

Thanks for posting the code - works really well and was just what I needed.

However, I would like to output something that says 'no results found' (if none were); have tried several things but to no avail.

Would appreciate some help with this one.

Anon

check
http://www.php.net/mysql_num_rows

That's a function to retrieve the number of results in the resultset. Something like this should work then:

if ( mysql_num_rows ( $resultID ) > 0 )
{
while ( /
That while-part here
/
}
else
___echo "No results, sorry.";

Anon

i'm interest in your code of small search engine , please mail me, thank you🙂

Juney wrote:

i have a code about small search engine that uses lIke .. mysql🙂 do u want?

jscs99

Me too, if you're willing. Thanks.

Anon

did anyone ever get the code from Juney?

i would like it too.

thanks

alex wrote:

i'm interest in your code of small search engine , please mail me, thank you🙂

Juney wrote:

i have a code about small search engine that uses lIke .. mysql🙂 do u want?