php 直接在页面上查询数据库,执行SQL语句
直接在页面上查询数据库,执行SQL语句 [代码片段(22行)]
<?php
if (isset($_POST[\'submit\'])) {
$rowID = $_POST[\'id\'];
mysql_connect(\"mysql153.secureserver.net\",\"java2s\",\"password\");
mysql_select_db(\"java2s\");
$query = \"SELECT * FROM Employee WHERE ID=\'$id\'\";
$result = mysql_query($query);
list($name,$productid,$price,$description) = mysql_fetch_row($result);
}
?>
<form action=\"<?php echo $_SERVER[\'PHP_SELF\']; ?>\" method=\"post\">
<select name=\"id\">
<option name=\"\">Choose a employee:</option>
<option name=\"1\">1</option>
<option name=\"2\">2</option>
<option name=\"3\">3</option>
</select>
<input type=\"submit\" name=\"submit\" value=\"Submit\" />
</form>
//该片段来自于http://outofmemory.cn
精彩图集
精彩文章






