PHP和下拉列表 [英] PHP and dropdownlist

问题描述

大家好！我需要你的帮助 ！我正在用PHP做一个表单，想在我的DB的dropdownlist name列中显示并保存从DB的dropdownlist中选择的名称的name_id.这是我的代码.

Hi guys! I need your help ! I''m doing a form in PHP and a want to display in my dropdownlist name column from my DB and save the name_id of that name selected from dropdownlist in DB. Here is my code.

if(isset($_POST["submit"]))
	{
	$bookshop_id = mysql_real_escape_string($_POST["bookshop_id"]);
	$book_id = mysql_real_escape_string($_POST["book_id"]);
	$quantity = mysql_real_escape_string($_POST["quantity"]);
		
mysql_query("INSERT INTO `books_bookshop`(`bookshop_id`,`book_id`,`quantity`)
             VALUES ('" . $bookshop_id . "','" . $book_id . "','" . $quantity . "')") 
or die ("Book could not be registered.");
		
}
	
?>
<form method="post" action="#">
<label for="bookshop_id">Bookshop Name</label>
<select style="width:148px;" id="bookshop_id" name="bookshop_id" value="bookshop_id">
<option>
<?php echo $row["name"]; ??>
</option>
<?php } ??>
</select>


<table><tbody><tr><td><select name="book" id="book" value="book">
<?php $query = mysql_query("SELECT `name` FROM `books`");<br mode="hold" /?>while ($row = mysql_fetch_array($query)){?>
<option><?php echo $row["name"]; ??></option>
<?php } ??>
</select>
<table><tbody><tr>
<td><input type="submit" name="submit" value="Register book"></input></td>
</tr></tbody></table>

</td></tr></tbody></table></form>

推荐答案

_POST [ 提交"]))) {

_POST["submit"])) {

bookshop_id = mysql_real_escape_string(

bookshop_id = mysql_real_escape_string(

_POST [ bookshop_id"])；

_POST["bookshop_id"]);

这篇关于PHP和下拉列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！