PHPÓʼþÊÕ·¢£¬ºÍ±àÂëÎÊÌâ¡£Êý¾ÝÆ¥Åä
<?php
header("content-type:text/html; charset=UTF-8");
/*
* record kid words and insert into database
* user by sending email to publication kid words
*
*/
include 'POP3.php';
include 'email_class.php';
include 'Mail_mimeDecode.php';
//include 'include/compatible.php';
include 'include/extend_common.php';
//include '../../htdocs/include/extend_common.php';
define('POST_from_EMAIL', 1);
define('DATABASE_CONNECTION_ERROR', 2);//Êý¾Ý¿âÁ¬½Óʧ°Ü´íÎó
define('EMAIL_CONNECTION_ERROR', 3);//ÓÊÏäÁ¬½Óʧ°Ü´íÎó
define('ACCOUNT_ERROR', 4);//ÓÊÏäµÄÕ˺ŴíÎó
define('SIGN_EMAIL_ERROR', 5);//Óʼþ±ê¼Çɾ³ý´íÎó
define('DELELET_ERROR', 6);//ɾ³ýÓʼþ´íÎó
define('INSERT_ERROR', 7);//²åÈëÊý¾Ýʧ°Ü´íÎó
class mail_data {
function mail_data(){
include 'config.php';
$mail_log=fopen("mail_log.txt","a+");
$conn=@mysql_connect($db_host,$db_user,$db_password);
if($conn){
mysql_select_db('t',$conn);
mysql_query("set names utf8");
$pop3=new Net_POP3();
//ÅжÏÁ¬½ÓÊÇ·ñ³É¹¦
if ($pop3->connect($host,110)){
//ÅжϵÇÈëÊÇ·ñ³É¹¦
if($pop3->login($user,$password)===true){
$list=$pop3->_cmdList();
$sum=$pop3->_cmdStat();
//ÿ´ÎÈ¡¶àÉÙÓʼþ
$step=2;
$r=0;
//ÏȶÔÓÊÏäÈ¡$stepÓʼþ
for($n=0;$n<$sum[0];$n+=$step){
$t=0;
$users=array();
$mail=array();
$offset=($sum[0]-$n)<$step?
Ïà¹ØÎĵµ£º
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 ......
PHPÊÇÒ»¸öºÜÓÅÐãµÄ¹¤¾ß£¬Ëü¿ÉÒÔ¼òµ¥£¬Ò²¿ÉÒÔ¸´ÔÓ¡£²»Ò»ÑùµÄÏîÄ¿£¬Ó¦¸ÃÓò»Ò»ÑùµÄPHP¡£
СÏîÄ¿ - ¼òµ¥¶øÖ±½ÓµÄPHP
Ò»°ã¶ÔÓÚÒ»¸ö¹¦ÄÜÒ³ÃæÔÚ20ÒÔϵÄÍøÕ¾£¬ÎÒÃÇ¿ÉÒÔÓÃÒ»¸öºÜ¼òµ¥µÄ¿ò¼Ü½á¹¹À´Ð´¡£ÔÚÕâ¸ö¹æÄ£ÉÏ£¬ÎÒ½¨ÒéÊÇʹÓñȽÏÖ±½ÓµÄÃæÏò¹ý³Ì±àÂë·½·¨£¬ÔÒòºÜ¼òµ¥£¬Ã»ÓбØÒª°ÑclassÎļþŪµÄN ¶à£¬½ ......