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¸ñʽ,¾¹ ......
<?php
/**
»ñÈ¡»úÆ÷Íø¿¨µÄÎïÀí£¨MAC£©µØÖ·
wwa $Exp
**/
class GetMacAddr
{
var $return_array = array(); // ·µ»Ø´øÓÐMACµØÖ·µÄ×Ö´®Êý×é
......
<?php
$start = ip2long('192.168.1.1');
$start = sprintf("%u", $start) ;
$end = ip2long('192.168.1.50');
$end = sprintf("%u", $end) ;
for ($start; $start<$end; $start++){
echo long2ip($start)."<br>";
}
?> ......
<?php
class Access//AccessÊý¾Ý¿â²Ù×÷Àà
{
var $databasepath,$constr,$dbusername,$dbpassword,$link;//ÀàµÄÊôÐÔ
function Access($databasepath,$dbusername,$dbpassword)//¹¹Ô캯Êý
{
$this->databasepath=$databasepath;
$this->username=$d ......