PHPÌáÈ¡8684¹«½»Êý¾Ý
×î½üÒ»ÄêÀ´Ò»Ö±ÔÚʹÓÃfedora£¬·¢ÏÖlinuxÕæÊÇÌ«ÊʺÏÎÒÁË£¬Ï²»¶Ð´³ÌÐò£¬×Ô¼ºÏ¹µ¹ÌÚ£¬°¦windowsÎóÎÒ´óºÃÄ껪……
ÓÃPHPдÁËÒ»¶Î³ÌÐòÓÃÓÚÌáÈ¡ÍøÒ³ÖеÄÊý¾Ý£¬ÏàÐÅËÑË÷ÒýÇæÒ²ÊDz¶àµÄÏë·¨£¬Ö»²»¹ýËûÃÇÊý¾Ý¶à£¬Ëã·¨ºÃЩ£¬ºÇºÇ
[php]
<?php
/*
*´ËÎļþµÄÄ¿±êÊÇ×Ô¶¯ËѼ¯´æ´¢8684ÉϵÄÉîÛÚÊй«½»Êý¾Ý
*
*ÓÉÓÚhttp»ñµÃµÄÍøÒ³Îªgbk±àÂëPHPÐèҪת»»£¬Ö»Äܽ«PHPÖØÐ±àÒë
*/
//ÔØÈësimple_html_domÀà·ÖÎöHTMLÎļþ
include 'simple_html_dom.php';
//´´½¨Ò»¸öSQLiteÊý¾Ý¿âÓÃÓÚ´æ´¢Êý¾Ý
$db = new SQLite3 ('BusData.db');
if ($db) //Êý¾Ý¿â´´½¨³É¹¦
{
//´´½¨Õ¾µãÃû±í
$db->exec('CREATE TABLE stationName (id INTEGER PRIMARY KEY AUTOINCREMENT,sName STRING)');
//´´½¨Ïß·±ísName,sNote,sTo,sfrom·Ö±ð´æ´¢Ïß·Ãû£¬±¸×¢£¬È¥³Ì£¬»Ø³Ì
$db->exec('CREATE TABLE Line (sName STRING, sNote STRING, sTo STRING, sfrom STRING)');
}
analysis($db, 'http://shenzhen.8684.cn/x_24f5dad9');
$db->close ();
echo "Congratulations! Write Sucessfully!";
//******************
//·ÖÎöÊý¾Ý,²åÈëÊý¾Ý²¿·Ö
//******************
function analysis($db, $url)
{
$html = new simple_html_dom ();
$html->load_file ($url); //ÔØÈëHTMLÎļþ£¬¿ÉÒÔ´Ó±¾µØ£¬Ò²¿ÉÊÇURL
$LName = ''; //ÓÃÓڼǼ¹«½»Ïß·Ãû³Æ
foreach ($html->find ('div[id=show] h2 a') as $lineName)
{
// echo mb_strlen($lineName->plaintext).'word<p>';±¾À´ÏëÈ¥µô¹«½»Ãû³ÆÖеđ·'×Ö£¬²»¹ýºóÀ´·¢ÏÖÕû¸öÃüÃû²»±ê×¼£¬ÒªÈ¥¿ÉÄÜÈ¥µÄÂÒÆß°ËÔãÁË
//¼Ç¼¹«½»Â·ÏßÃû³Æ
$LName = $LName.mb_strcut(mb_convert_encoding($lineName->plaintext,'UTF-8','gbk'),6);
}
//¼Ç¼Ïß·±¸×¢ÐÅÏ¢:
$note = '|';
foreach ($html->find ('div[id=show] li') as $Note)
$note = $note.mb_convert_encoding($Note->plaintext,'UTF-8','gbk').'|'; //½«±¸×¢Á¬½Ó
$i = 0; //ÓÃÒÔÅжÏÐг̣¨È¥³Ì£¯»Ø³Ì£©
$s_To = '.'; //¼Ç¼ȥ³Ì·Ïß
$s_from = '.'; //¼Ç¼»Ø³Ì·Ïß
//Êä³ö¹«½»Õ¾µãÐÅÏ¢
foreach ($html->find ('span') as $element)
{
$i++; //¿ØÖƱäÁ¿×ÔÔö
//iÎªÆæÊýʱÅжÏΪȥ³Ì
if ($i % 2)
{
foreach ($element->find ('a
Ïà¹ØÎĵµ£º
define("DB_SERVER","127.0.0.1");
define("DB_PORT",3306);
define("DB_CATALOG","uab");
define("DB_USERID","root");
define("DB_PASSWORD","");
$dsn="mysql:host=".DB_SERVER.";port=".DB_PORT.";dbname=".DB_CATALOG;
self::$__PDO=new PDO($dsn, DB_USERID, DB_PASSWORD);
//support long connection
self:: ......
£¨×ª×Ôhttp://www.jb51.net/article/20829.htm£©
ÕâÀï½éÉÜÒ»¸öÖ±½Ó½«excelÎļþµ¼ÈëmysqlµÄÀý×Ó¡£ÎÒ»¨ÁËÒ»ÍíÉϵÄʱ¼ä²âÊÔ£¬ÎÞÂÛµ¼Èë¼ò·±Ìå¶¼²»»á³öÏÖÂÒÂ룬·Ç³£ºÃÓá£
PHP-ExcelReader,ÏÂÔØµØÖ·: http://sourceforge.net/projects/phpexcelreader
˵Ã÷£º
²âÊÔ»·¾³£ºMYSQLÊý¾Ý¿â²ÉÓÃutf8±àÂë.µ¼ÈëEXCELÎĵµÊÇxls¸ñʽ,¾¹ ......
¸ÚλְÔð
»¥ÁªÍøÏà¹Ø²úÆ·¿ª·¢£¬ÏîÄ¿¿ª·¢£¬ÏµÍ³Î¬»¤µÈ
ÈÎÖ°ÒªÇó
1. ¾«Í¨PHP¿ª·¢ÓïÑÔ£¬ÊìÏ¤ÃæÏò¶ÔÏóµÄÈí¼þÉè¼Æ·½·¨£»
2. ÊìϤUnix/Linux²Ù×÷ϵͳ£¬ÊìϤC/C++±à³Ì£¬ÊìϤShell½Å±¾±à³Ì¼°³£ÓÃUnix¹ÜÀíÃü
ÁÊìϤbash/python/perl£»
3. ÊìϤHTTPÐÒé¼°W3CÏà¹Ø»¥ÁªÍø¹æ·¶£¬ÊìÁ·ÕÆÎÕXHTML¡¢CSS¡¢ ......
http://www.521000.com/bbs/dispbbs.asp?BoardID=9&ID=1236357
PHP»·¾³´î½¨
ApacheµÄ°²×°ÓëÅäÖÃ
Ò»¡¢ApacheµÄ°²×°
1.´ÓApacheµÄ¹Ù·½ÍøÕ¾ÏÂÔØ°²×°Èí¼þ£ºhttp://httpd.apache.org/download.cgi£¬Ä¿Ç°µÄ×îа汾ÊÇapache_2.2.11-win32-x86-no_ssl.msi¡£
2.´ò¿ªÎҵĵçÄÔ£¬½øÈëDÅÌ£¬ÔÚÆäÏÂн¨Ò»¸öÎļþ¼Ð£¬ÃûΪ loca ......