ÒÔ°Ù¶ÈΪÀý£¬Ë¼Â·ÈçÏ£º
1¡¢ËÑË÷Ö÷¹Ø¼ü´Ê£¬·ÖÎöÏà¹ØËÑË÷Á´½Ó£¬´æÈëÍøÖ·¿â£¬±ê¼ÇΪδץȡ¡£
2¡¢¶ÁÈ¡Êý¾Ý¿âÖбê¼ÇΪδץȡµÄÍøÖ·£¬×¥È¡ºó·ÖÎöÏà¹ØËÑË÷£¬´æÈëÍøÖ·¿â£¬±ê¼ÇΪδץȡ¡£
3¡¢Öظ´2Ö±µ½Ö¸¶¨Éî¶È£¨Ò»°ãÈÈÃŹؼü´Ê6²ã×óÓÒÉî¶È²î²»¶àÈ«²¿¶ÁÈ¡£¬Ò»°ã¹Ø¼ü´Ê4²ã¼´¿É£¬ÀíÂÛÉÏ¿ÉÒÔÎÞÏ޲㣬µ«ÐèҪץȡµÄÊý¾ÝÁ¿³Ê¼¶ÊýÔö³¤£¬Ïà¹ØÐÔÒ²Ô½À´Ô½²î£¬Ã»±ØÒª£©¡£
4¡¢È˹¤´¦Àí³¤Î²´Ê£¬ÕâÀïÐèÒªÈ˹¤È¥³ýһЩÎ޹صĹؼü´Ê£¬±£ÁôºÏÊʵģ¨µ±Ç°ËÑËØÒýÇæµÄÓïÒå´¦ÀíÄÜÁ¦»¹ºÜÈõ£©¡£
ÖÁ´Ë£¬»ù±¾Íê³ÉÁ˶Գ¤Î²¹Ø¼ü´ÊµÄ´¦Àí£¬¿ÉÒÔ»ñµÃÒ»¸ö±È½ÏÈ«µÄ³¤Î²¹Ø¼ü´ÊÁбíÁË¡£ÓÉÓÚ¸öÈË»¹ÐèÒªÑо¿²»Í¬²ã´Î¹Ø¼ü´ÊÖ®¼äµÄ¹Øϵ£¬ËùÒÔ´æ´¢ÁËËÑË÷½á¹ûµÄÍøÒ³£¬¶¨ÒåÁ˸¸×Ó¹Øϵ£¬Ò²Ã»ÓйýÂ˲»Í¬²ãÖ®¼äÏàͬµÄ¹Ø¼ü´Ê£¬ÕâЩ¶ÔÕÒ³¤Î²´ÊÓô¦²»´ó¡£
×Ô¶¯»ñÈ¡ÎļþÖ¸¶¨Ä¿±ê¹Ø¼ü´ÊµÄphpʵÏÖ¼û¸½¼þ£ºspider_keywords
ÕâÊÇÎÒ×ÔÓóÌÐò£¬Ìṩһ¸öʵÏÖ·½Ê½£¬´òËãÓõĻ°»¹ÐèÒª¸ù¾Ý×Ô¼ºÊ¹Óû·¾³Ð޸ģ¬ÒªÇó¶®php£¬SQL¡£¹Ø¼ü²¿·ÖÈçÏà¹Ø¹Ø¼ü´Ê·ÖÎöÌáÈ¡ÒѾ×öµÄ±È½ÏÎȶ¨£¬Çë·ÅÐÄʹÓá£ÆäÖУº
mykeyword.datΪ´æ·Å¹Ø¼ü´ÊµÄÎļþ£¬Ã¿ÐÐÒ»¸öÖ÷¹Ø¼ü´Ê¡£
$depthΪץȡÉî¶È£¬Ä¬ÈÏ5²ã£¬¶ÔÓÚÒ»°ã¹Ø¼ü´Ê¹»Éî¡£
³ÌÐòÍÚ¾òÊý¾Ýºó´æ·ÅÔÚÎÒµÄPostgreSQLÊý¾Ý¿â£¬Êý¾Ý¿âĬÈÏUTF-8±àÂ룬¿ÉÒÔ¸ù¾Ý×Ô¼ºµÄʵ¼ÊÐèÒªÐ޸ġ£Êý¾Ý±í½á¹¹ÈçÏ£º
Table: mykeywords
DROP TABLE mykeywords;
CREATE TABLE mykeywords
(id serial NOT ¼ÃÄÏÍøÕ¾½¨É蹫˾ NULL,
father text,
"content" text,
sons text,
depth text,
keyname text,
remark text,
is_spidered boolean,
CONSTRAINT mykeywords_pkey PRIMARY KEY (id)
)
WITH (OIDS=FALSE);
ALTER TABLE mykeywords OWNER TO º£¿ÚÍøÕ¾½¨É蹫˾ postgres;
±¾ÎÄÓÉseoÖ©ÖëÕ¾³¤Ëùд£¬³öÆ·ÅÆÍøÕ¾½¨Éè´¦£ºhttp://www.seozzj.com/seo-tips/long-tail-keywords-bulk/ תÔØÇë×¢Ã÷£¡
ÄϾ©ÄÁÀÇÎÄ»¯´«Ã½ÓÐÏÞ¹«Ë¾¼ò½é£º
ÄÁÀÇ´«Ã½£¬ÄÁÕßÖ®ÐÄ£¬ÀÇÕßÖ®ÐÔ£¬ÒÔÄÁ֮ǫ±°¿íÈÝÖ®ÐÄ´ýÈË£¬ÒÔÀÇ͎֮áÎÞη֮ÐÔ×öÊ£¡
¡¡¡¡¹«Ë¾×¢²á×ʽð100Íò£¬Ö÷ÓªÖÚ³ïÈ«°¸·þÎñ¡¢ÍøÕ¾ÓªÏúÈ«°¸·þÎñ¡¢ÍøÕ¾½¨É衢΢ÐÅС³ÌÐò¿ª·¢¡¢µçÉÌÍøµêÉè¼Æ¡¢H5Ò³ÃæÉè¼Æ¡¢ÌÚѶÉç½»¹ã¸æͶ·ÅÒÔ¼°µçÉÌÓªÏúÍƹãÈ«°¸µÈÏà¹ØÒµÎñ£¬ÖÂÁ¦ÓÚΪ¿Í»§Ìṩ¸üÓмÛÖµµÄ·þÎñ,´´ÔìÈÃÓû§ÂúÒâµÄЧ¹û£¡
¡¡¡¡Îª°Ù¶È¹Ù·½¼°Æä´ó¿Í»§¡¢ËÕÄþÒ×¹º¡¢½ðɽWPSÐãÌá¢ÃÀµÄ¡¢´´Î¬¼Òµç¡¢Ð¶«·½ÔÚÏß¡¢ÒÁÀ³¿Ë˹¡¢±¦ÀöÀ³µÈ¹úÄÚ¹úÍâÖªÃûÆ·ÅÆ·þÎñ¹ý£¬·þÎñ¾Ñé·á¸»£¡Í¬Ê±£¬¹«Ë¾Ò²ÊÇÄϾ©µç×ÓÉÌÎñлá»áÔ±µ¥Î»¡¢Öí°Ë½äÍø¹Ù·½ÈÏ֤ǩԼ·þÎñÉÌ¡¢½Ëհ˽ä·þÎñÍøÁªÃË¡¢ÄϾ©ÆÖ¿ÚÎÄ»¯²úÒµÁªºÏ»á»áÔ±µ¥Î»£¬¿ÉÒÔΪÄúÌṩ¸üºÃµÄ·þÎñ£¡
¡¡¡¡Ö÷ÓªÏîÄ¿£ºÖÚ³ïÈ«°¸·þÎñ¡¢ÍøÕ¾ÓªÏúÈ«°¸·þÎñ¡¢ÍøÕ¾½¨É衢΢ÐÅС³ÌÐò¿ª·¢¡¢µçÉÌÍøµêÉè¼Æ¡¢H5Ò³ÃæÉè¼Æ¡¢ÌÚѶÉç½»¹ã¸æͶ·Å¡¢¾º¼ÛÍйܡ¢ÍøÕ¾ÓÅ»¯¡¢µçÉÌ´úÔËÓªµÈ
¡¡¡¡ºÏ×÷¿Í»§£º°Ù¶È¡¢ËÕÄþÒ×¹º¡¢¶öÁËô¡¢ÃÀµÄ¡¢´´Î¬¼Òµç¡¢Ð¶«·½ÔÚÏß¡¢±¦ÀöÀ³¡¢½ðɽWPSÐãÌá¢ÒÁÀ³¿Ë˹
¡¡¡¡×ÊÖÊÈÙÓþ£º°Ù¶ÈÉÌÒµ·þÎñÊг¡2017Äê¶È×î¼ÑͼƬ·þÎñÉÌ¡¢ÄϾ©µç×ÓÉÌÎñлá»áÔ±µ¥Î»¡¢Öí°Ë½äÍø¹Ù·½ÈÏ֤ǩԼ·þÎñÉÌ¡¢½Ëհ˽ä·þÎñÍøÁªÃË¡¢ÄϾ©ÆÖ¿ÚÎÄ»¯²úÒµÁªºÏ»á»áÔ±µ¥Î»¡¢°Ë½äͨTOP·þÎñÉÌ¡¢"Ò×Åļ´ºÏ±"H5´´Òâ´óÈü"ÈýµÈ½±"¡£