最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
php 增加数据保存到mysql数据库实例教程
时间:2010-05-14 编辑:简简单单 来源:一聚教程网
if( $_POST )
{
mysql_connect('localhost','root','root');
mysql_select_db('fangke_cc');
mysql_query("set names 'gbk'");
$title = htmlspecialchars(isset($_POST['title'])?$_POST['title']:'');
$keyword = htmlspecialchars(isset($_POST['keyword'])?$_POST['keyword']:'');
$desc = htmlspecialchars(isset($_POST['desc'])?$_POST['desc']:'');
$body = htmlspecialchars(isset($_POST['body'])?$_POST['body']:'');
if( $title == "" || strlen( $title ) > 200 )
{
exit('');
}
else if( $body == "" || strlen( $body ) >2048 )
{
exit('');
}
else
{
$time = time();
$body=preg_replace("/$title/","
".$title."
",$body,1);$sql = "insert into su_zt(title,description,keyword,body,datetimes) values('$title','$desc','$keyword','$body','$time')";
mysql_query( $sql ) or die(mysql_error().$sql);
die('');
}
}
?>
su_zt表结构
CREATE TABLE IF NOT EXISTS `su_zt` (
`id` int(8) NOT NULL auto_increment,
`title` varchar(200) character set gb2312 default NULL,
`keyword` varchar(60) character set gb2312 default NULL,
`description` text character set gb2312,
`body` text character set gb2312,
`datetimes` int(4) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
本站原创教程,转载注明来源http://www.111com.net,否则必究
-
上一个: php连接mysql数据库
-
下一个: php常用的魔术函数详细解析
相关文章
- php 保存数据到mysql数据库实例 12-20
- PHP导出数据超时的优化建议解读 10-31
- PHP之mysql位运算解析 10-31
- Laravel实现登录跳转功能解析 10-31
- php双向队列解读 10-31
- Laravel异常上下文解决教程 10-24