<html>
<body>
<?/* 该段用于连接数据库 */$connect = mysql_connect("localhost","root","");
/* echo "Root user login in MYSQL server @ localhost successful. \n <br>"; */
$selectdb = mysql_select_db("num_data");/* 该段用于初始化各变量 */$temp_url = "";
$temp_string = "";
$code_02 = 0;$color_1_add = 0;
$data['color_1'] = array('01'=>0,'02'=>1,'04'=>0,'08'=>0,'16'=>0,'32'=>0,'64'=>0);$size_1_add = 0;
$data['size_1'] = array('01'=>0,'02'=>2,'04'=>0);$shape_1_add = 0;
$data['shape_1'] = array('0001'=>0,'0002'=>3,'0004'=>0,'0008'=>0,'0016'=>0,'0032'=>0,'0064'=>0,
'0128'=>0,'0256'=>0,'0512'=>0,'1024'=>0,'2048'=>0,'4096'=>0);/* 该段用于取出上级表单所传递过来的值,并对同类变量的值进行累加,生成编码的第三、四、五位 */foreach($data as $key=>$values){
$addkey = $key."_add";
foreach($values as $subkey=>$value){
if(isset ($_POST["$key_$subkey"])){
$data[$key][$subkey] = $_POST["$key_$subkey"];
$$addkey += $_POST["$key_$subkey"];
}
}
}/* 该段用于判断编码是否有效,若有效,则将编码存入数据库;若无效,则弹出错误提示网页,返回上一级诊断网页 */echo '$color_1_add = ',$color_1_add,"<br>";
echo '$size_1_add = ',$size_1_add,"<br>";
echo '$shape_1_add = ',$shape_1_add,"<br>";if (($color_1_add > 0)&&($size_1_add > 0)&&($shape_1_add > 0))
{
$code_02 = 1;
$temp_string = " insert into tomato_temp values(".$code_02.")";
$inserttable = mysql_query($temp_string);
$temp_string = " insert into tomato_temp values(".$color_1_add.")";
$inserttable = mysql_query($temp_string);
$temp_string = " insert into tomato_temp values(".$size_1_add.")";
$inserttable = mysql_query($temp_string);
$temp_string = " insert into tomato_temp values(".$shape_1_add.")";
$inserttable = mysql_query($temp_string);
}
else
{
$temp_url = "error_1.htm";
echo "<script language='javascript'>";
echo " location='$temp_url';";
echo "</script>";
}
?>
</body>——————————————————————————————————
<body>
<?/* 该段用于连接数据库 */$connect = mysql_connect("localhost","root","");
/* echo "Root user login in MYSQL server @ localhost successful. \n <br>"; */
$selectdb = mysql_select_db("num_data");/* 该段用于初始化各变量 */$temp_url = "";
$temp_string = "";
$code_02 = 0;$color_1_add = 0;
$data['color_1'] = array('01'=>0,'02'=>1,'04'=>0,'08'=>0,'16'=>0,'32'=>0,'64'=>0);$size_1_add = 0;
$data['size_1'] = array('01'=>0,'02'=>2,'04'=>0);$shape_1_add = 0;
$data['shape_1'] = array('0001'=>0,'0002'=>3,'0004'=>0,'0008'=>0,'0016'=>0,'0032'=>0,'0064'=>0,
'0128'=>0,'0256'=>0,'0512'=>0,'1024'=>0,'2048'=>0,'4096'=>0);/* 该段用于取出上级表单所传递过来的值,并对同类变量的值进行累加,生成编码的第三、四、五位 */foreach($data as $key=>$values){
$addkey = $key."_add";
foreach($values as $subkey=>$value){
if(isset ($_POST["$key_$subkey"])){
$data[$key][$subkey] = $_POST["$key_$subkey"];
$$addkey += $_POST["$key_$subkey"];
}
}
}/* 该段用于判断编码是否有效,若有效,则将编码存入数据库;若无效,则弹出错误提示网页,返回上一级诊断网页 */echo '$color_1_add = ',$color_1_add,"<br>";
echo '$size_1_add = ',$size_1_add,"<br>";
echo '$shape_1_add = ',$shape_1_add,"<br>";if (($color_1_add > 0)&&($size_1_add > 0)&&($shape_1_add > 0))
{
$code_02 = 1;
$temp_string = " insert into tomato_temp values(".$code_02.")";
$inserttable = mysql_query($temp_string);
$temp_string = " insert into tomato_temp values(".$color_1_add.")";
$inserttable = mysql_query($temp_string);
$temp_string = " insert into tomato_temp values(".$size_1_add.")";
$inserttable = mysql_query($temp_string);
$temp_string = " insert into tomato_temp values(".$shape_1_add.")";
$inserttable = mysql_query($temp_string);
}
else
{
$temp_url = "error_1.htm";
echo "<script language='javascript'>";
echo " location='$temp_url';";
echo "</script>";
}
?>
</body>——————————————————————————————————
<html>
<body>
<?
/* 该段用于连接数据库 */$connect = mysql_connect("localhost","root","");
/* echo "Root user login in MYSQL server @ localhost successful. \n <br>"; */
$selectdb = mysql_select_db("num_data");/* 该段用于初始化各变量 */$temp_url = "";
$temp_string = "";
$code_02 = 0;$color_1_add = 0;
$data['color_1'] = array('01'=>0,'02'=>1,'04'=>0,'08'=>0,'16'=>0,'32'=>0,'64'=>0);
$size_1_add = 0;
$data['size_1'] = array('01'=>0,'02'=>2,'04'=>0);
$shape_1_add = 0;
$data['shape_1'] = array('0001'=>0,'0002'=>3,'0004'=>0,'0008'=>0,'0016'=>0,'0032'=>0,'0064'=>0,'0128'=>0,'0256'=>0,'0512'=>0,'1024'=>0,'2048'=>0,'4096'=>0);/* 该段用于取出上级表单所传递过来的值,并对同类变量的值进行累加,生成编码的第三、四、五位 */foreach($data as $key=>$values){
$addkey = $key."_add";
foreach($values as $subkey=>$value){
if(isset ($_POST["$key_$subkey"])){
$data[$key][$subkey] = $_POST["$key_$subkey"];
$$addkey += $_POST["$key_$subkey"];
}
}
}/* 该段用于判断编码是否有效,若有效,则将编码存入数据库;若无效,则弹出错误提示网页,返回上一级诊断网页 */echo '$color_1_add = ',$color_1_add,"<br>";
echo '$size_1_add = ',$size_1_add,"<br>";
echo '$shape_1_add = ',$shape_1_add,"<br>";if (($color_1_add > 0)&&($size_1_add > 0)&&($shape_1_add > 0))
{
$code_02 = 1;
$temp_string = " insert into tomato_temp values($code_02),($color_1_add),($size_1_add),($shape_1_add)";
$inserttable = mysql_query($temp_string);
}
else
{
$temp_url = "error_1.htm";
echo "<script language='javascript'>";
echo " location='$temp_url';";
echo "</script>";
}
?>
</body>
——————————————————————————————————
————————————————————————————————————————
if (($color_1_add > 0)&&($size_1_add > 0)&&($shape_1_add > 0))
{
$code_02 = 1;
$temp_string = " insert into tomato_temp values($code_02),($color_1_add),($size_1_add),($shape_1_add)";
$inserttable = mysql_query($temp_string);
}
————————————————————————————————————————
该段程序中的$temp_string若写成$temp_string = " insert into tomato_temp values(".$code_02.",".$color_1_add.",".$size_1_add.",".$shape_1_add.")";是否是更严谨一些?另外请问两者的处理速度和稳定性哪个更好一些,谢谢!!!
<body>
<?/* 该段用于连接数据库 */$connect = mysql_connect("localhost","root","");
/* echo "Root user login in MYSQL server @ localhost successful. \n <br>"; */
$selectdb = mysql_select_db("num_data");/* 该段用于初始化各变量 */$temp_url = "";
$temp_string = "";
$code_02 = 0;$size_1_add = 0;
$color_1_add = 0;
$shape_1_add = 0;/* 该段用于取出上级表单所传递过来的值,并对同类变量的值进行累加,生成编码的第三、四、五位 */foreach($_POST as $k=>$v) {
if(substr($k,0,8) == 'color_1_')
$color_1_add += $v;
if(substr($k,7) == 'size_1_')
$size_1_add += $v;
if(substr($k,8) == 'shape_1_')
$shape_1_add += $v;
}/* 该段用于判断编码是否有效,若有效,则将编码存入数据库;若无效,则弹出错误提示网页,返回上一级诊断网页 */echo '$color_1_add = ',$color_1_add,"<br>";
echo '$size_1_add = ',$size_1_add,"<br>";
echo '$shape_1_add = ',$shape_1_add,"<br>";if (($color_1_add > 0)&&($size_1_add > 0)&&($shape_1_add > 0))
{
$code_02 = 1;
$temp_string = " insert into tomato_temp values($code_02),($color_1_add),$size_1_add"),($shape_1_add)";
$inserttable = mysql_query($temp_string);
}
else
{
$temp_url = "error_1.htm";
echo "<script language='javascript'>";
echo " location='$temp_url';";
echo "</script>";
}
?>
</body>注意:
$temp_string = " insert into tomato_temp values($code_02),($color_1_add),($size_1_add),($shape_1_add)";
和
$temp_string = " insert into tomato_temp values(".$code_02.",".$color_1_add.",".$size_1_add.",".$shape_1_add.")";
是两回事