程序: $keywords =trim($_REQUEST['keywords']);
if(!empty($keywords) && $keywords != L('SEARCH_KEYWORDS'))
{
$tablename = 'searchword_'.date("Ym",time());
$ip = get_client_ip();
$newsearch = M($tablename);
$newsearch->searchword = $keywords;
$newsearch->ip = $ip;
$newsearch->create_time = gmtTime();
$newsearch->add(); 。
。插入数据
}
程序中判断了$keywords不为空时的插入数据,mysql数据库中怎么会有这个这个字段的空的数据,而且插入数据的ip大都来自同一个省?CREATE TABLE `sj_searchword_201011` (
`id` int(11) NOT NULL auto_increment,
`searchword` varchar(60) NOT NULL COMMENT '搜索关键词',
`ip` varchar(20) NOT NULL COMMENT '用户ip',
`create_time` int(11) unsigned NOT NULL COMMENT '搜索时间',
PRIMARY KEY (`id`),
KEY `searchword` (`searchword`,`create_time`)
) ENGINE=MyISAM AUTO_INCREMENT=35051 DEFAULT CHARSET=utf8; select * from sj_searchword_201011 where searchword ="" order by id desc limit 10;
执行的结果:
+--------+------------+---------------+-------------+
| id | searchword | ip | create_time |
+--------+------------+---------------+-------------+
| 125730 | | 124.115.0.104 | 1290588875 |
| 125729 | | 124.115.0.161 | 1290588871 |
| 125722 | | 124.115.0.170 | 1290588861 |
| 125717 | | 124.115.4.199 | 1290588852 |
| 125715 | | 124.115.0.18 | 1290588850 |
| 125713 | | 124.115.0.19 | 1290588848 |
| 125708 | | 124.115.0.16 | 1290588839 |
| 125703 | | 124.115.0.102 | 1290588831 |
| 125702 | | 124.115.4.204 | 1290588828 |
| 125696 | | 124.115.4.190 | 1290588794 |
+--------+------------+---------------+-------------+
if(!empty($keywords) && $keywords != L('SEARCH_KEYWORDS'))
{
$tablename = 'searchword_'.date("Ym",time());
$ip = get_client_ip();
$newsearch = M($tablename);
$newsearch->searchword = $keywords;
$newsearch->ip = $ip;
$newsearch->create_time = gmtTime();
$newsearch->add(); 。
。插入数据
}
程序中判断了$keywords不为空时的插入数据,mysql数据库中怎么会有这个这个字段的空的数据,而且插入数据的ip大都来自同一个省?CREATE TABLE `sj_searchword_201011` (
`id` int(11) NOT NULL auto_increment,
`searchword` varchar(60) NOT NULL COMMENT '搜索关键词',
`ip` varchar(20) NOT NULL COMMENT '用户ip',
`create_time` int(11) unsigned NOT NULL COMMENT '搜索时间',
PRIMARY KEY (`id`),
KEY `searchword` (`searchword`,`create_time`)
) ENGINE=MyISAM AUTO_INCREMENT=35051 DEFAULT CHARSET=utf8; select * from sj_searchword_201011 where searchword ="" order by id desc limit 10;
执行的结果:
+--------+------------+---------------+-------------+
| id | searchword | ip | create_time |
+--------+------------+---------------+-------------+
| 125730 | | 124.115.0.104 | 1290588875 |
| 125729 | | 124.115.0.161 | 1290588871 |
| 125722 | | 124.115.0.170 | 1290588861 |
| 125717 | | 124.115.4.199 | 1290588852 |
| 125715 | | 124.115.0.18 | 1290588850 |
| 125713 | | 124.115.0.19 | 1290588848 |
| 125708 | | 124.115.0.16 | 1290588839 |
| 125703 | | 124.115.0.102 | 1290588831 |
| 125702 | | 124.115.4.204 | 1290588828 |
| 125696 | | 124.115.4.190 | 1290588794 |
+--------+------------+---------------+-------------+
来自同一个省 可能是访问你网站的人 那个省的多吧.
+--------+------------+----------------+-------------+
| id | searchword | ip | create_time |
+--------+------------+----------------+-------------+
| 126400 | | 124.115.0.101 | 1290590366 |
| 126399 | 餐 | 220.181.94.228 | 1290590360 |
| 126398 | | 124.115.0.16 | 1290590358 |
| 126397 | ugg | 123.185.67.232 | 1290590356 |
| 126396 | 男 装 | 183.167.133.75 | 1290590355 |
| 126395 | 鞋 | 125.33.73.44 | 1290590352 |
| 126394 | 羽绒服 | 124.236.54.57 | 1290590351 |
| 126393 | 鞋 | 58.251.31.64 | 1290590350 |
| 126392 | 靴 | 218.2.115.162 | 1290590350 |
| 126391 | | 124.115.0.164 | 1290590350 |
+--------+------------+----------------+-------------+
mssql会报错:
消息 8152,级别 16,状态 14,第 1 行
将截断字符串或二进制数据。
语句已终止。
ps:建议:清空所有keywords为空的数据,手动置为空测试
+------+
| num |
+------+
| 2854 |
+------+
1 row in set (0.01 sec)mysql> select count(*)as num from sj_searchword_201011 where searchword ="" and ip like "124.115%";
+------+
| num |
+------+
| 2740 |
+------+
1 row in set (0.02 sec)
124.115.4.* 是来自soso 搜索引擎的ip