search me php

[theolam]

re paides exw megalo problhma me to search me xrhsh php kai mysql, dilidi :

 

as poyme oti exw sti vasi mou tin eggrafi "insomnia web forum" exw kanei to ekseis

 

select * from articles where itemTitle like '%search%' or itemFull like '%search%'

 

exw kanei ena str_replace("",%,$search) wste otan vriskei to keno na vazei to % gia na xwrizete etsi to string kai na min to pianei mia eniaia leksi me ta kena...

 

to provlima mou pws otan grafw "insomnia web forum 2005" tin egrafi mou + kati akoma poy den yparxei stin eggrafh :2005 den mou emfanizei ka8olou...

i an grapsw mperdemenes tis lekseis px: "web forum insomnia" na mou vriskei to ar8ro efoson yparxoun aytes oi lekseis sti vasi

 

thelw na pisteyw na ta egrapsa katanohte

 

thnks boys

[death2all]

afto pou kaneis me to str_replace metatrepei to keimeno "insomnia web forum 2005" se "insomnia%web%forum%2005" kai etsi to search spaxnei gia "%insomnia%web%forum%2005%" to opoio vriskei oles tis eggrafes pou periexoun tis lekseis se auti kai mono tin sira. an thes na tis vriskei kai mperdemenes tote prepei na spasis to keimeno se array (des implode) kai na ftiakseis to sql xrisimopoiontas to array gia paradigma to sql gia na vriskei eggrafes me oles tis lekseis anakatemenes tha prepei se teliki analisi na ginei:

 

select * from articles where

(itemTitle like '%insomnia%' or itemFull like '%insomnia%') and

(itemTitle like '%web%' or itemFull like '%web%') and

(itemTitle like '%forum%' or itemFull like '%forum%') and

(itemTitle like '%2005%' or itemFull like '%2005%')

 

gia na vriksei tis eggrafes pou periexoun esto kai mia leksi allakse ta and se or

 

(me to or isos sou vriskei eggrafes dio fores)

[theolam]

ta xa skeftei.. otan vriskei ena keno na dimiourgei ena ksexoristo string.. alla pws ginete ayto.. ekei pezete to problem... lol

thx

[death2all]

apo: http://gr.php.net/manual/el/function.explode.php

 

$words = explode(' ', $string);

 

foreach($words as $value)

{

//Kaneis oti thes me to $value pou periexei tin ekastote leksei

}

[theolam]

http://www.devarticles.com/c/a/MySQL/Developing-A-Site-Search-Engine-With-PHP-And-MySQL/

[theolam]

theorw pos to thema searching mesa se mia selida einai poly shmantiko alla kai diskolo kata tin ylopoihsh tou...

 

enas xrhsths poy na exei hdh efarmosh search se istoselida proswpikh den yparxei ?