一位被互联网耽误的文艺青年

有人说,生命是晚霞衬红日,青松立峭壁,万里黄沙落秋雁,三月阳春映白雪,是金刀宝马,是银貂美酒,是皓月清歌的漂泊……

我的主业

以前听说会画画的程序员很帅气,又听说懂市场的运营很睿智。最后,我成了最懂运营的程序员、最懂编程的美工 和 最懂PS的产品经理。

网站设计

网站的整体框架设计,页面的版式设计,网站的功能、用途的定位,网络营销的策划,会员数据的统一。最重要的,一定要漂亮!HTML、CSS、JS、PHP、MYSQL、MSSQL、.NET都会,任选,不挑剔。

产品经理

经常被问:产品经理究竟是干嘛的?
其实也就是产品定义规划,需求调研,竞争分析,受众分析,业务建模,产品验收,线下线上运营,用户跟踪,售后处理等等。若成功,必身退二线;或失败,卷铺盖走人的高危职业。

网站优化

百度和GOOGLE优化。
只有一个原则,必须上首页。如果是做外贸自建站的,非常有必要优化下,因为GOOGLE对自建站非常友好;如果是国内项目,看心情了,反正百度这碧池只要花钱就给上。

业余爱好

生活,需要一颗安静的心和不停的脚步,不停地遇见,不停地思考,不停地流逝自己的思想,不停地更新自己的记忆。锦素年华,岁月无恙。

留 言 板

心情不错:24小时内回复;心情不好:三天回复一次;如果长时间不回复,请帮我报失踪!

img

自从有了SEO优化这么一个名词,从事互联网功课的站长仿佛就与它有着不解之缘。SEO优化也一直是诸位站长必须面临的首要问题,此刻的[搜索]就像不再纯净的天空,变得混浊紊乱,使得百度或GOOGLE的优化之路变得越来越难行走,即便如此,仍然要坚决的崇奉。

关于优化

最近文章

执笔,画圈,一闪而过的思绪,总是一而再,再而三的被遗忘,那些年少轻狂的激情,都尘封在了时光的角落,庸庸碌碌中,任光阴无情的在指缝中删删减减。

insert ignore intro 插入不重复记录

insert ignore into term(term) VALUES (‘$term’)

有表A;

id是自增的,同时也是主键,term VARCHER;其他的外键、索引什么的都没有。

要求是:不能使term重复插入;

刚开始认为就是判断的插入的数据是否重复,然后发现不是这样的,它判断的是主键或者索引是否重复。

这里要说说这个自增的id了,因为在insert ignore into插入的时候你的现在将要插入的数据的id已经是增加一了,所以你的这个自增主键id是无论如何也不能相等的,所以自然你的数据也就不会听话的把重复的数据不插入,这也就是为什么,即使ignore时没有插入数据它的自增的键也会跳过,所以这个要注意。

解决方法:把字段term加索引 UNIQUE

PHP 将中文转换成拼音

<?php
header(“Content-Type: text/html; charset=utf-8″);
error_reporting(E_ALL);

class Utf8ToPinyin {
/**
* 拼音字符转换图
* @var array
*/
private static $_aMaps = array(
‘a’=>-20319,’ai’=>-20317,’an’=>-20304,’ang’=>-20295,’ao’=>-20292,
‘ba’=>-20283,’bai’=>-20265,’ban’=>-20257,’bang’=>-20242,’bao’=>-20230,’bei’=>-20051,’ben’=>-20036,’beng’=>-20032,’bi’=>-20026,’bian’=>-20002,’biao’=>-19990,’bie’=>-19986,’bin’=>-19982,’bing’=>-19976,’bo’=>-19805,’bu’=>-19784,
‘ca’=>-19775,’cai’=>-19774,’can’=>-19763,’cang’=>-19756,’cao’=>-19751,’ce’=>-19746,’ceng’=>-19741,’cha’=>-19739,’chai’=>-19728,’chan’=>-19725,’chang’=>-19715,’chao’=>-19540,’che’=>-19531,’chen’=>-19525,’cheng’=>-19515,’chi’=>-19500,’chong’=>-19484,’chou’=>-19479,’chu’=>-19467,’chuai’=>-19289,’chuan’=>-19288,’chuang’=>-19281,’chui’=>-19275,’chun’=>-19270,’chuo’=>-19263,’ci’=>-19261,’cong’=>-19249,’cou’=>-19243,’cu’=>-19242,’cuan’=>-19238,’cui’=>-19235,’cun’=>-19227,’cuo’=>-19224,
‘da’=>-19218,’dai’=>-19212,’dan’=>-19038,’dang’=>-19023,’dao’=>-19018,’de’=>-19006,’deng’=>-19003,’di’=>-18996,’dian’=>-18977,’diao’=>-18961,’die’=>-18952,’ding’=>-18783,’diu’=>-18774,’dong’=>-18773,’dou’=>-18763,’du’=>-18756,’duan’=>-18741,’dui’=>-18735,’dun’=>-18731,’duo’=>-18722,
‘e’=>-18710,’en’=>-18697,’er’=>-18696,
‘fa’=>-18526,’fan’=>-18518,’fang’=>-18501,’fei’=>-18490,’fen’=>-18478,’feng’=>-18463,’fo’=>-18448,’fou’=>-18447,’fu’=>-18446,
‘ga’=>-18239,’gai’=>-18237,’gan’=>-18231,’gang’=>-18220,’gao’=>-18211,’ge’=>-18201,’gei’=>-18184,’gen’=>-18183,’geng’=>-18181,’gong’=>-18012,’gou’=>-17997,’gu’=>-17988,’gua’=>-17970,’guai’=>-17964,’guan’=>-17961,’guang’=>-17950,’gui’=>-17947,’gun’=>-17931,’guo’=>-17928,
‘ha’=>-17922,’hai’=>-17759,’han’=>-17752,’hang’=>-17733,’hao’=>-17730,’he’=>-17721,’hei’=>-17703,’hen’=>-17701,’heng’=>-17697,’hong’=>-17692,’hou’=>-17683,’hu’=>-17676,’hua’=>-17496,’huai’=>-17487,’huan’=>-17482,’huang’=>-17468,’hui’=>-17454,’hun’=>-17433,’huo’=>-17427,
‘ji’=>-17417,’jia’=>-17202,’jian’=>-17185,’jiang’=>-16983,’jiao’=>-16970,’jie’=>-16942,’jin’=>-16915,’jing’=>-16733,’jiong’=>-16708,’jiu’=>-16706,’ju’=>-16689,’juan’=>-16664,’jue’=>-16657,’jun’=>-16647,
‘ka’=>-16474,’kai’=>-16470,’kan’=>-16465,’kang’=>-16459,’kao’=>-16452,’ke’=>-16448,’ken’=>-16433,’keng’=>-16429,’kong’=>-16427,’kou’=>-16423,’ku’=>-16419,’kua’=>-16412,’kuai’=>-16407,’kuan’=>-16403,’kuang’=>-16401,’kui’=>-16393,’kun’=>-16220,’kuo’=>-16216,
‘la’=>-16212,’lai’=>-16205,’lan’=>-16202,’lang’=>-16187,’lao’=>-16180,’le’=>-16171,’lei’=>-16169,’leng’=>-16158,’li’=>-16155,’lia’=>-15959,’lian’=>-15958,’liang’=>-15944,’liao’=>-15933,’lie’=>-15920,’lin’=>-15915,’ling’=>-15903,’liu’=>-15889,’long’=>-15878,’lou’=>-15707,’lu’=>-15701,’lv’=>-15681,’luan’=>-15667,’lue’=>-15661,’lun’=>-15659,’luo’=>-15652,
‘ma’=>-15640,’mai’=>-15631,’man’=>-15625,’mang’=>-15454,’mao’=>-15448,’me’=>-15436,’mei’=>-15435,’men’=>-15419,’meng’=>-15416,’mi’=>-15408,’mian’=>-15394,’miao’=>-15385,’mie’=>-15377,’min’=>-15375,’ming’=>-15369,’miu’=>-15363,’mo’=>-15362,’mou’=>-15183,’mu’=>-15180,
‘na’=>-15165,’nai’=>-15158,’nan’=>-15153,’nang’=>-15150,’nao’=>-15149,’ne’=>-15144,’nei’=>-15143,’nen’=>-15141,’neng’=>-15140,’ni’=>-15139,’nian’=>-15128,’niang’=>-15121,’niao’=>-15119,’nie’=>-15117,’nin’=>-15110,’ning’=>-15109,’niu’=>-14941,’nong’=>-14937,’nu’=>-14933,’nv’=>-14930,’nuan’=>-14929,’nue’=>-14928,’nuo’=>-14926,
‘o’=>-14922,’ou’=>-14921,
‘pa’=>-14914,’pai’=>-14908,’pan’=>-14902,’pang’=>-14894,’pao’=>-14889,’pei’=>-14882,’pen’=>-14873,’peng’=>-14871,’pi’=>-14857,’pian’=>-14678,’piao’=>-14674,’pie’=>-14670,’pin’=>-14668,’ping’=>-14663,’po’=>-14654,’pu’=>-14645,
‘qi’=>-14630,’qia’=>-14594,’qian’=>-14429,’qiang’=>-14407,’qiao’=>-14399,’qie’=>-14384,’qin’=>-14379,’qing’=>-14368,’qiong’=>-14355,’qiu’=>-14353,’qu’=>-14345,’quan’=>-14170,’que’=>-14159,’qun’=>-14151,
‘ran’=>-14149,’rang’=>-14145,’rao’=>-14140,’re’=>-14137,’ren’=>-14135,’reng’=>-14125,’ri’=>-14123,’rong’=>-14122,’rou’=>-14112,’ru’=>-14109,’ruan’=>-14099,’rui’=>-14097,’run’=>-14094,’ruo’=>-14092,
‘sa’=>-14090,’sai’=>-14087,’san’=>-14083,’sang’=>-13917,’sao’=>-13914,’se’=>-13910,’sen’=>-13907,’seng’=>-13906,’sha’=>-13905,’shai’=>-13896,’shan’=>-13894,’shang’=>-13878,’shao’=>-13870,’she’=>-13859,’shen’=>-13847,’sheng’=>-13831,’shi’=>-13658,’shou’=>-13611,’shu’=>-13601,’shua’=>-13406,’shuai’=>-13404,’shuan’=>-13400,’shuang’=>-13398,’shui’=>-13395,’shun’=>-13391,’shuo’=>-13387,’si’=>-13383,’song’=>-13367,’sou’=>-13359,’su’=>-13356,’suan’=>-13343,’sui’=>-13340,’sun’=>-13329,’suo’=>-13326,
‘ta’=>-13318,’tai’=>-13147,’tan’=>-13138,’tang’=>-13120,’tao’=>-13107,’te’=>-13096,’teng’=>-13095,’ti’=>-13091,’tian’=>-13076,’tiao’=>-13068,’tie’=>-13063,’ting’=>-13060,’tong’=>-12888,’tou’=>-12875,’tu’=>-12871,’tuan’=>-12860,’tui’=>-12858,’tun’=>-12852,’tuo’=>-12849,
‘wa’=>-12838,’wai’=>-12831,’wan’=>-12829,’wang’=>-12812,’wei’=>-12802,’wen’=>-12607,’weng’=>-12597,’wo’=>-12594,’wu’=>-12585,
‘xi’=>-12556,’xia’=>-12359,’xian’=>-12346,’xiang’=>-12320,’xiao’=>-12300,’xie’=>-12120,’xin’=>-12099,’xing’=>-12089,’xiong’=>-12074,’xiu’=>-12067,’xu’=>-12058,’xuan’=>-12039,’xue’=>-11867,’xun’=>-11861,
‘ya’=>-11847,’yan’=>-11831,’yang’=>-11798,’yao’=>-11781,’ye’=>-11604,’yi’=>-11589,’yin’=>-11536,’ying’=>-11358,’yo’=>-11340,’yong’=>-11339,’you’=>-11324,’yu’=>-11303,’yuan’=>-11097,’yue’=>-11077,’yun’=>-11067,
‘za’=>-11055,’zai’=>-11052,’zan’=>-11045,’zang’=>-11041,’zao’=>-11038,’ze’=>-11024,’zei’=>-11020,’zen’=>-11019,’zeng’=>-11018,’zha’=>-11014,’zhai’=>-10838,’zhan’=>-10832,’zhang’=>-10815,’zhao’=>-10800,’zhe’=>-10790,’zhen’=>-10780,’zheng’=>-10764,’zhi’=>-10587,’zhong’=>-10544,’zhou’=>-10533,’zhu’=>-10519,’zhua’=>-10331,’zhuai’=>-10329,’zhuan’=>-10328,’zhuang’=>-10322,’zhui’=>-10315,’zhun’=>-10309,’zhuo’=>-10307,’zi’=>-10296,’zong’=>-10281,’zou’=>-10274,’zu’=>-10270,’zuan’=>-10262,’zui’=>-10260,’zun’=>-10256,’zuo’=>-10254
);

/**
* 将中文编码成拼音
* @param string $utf8Data utf8字符集数据
* @param string $sRetFormat 返回格式 [head:首字母|all:全拼音]
* @return string
encode方法中传进两个参数,$utf8Data, $sRetFormat,第一个参数为传入的中文,字符编码为utf-8,如果不是这个编码要转换成utf-8,第二个参数head:首字母|all:全拼音,返回值为转换后的拼音
*/
public static function encode($utf8Data, $sRetFormat=’head’){
$sGBK = iconv(‘UTF-8’, ‘GBK’, $utf8Data);
$aBuf = array();
for ($i=0, $iLoop=strlen($sGBK); $i<$iLoop; $i++) {
$iChr = ord($sGBK{$i});
if ($iChr>160)
$iChr = ($iChr<<8) + ord($sGBK{++$i}) – 65536;
if (‘head’ === $sRetFormat)
$aBuf[] = substr(self::zh2py($iChr),0,1);
else
$aBuf[] = self::zh2py($iChr);
}
if (‘head’ === $sRetFormat)
return implode(”, $aBuf);
else
return implode(‘-‘, $aBuf);
}

/**
* 中文转换到拼音(每次处理一个字符)
* @param number $iWORD 待处理字符双字节
* @return string 拼音
*/
private static function zh2py($iWORD) {
if($iWORD>0 && $iWORD<160 ) {
return chr($iWORD);
} elseif ($iWORD<-20319||$iWORD>-10247) {
return ”;
} else {
foreach (self::$_aMaps as $py => $code) {
if($code > $iWORD) break;
$result = $py;
}
return $result;
}
}
}

$a=”杭州移动宽带”;
$test=new Utf8ToPinyin();//初始化类实例
$b = $test->encode($a,’all’);//调用类中的方法
echo “b:”.$b;
?>

将JSON文件导入MYSQL数据库,三级联动省市县

<?php
header(“Content-Type: text/html; charset=utf-8”);
date_default_timezone_set(‘PRC’);
error_reporting(0);
ob_start();
session_start(); //打开会话
//session_set_cookie_params( 12*60*60 );
//session_cache_expire(60*60);
$dblink=@mysql_connect(“111.111.111.111″,”username”,”password”); //mysql主机,用户名,密码
if($dblink==null)
{
echo “数据库打开失败”;
exit;
} //如果数据库无法链接则提示
mysql_select_db(“database”); //选择数据库
mysql_query(“SET NAMES utf8”); //mysql 字符集 UTF-8
// 从文件中读取数据到PHP变量

//https://github.com/modood/Administrative-divisions-of-China   下载
$json_string = file_get_contents(‘citys.json’);

// 用参数true把JSON字符串强制转成PHP数组
$data = json_decode($json_string, true);

foreach ($data as $key => $value) {
$code1=$value[“code”];
$name1=$value[“name”];
$sql1=”insert into t_dq1 (code,name) values (‘$code1′,’$name1’)”;
mysql_query($sql1);

foreach ($value[“children”] as $k => $v) {

$code2=$v[“code”];
$name2=$v[“name”];
$sql2=”insert into t_dq2 (code,name,fsort) values (‘$code2′,’$name2′,’$code1’)”;
mysql_query($sql2);

foreach ($v[“children”] as $k3 => $v3) {

$code3=$v3[“code”];
$name3=$v3[“name”];

$sql3=”insert into t_dq3 (code,name,fsort) values (‘$code3′,’$name3′,’$code2’)”;
mysql_query($sql3);
}
}

}
?>