作者ilay (resolution)
看板FreeBSD
标题Re: [问题] 关於 php5 的怪问题
时间Wed Mar 26 19:03:26 2008
: 你要不要把 php code 贴上来看看 ?
这是主要 code
query.php:
<?php
require("config.php");
header("Content-Type: text/plain; charset=UTF-8");
$db_conn = mysql_connect(mysql_conn_host,mysql_conn_user,mysql_conn_pass)
or die("无法连接资料库\n");//连结资料库系统
$result = mysql_select_db(mysql_db_name, $db_conn);//连上目标资料库
//$db_conn = mysql_connect("localhost","root","netlab") or die("无法连接资料
库\n");//连结资料库系统
//$result = mysql_select_db("Northwind", $db_conn);//连上目标资料库
if($result === FALSE)
{
print "Northwind资料库连接失败\n";
exit();
}
$query = $_POST["query"];//query内容
$result = @mysql_query($query, $db_conn);//下query
$rqfields = mysql_num_rows($result);//查询有多少fields
echo "<\"table width=\"100%\" border=\"0\">";
while($record=mysql_fetch_array($result))//找出所有rows并丢回array
{
echo "<tr>";
for($i=0; $i<$rqfields ;$i++)//列出所有fields
{
echo "<td>"."$record[$i]"."</td>";//印出对应rows
}
echo "</tr>";
}
echo "</table>";
$result = mysql_close($db_conn);//close connect
?>
index.html:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<title>SQL Query : use Northwind</title>
</head>
<body>
<form method="POST" action="query.php">
<textarea name="query" cols="100" rows="15" id="query"></textarea>
<br>
<input type="submit" name="submit" id="submit" value="送出" />
<input type="reset" name="clean" id="clean" value="清除" />
</form>
</body>
</html>
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 210.71.22.15