UC知道php+mysql新手问题
来源：百度知道 编辑：UC知道 时间：2024/06/25 18:49:23
刚学pHP做个留言板~！~大家帮我看看为什么留言数据写不进数据库啊
<?php
echo $_POST['name'].'<p>';
echo $_POST['sex'].'<p>';
echo $_POST['email'].'<p>';
echo $_POST['info'];
//连接数据库
$mysql_server_name = "localhost";
$mysql_username = "root";
$mysql_password = "root";
$mysql_database = "wwx";
$sql = "INSERT INTO `wwx`.`gbook` (`id` ,`name` ,`sex` ,`email` ,`info` )VALUES ('' '$_POST['name']', '$_POST['sex']', '$_POST['email']', '$_POST['info]')";
$conn=mysql_connect( $mysql_server_name,$mysql_username,$mysql_password);
mysql_select_db($mysql_database,$conn);
$result = mysql_query($sql);
$id = mysql_insert_id();
mysql_close($conn);
?>
<?php
echo $_POST['name'].'<p>';
echo $_POST['sex'].'<p>';
echo $_POST['email'].'<p>';
echo $_POST['info'];
//连接数据库
$mysql_server_name = "localhost";
$mysql_username = "root";
$mysql_password = "root";
$mysql_database = "wwx";
$sql = "INSERT INTO `wwx`.`gbook` (`id` ,`name` ,`sex` ,`email` ,`info` )VALUES ('' '$_POST['name']', '$_POST['sex']', '$_POST['email']', '$_POST['info]')";
$conn=mysql_connect( $mysql_server_name,$mysql_username,$mysql_password);
mysql_select_db($mysql_database,$conn);
$result = mysql_query($sql);
$id = mysql_insert_id();
mysql_close($conn);
?>
$sql = <<<END
INSERT INTO wwx.gbook (name,sex,email,info)
VALUES ("$_POST['name']", "$_POST['sex']", "$_POST['email']", "$_POST['info]")
END;
你的SQL里面引号嵌套太多，我给你改为上面这样的多行字符串形式，至于第一个END后面不能有任何字符，第二个END前面不能有任何字符，包括空格。