你的puttime是timedata类型吧,用time()函数得到的不能直接插入数据库里,要对它进行处理:
$date=getdate();
$time=$date["year"]."-";
$time=$time.$date["mon"]."-";
$time=$time.$date["mday"]." ";
$time=$time.$date["hours"].":";
$time=$time.$date["minutes"].":";
$time=$time.$date["seconds"];
$date=getdate();
$time=$date["year"]."-";
$time=$time.$date["mon"]."-";
$time=$time.$date["mday"]." ";
$time=$time.$date["hours"].":";
$time=$time.$date["minutes"].":";
$time=$time.$date["seconds"];
(2)在程序的最后输出
mysql_quer(...);
echo mysql_errno().":".mysql_error();
可以得到错误的编号和信息。
你先將
$sql="inert into chat(name,puttime,chat) values('$name','$time','$chat')";
mysql_query($sql,$conn);
}
?>
<form method="post" action="put.php">改為
$sql="insert into chat(name,puttime,chat) values('$name','$time','$chat')";
mysql_query($sql,$conn);
}
?>
<form name=form1 method="post" action=="<?=$PHP_SELF?>">
試試看