Brainfarts Uncategorized Search engine

Search engine

May 10, 2013May 10, 2013| adminadmin| 0 Comment| 07:58
Categories:

This post was most recently updated on December 11th, 2018

 A simple search engine has been created to search on specific keywords:

'; echo 'RTL Gemist: Zoeken										 			 					';echo '';echo '

RTL Gemist: Zoeken


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

';echo '';echo '';echo '';echo '    ';echo '





Geef de gewenste zoekterm op:';echo '    
';echo '	';echo '	






';?>
 ";?>

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

			'; echo 'RTL Gemist: Zoeken										 			 					';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;	}?>

Related Post