MYSQL无法记录

来源:百度知道 编辑:UC知道 时间:2024/05/15 11:48:51
<?

echo $name=$_POST['name']</p>;
echo $sex=$_POST['sex']</p>;
echo $email=$_POST['email']</p>;
echo $info=$_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())";

$conn=mysql_connect($mysql_srver_name,$mysql_username,$mysql_password);
mysql_select_db($mysql_database,$conn);
$result = mysql_query($sql);
$id = mysql_insert_id();
mysql_close($conn);

?>

======================================================
这段代码

$sql = "INSERT INTO `milk`.`gbook` (`id`, `name`, `sex`, `email`, `info`, `ip`, `time_at`)
我没记错的话 INSERT INTO 后面应该是表名吧?你这里怎么看到2个表名呢(milk`.`gbook)?如果要同时添加2个表,最好分开来添加,这样比较简单 明了