php±à³Ì£¬Õë¶ÔMYSQLµÄ²Ù×÷Àà
<?php
/*
*PHP¹ÜÀíMYSQLµÄÊý¾Ý¿âÀà
ʹÓ÷½·¨£º$dbConn = new DbConn([$Êý¾Ý¿âÃû(¿ÉÑ¡)]);
ÔÊÐí·µ»ØµÄ·½·¨£º
Execute($sql) //Ö´ÐÐSQLÓï¾ä£¬Ã»Óзµ»ØÖµ;
getRs($sql) //·µ»Ø²éѯÓï¾äµÄ¼Ç¼£¬Ò»Ìõ;
getRsArray($sql) //·µ»Ø¼Ç¼¼¯Êý×é;
getGoPageRs($sql,$maxline,$offset) //·µ»Ø·Ò³³ÌÐòËùÐèÒªµÄÊý×é;
Quit() //¹Ø±ÕÊý¾Ý¿âÁ¬½Ó
getParameter() //·µ»Ø·ÖÒ³ÒÔ¼°ÅÅÐòµÄ²ÎÊý
getInsertID() //·µ»Ø²åÈëµÄ×îºóÒ»Ìõ¼Ç¼
ÔÊÐí·µ»ØµÄÊôÐÔ£º
$num_rows; //Ö´ÐвÙ×÷µÄ¼Ç¼¼¯µÄÊýÁ¿;
$affected_rows //Ö´ÐвÙ×÷Ó°ÏìµÄ¼Ç¼Êý;
*/
class DbConn{
var $servername="localhost"; // Êý¾Ý¿âÁ¬½Ó·þÎñµØÖ·
var $dbname="xinwei"; // Á¬½ÓÊý¾Ý¿âÃû
var $username = "root"; // µÇ½Óû§
var $password = ""; // µÇ½ÃÜÂë
var $conn; // Êý¾Ý¿âÁ¬½ÓÖ¸Õë
var $num_rows; // ·µ»ØµÄÌõÄ¿Êý
var $query_id; // Ö´ÐÐqueryÃüÁîµÄÖ¸Õë
var $affected_rows; // ´«»ØqueryÃüÁîËùÓ°ÏìµÄÁÐÊýÄ¿
var $insertid; // ×îвåÈë¼Ç¼µÄIDºÅ
//ÏÂÃæÊǺͷÖÒ³³ÌÐòÓйصıäÁ¿£»
var $offset; //·ÖҳƫÒÆÁ¿
var $maxline = 12; //ÏÔʾÐÐÊý
var $offset; //ÉèÖÃÆ«ÒÆÁ¿
var $tpages; //×ÜÒ³Êý
var $total; //×ܼǼÊý
function DbConn($dbname=""){ //¹¹Ô캯Êý£¬½¨Á¢Êý¾Ý¿âÁ¬½Ó£¬¿ÉÒÔÖ¸¶¨Á¬½Óµ½ÆäËûÊý¾Ý¿â
$this->conn = @mysql_connect($this->servername, $this->username, $this->password) or die(mysql_error("Êý¾Ý¿âÁ´½Óʧ°Ü"));
if($dbname!=""){
$this->dbname = $dbname;
}
if(!mysql_select_db($this->dbname)){
$this->getErr("Êý¾Ý¿âÁ´½Óʧ°Ü");
Ïà¹ØÎĵµ£º
ÔÎÄÄÚÈÝûÓб仯£¬ÔÚ¹«Ë¾¿ìÏû»¯ÁËÁ½¸öϵͳÁË£¬ËùÒÔ´òËã×Ô¼ºÐ´Ò»¸ö¹¦ÄÜ»¹¿ÉÒԵĸöÈËϵͳ£¬ÎÒÖªµÀÍøÉϺܶ࣬ÎÒÒ²ÊÕ¼¯Á˺ü¸¸ö£¬µ«ÊÇÏë¿´¿´×Ô¼ºÄܲ»ÄÜ×ö³öÀ´£¬ºÃºÃ¼ÓÓÍ°É£¬ÔڳﱸµÄ¹ý³ÌÖÐÓöµ½ÁËÓʼþÕâÑùµÄÎÊÌ⣬ËùÒÔ»¨Á˵ãʱ¼äÑо¿ÁËÒ»·¬£¬ÍøÉÏÕÒµ½µÄºÃÄÚÈÝ£¬ÄóöÀ´·ÖÏíÒ»ÏÂ
ÒýÓÃÍøÖ·£ºhttp://www.china-askpro.com/msg36/qa ......
·Ö±ðÏÂÔØÁËphp5.2.10ºÍ5.3.0°æ±¾µÄÔ´Â룬²éÕÒµ½ÀïÃæcall_user_function(ÔÚext/standard/basic_functions.c)µÄ·½·¨¡£
ÔÚ5.2.10°æ±¾Àcall_user_functionÓõÄÊDZê×¼µÄphp º¯ÊýµÄд·¨£¬ÓÃzvalÀàÐÍÀ´´æ´¢½ÓÊյIJÎÊý£¬µ÷ÓÃcall_user_function_exÀ´Ö´ÐÐÓû§µÄ·½·¨¡£Èç¹ûµ÷Óò»³É¹¦Ôò·ÖÎöÊDz»ÊǽÓÊÕµ½µÄ²ÎÊýÀïÓÐʲô´íÎó¡£
µ«Ô ......
ÀýÈ磺
A.php
<?php
$usernane
?>
Òª½«A.phpÖصÄ$usernaneÖµ´«¸øÁíÍâÒ»¸öÒ³Ã棨B.php£©ÖеÄʵÏÖ·½·¨£º
<meta http-equiv='refresh' content='0;url='B.php£¿user=$username'>
½ÓÊÕ
echo $_GET['user'];
ÕâÑù£¬¾Í¿ÉÒÔÔÚB.phpÖзÃÎÊ$use ......
·½·¨Ò»£º½¨Ò»¸öÆ´Òô±í t_cosler £¬´æ·Åÿ¸ö×Öĸ¿ªÍ·µÄµÚÒ»¸öºº×ֵıàºÅºÍ×îºóÒ»¸öºº×ֵıàºÅ¡£
BatchFile code+------+--------+-------+
| f_PY | cBegin | cEnd |
+------+--------+-------+
| A | 45217 | 45252 |
| B | 45253 | 45760 |
.....
| Z | 54481 | 55289 |
+------+--------+-------+
......
TIOBEÊÀ½ç±à³ÌÓïÑÔÅÅÐаñÕ¹ÏÖÁ˱à³ÌÓïÑÔµÄÁ÷ÐÐÇ÷ÊÆ¡£Ã¿¸öÔ£¬¶¼ÓÐ×îеÄÊý¾Ý±»¸üС£Õâ·ÝÅÅÐаñµÄÊý¾ÝÈ¡ÑùÀ´Ô´ÓÚ»¥ÁªÍøÉϸ»ÓоÑéµÄ³ÌÐòÔ±¡¢ÉÌ ÒµÓ¦Óá¢ÖøÃûµÄËÑË÷ÒýÇ棨ÖîÈç¹È¸è¡¢ MSN ¡¢ÑÅ»¢£©µÄ¹Ø¼ü×ÖÅÅÃû¡¢ Alexa ÉϵÄÅÅÃûµÈ¡£Çë×¢ÒâÕâ¸öÅÅÐаñÖ»ÊÇ·´Ó³ÁËij¸ö±à³ÌÓïÑÔµÄÈÈÃÅ³Ì¶È , Õâ²¢²»´ú±íËüÊÇÒ»¸ö×îºÃµÄ±à³ÌÓïÑÔ»òÊ ......