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¸ñʽ,¾¹ ......
excelÕâÀàÎļþÆäʵ¾ÍÊÇÌØÊâ¸ñʽµÄÎı¾Îļþ£¨Ó¦¸ÃËùÓиñʽ¶¼ÊÇÌØÊâ¸ñʽµÄÎı¾ÎļþºÍ¶þ½øÖÆÎļþ£©£¬
excel²»Í¬µÄÐÐÌåÏÖÔÚÎı¾ÖеĻ»ÐУ¬ÀïÃæµÄÐèҪתÒåµÄ×Ö·û°üÀ¨,\ºÍ\r\nÕâÁ½¸ö£¬Óöµ½ÕâЩ×Ö·ûµÄʱºòÕâ¸öµ¥Ôª¸ñÐèÒªÓÃ""¸ñ¿ª ......
×î½üÒ»ÄêÀ´Ò»Ö±ÔÚʹÓÃfedora£¬·¢ÏÖlinuxÕæÊÇÌ«ÊʺÏÎÒÁË£¬Ï²»¶Ð´³ÌÐò£¬×Ô¼ºÏ¹µ¹ÌÚ£¬°¦windowsÎóÎÒ´óºÃÄ껪……
ÓÃPHPдÁËÒ»¶Î³ÌÐòÓÃÓÚÌáÈ¡ÍøÒ³ÖеÄÊý¾Ý£¬ÏàÐÅËÑË÷ÒýÇæÒ²ÊDz¶àµÄÏë·¨£¬Ö»²»¹ýËûÃÇÊý¾Ý¶à£¬Ëã·¨ºÃЩ£¬ºÇºÇ
[php]
<?php
/*
*´ËÎļþµÄÄ¿±êÊÇ×Ô¶¯ËѼ¯´æ´¢8684ÉϵÄÉîÛÚÊй«½»Êý¾Ý
*
*ÓÉ ......