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?
Ïà¹ØÎĵµ£º
ÔÚphpÖз¢ËÍÓʼþ¿ÉÒÔÓÃ×Ô´øµÄmail()º¯Êý£¬µ«ÊÇÕâ¸öº¯Êý²»×ãµãºÜÃ÷ÏÔ£¬×îÖ÷ÒªÊÇÔÛ±¾»úÉÏûÓа²×°smtp·þÎñ¾Íû·¨Ê¹ÓÃmail()¡£
µ±È»ÏÖÔÚ»¹ÓÐphpÆäËûµÄ²å¼þ¡¢ÀàʲôµÄ£¬ÄÇЩҲÐí¹¦ÄÜÆëÈ«£¬¿ÉÊÇÍâ¼Ó¾Í¸Ð¾õ²»Ë¬¡£
ÄÇÆäËû°ì·¨µÄ»°£¬Ò»°ã»áÏ뵽ͨ¹ýSMTP·þÎñÆ÷À´·¢ËÍÓʼþ£¬µ«ÊÇÒ²»á²úÉúһϵÁÐÎÊÌ⣨¾ßÌåÓÐÄÄЩÎÊÌâ¿É¼û²Î¿¼×ÊÁÏ"ÎÞÐ ......
£¨×ª×Ô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¡¢ ......
¸öÈ˱ȼÛÈϿɣ¬ÏÖÔÚÊÇÓà netbean 6.8 ¹Ù·½Ìṩ²å¼þºÜÆëÈ«¡£
http://www.ibm.com/developerworks/cn/opensource/os-php-ide/
http://www.pusuo.net/2009-09-19/110884581.html
ÔÙÓбȽϹØ×¢vs 2010µÄÕýʽ°æ£¬ÏëÒªºÍvs.net£¬ÔÀ´Êǰ²×°ÔÚvs2008 ÒÔÉϰ汾µÄ£¬ÏÖÔÚ²»ÖªµÀÊDz»ÊÇ¿ÉÒÔÕûºÏµ½vs 2010
Èç¹û¿ÉÒÔÕûºÏµÄ»°£¬ÄÇôΠ......
×î½üÒ»ÄêÀ´Ò»Ö±ÔÚʹÓÃfedora£¬·¢ÏÖlinuxÕæÊÇÌ«ÊʺÏÎÒÁË£¬Ï²»¶Ð´³ÌÐò£¬×Ô¼ºÏ¹µ¹ÌÚ£¬°¦windowsÎóÎÒ´óºÃÄ껪……
ÓÃPHPдÁËÒ»¶Î³ÌÐòÓÃÓÚÌáÈ¡ÍøÒ³ÖеÄÊý¾Ý£¬ÏàÐÅËÑË÷ÒýÇæÒ²ÊDz¶àµÄÏë·¨£¬Ö»²»¹ýËûÃÇÊý¾Ý¶à£¬Ëã·¨ºÃЩ£¬ºÇºÇ
[php]
<?php
/*
*´ËÎļþµÄÄ¿±êÊÇ×Ô¶¯ËѼ¯´æ´¢8684ÉϵÄÉîÛÚÊй«½»Êý¾Ý
*
*ÓÉ ......