<?
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>

<?
$conn = new com("ADODB.connection") or die ("Ko ket noi duoc");
$conn -> open("Provider = MQLOLEDB.1;UID=username,PWD=password; initial catalog=ten_csdl;Server=ten_server");
?>

<?
$rs = $conn->execute("select * from tbltest");
while (!$rs->EOF)
{
$fv = $rs->fields("myfield");
echo $fv->value."<br>";
$rs->movenext();
}
$rs->close();
?>

<?
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);
?>