在我的网站上,用户填写一个表单进行注册,然后将该信息添加到数据库中。我试图让信息被写入一个CSV文件也。到目前为止,我的代码给出了这个错误:
警告:fopen() [function。在/home/content/m/a/t/matronryan/html/sendmail3.php第122行
122行:$fp = fopen($filename, "w");
我想不出问题是什么。下面是代码:$first_name = $_POST['first_name']; // required
$last_name = $_POST['last_name']; // required
$email_from = $_POST['email']; // required
$stilldonate = $_POST['stilldonate']; // not required
$phone = $_POST['phone'];
$bid = $_POST['bid']; // required
$item = $_POST['item'];
$address1 = $_POST['address1']; // required
$address2 = $_POST['address2'];
$city = $_POST['city'];
$county = $_POST['county']; // required
$postcode = $_POST['postcode']; // required
$updated = $_POST['updated'];
include('db_functions.php');
connect_to_db();
$query="insert into auctionusers (firstname, lastname, address1, address2, city, county, postcode, email, phone, bid, stilldonate, item, updated) values ('$first_name', '$last_name', '$address1', '$address2', '$city', '$county', '$postcode', '$email_from', '$phone', '$bid', '$stilldonate', '$item', '$updated')";
$result=mysql_query($query);
$filename == 'auctionusers.csv';
$fp = fopen($filename, "w");
$res = mysql_query("SELECT * FROM auctionusers");
// fetch a row and write the column names out to the file
$row = mysql_fetch_assoc($res);
$line = "";
$comma = "";
foreach($row as $name => $value) {
$line .= $comma . '"' . str_replace('"', '""', $name) . '"';
$comma = ",";
}
$line .= "n";
fputs($fp, $line);
// remove the result pointer back to the start
mysql_data_seek($res, 0);
// and loop through the actual data
while($row = mysql_fetch_assoc($res)) {
$line = "";
$comma = "";
foreach($row as $value) {
$line .= $comma . '"' . str_replace('"', '""', $value) . '"';
$comma = ",";
}
$line .= "n";
fputs($fp, $line);
}
fclose($fp);
mysql_close();
header('location: index2.php?op=Thank You&id=bid');
}
?>
有谁能看出是怎么回事吗?
变化:
$filename == 'auctionusers.csv';
:
$filename = 'auctionusers.csv';
Double equal对变量执行布尔运算。你一定是加错等号了