`mk_id` int(10) unsigned NOT NULL auto_increment,
`title` text collate utf8_bin NOT NULL,
`content` text collate utf8_bin NOT NULL,
`type` enum('url','txt','rss') collate utf8_bin NOT NULL,
`sort` int(11) unsigned NOT NULL,
`star` enum('N','Y') collate utf8_bin NOT NULL,
`time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`mk_id`)
直接用phpmyadmin建立的简单数据表结构
数据库连接正常,但是我插入如下记录或出错
$time = date("Y-m-d H:i:s");
'insert into s values(0,"Yupoo收费了","http://omiga.org/blog/archives/130","url",1,"N")
新手~对MySQL不熟悉···先谢过
`title` text collate utf8_bin NOT NULL,
`content` text collate utf8_bin NOT NULL,
`type` enum('url','txt','rss') collate utf8_bin NOT NULL,
`sort` int(11) unsigned NOT NULL,
`star` enum('N','Y') collate utf8_bin NOT NULL,
`time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`mk_id`)
直接用phpmyadmin建立的简单数据表结构
数据库连接正常,但是我插入如下记录或出错
$time = date("Y-m-d H:i:s");
'insert into s values(0,"Yupoo收费了","http://omiga.org/blog/archives/130","url",1,"N")
新手~对MySQL不熟悉···先谢过
addslashes()函数