E作者kinglislie (小黑)
看板PHP
标题[请益] 资料库相关
时间Wed Jun 18 17:15:03 2008
我用Dreamweaver插入记录功能把form里的资料放入资料库
有几个form已经是成功的
不过突然有一个一直遇到以下错误
Warning: Invalid argument supplied for foreach() in
C:\AppServ\www\XXX.php on line 37
Warning: Cannot modify header information - headers already
sent by (output started at C:\AppServ\www\XXX.php:37)
in C:\AppServ\www\XXX.php on line 53
不知道有没有哪位大大知道如何解决??
有点冗长...黄色为第53行
蓝色为第37行
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form2")) {
foreach($_POST['pizza _name'] as $i => $val){
$insertSQL = sprintf("INSERT INTO pizza_order (ordernum, pizza_name, Vegetable, PS, Price) VALUES (%s, %s, %s, %s, %s)",
GetSQLValueString($_POST['ordernum'], "text"),
GetSQLValueString($_POST['pizza _name'][$i], "text"),
GetSQLValueString($_POST['Vegetable'][$i], "text"),
GetSQLValueString($_POST['PS'][$i], "text"),
GetSQLValueString($_POST['Price'][$i], "int"));
mysql_select_db($database_products, $products);
$Result1 = mysql_query($insertSQL, $products) or die(mysql_error());
}
$insertGoTo = "index.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
?>
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 123.193.146.62
1F：→ jimms:53行是....？ 06/18 17:24
※ 编辑: kinglislie 来自: 123.193.146.62 (06/18 17:27)
2F：推 yanli2:if ((isset($_POST["MM_insert"]))←多一个括号,右边也是 06/18 17:28
3F：→ kinglislie:不过那是系统自动产生的程式码说...我检查一下成功的 06/18 17:31
4F：→ kinglislie:也都是相同的括法耶>_____<.... 06/18 17:32
5F：→ arianda:BOM?还是你这档案最前面有空白? 06/18 18:02
6F：→ arianda:黄色部份的header使用时候，前面不可输出任何字元 06/18 18:03
7F：→ arianda:蓝色部份你要先确认$_POST['pizza _name']是阵列元素 06/18 18:04
8F：→ arianda:用var_dump($_POST['pizza _name'])看看结构 06/18 18:04