- <?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://www.phpxs.com/code/1003342/