All pastes #802129 Raw Edit

PR

public php v1 · immutable
#802129 ·published 2007-11-29 23:03 UTC
rendered paste body
if(isset($_POST['search'])){	$string = $_POST['string'];			// String to search for		$string = explode(" ", $string);	for($i = 0; $i < count($string); $i++)	{		($i == 0) ? $search_query = $search_query .'\'%'.$string[$i].'%\'' : $search_query = $search_query .' AND \'%'.$string[$i].'%\'';	}	$search_query = '"SELECT * FROM guestbook WHERE text LIKE '.$search_query.' ORDER BY time DESC"';	echo $search_query;	$search = mysql_query($search_query);}// --------------------------------------------------------------------------------------------if(isset($_POST['search'])) {	$num = mysql_num_rows($search);	if($num == 0) {		echo '<p>Tyvärr, inga träffar på din sökning: <b>'.implode(" ", $string).'</b></p>';	} else {		echo '<p>Din sökning gav <b>'.$num.'</b> träff[ar].</p>';	}	while($q = mysql_fetch_array($search))	{		$id = $q['id'];		$uid = $q['uid'];		$time = $q['time'];		$msg = $q['text'];		$ip = $q['ip'];						$msg = stripslashes($msg);		$msg = htmlentities($msg);		$msg = nl2br($msg);				$msg = str_ireplace($string, '<b>'.$string.'</b>', $msg);				//($time > $last_visited) ? $class = 'class="new"' : $class = 'class="old"';				echo '<a name="'.$id.'"></a><fieldset class="old"><legend class="old">'.uid2username($uid).' | '.date("Y.m.d", $time).'</legend>'.$msg.'</fieldset>';	}} else {	display_posts();}