ÏÈ´´½¨Ò»¸öÊý¾Ý¿âMyDB
CREATE DATABASE `mydb` ;
ÔÙ´´½¨Ò»¸ö¼òµ¥µÄÊý¾Ý±í
CREATE TABLE `MyDB`.`MyTable` (
`Name` VARCHAR( 20 ) NOT NULL ,
`Age` INT NOT NULL
) ENGINE = MYISAM
²åÈëһЩÊý¾Ý
INSERT INTO `mydb`.`mytable` (
`Name` ,
`Age`
)
VALUES (
'Jim', '15'
), (
'Amy', '16'
), (
'Jack', '12'
), (
'Mike', '21'
);
н¨Ò»¸öPHPÍøÒ³
<?php
$m_DB = mysql_connect("localhost","root","123"); //Á¬½ÓÊý¾Ý¿â
mysql_select_db("MyDB",$m_DB); //Ñ¡ÔñÒª²Ù×÷µÄÊý¾Ý¿â
$sql = "SELECT * from MyTable"; //¹¹Ôì²éѯÓï¾ä
$re = mysql_query($sql,$m_DB); //Ö´Ðвéѯ
while($row=mysql_fetch_array($re)){ //Ñ»·Êä³öÊý¾Ý
print_r($row); //´òÓ¡³öÀ´
print("<br/>");
}
mysql_close($m_DB);
?>
ÔËÐнá¹ûÈçÏ£º
Array ( [0] => Amy [Name] => Amy [1] => 16 [Age] => 16 )
Array ( [0] => Jim [Name] => Jim [1] => 15 [Age] => 15 )
Array ( [0] => Jack [Name] => Jack [1] => 12 [Age] => 12 )
Array ( [0] => Mike [Name] => Mike [1] => 21 [A ......
ÏÈ´´½¨Ò»¸öÊý¾Ý¿âMyDB
CREATE DATABASE `mydb` ;
ÔÙ´´½¨Ò»¸ö¼òµ¥µÄÊý¾Ý±í
CREATE TABLE `MyDB`.`MyTable` (
`Name` VARCHAR( 20 ) NOT NULL ,
`Age` INT NOT NULL
) ENGINE = MYISAM
²åÈëһЩÊý¾Ý
INSERT INTO `mydb`.`mytable` (
`Name` ,
`Age`
)
VALUES (
'Jim', '15'
), (
'Amy', '16'
), (
'Jack', '12'
), (
'Mike', '21'
);
н¨Ò»¸öPHPÍøÒ³
<?php
$m_DB = mysql_connect("localhost","root","123"); //Á¬½ÓÊý¾Ý¿â
mysql_select_db("MyDB",$m_DB); //Ñ¡ÔñÒª²Ù×÷µÄÊý¾Ý¿â
$sql = "SELECT * from MyTable"; //¹¹Ôì²éѯÓï¾ä
$re = mysql_query($sql,$m_DB); //Ö´Ðвéѯ
while($row=mysql_fetch_array($re)){ //Ñ»·Êä³öÊý¾Ý
print_r($row); //´òÓ¡³öÀ´
print("<br/>");
}
mysql_close($m_DB);
?>
ÔËÐнá¹ûÈçÏ£º
Array ( [0] => Amy [Name] => Amy [1] => 16 [Age] => 16 )
Array ( [0] => Jim [Name] => Jim [1] => 15 [Age] => 15 )
Array ( [0] => Jack [Name] => Jack [1] => 12 [Age] => 12 )
Array ( [0] => Mike [Name] => Mike [1] => 21 [A ......
ÕâÀï50¸öÓÐÒæµÄPHP¹¤¾ß£¬¿ÉÒÔ´ó´óÌá¸ßÄãµÄ±à³Ì¹¤×÷£º
µ÷ÊÔ¹¤¾ß
Webgrind
Xdebug
Gubed PHP Debugger
DBG
PHP_Debug
PHP_Dyn
MacGDBp
²âÊÔºÍÓÅ»¯¹¤¾ß
PHPUnit
SimpleTest
Selenium
PHP_CodeSniffer
dBug
PHP Profile Class
Îĵµ¹¤¾ß
phpDocumentor
PHP DOX
°²È«¹¤¾ß
Securimage
£ºÑéÖ¤Â빤¾ß¡£
Scavenger
PHP-IDS
Pixy
£º´úÂë¼ì²é¹¤¾ß¡£
ͼÐδ¦Àí
PHP/SWF Charts
pChart - a chart-drawing PHP library
WideImage
MagickWand For PHP
´úÂëÓÅ»¯
PHP_Beautifier
PHPCodeBeautifier
GeSHi - Generic Syntax Highlighter
°æ±¾¿ØÖÆÏµÍ³
Phing
xinc
ÓÐÓõÄÍØÕ¹£¬Ê¹Óù¤¾ßºÍÀà
SimplePie
£ºPHP RSS ½âÎö³ÌÐò
HTML Purifier
£º¿ÉÒÔÓÃÀ´ÒƳýËùÓжñÒâ´úÂë(XSS)£¬¶øÇÒ»¹ÄÜÈ·±£ÄãµÄÒ³Ãæ×ñÑW3CµÄ±ê×¼¹æ·¶¡£
TCPDF
£ºÒ»¸öÓÃÓÚ¿ìËÙÉú³ÉPDFÎļþµÄPHP5º¯Êý°ü¡£
htmlSQL
£ºÒ»¸öÊÇÄã¿ÉÒÔ·½±ãµÄ¶ÔHTMLºÍXMLÄÚÈÝ·½±ãµÄʹÓÃÀàËÆSQLÓï¾ä½øÐмìË÷µÄPHPÀà¡£
The Greatest PHP Snippet File Ever (Using Quicktext for Notepad++)
Creole
£ºÓÃPHP5±àд£¬ ÊÇÒ»¸ö»ùÓÚÕæÕýÒâÒåµÄOOµÄ²ã£¬API½Ó¿ÚÒÔJDBCΪ»ù´¡¡£
PHPLinq
£ºÓÃSQLÓï·¨²Ù×÷PHPÊý×é ......
ÈçºÎÓÃphpÖ±½Óµ÷ÓÃÎı¾ÎļþÄÚÈÝ:Ê×ÏÈͨ¹ýfileº¯Êý´ò¿ª·þÎñÆ÷ÉϵÄÒ»¸öÎı¾Îļþ£¬·µ»ØµÄ$myFile ¾Í½«³ÉΪÕâ¸öÎļþ²Ù×÷µÄ¾ä±ú£¬È»ºóÔÙͨ¹ýÑ»·Ö¸Áȡ³öÎļþÖÐÿһÐеÄÄÚÈݲ¢´òÓ¡³öÀ´¡£
±à³Ì˼·
Ê×ÏÈҪʹÓõĺ¯ÊýΪfi1e£¬±¾º¯ÊýÓë readfile() ÀàËÆ£¬²»Í¬µÄµØ·½Îª file º¯Êý½«ÎļþÖеÄÄÚÈÝÈ«²¿¶Á³ö£¬²¢Êä³öµ½Êý×éµÄ±äÁ¿ÖС¢Ã¿Ðж¼Êǵ¥¶ÀµÄÊý×éÔªËØ¡£Ê¹Óà file º¯Êý´ò¿ªÒ»¸ö data.txt µÄÎļþ,data.txt ÎļþµÄÄÚÈÝΪ:
µÚÒ»ÐÐ1
µÚ¶þÐÐ2
µÚÈýÐÐ3
´ò¿ªÎļþµÄÓï¾äΪ£º$myFile=file("data.txt");Õâʱ$myFileÊÇÒ»¸öÊý×é±äÁ¿¡£
È»ºóͨ¹ýÑ»·Ö¸ÁîÔÚÊý×éÖеÄÑ»·£¬´òÓ¡³öÊý×éµÄÿһ¸öÔªËØµÄÄÚÈÝ£¬ÕâÀïʹÓõÄcount()µÄº¯ÊýÓÃÀ´
È¡µÃÊý×éÔªËØµÄ¸öÊý¡£´òÓ¡Êý×éÄÚÈݵÄÓï¾äΪ:print($myFile[$index]."¡¡")¡£
´´×÷²½Öè
Ò»¡¢Ê¹Óà file º¯Êý´ò¿ªÎļþ
ÒÔÏÂÊÇÒýÓÃÆ¬¶Î£º
$myFile=file("data.txt");
¶þ¡¢ÔÚÊý×éÖÐÑ»·£¬´òÓ¡Êý×éµÄÔªËØ
ÔÚÕâÀͨ¹ý
ÒÔÏÂÊÇÒýÓÃÆ¬¶Î£º
for($index=0;$index
for($index=0;$index {
print($myF ......
ÓÐÖÖ˵·¨£ºPHPÊÇ×î¼òµ¥µÄÍøÕ¾¿ª·¢ÓïÑÔ£¬ÕâÖÖ¹ÛµãÊÇ´íµÄ¡£
ľͷ±È»ýľ¼òµ¥£¬µ«Ä¾½³ºÍº¢×ӵIJî±ðÊÇľ½³ÄܰÑľͷºÍ»ýľ¶¼±ä³É·¿×Ó£¬º¢×ÓÖ»Äܰѻýľ±ä³É·¿×Ó£¬¶ÔÓÚľͷËûÃÇÖ»ÄÜÔÚÉÏÃæ»¸ö·¿×Ó¶øÒÑ¡£
PHP¾ÍÏñľͷ£¬²ËÄñÖ»ÄÜÓÃËü×öµã¼òµ¥µÄÊÂÇ飬¸ßÊ־ͻá°ÑËü±ä³ÉÎÞËù²»ÄÜ¡£
¼ÈÈ»PHP¼òµ¥ÓÖÊǸßÊÖìÅÒ«µÄ¶«Î÷£¬ÄÇÔõôѧ²ÅÄܱä³É¸ßÊÖÄØ£¿
ÇëÍùÏ¿´……
֮ǰ ȥѧϰC#»òJAVA»ù´¡¡£
Ϊʲô£¿¸úPHP²»Ïà¹Ø°¡¡£¶Ô£¡¾ÍÊÇÒªÏÈѧÕâЩ£¬Á˽â»ù±¾µÄ¶«Î÷£¬×îÖØÒªµÄÊÇҪѧ»áÃæÏò¶ÔÏó±à³Ì¡£Ñ§»áÕâЩ¾ÍËã»áÅÀÁË¡£
Ê×ÏÈ PHPµÄ»ù´¡
Õâ¸öÄãµÃ»á°É£¬Á¬×ß¶¼²»»áÔõô·É£¿Ê²Ã´±äÁ¿¡¢³£Á¿¡¢Óï¾ä¡¢º¯Êý£¬Á˽âweb¿ª·¢µÄһЩ»ù±¾³£Ê¶£¬Ê²Ã´getÇëÇó/postÇëÇó£¬html£¬±íµ¥°¡Ö®ÀàµÄ¡£
½ÓÏÂÀ´ ¸ù¾Ý×î¿ªÊ¼ÕÆÎÕµÄÃæÏò¶ÔÏó±à³Ì֪ʶ±È¶ÔѧϰPHPµÄÃæÏò¶ÔÏó±à³Ì¡£
ÒòΪPHPµÄÃæÏò¶ÔÏó±à³ÌÓï·¨±È½ÏÌØÊ⣬ËùÒÔ²ÅÒªÄã֮ǰѧдC#»ù´¡¡£ÄãÒª²»Ñ§ÕâЩ£¬Ó²¿ÐPHPµÄÃæÏò¶ÔÏóҲûÈËÀ¹Äã¡£
ÔÙÏÂÀ´ дµãС¶«Î÷
ÁôÑÔ°åʲô֮ÀàµÄ£¬Ê¼þ³öÕæÖª°¡£¬¶ÍÁ¶ºÜÖØÒªµÄ¡£ÄÜд³öÀ´¾Í˵Ã÷»ù´¡ÕÆÎյIJ»´íÁË¡£×Ô¼º¼ÌÐøÐ´¸öʲôCMS»òÕßÂÛ̳֮ÀàµÄ°É¡£ÎÞ´ÓÏÂÊÖ£¿ÍùÏ¿´¡£
ÔÙÏÂÀ´ ±ßд×Ô¼ºµÄ¶«Î÷£¬±ß²ÎÕÕ±ðÈ˵ĴúÂ룬±ßÑ§Ï ......
1.ÏÂÔØ°²×°mcrypt
ÏÈÈ¥http://www.sourceforge.netÏÂÔØLibmcrypt,mhash,mcrypt°²×°°ü
2 .ÏȰ²×°Libmcrypt
#tar -zxvf libmcrypt-2.5.8.tar.gz
#cd libmcrypt-2.5.8
#./configure
#make
#make install
˵Ã÷£ºlibmcriptĬÈϰ²×°ÔÚ/usr/local
3.°²×°mhash
#tar -zxvf mhash-0.9.9.9.tar.gz
#cd mhash-0.9.9.9
#./configure
#make
#make install
4.°²×°mcrypt
#tar -zxvf mcrypt-2.6.8.tar.gz
#cd mcrypt-2.6.8
#LD_LIBRARY_PATH=/usr/local/lib ./configure
#make
#make install
˵Ã÷£ºÓÉÓÚÔÚÅäÖÃMcryptʱ£¬»áÕÒ²»µ½libmcryptµÄÁ´½Ó¿â£¬µ¼ÖÂÎÞ·¨±àÒ룬ÒòΪLibmcryptµÄÁ´½Ó¿âÔÚ/usr/local/Îļþ¼ÐÏ¡£ÒòЩÔÚÅäÖÃmcryptʱҪ¼ÓÈëLD_LIBRARY_PATH=/usr/localµ¼Èë¼ü½Ó¿â
5.°²×°PHPÀ©Õ¹Ä£¿é:¶¯Ì¬¼ÓÔØ
ʹÓÃphpµÄ³£¼ûÎÊÌâÊÇ£º±àÒëphpʱÍü¼ÇÌí¼ÓijÀ©Õ¹£¬ºóÀ´ÏëÌí¼ÓÀ©Õ¹£¬µ«ÊÇÒòΪ°²×°phpºóÓÖ×°ÁËһЩ¶«Î÷ÈçPEARµÈ£¬²»Ïëɾ³ýÄ¿Â¼ÖØ×°£¬ÓÚÊÇ¿ÉÒÔ²ÉÓÃphpize¡£
·½·¨ÊÇ£º
1).ÒªÓÐÓëÏÖÓÐphpÍêÈ«ÏàͬµÄphpѹËõ°ü ,Õ¹¿ªºó½øÈëÀïÃæµÄext/mcryptĿ¼ (ÀïÃæÊÇmcryptµÄphpÀ©Õ¹)
#cd /usr/local/software/php-5.3.2/ext/mcrypt
2).Ö´ÐÐ/usr/local/php/bin/phpize
#/usr/lo ......
×î½üÔÚѧPHP £¬¾õµÃ±È½Ï¼òµ¥£¬¿ÉÄÜÊÇÒòΪÓÐÒ»µã±à³Ì¾ÑéµÄÔµ¹Ê°É£¬½ñÌì½Ì´ó¼ÒÓÃPHPÖÆ×÷ͨѶ¼£¬¹¦ÄܱȽϼòµ¥£¬µÚÒ»´Î×öÍøÒ³½Ì³Ì£¬¶øÇÒ²»ÊǺÜÓÐPHP¾Ñ飬ËùÒÔ²»×ãµÄµØ·½´ó¼ÒÁôÑÔ¸æËßÎÒ£¬·Ï»°²»¶à˵£¬ÏÖÔÚ¿ªÊ¼
»·¾³£ºWindows XP SP3 + PHP5 + apache2 + mysql5
Ê×ÏÈ´´½¨Ò»¸öÊý¾Ý¿â£¬ÃûΪ MyDB £¨ÎÒÕâÀïʹÓõÄÊÇMySQL£©£¬SQL´úÂë¡£
CREATE DATABASE `MyDB` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
È»ºó´´½¨Ò»ÕÅ±í£¬ÃûΪ AddrList £¬SQL´úÂë
CREATE TABLE `mydb`.`AddrList` (
`ID` INT NOT NULL AUTO_INCREMENT ,
`Name` VARCHAR( 15 ) NOT NULL ,
`Sex` INT NOT NULL ,
`Birthday` DATE NOT NULL ,
`QQ` VARCHAR( 15 ) NOT NULL ,
`Mobile` VARCHAR( 25 ) NOT NULL ,
`Email` VARCHAR( 30 ) NOT NULL ,
`Address` VARCHAR( 50 ) NOT NULL ,
PRIMARY KEY ( `ID` )
) ENGINE = MYISAM
˵Ã÷£º NameΪÐÕÃû £» SexΪÐÔ±ð£¬0ÊÇ“ÄД£¬1ÊǓŮ” £» Birthday£ºÉúÈÕ£¬¸ñʽ£º Äê-ÔÂ-ÈÕ £» Mobile£ºÊÖ»úºÅÂë £» Address£ºµØÖ·¡£
Íê³ÉµÚÒ»²½ÁË
½ÓÏÂÀ´Ð½¨Ò»¸öPHPÎļþ£¬¿ª·¢¹¤¾ßÈÎÒ⣬ÎÒÕâÀïÓõÄÊÇDreamweaver ¡£
<?php
/**
* ......