database_search.php

自制国外大学学校计算机学院网站

<?php
	include("database_access.php");
	$query = "SELECT * FROM module_info";
	$result = mysql_query($query) or die("Could not execute query.");
	$request = $_GET["q"];
	$req_length = strlen($request);
	$counter = 0;
	$num_row = mysql_num_rows($result);
	
	for($i=0;$i<$num_row;$i++){
		$row = mysql_fetch_array($result,MYSQL_ASSOC);
		$module_name[] = $row['module_name'];
		if(strstr(strtolower($module_name[$i]),strtolower($request))!=FALSE){
			$hl_pos = strpos(strtolower($module_name[$i]),strtolower($request));
			$hl_end = $hl_pos + $req_length;
			$length_str = strlen($module_name[$i])-$hl_end;
			
			$begin_part = substr($module_name[$i],0,$hl_pos);
			$hl_part = substr($module_name[$i],$hl_pos,$req_length);
			$end_part = substr($module_name[$i],$hl_end,$length_str);
			
			if ($ans_array == ""){
				$ans_array = $ans_array."<ol>";
			}
			
			if($hl_pos == 0){
				$ans_array = $ans_array."<li><a href=\"javascript:showUser('".$module_name[$i]."')\"><span style=\"color:#FF0000;\"><b>".$hl_part."</b></span>".$end_part."</a></li><br />";
			}
			elseif(hl_pos == $length_str){
				$ans_array = $ans_array."<li><a href=\"javascript:showUser('".$module_name[$i]."')\">".$begin_part."<span style=\"color:#FF0000;\"><b>".$hl_part."</b></span></a></li><br />";
			}
			else{
				$ans_array = $ans_array."<li><a href=\"javascript:showUser('".$module_name[$i]."')\">".$begin_part."<span style=\"color:#FF0000;\"><b>".$hl_part."</b></span>".$end_part."</a></li><br />";
			}
			$counter++;
		}		
	}
	if ($ans_array == ""){
		$ans = "No result found!";
	}
	else {
		echo "<br />There are <span style=\"color:#FF0000;\"><i><b>".$counter."</b></i></span> answers have been found!><br />";
		$ans = $ans_array."</ol>";
	}
	echo $ans;
?>