Textsearch with PHP

[Phlexus]

Hey guys,

I want to have a textfield that searches a particular part in the DB. The code below is what I have so far, but I don't know how to do the textfieldsearch.

The part that needs to be searched on a string of letters is the field 'mezelf'.

Can someone help please? PS: I haven't written this code myself.

<?php
$CACHE_LIMITER="";
include ("/usr/local/plesk/apache/vhosts/XXXXXX.nl/httpdocs/support.inc");
$title = "XXXXXX: Zoekresultaten";
include ($headerfile);

$default_foto = $persoon["foto"];
$dbinfo["table_categorie"] = $table_categorie;

$search_info = "<B>Je hebt gezocht op de volgende criteria:</B><BR><BR>";

$query_start_total = "SELECT ".$dbinfo["table_persoon"].".id FROM ".$dbinfo["table_persoon"].",".$dbinfo["table_categorie"]." ";
$query_start = "SELECT ".$dbinfo["table_persoon"].".* FROM ".$dbinfo["table_persoon"].",".$dbinfo["table_categorie"]." ";
$query .= "WHERE ".$dbinfo["table_persoon"].".id=".$dbinfo["table_categorie"].".persoon_id";

/ Add query string geslacht /
$query .= (($persoon["geslacht"] == "M" || $persoon["geslacht"] == "V") ? " AND ".$dbinfo["table_persoon"].".geslacht LIKE '".$persoon["geslacht"]."'" : "");
$search_info .= "geslacht <SPAN CLASS=searchinfo><B>".($persoon["geslacht"] == "M" ? "man" : ($persoon["geslacht"] == "V" ? "vrouw" : "man of vrouw"))."</B></SPAN>";

/ Add query string for persoon.provincie if necessary /
if ($persoon["provincie"] == "")
$persoon["provincie"] = "NVT";

$query .= ($persoon["provincie"] != "NVT" ? " AND ".$dbinfo["table_persoon"].".provincie LIKE '".$persoon["provincie"]."'" : "");

if ($persoon["provincie"] != "NVT")
$search_info .= " / provincie <SPAN CLASS=searchinfo><B>".$persoon["provincie"]."</B></SPAN>";

if ($default_foto == "yes") {
$query .= " AND ".$dbinfo["table_fotoalbum"].".persoon_id=".$dbinfo["table_persoon"].".id AND ".$dbinfo["table_fotoalbum"].".hoofdfoto LIKE 'J' AND ".$dbinfo["table_fotoalbum"].".foto NOT LIKE ''";
$search_info .= " / met foto";

}

if (isset ($persoon["leeftijd_range"]) and ($persoon["leeftijd_range"] != "NVT")) {
	list ($start, $end) = split ("-", $persoon["leeftijd_range"]);
	$query .= " AND ".$dbinfo["table_persoon"].".leeftijd >= $start AND ".$dbinfo["table_persoon"].".leeftijd <= $end ";
	$search_info .= " / leeftijd <SPAN CLASS=searchinfo><B>".$persoon["leeftijd_range"]."</B></SPAN> jaar";
}
else {	
	$query .= (strlen ($persoon["leeftijd"]) ? " AND ".$dbinfo["table_persoon"].".leeftijd".$persoon["leeftijd_richting"].$persoon["leeftijd"]." AND ".$dbinfo["table_persoon"].".leeftijd NOT LIKE ''" : "");

}

if ($default_categoriekeuze == "$script_thema") {

/* Add query string for persoon.genre if necessary*/
$genre = array ("pop", "top40", "dance_house", "garage", "rnb_soul", "hiphop", "lounge_trip", "jungle", "jazz", "jazzrock", "electro", "nederlands", "alt_punk_goth", "hardrock", "blues", "klassiek_opera", "latino", "country", "reggae");
for ($t=0; $t < count ($genre); $t++) {
	$eval_str = "if (strlen (\$persoon[\"genre_".$genre[$t]."\"])){ \$query .= \" AND \".\$dbinfo[\"table_persoon\"].\".genre LIKE '%\".\$persoon[\"genre_".$genre[$t]."\"].\"%'\";\$search_info_genre[] = \$persoon[\"genre_".$genre[$t]."\"];}";
	eval ($eval_str);
}

if (count ($search_info_genre))
	$search_info .= " / favoriete genre <SPAN CLASS=searchinfo><B>".join (", ", $search_info_genre)."</B></SPAN>";

}

etc etc

[Pig]

Do you mean, search a field to see if a particular string is in it?

SELECT * FROM table_name WHERE field_name LIKE '%$string%'

[Rayman3_tk]

Hey, thanks pig!

Your example was just what I needed, I knew that I had to do something with the %%%, but I didn't know that I had to use LIKE, and my comma's where at the wrong place too.

Thanks!

[Pig]

np

[Phlexus]

Yes, I sorta know what the query should look like. But how do I fit it in the code above??? Thats the question.

Also, can you search multiple fields? Would this be with something like AND texfield_1 AND textfield_2 and so on?

Please help me out here.

[Pig]

I dunno... That code doesn't make a lot sense to me, but I also have a headache. Maybe someone else can help you out. I'll take another look later.

You can search multiple fields, just make sure you have your syntax right. If you say AND then you will require that both fields match.