如何用PHP在网页上直接执行SQL命令？
- 内容介绍
- 文章标签
- 相关推荐
本文共计154个文字，预计阅读时间需要1分钟。
当用户点击提交按钮时，程序会检查是否有ID提交。如果存在，程序会连接数据库并查询Employee表，然后输出名字。
<?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>
本文共计154个文字，预计阅读时间需要1分钟。
当用户点击提交按钮时，程序会检查是否有ID提交。如果存在，程序会连接数据库并查询Employee表，然后输出名字。
<?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>