当前位置 : 主页 > 网络编程 > PHP >

PHP实现直接在页面上执行SQL语句

来源:互联网 收集:自由互联 发布时间:2021-07-03
?phpif (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
<?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>
网友评论