21,889
社区成员
发帖
与我相关
我的任务
分享这个为什么执行不了？
<html>
<head>
<title>PHP SQL Code Tester</title>
</head>
<body>
<?
$host="localhost";
$user="root";
$password="";
?>
<FORM METHOD=POST ACTION="mysql_test.php">
Please select the database for the query:<br><br>
<select name=database size=1>
<?php
mysql_connect($host,$user,$password);
$db_table= mysql_list_dbs();
for ($i=0; $i< mysql_num_rows($db_table);$i++)
{
echo ("<OPTION>".mysql_tablename($db_table,$i));
}
?>
</select><br><br>
SQL query:<br><br>
<TEXTAREA NAME="query" ROWS="10" COLS="50"></TEXTAREA><br><br>
<INPUT TYPE="submit" value="Execute Query!">
</FORM>
</body>
</html>
//mysql_test.php
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
</HEAD>
<BODY>
<?
$host="localhost";
$user="root";
$password="";
mysql_connect($host,$user,$password);
mysql_select_db($database);
$query=stripSlashes($query);
$result=mysql_query($query);
?>
Results of query <b><?php echo($query);?></b><br>
<?php
if ($result == 0):
echo ("<b>error ".mysql_errno() . ": " . mysql_error() ."</b>");
elseif (mysql_num_rows($result)==0):
echo ("<b>Query executed successfully!</b>");
else:
?>
<TABLE>
<Thead>
<tr>
<?php
for ($i=0;$i<mysql_num_fields($result);$i++){
echo ("<th>".mysql_field_name($result,$i). "</th>");
}
?>
</TR>
</thead>
<tbody>
<?php
for ($i =0; $i <mysql_num_rows($result);$i++){
echo("<tr>");
$row_array=mysql_fetch_row($result);
for ($j =0; $j<mysql_num_fields($result);$j++){
echo ("<td>" .$row_array[$j] . "</td>");
}
echo ("</tr>");
}
?>
</tbody>
</TABLE>
<?php
endif
?>
<hr>
<br>
<FORM METHOD=POST ACTION="query.php">
<INPUT TYPE="submit" value="New query">
</FORM>
</BODY>
</HTML>
<head>
<title>PHP SQL Code Tester</title>
</head>
<body>
<?
$host="localhost";
$user="root";
$password="";
?>
<FORM METHOD=POST ACTION="mysql_test.php">
Please select the database for the query:<br><br>
<select name=database size=1>
<?php
mysql_connect($host,$user,$password);
$db_table= mysql_list_dbs();
for ($i=0; $i< mysql_num_rows($db_table);$i++)
{
echo ("<OPTION>".mysql_tablename($db_table,$i));
}
?>
</select><br><br>
SQL query:<br><br>
<TEXTAREA NAME="query" ROWS="10" COLS="50"></TEXTAREA><br><br>
<INPUT TYPE="submit" value="Execute Query!">
</FORM>
</body>
</html>
//mysql_test.php
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
</HEAD>
<BODY>
<?
$host="localhost";
$user="root";
$password="";
mysql_connect($host,$user,$password);
mysql_select_db($database);
$query=stripSlashes($query);
$result=mysql_query($query);
?>
Results of query <b><?php echo($query);?></b><br>
<?php
if ($result == 0):
echo ("<b>error ".mysql_errno() . ": " . mysql_error() ."</b>");
elseif (mysql_num_rows($result)==0):
echo ("<b>Query executed successfully!</b>");
else:
?>
<TABLE>
<Thead>
<tr>
<?php
for ($i=0;$i<mysql_num_fields($result);$i++){
echo ("<th>".mysql_field_name($result,$i). "</th>");
}
?>
</TR>
</thead>
<tbody>
<?php
for ($i =0; $i <mysql_num_rows($result);$i++){
echo("<tr>");
$row_array=mysql_fetch_row($result);
for ($j =0; $j<mysql_num_fields($result);$j++){
echo ("<td>" .$row_array[$j] . "</td>");
}
echo ("</tr>");
}
?>
</tbody>
</TABLE>
<?php
endif
?>
<hr>
<br>
<FORM METHOD=POST ACTION="query.php">
<INPUT TYPE="submit" value="New query">
</FORM>
</BODY>
</HTML>
...全文
请发表友善的回复…
发表回复
