我已经创建了一个基本的管理界面,上传项目到一个小的"网上商店"数据库。该页不会有一个购物车系统,因为没有交易将发生在页面上。整个页面只是用来展示的。我不得不提一下,我已经复制了一些代码,一切都是为了学校的项目。
mysql数据库有一个表,列有:id, product_name, price, details, category, subcategory, date_added"。下面的表单和php代码管理在数据库
中插入新值我希望"子类别"字段根据所选类别仅显示几个选项。为例。如果我选择category=value1,子类别只给我"valuex"one_answers"valuey"之间的选择,所以管理员不能混淆。
如何填充子类别下拉列表?
这里是PHP部分
$product_name = mysql_real_escape_string($_POST['product_name']);
$price = mysql_real_escape_string($_POST['price']);
$category = mysql_real_escape_string($_POST['category']);
$subcategory = mysql_real_escape_string($_POST['subcategory']);
$details = mysql_real_escape_string($_POST['details']);
// See if that product name is an identical match to another product in the system
$sql = mysql_query("SELECT id FROM products WHERE product_name='$product_name' LIMIT 1");
$productMatch = mysql_num_rows($sql); // count the output amount
if ($productMatch > 0) {
echo 'Sorry, rename your product, <a href="inventory_list.php">click here</a>';
exit();
}
// Adds to database database
$sql = mysql_query("INSERT INTO products (product_name, price, details, category, subcategory, date_added)
VALUES('$product_name','$price','$details','$category','$subcategory',now())") or die (mysql_error());
$pid = mysql_insert_id();
// Place image in the folder
$newname = "$pid.jpg";
move_uploaded_file( $_FILES['fileField']['tmp_name'], "../inventory_images/$newname");
header("location: inventory_list.php");
exit();
这就是HTML表单
<div align="right"><a href="inventory_list.php#inventoryForm">+ Add New Inventory Item</a></div>
<a name="inventoryForm" id="inventoryForm"></a>
<h3>
Add New Inventory Item Form
</h3>
<form action="inventory_list.php" enctype="multipart/form-data" name="myForm" id="myform" method="post">
<tr>
<td>Product Name</td>
<td><label>
<input name="product_name" type="text" id="product_name" size="64" />
</label></td>
</tr>
<tr>
<td align="left">Product Price</td>
<td><label>
€
<input name="price" type="text" id="price" size="12" />
</label></td>
</tr>
<tr>
<td align="left">Category</td>
<td><label>
<select name="category" id="category">
<option value="value1">value1</option>
<option value="value2">value2</option>
<option value="value3">value3</option>
</select>
</label></td>
</tr>
<tr>
<td align="left">Subcategory</td>
<td><select name="subcategory" id="subcategory">
<option value=""></option>
<option value="valuex">valuex</option>
<option value="valuey">valuey</option>
<option value="valuez">valuez</option>
</select></td>
</tr>
<tr>
<td align="left">Product Details</td>
<td><label>
<textarea name="details" id="details" cols="64" rows="5"></textarea>
</label></td>
</tr>
<tr>
<td align="left">Product Image</td>
<td><label>
<input type="file" name="fileField" id="fileField" />
</label></td>
</tr>
<tr>
<td> </td>
<td><label>
<input type="submit" name="button" id="button" value="Add Item Now" />
</label></td>
</tr>
</table>
</form>
谢谢大家!
试试这段代码,它将获取类别和子类别,并根据您选择的选项显示选项。让我知道这是有效的。
**<select name="category" id="category"><?php
$category = mysql_query("SELECT category FROM products");
while ($sql = mysql_fetch_array($category)) { ?>
<option value="value1"><?php echo $sql['category']; ?></option>
<?php } ?> </select> $category = mysql_fetch_array($category);
$categoryname = $category['category'];
$sqls = mysql_query("SELECT subcategory FROM products where category
='$categoryname'"); ?> <select name="subcategory" id="subcategory">
<?php $subcategory = mysql_fetch_array($sqls);
while (mysql_fetch_array($subcategory)) { ?>
<option value="value1"><?php echo $subcategory['subcategory']; ?></option>
<?php } ?> </select>**