product.php

电子商务---产品发布系统 采用PHP+MYSQL+APACHE的环境,非常方便的一个小系统,可以嵌入其他系统内使用

<?php 
	include('dbconnect.php');
	?>
<script  language="javascript">
	function validate(s){
 	 var pattern = /^[0-9_-]+$/; 
  	return pattern.test(s);
	}
		function check() {
			if (productform.product_id.value==""){
				alert ("产品编号不能为空");
				productform.product_id.focus();
				return false;
				}
			if (productform.product_name.value==""){
				alert ("产品名称不能为空");
				productform.product_name.focus();
				return false;
				}
			if (productform.price.value==""){
				alert ("产品价格不能为空");
				productform.price.focus();
				return false;
				}
			if(!validate(productform.price.value)){
   		   		alert("价格只是数字，请重新填写！");
		   		productform.price.focus();
   		   		return false;
  			}
			if (productform.info.value==""){
				alert ("产品介绍不能为空");
				productform.info.focus();
				return false;
				}
			}
</script>
<form action="process.php?action=create" method="post" name="productform" id="productform" onSubmit="return check()">
  <table width="600" border="0" cellpadding="0" cellspacing="0" class="nofloat">
    <tr>
      <td width="110">&nbsp;</td>
      <td width="490">添加新产品</td>
    </tr>
    <tr>
      <td>产品编号 </td>
      <td><input name="product_id" type="text" id="product_id"></td>
    </tr>
    <tr>
      <td>产品名称</td>
      <td><input name="product_name" type="text" id="product_name"></td>
    </tr>
    <tr>
      <td>产品价格</td>
      <td><input name="price" type="text" id="price"></td>
    </tr>
    <tr>
      <td>产品类别</td>
      <td>	  <select name="classes" id="classes">
  <?php
  	$parent_id='0';
	$classes_sql="select *from classes where parent_id='$parent_id'";
	$classes_result=mysql_query($classes_sql,$conn);
	
	while ($classes_row_root=mysql_fetch_array($classes_result)){
	  echo "<option value=".$classes_row_root['class_name'].">".$classes_row_root['class_name']."</option><br>";
	 
	 	$classes_child_sql="select *from classes where parent_id=".$classes_row_root['class_id'];
		$classes_child_result=mysql_query($classes_child_sql);
		
		while ($classes_row=mysql_fetch_array($classes_child_result))
	  	  echo "<option value=".$classes_row['class_name'].">".$classes_row_root['class_name']."->".$classes_row['class_name']."</option><br>";
			}
		?>
      </select></td>
    </tr>
    <tr>
      <td>原产地</td>
      <td>
	  	<select name="origin" id="origin">
		<?php
	    $sql_origin="select origin_name from origins";
		$result_origin=mysql_query($sql_origin,$conn);
		while ($row_origin=mysql_fetch_array($result_origin)) {
			echo "<option value=".$row_origin['origin_name']." >".$row_origin['origin_name']."</option>";
			}
			?>
        </select>	  </td>
    </tr>
    <tr>
      <td valign="top">产品介绍</td>
      <td><textarea name="info" cols="50" rows="6" id="info"></textarea></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td>        <input name="Submit" type="submit" id="Submit" value="提交">
      <input name="Reset" type="reset" id="Reset" value="重置"></td></tr>
  </table>
</form>