ʹÓÃWAMP5´î½¨Apache+MySQL+PHP»·¾³
Ä¿Ç°Óв»ÉÙAMP£¨Apache\MySQL\PHP£©µÄ¼¯³ÉÈí¼þ£¬¿ÉÒÔÈÃÎÒÃÇÒ»´Î°²×°²¢ÉèÖúá£Õâ¶ÔÓÚ²»ÊìϤAMPµÄÓû§À´Ëµ£¬ºÃ´¦¶à¶à¡£
Ò»¡¢Ê¹ÓÃAMP¼¯³ÉÈí¼þµÄÓŵ㣺
1¡¢¿É±ÜÃâÓÉÓÚȱ·¦AMPµÄ֪ʶ£¬¶øÎÞ·¨ÕýÈ·ÉèÖû·¾³£»
2¡¢¿É¿ìËÙ°²×°²¢ÉèÖúÃAMP»·¾³£¬ÈÃÎÒÃÇÖ±½Ó¿ªÊ¼ÕæÕý¸ÐÐËȤµÄÈí¼þ£¬Èçxoops£»
3¡¢¿É·½±ãµÄ´î½¨²âÊÔ»·¾³£¬¶ÔÓÚ²âÊÔ“ÊÇAMP»·¾³ÎÊÌ⣬»¹ÊÇXOOPSÔì³ÉµÄÎÊÌ┺ÜÓаïÖú£¬²ÉÓÃÅųý·¨¼´¿É¡£
¶þ¡¢³£ÓõÄAMP¼¯³ÉÈí¼þ£º
1¡¢AppServ£ºhttp://www.appservnetwork.com/
Õâ¸öÈí¼þÔŲ́ÍåºÜÁ÷ÐС£¿´µ½²»ÉÙÊé¼®Ò²¼«Á¦ÍƼö£¬¹À¼Æ¶¼ÊÇÊŲ̈ÍåÓû§µÄÓ°Ïì¡£
2¡¢XAMPP£ºhttp://www.apachefriends.org/en
Õâ¸öÈí¼þÖ§³Ö¶à¸öƽ̨,Win\Linux\Solaris\Mac OS X£¬Ä¿Ç°Ò²Óв»ÉÙÈËʹÓá£
3¡¢WAMP5£ºhttp://www.wampserver.com/en/
ÕâÊÇÎÒ½ñÌ켫Á¦ÍƼöµÄ£¬¾ø¶ÔÎåÐǼ¶¡£×¢ÒâËüµÄÃû×ÖÊÇ´ø¸ö5µÄŶ£¬Òâ˼¾ÍÊÇWAMP5ʹÓÃ×îеÄPHP5°æ±¾£¬ÕýÈç¹Ù·½ÍøÕ¾ÉϵĿںţºDiscover PHP5 with WAMP5 !
Èý¡¢¸ù¾ÝÎҵľÑ飬WAMP5ÓÐÈçÏÂÓŵ㣺
1¡¢XOOPSÔÚWAMP5ÖÐʹÓã¬Ã»ÓÐÈκÎÎÊÌâ¡£
2¡¢WAMP5רעÓÚWindowsƽ̨£¬°²×°ÉèÖü°Æä¼òµ¥¡£
3¡¢PHPĬÈϵÄÊÇ5.x°æ±¾£¬Èç¹ûÐèÒªphp4.x£¬Ö»Òª°²×°php4.x²å¼þ£¬¾Í¿ÉÒÔÔÚÁ½ÕßÖ®¼ä×ÔÓɵÄÇл»£¬·Ç³£·½±ã¡£
4¡¢MySQLĬÈϵÄÊÇ5.x°æ±¾£¬µ«¿ÉÒÔͨ¹ýÑ¡ÔñÀÏ°æ±¾µÄWAMP5£¬´Ó¶øʹÓÃ4.xµÄMySQL¡£
5¡¢¿ÉÊÓ»¯µÄ²Ëµ¥¹ÜÀí£¬¼«Æä·½±ã¡£È磬´ò¿ª¹Ø±Õphp extention¡¢Apache moduleµÈ£¬Ö±½Óͨ¹ý²Ëµ¥Ñ¡Ôñ¾Í¿ÉÒÔ¡£
6¡¢»¹Óи÷ÖÖ²å¼þ£¬ÈçZEND OPTIMIZER ADD-ONµÈ¡£
7¡¢Èç¹ûÓÐÒÉÎÊ£¬¹Ù·½»¹ÓÐÂÛ̳¿ÉÒÔÇóÖú¡£
......¸ü¶àÓŵ㣺ËÓÃËÖªµÀ£¬ÔçÓÃÔçÖªµÀ^_^
ËÄ¡¢Ê¹ÓÃWAMP5µÄ¾Ñé¡¢¼¼ÇÉ
1¡¢°²×°Ê±µÄÉèÖ㺿ÉÒÔ×Ô¶¨ÒåWWW¸ùĿ¼µÄ´æ·ÅλÖÃŶ£¬Ç¿ÁÒ½¨Òé·Åµ½DÅ̵Ȱ²È«µÄ·ÖÇøÖУ¬ÒÔ±ÜÃâÍòһϵͳ±ÀÀ££¬Ôì³ÉÊý¾Ý¶ªÊ§¡£
2¡¢¶ÔÓÚÖÐÎÄÓû§À´Ëµ£¬°²×°½áÊøºó£¬Ê×ÏÈÒªÉèÖõÄÊÇ£¬°ÑMySQLµÄÊý¾Ý¿âĬÈϱàÂë¸ÄΪUTF-8£¬ÕâÑù¿ÉÒÔÅųýºÜ¶àÖÐÎÄÂÒÂëÎÊÌ⣺ÔÚWAMP5²Ëµ¥ÖÐÑ¡Ôñ´ò¿ªmy(wamp).ini£¬ÉèÖÃÆäÖеÄdefault-character-set=utf8, È»ºóÖØÆôWAMP5¡£
3¡¢Êý¾Ý¿âĬÈϵÄÃÜÂëÊǿյģ¬¿ÉÒÔÔÚphpMyAdminÖÐÉèÖÃrootÕʺŵÄÃÜÂëΪ123456£»µ±È»ÐÞ¸ÄÖ®ºó£¬¾ÍÒª¸ú×ÅÐÞ¸ÄphpMyAdminµÄÅäÖÃÎļþconfig.inc.php£¬·ñÔòphpMyAdmin¾Í½ø²»ÁËÊý¾Ý¿âÀ²£º
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '123456';
4¡¢Èç¹ûÐèÒªmysql4.x + php4.x£¬¿ÉÑ¡ÓÃWAMP5 1.44°æ±¾ÒÔ¼
Ïà¹ØÎĵµ£º
2009Äê10ÔÂ30ÈÕ ÐÇÆÚÎå 22:53
1, ²é¿´MySQL
·þÎñÆ÷ÅäÖÃÐÅÏ¢
mysql> show variables;
mysql> show variables;
2, ²é¿´MySQL·þÎñÆ÷ÔËÐеĸ÷ÖÖ״ֵ̬
mysql> show global status;
mysql> show global status;
3, Âý²éѯ
mysql> show variables like '%slow%';
+--------------- ......
use mysql
update user set Password=password('newpassword') where User='root';
flush privileges;
1.ͨ¹ýÐÞ¸ÄMYSQLÊý¾Ý¿âÖÐMYSQL¿âµÄUSER±í
¾ÍÓÃÆÕͨµÄUPDATE¡¢INSERTÓï¾ä¾Í¿ÉÒÔ
2.ÔÚÃüÁîÐÐÖÐʹÓÃÈçÏÂÃüÁî
MYSQLADMIN -u root -p PASSWORD mypasswd
3.¿ÉÒÔÐÞ¸ÄMYSQLÎļþ¼ÐÖеÄMY.INIÎļþ
4.ʹÓÃSET PASSWORDÓï¾ ......
Á¬½Ó£º
$conn=mysql_connect ("localhost:3306", "username", "password");
mysql_select_db("DBname");
¶Á£º
$exec="select * from stu";
$result=mysql_query($exec);
while($rs=mysql_fetch_object($result))
{
echo $rs->id." & ......
£±£®Ëæ»ú×Ö·ûÐòÁÐÉú³Éº¯Êý£º
<?php
//ÓÃÓÚÑéÖ¤ÂëÐòÁÐÉú³ÉµÈ..
function random($length) {
$hash = '';
$chars = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789abcdefghijklmnopqrstuvwxyz';
$max = strlen($chars)-1;
$length=4;//³¤¶È×ÔÐÐÉ趨
mt_srand((double)microtime() * 1000000);
for($i = 0; $i < ......
ÒýÓÃÎļþµÄ·½·¨ÓÐ2ÖÖ£º
1¡¢require
require("conn.php"); Ò»°ã·ÅÔÚÒ³ÃæµÄµÚÒ»ÐУ¬×öΪ¸ÃÒ³Ö´ÐеÄÒ»²¿·Ö£¬Ê×ÏÈÖ´ÐÐrequireÄÚµÄconn.php È»ºóÔÙÖ´ÐÐÏÂÃæµÄ´úÂë
2¡¢include
include("header.php");µ±³ÌÐòµ½´ïÕâÀïµÄʱºò²Å»áÖ´ÐÐincludeµÄ header.php ......