<body bgcolor=#ffffdd>
<b>database</b>: test <b>table</b>: student, subject, regist<br>
<form action=''>
<textarea name=q rows=4 cols=90 wrap=off>
select * from student join regist
where student.sid = regist.sid
order by regist.ryear,regist.sid
</textarea>
<input type=submit value=query>
</form>
<?
$c = mysql_connect("127.0.0.1:3306","admin","p");
if (isset($_REQUEST["q"]) && strlen($_REQUEST["q"]) > 5) {
$q = stripslashes($_REQUEST["q"]);
$result = mysql_db_query("test",$q);
} else {
$q = "select * from student";
$result = mysql_db_query("test",$q);
}
while($row = mysql_fetch_array($result)) {
for($i=0;$i<count($row);$i++)
if(isset($row[$i])) echo $row[$i]."_";
echo "<hr>";
}
mysql_close($c);
?>
|
