PHPÂëÅ©½ø»¯Ê·6
1.PHP±à³ÌÄÜÁ¦
2.MysqlÄÜÁ¦
A.Á˽⣺֪µÀʹÓÃPHPÁ´½ÓÊý¾Ý¿â£»¶®µÃһЩ¼òµ¥µÄSQL;½¨Á¢Ò»Ð©¼òµ¥µÄË÷Òý£»¶®µÃÓù¤¾ß¼òµ¥²Ù×÷Ò»ÏÂÊý¾Ý¿â£¨Ôöɾ¸Ä²éÊý¾Ý±í½á¹¹£©¡£
B.ÊìϤ£º¶®µÃÔÚ¿ª·¢Ó¦ÓÃÉÏÉè¼ÆÊý¾Ý¿â£¬½¨Á¢Ò»Ð©ÓÐЧµÄË÷Òý£¬ÓÃexplain·ÖÎöSQLÐÔÄÜ£¬Ñ¹Á¦²âÊԵȵȡ£
C.ºÜÊìϤ£ºÉîÈëÁ˽âÊý¾Ý¿âË÷Òý£¬´æ´¢ÒýÇæÔÀíÒÔ¼°ÔËÐлúÖÆ£¬ÄÜÓÐЧµØ¹¹½¨¸ßÐÔÄÜ¿ÉÀ©Õ¹µÄÊý¾Ý½á¹¹/¼Ü¹¹£¬ÓÐЧµØÓÅ»¯Êý¾Ý¿âÐÔÄÜÅäÖò¢¼ÓÒÔµ÷ÊÔ£¬·ÖÎöÊý¾Ý¿âÔËÐÐ״̬¡£
D.¾«Í¨£º¾ß±¸ÒÔÉÏËùÓÐÄÜÁ¦Í¬Ê±£¬ÓжàÄê¸ß¸ºÔØ·Ö²¼Ê½»·¾³ÏÂÓÅ»¯¹ÜÀíµÄ¾Ñé¡£
ÓÐÈË˵£º70%µÄPHPer´¦ÔÚÁ˽â½×¶Î£¬25%´¦ÓÚÊìϤ½×¶Î£¬>4%ºÜÊìϤ£¬¾«Í¨µÄÈË»ù±¾¾Í²»ÊÇphperÁË¡£70%Õâ¸öȺÌå×îÈÝÒ׺öÊÓMySQL£¬ÒÔΪMySQLÖ»ÊǼòµ¥µÄ´æ´¢Ã½½é£¬Ã»ÓÐÓÅ»¯Òâʶ£¬ÈÏΪ¼Ó¸öÄÚ´æ¡¢CPU¾ÍÄܽâ¾öÎÊÌâ¡£µäÐÍʼþ£ºjoin¡¢order by¡¢group byµÈÓï¾äÐÔÄÜÒ»ËúºýÍ¿£¬Êý¾Ý¿â¸ù±¾Ã»ÓÐÉè¼Æ(½öÏÞÓÚ²ð³ÉÒ»¸öÖ÷±í£¬N¸ö¸½±íµÈ)£¬¸ã²»Çå×Ö¶ÎÀàÐͼ°×÷Óã¬Åöµ½´ó±íµÄ¸´ÔÓ²éѯ¾ÍûÕÞ¡£20%Õâ¸öȺÌåµÄÈËÖ»ÊÇMySQLÔËÐлúÖÆÀí½â²»Í¸³¹£¬¶ÔÓ°ÏìMySQLÐÔÄܵĹؽ¡ÒòËØ°ÑÎÕ²»Ã÷È·£¬²»ÊìÁ·¡£µäÐÍʼþ£ºÊì¶ÁÊֲᣬµ«Ëµ²»ÇåË÷ÒýÔÀí£¬²»ÖªµÀ¶þ²æÊ÷¡¢HASHµÈËã·¨¶ÔÓÚÊý¾Ý¿âµÄ×÷Óá£4%µÄȺÌåÒѾ»ù±¾¿ÉÒÔʤÈÎDBAµÄÖ°ÄÜ¡£
3.OOPÄÜÁ¦
A.Á˽⣺Á˽â±äÁ¿µÄ×÷ÓÃÓò£¬ÀàÐͼ°ÆäÒâÒ壬Á˽â¼Ì³Ð»úÖƵȣ¬¶®µÃ¸´Ó㬷â×°¸ÅÄî¡£
B.ÊìϤ£ºÊìÁ·Ó¦Óýӿڣ¬³éÏóµÈ¼¼Êõ»ìºÏ¿ª·¢³ÌÐò£¬²¢Àí½âÆäÖк¬Ò壬һ°ãÑо¿¹ýJAVA¡£
C.ºÜÊìϤ£ºÓйýOOP¼Ü¹¹Éè¼Æ¾Ñ飬ÊìϤÉè¼Æģʽ£¬UML,ÊìϤPHP¶ÔÏóÔËÐлúÖÆ£¬ÄÚÈݹÜÀíµÈ¡£
D.¾«Í¨£ºÓ¦¸ÃÊǼܹ¹Ê¦¼¶±ðµÄÁË£¬²»ÏÞÓÚPHP¡£
4.´óÐÍÍøÕ¾¾Ñé
A.Á˽â:ÊìϤPHP¿ª·¢ÏµĻº´æÓ¦ÓÃ(memacahe,APCµÈ);½Ó´¥¹ýLVS,SQUIDÓ¦Óá£
B.ÊìϤ£ºÕÆÎÕ·Ö²¼Ê½»º´æ¼°²Å»º´æÐÔÄÜÓÅ»¯£¬ÊìϤ´æ´¢ÏµÍ³£¬Îļþϵͳ£¬Êý¾Ý¿â£¬¿ª·¢¿ÉÀ©Õ¹Æ½Ì¨¡£ÄܽáºÏ¸ºÔؾùºâºÏÀí²»Ö¹Á÷Á¿£¬¶ÔPHPÔËÐÐÐÔÄܽøÐмà¿ØºÍ·ÖÎö¡£
C.·Ç³£ÊìϤ£º¾ß±¸ÏµÍ³·ÖÎöʦÄÜÁ¦£¬ÒѾ³¬³öPHPER»·½Ú¡£
D.¾«Í¨:Éñ¡£
5.DOM¿ª·¢ÄÜÁ¦
6.*inuxÓ¦ÓÃÄÜÁ¦
Ïà¹ØÎĵµ£º
жÔØMysql
[root@localhost ~]# rpm -qa | grep mysql
mysql-3.23.58-9
php-mysql-4.3.4-11
mod_auth_mysql-20030510-4.1
mysql-server-3.23.58-9
˵Ã÷£ºrpm –qa | grep mysql ÃüÁîÊÇΪÁË°ÑmysqlÏà¹ØµÄ°ü¶¼ÁгöÀ´£¬Ð¶Ôض¼´Ó×îÏÂÃæµÄÒ»¸ö°ü¿ªÊ¼£¬Ö±µ½Ð¶ÔصôµÚÒ»¸öΪֹ¡£Ö´ÐÐrpm -q php£¬Èç¹û·µ»Øphp°æ±¾£¬ ......
Mysql×ÔÉíѧϰ
1.Êý¾Ý¿â³£ÓõÄ×Ö¶ÎÀàÐÍ£º
ÕûÊýÐÍ: TINYINT(0-255×Ö¶Î), SMALLINT(´óµã), INT(¸ü³¤), BIGINT;
СÊýÐÍ: FLOAT, BOUBLE, DECIMAL(M(ÕûÊý),D£¨Ð¡Êý£©);
×Ö·ûÐÍ: CHAR(¹Ì¶¨), VARCHAR(µ¯ÐÔ×Ö·ûÐÍ£¬¼õ»ºÈÝÁ¿);£¨××Ö·ûΪ255£©
ÈÕÆÚÐÍ: DATETIME£¨ÈÕÆÚʱ¼ä£©, DATE£¨ÈÕÆÚ£©, TIMESTAMP£¨ÈÕÆÚת»¯ÎªÊý×Ö.¾«¶È ......
·µ»ØÒ»¸ö½á¹ûÈ«ÊÀ½ç¶¼ÖªµÀÔõô´¦Àí£¬¹Ø¼üÊÇ·µ»Ø¶à¸ö½á¹û¼¯¾Í²»ºÃ°ìÁË£¬ÏÂÃæÓÐÒ»½â¾ö°ì·¨
´æ´¢¹ý³Ì´úÂë
DELIMITER $$;
DROP PROCEDURE IF EXISTS `test`.`sp_test`$$
CREATE PROCEDURE `test`.`sp_test` ()
BEGIN
select * from `user`.`user` limit 0, 50;
select coun ......
½ñÌìÔÚ¼ÒÀïÖØа²×°ÁËÒ»ÏÂPHP µ±ÈÃÒ²ÓÐApacheÁË¡£µ«ÊÇÎÒÓöµ½ÁËÒ»¸öÎÊÌ⣬¾ÍÊÇApache·þÎñÎÞ·¨¿ªÆô£¬ºó¹ûÔõÑùÎÒÏëºÜ¶àÈ˶¼ÊÇÖªµÀµÄ£¬µ±Ê±Ò²Ã»ÓжàÏ룬ÒÔΪÊÇ×Ô¼º°²×°µÄʱºò³öÏÖÁËʧÎó¾ÍÖØа²×°Ò»±é£¬¿ÉÊÇ»¹ÊÇÒ»ÑùÎÞ·¨´ò¿ª£¬È»ºóÎÒ¾ÍÔÚÏëÊÇʲôÎÊÌ⣬¶Ë¿ÚºÅ80.ÎҲ鿴ÁËһϣ¬·¢ÏÖûÓдíÎó°¡£¬Ë¼¿¼Á˺ܾ㬶ÔÍøÂçÒÔ¼°·À» ......
µÚÒ»ÖÖ·½·¨£º
<?php
class Access{
function getConn(){
$conn = @new COM("ADODB.Connection") or die ("ADOÁ¬½Óʧ°Ü!");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath(__IMP ......