第一段:
$query = "INSERT INTO products (products_quantity) VALUES ('10000')";
if($result33 = mysql_db_query($DataBase, $query)){
$new_id=mysql_insert_id();
echo" product insert ok $new_id <br>";
}
第二段:
$query = "INSERT INTO products (products_quantity) VALUES ('10000')";
$result33 = mysql_db_query($DataBase, $query);
$new_id=mysql_insert_id();
if($result33)
{
echo" product insert ok $new_id <br>";
}
$query = "INSERT INTO products (products_quantity) VALUES ('10000')";
if($result33 = mysql_db_query($DataBase, $query)){
$new_id=mysql_insert_id();
echo" product insert ok $new_id <br>";
}
第二段:
$query = "INSERT INTO products (products_quantity) VALUES ('10000')";
$result33 = mysql_db_query($DataBase, $query);
$new_id=mysql_insert_id();
if($result33)
{
echo" product insert ok $new_id <br>";
}
两者没有区别如果要依赖 MySQL 去检查 SQL 语句的正确性,那么建议你放弃编程
然后我换第一段代码,就没有重复记录的现象了,所以我有点怀疑了,难道 if($result33) 这样也会多运行一次插入记录的操作?
然后我又运行了一次,这两段代码都会造成产品记录的重复插入,难道是MYSQL的配置问题?就用ZENCART系统的products 表进行测试就行了,就会有这种现象在GODADDY上虚拟空间上有这种现象
$result33 = mysql_db_query($DataBase, $query);if($result33)
{
$new_id=mysql_insert_id();
echo" product insert ok $new_id <br>";
}