<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title></title>
</head>
<body>
<form name="first" action="test.php" method="post">
<input type="text" value="" name="fdfadsfad">
<input type="submit" value="查询" name="submit">
</form>
<?php $area= $_POST["fdfadsfad"];if(!empty ($area))
{
mssql_connect("localhost", "sa", "sa") or die ("连接数据库失败");
mssql_select_db("test1"); $sql = "SELECT longitude,latitude FROM YL_Garden WHERE (gardenname LIKE N'%".$area."%' )";
$result = mssql_query($sql);
echo $sql;
echo mssql_num_rows($result);
while($array = mssql_fetch_array($result))
{
print_r($array);
}
mssql_close();
} ?>
</body>
</html>
实现的功能是在表单中输入字符,点击查询按钮可以得到数据库中的数据!!!
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title></title>
</head>
<body>
<form name="first" action="test.php" method="post">
<input type="text" value="" name="fdfadsfad">
<input type="submit" value="查询" name="submit">
</form>
<?php $area= $_POST["fdfadsfad"];if(!empty ($area))
{
mssql_connect("localhost", "sa", "sa") or die ("连接数据库失败");
mssql_select_db("test1"); $sql = "SELECT longitude,latitude FROM YL_Garden WHERE (gardenname LIKE N'%".$area."%' )";
$result = mssql_query($sql);
echo $sql;
echo mssql_num_rows($result);
while($array = mssql_fetch_array($result))
{
print_r($array);
}
mssql_close();
} ?>
</body>
</html>
实现的功能是在表单中输入字符,点击查询按钮可以得到数据库中的数据!!!
$sql = "SELECT longitude,latitude FROM YL_Garden WHERE gardenname LIKE '%$area%'";