Search engine

After pushing the search button it will show results using this page:

			'; echo '										 			 					';echo '';echo '
RTL Gemist zoeken

';?>		';echo 'Maandag';echo 'Dinsdag';echo 'Woensdag';echo 'Donderdag';echo 'Vrijdag';echo 'Zaterdag';echo 'Zondag';echo 'Alle Programmas

';// echo '';?>= $min_length){		// if query length is more or equal minimum length then		$query = htmlspecialchars($query);		// changes characters used in html to their equivalents, for example: < to >		$query = mysql_real_escape_string($query);		// makes sure nobody uses SQL injection		$raw_results = mysql_query("SELECT * FROM item			WHERE (`serieskey` LIKE '%".$query."%') OR (`samenvattinglang` LIKE '%".$query."%')") or die(mysql_error());		echo '

U heeft gezocht op: '.$query.'

';		//	echo '

';		// * means that it selects all fields, you can also write: `id`, `title`, `text`		// articles is the name of our table		// '%$query%' is what we're looking for, % means anything, for example if $query is Hello		// it will match "hello", "Hello man", "gogohello", if you want exact match use `title`='$query'		// or if you want to match just full word so "gogohello" is out use '% $query %' ...OR ... '$query %' ... OR ... '% $query'		if(mysql_num_rows($raw_results) > 0){ // if one or more rows are returned do following			while($results = mysql_fetch_array($raw_results)){			// $results = mysql_fetch_array($raw_results) puts data from database into array, while it's valid it does the loop			$title=$results['title'];			$serienaam=$results['serienaam'];			$episodetitel=$results['episodetitel'];			$dayname=$results['dayname'];			$thumbnail=$results['thumbnail'];			$movie=$results['movie'];			$broadcastho
ur=$results['broadcasthour'];			$samenvattingkort=$results['samenvattingkort'];				echo "


".$serienaam."

Aflevering: ".$title."



";				echo '

';				echo "";				echo "";				echo '"; 				// posts results gotten from database(title and text) you can also show id ($results['id'])			echo "




Datum: '.$dayname.' '.$broadcasthour.' 
';				echo "Omschrijving: ".$samenvattingkort." 
";				echo "





";			}		}		else{ 	// if there is no matching rows do following			echo "No results";		}	}	else{	// if query length is less than minimum		echo "Minimum length is ".$min_length;	}?>