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);
?>
======================================================
这段代码
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个表,最好分开来添加,这样比较简单 明了