PHP高手们 帮我解决下好吗 insert into

Question

-------------------------------------------------------------------------------------
write.php
-------------------------------------------------------------------------------------<?
  include "lib.php";
  $connect = dbconn();
?><form action="write_post.php" method="post" enctype="multipart/form-data"><li><input type="text" name="subject" size="60" />
<li><input type="text" name="name" size="20" />
<li><input type="text" name="email" size="30" />
<li><input type="password" name="password" size="20" />
<li><textarea name="memo" cols="70" rows="8" /></textarea>
<li><input type="text" name="url" size="60" />
<li><input type="file" name="file" size="50" />
<li><input type="submit" value="发布" /></form>-------------------------------------------------------------------------------------
write_post.php
-------------------------------------------------------------------------------------
<?
  include "lib.php";
  $connect = dbconn();
  
  $query = "insert into moasan_board_data(  // <- 问题就是这里 到底怎么写才正确呢？
  id,
  subject,
  name,
  email,
  password,
  memo,
  url,
  regdate)
  values(
  '$id',
  '$subject',
  '$name',
  '$email',
  '$password',
  '$memo',
  '$url',
  '$regdate')";
    
  mysql_query($query, $connect);
?><script>
  location.href='list.php';
</script>
-------------------------------------------------------------------------------------
lib.php
-------------------------------------------------------------------------------------<?
  function dbconn(){
    $connect = mysql_connect("localhost","root","123");
mysql_select_db('moasan',$connect);
return $connect;
  }
?>-------------------------------------------------------------------------------------问题就是 insert into moasan_board_data 不能上传 数据库里 看了 数据库里 确实没进来
  id
  subject
  name
  email
  password  内容都不显示 高手们帮我解决下好吗 55555

Answer 1

 $query = 写成一行，
$query = "insert into moasan_board_data( id,subject……

Answer 2

你先打印下$query，看是否取到了值。

Answer 3

$query = "insert into moasan_board_data"
     ."( id,subject,name,email,password,memo,url, regdate) values('"
     .$_POST['id']."','".$_POST['subject']."','".$_POST['name']."','"
     .$_POST['email']."','".$_POST['password']."','".$_POST['memo']."','".$_POST['url']
     ."', '".$_POST['regdate']."');";