<?php
date_default_timezone_set("PRC");
if(isset($_POST['submit'])){
$title=htmlentities($_POST['diaryTitle']);//获取日记标题
$content=htmlentities($_POST['textarea']);//获取日记内容
$datetime=date("Y-m-d").date("H:i:s");
$mysqli=new mysqli("localhost","root","secret","test");
if($mysqli->errno)
printf("connect error:%s",$mysqli->error);
$query="insert into diary(id,title,content,date) values
(1,$title,$content,$datetime)";//diary是表名,有四个字段,id,title,content,date
$result=$mysqli->query($query,MYSQLI_STORE_RESULT);
?>
语法上没有报错,但是phpmyadmin上就是没有记录,行数总为零,请各位帮忙看下
date_default_timezone_set("PRC");
if(isset($_POST['submit'])){
$title=htmlentities($_POST['diaryTitle']);//获取日记标题
$content=htmlentities($_POST['textarea']);//获取日记内容
$datetime=date("Y-m-d").date("H:i:s");
$mysqli=new mysqli("localhost","root","secret","test");
if($mysqli->errno)
printf("connect error:%s",$mysqli->error);
$query="insert into diary(id,title,content,date) values
(1,$title,$content,$datetime)";//diary是表名,有四个字段,id,title,content,date
$result=$mysqli->query($query,MYSQLI_STORE_RESULT);
?>
语法上没有报错,但是phpmyadmin上就是没有记录,行数总为零,请各位帮忙看下
if (!$result=$mysqli->query($query,MYSQLI_STORE_RESULT)) echo $mysqli->error;
“You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':23:42)' at line 1”能告诉我是哪错了么???
另外,表中的date字段是什么类型的?
$query="insert into diary (id,title,content,date) values (1,'{$title}','{$content}','{$datetime}')";
(1,$title,$content,$datetime)";//diary是表名,有四个字段,id,title,content,date你的id字段是不是自动编号(auto_increment),如果你的id编号也是自动编号,你就不能用1,应该用NULL,最后应该变成:[code=PHP]$query="insert into `diary`(`id`,`title`,`content`,`date`) values
(NULL,'$title','$content','$datetime')";你复制上去看一下是否可以
左边的括号好像不一样,不是用英文的,好像你用中文的,所以最终应该是$query="insert into `diary`(`id`,`title`,`content`,`date`) values(NULL,'$title','$content','$datetime')";