PHP里资料无法在mysql中记录
来源:百度知道 编辑:UC知道 时间:2024/06/17 04:34:46
<?
echo $_POST['name'].'</p>';
echo $_POST['sex'].'</p>';
echo $_POST['email'].'</p>';
echo $_POST['info'].'</p>';
$ip = getenv('REMOTE_ADDR');
//insert语法
//基本设定
$mysql_server_name = "localhost:8000";
$mysql_username = "root";
$mysql_password = "root";
$mysql_database = "milk";
$sql = 'INSERT INTO `milk`.`gbook` (`id`, `name`, `sex`, `email`, `info`, `ip`, `time_at`) VALUES (NULL, \'$name\', \'$sex\', \'$email\', \$info\', \'$ip\', NOW());';
//$sql = "'INSERT INTO `milk`.`gbook` (`id`, `name`, `sex`, `email`, `info`, `ip`, `time_at`) VALUES (NULL, \'dd\', \'1\', \'32131@163.com\', \'fdsafasfasdfsdafsabbbbbbb&
echo $_POST['name'].'</p>';
echo $_POST['sex'].'</p>';
echo $_POST['email'].'</p>';
echo $_POST['info'].'</p>';
$ip = getenv('REMOTE_ADDR');
//insert语法
//基本设定
$mysql_server_name = "localhost:8000";
$mysql_username = "root";
$mysql_password = "root";
$mysql_database = "milk";
$sql = 'INSERT INTO `milk`.`gbook` (`id`, `name`, `sex`, `email`, `info`, `ip`, `time_at`) VALUES (NULL, \'$name\', \'$sex\', \'$email\', \$info\', \'$ip\', NOW());';
//$sql = "'INSERT INTO `milk`.`gbook` (`id`, `name`, `sex`, `email`, `info`, `ip`, `time_at`) VALUES (NULL, \'dd\', \'1\', \'32131@163.com\', \'fdsafasfasdfsdafsabbbbbbb&
下面的语句有错:
$sql = 'INSERT INTO `milk`.`gbook` (`id`, `name`, `sex`, `email`, `info`, `ip`, `time_at`) VALUES (NULL, \'$name\', \'$sex\', \'$email\', \$info\', \'$ip\', NOW());';
应该修改为:
$sql = "INSERT INTO `milk`.`gbook` (`id`, `name`, `sex`, `email`, `info`, `ip`, `time_at`) VALUES (NULL, '$name', '$sex', '$email', '$info', '$ip', NOW())";
因为但引号不解释变量!
此外,下面这段语句也应该修改:
echo $_POST['name'].'</p>';
echo $_POST['sex'].'</p>';
echo $_POST['email'].'</p>';
echo $_POST['info'].'</p>';
改为:
$name=$_POST['name'];
$sex=$_POST['sex'];
$email=$_POST['email'];
$info=$_POST['info'];
把你的SQL打印出来,然后放到phpmyadmin中运行一下,看看是否报错,
另外,我怀疑你的字段长度设