所以我正在尝试为时事通讯注册表单存储一些用户信息，它在 XAMPP 中运行良好，但我在将数据保存到我的实时数据库 （GoDaddy） 时遇到了一些麻烦。我还回显了一个错误语句，它说我的查询是空的，但我无法弄清楚为什么......这是我的代码（电子邮件重复测试也在本地工作，但显然不再有效）：
<?php
//Start session
session_start();
//Log into the server
@ $db = mysql_pconnect("hostnamewashere", "usernamewashere", "pwwashere");
//Select the database desired
mysql_select_db("databasenamewashere");
//If no connection can be made, echo it out to the screen
if(!$db){
echo "Error: Could not connect to the database. Please try again later.";
exit;
}
//Retrieve data from form and create variables
$email = Trim(($_POST['email']));
$ip_orig = $_SERVER['REMOTE_ADDR'];
$ip = ip2long($ip_orig);
$date = date('Y-m-d');
$time = date('H:i:s');
//Validate data
if(empty($_POST['email'])) {
$_SESSION["errorMsg"] = "Please enter your email.";
Header("Location: index.php");
exit;
}
if(!preg_match("/^[_'.0-9a-zA-Z-]+@([0-9a-zA-Z][0-9a-zA-Z-]+'.)+[a-zA-Z]{2,6}$/i", ($_POST['email']))) {
$_SESSION["errorMsg"] = "Incorrect email format; please try again.";
Header("Location: index.php");
exit;
}
//Check to see that no duplicates exist in the database
$sql = "SELECT newsletter_email FROM Newsletter WHERE newsletter_email='".$email."'";
$result = mysql_query($sql);
if(empty($result)) {
$num_results = 0;
}else {
$num_results = mysql_num_rows($result);
}
if($num_results !== 0) {
$_SESSION["errorMsg"] = "Sorry, that email address is already in our database.";
Header("Location: index.php");
exit;
}
//Place into database
$sql = "INSERT INTO Newsletter(newsletter_email, newsletter_ip, newsletter_date, newsletter_time) VALUES('".$email."', '".$ip."', '".$date."', '".$time."')";
//Run query and get result back; shouldn't return anything
$result = mysql_query($sql);
//Redirect user to successful registration page
Header("Location: index.php");
$_SESSION["errorMsg"] = "Thanks! We will be in touch with you soon.";
exit;
//Close the database connection
mysql_close($db);
?>
我有点重写了脚本，但我真正看到的唯一给我带来错误的是没有date_default_timezone_set（"America/Los_Angeles"））; set。
以下脚本对我有用：
<?php
//Start session
session_start();
date_default_timezone_set("America/Los_Angeles");
$dbhost = 'localhost';
$dbuser = 'dbuser';
$dbpass = 'pass';
$dbname = 'test';
if ($_POST)
{
//Retrieve data from form and create variables
$email = trim($_POST['email']);
$ip_orig = $_SERVER['REMOTE_ADDR'];
$ip = ip2long($ip_orig);
$date = date('Y-m-d');
$time = date('H:i:s');
//Validate data
if(empty($_POST['email'])) {
$_SESSION["errorMsg"] = "Please enter your email.";
header("Location: index.php");
exit;
}
if(!preg_match("/^[_'.0-9a-zA-Z-]+@([0-9a-zA-Z][0-9a-zA-Z-]+'.)+[a-zA-Z]{2,6}$/i", ($_POST['email']))) {
$_SESSION["errorMsg"] = "Incorrect email format; please try again.";
header("Location: index.php");
exit;
}
//Log into the server
$db = @mysql_pconnect($dbhost, $dbuser, $dbpass);
//Select the database desired
mysql_select_db($dbname);
//If no connection can be made, echo it out to the screen
if(!$db){
echo "Error: Could not connect to the database. Please try again later.";
exit;
}
//Check to see that no duplicates exist in the database
$sql = "SELECT newsletter_email FROM Newsletter WHERE newsletter_email='".$email."'";
$result = mysql_query($sql);
if (mysql_num_rows($result) > 0)
{
$_SESSION["errorMsg"] = "Sorry, that email address is already in our database.";
header("Location: index.php");
exit;
}
//Place into database
$sql = "INSERT INTO Newsletter(newsletter_email, newsletter_ip, newsletter_date, newsletter_time) VALUES('".$email."', '".$ip."', '".$date."', '".$time."')";
//Run query and get result back; shouldn't return anything
$result = mysql_query($sql);
//Redirect user to successful registration page
$_SESSION["errorMsg"] = "Thanks! We will be in touch with you soon.";
header("Location: index.php");
exit;
//Close the database connection
mysql_close($db);
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<form method="post" action="index.php">
<input name="email" value="" />
<input type="submit" name="submit" value="Submit" />
</form>
</body>
</html>