<?
	include("dbinfo.php");
	$sql = "select * from sv";
	$result =  mysql_query($sql,$link);
	$i = 0;
	while ($row = mysql_fetch_array($result))
	{
		$i++;
		echo $i.". ".$row['hten']."<p>";
	}
?>
<h2>Tim kiem</h2>
<form id="form1" name="form1" method="post" action="result.php">
  <p>Nhap tu tim kiem
    <input type="text" name="txtkeyword" /> 
</p>
  <p>
    <input type="submit" name="Submit" value="Submit" />
</p>
</form>

<?
	include("dbinfo.php");
	$sql = "select * from sv";
	$result =  mysql_query($sql,$link);
	$i = 0;
	while ($row = mysql_fetch_array($result))
	{
		$i++;
		echo $i.". ".$row['hten']."<p>";
	}
?>

<h2>Ket qua tim kiem <?=$HTTP_POST_VARS["txtkeyword"] ?></h2>
<?
	function Search_A_Word($keyword,$link)
	{
		$sql = "Select * from sv where instr(sv.hten,'".$keyword."') > 0";
		$result = mysql_query($sql,$link);
		while ($row = mysql_fetch_array($result))
		{
			echo $row['hten']."<p>";
		}
	}//function
	
	$keyword = $HTTP_POST_VARS["txtkeyword"];
	if ($keyword <> "")
	{
		//Tim ca tu
		Search_A_Word($keyword,$link);
		//Tach tu theo khoang trang neu co	
		$search =  explode(" ",$keyword);
		if (count($search) > 1)
		{
			for ($i=0;$i<count($search);$i++)
			{
				Search_A_Word($search[$i],$link);
			}//for
		}//if (count($search) > 1)
	}//if ($keyword <> "")
?>
<p>
<h2><a href="index.php">Quay lai tim kiem</a></h2>

<?
	$db_host="localhost";
	$db_user="username;
	$db_pass="password";
	$db_name="test";//Ten CSDL can truy xuat
	$db_prefix="";	
	//Ket noi CSDL
	$link=mysql_connect($db_host,$db_user,$db_pass) or die("Loi ket noi CSDL so 1");
	mysql_select_db($db_name,$link);
?>

<?
	include("dbinfo.php");
	$sql = "select * from sv";
	$result =  mysql_query($sql,$link);
	$i = 0;
	while ($row = mysql_fetch_array($result))
	{
		$i++;
		echo $i.". ".$row['hten']."<p>";
	}
?>

<h2>Ket qua tim kiem <?=$HTTP_POST_VARS["txtkeyword"] ?></h2>
<?$var = '-_+*:,.@{}[]()~$#%^&=|;?/<>!';
    $len = strlen($var);
    $var = trim($var);
    for($i=0;$i<$len;$i++)
    {
    	$search[]= $var[$i];
        $replace[] = ' ';
    }
    $data = str_replace($search,$replace,$_POST['txtkeyword']);
    $data = str_replace('','',$_POST['txtkeyword']);
               
    $aquery= explode(' ',$_POST['txtkeyword']);  

    $where = "hten LIKE '%$data%'";
    foreach($aquery as $k=>$value) 
	{
    	$where .= " || hten LIKE '%$value%'";
    }
    $sql = "SELECT * FROM sv WHERE " . $where;
	$result = mysql_query($sql,$link);
	while ($row = mysql_fetch_array($result))
	{
		echo $row['hten']."<p>";
	}

?>
<p>
<h2><a href="index.php">Quay lai tim kiem</a></h2>