adm_addpara.php

这个版本只是修正了一些BUG

<?php
/*
	adm_addpara.php

	Version  : 1.0.0
	Author   : Tracemouse ([e-mail])
	Copyright: http://www.vitci.com
	Writed   : 2003/08/20
	Modified : 2003/12/15
*/

require "./common.php";
$file_name='./adm_addpara.php';

if (!$productid) $productid=0;

$sqlstr="SELECT productname,paraid FROM $table_products WHERE productid=$productid";
$query = $db->query($sqlstr);
if($dbq_rec = $db->fetch_array($query))
{
	if ($dbq_rec['paraid'] == 1)
  		gotourl($language['product_nopara']);
  	else
    {
    	$paraid=$dbq_rec['paraid'];
    	$productname=$dbq_rec['productname'];
    }
}
else
{
  gotourl($language['db_notfound']);
}


if (!$editsubmit)           //未发送表单
{
    $sqlstr="SELECT paraname FROM $table_parameters WHERE paraid=$paraid";
    if($query=$db->query($sqlstr))
		$paraname=$db->result($query,0);
	else
    	gotourl($language['db_err'].":<br>".$sqlstr);
    $sqlstr="SELECT a.productid,a.paraid,a.varname,a.value,b.varhint,b.remarks
		 FROM $table_paravals a ,$table_paravars b WHERE
		 a.paraid=b.paraid AND a.varname=b.varname AND a.productid=$productid";
	$query=$db->query($sqlstr);
	$line='';
	$all_varname = $comma = ' ';
	while($dbq_rec = $db->fetch_array($query))
	{
 		$varname=$dbq_rec['varname'];
 		$all_varname .= $comma.'\''.$varname.'\'';
 		$comma=',';
 		$varhint=$dbq_rec['varhint'];
 		$remarks=$dbq_rec['remarks'];
 		$value=$dbq_rec['value'];
 		$line=$line."<tr class=line_1><td><b>".$varhint.":</b><br>".$remarks."</td>";
 		$line=$line."<td><input type=text size=60 value='".$value."' name=".$varname."></td></tr>";
	}
	if ($all_varname == ' ') $all_varname='\' \'';

	$sql="SELECT varname,varhint,remarks FROM $table_paravars WHERE paraid = $paraid AND varname NOT IN ($all_varname)";
	$query=$db->query($sql);
	while($dbq_rec = $db->fetch_array($query))
	{
 		$varname=$dbq_rec['varname'];
 		$varhint=$dbq_rec['varhint'];
 		$remarks=$dbq_rec['remarks'];
 		$line=$line."<tr class=line_1><td width=40%><b>".$varhint.":</b><br>".$remarks."</td>";
 		$line=$line."<td><input type=text size=60  name=".$varname."></td></tr>";
	}
}
elseif ($editsubmit)    //发送表单处理
{
	$sqlstr="SELECT paraid,varname FROM $table_paravars WHERE paraid = $paraid";
  	$query=$db->query($sqlstr);
  	while($dbq_rec = $db->fetch_array($query))
  	{
    	$varname=$dbq_rec['varname'];
    	$value=$$varname;
   		$query_1 = $db->query("SELECT COUNT(*) FROM $table_paravals WHERE paraid =$paraid AND productid=$productid AND varname='$varname'");
    	$recnum = $db->result($query_1, 0);
    	if ($recnum == 0)
       		$sqlstr="INSERT INTO $table_paravals(productid,paraid,varname,value)
          		 VALUES($productid,$paraid,'$varname','$value')";
    	else
    	 	$sqlstr="UPDATE $table_paravals SET value = '$value'
     	    	  WHERE productid=$productid AND paraid=$paraid AND varname='$varname'";
      	if(!($query_1=$db->query($sqlstr)))
        	gotourl($language['db_err'].":<br>".$sqlstr);
   	}
    gotourl($language['editsuccess'],'./adm_product.php?searchsubmit=act&productid='.$productid);
}

include template('addpara');
?>