文档介绍:该【phpmysql基础知识 】是由【fangjinyan2017001】上传分享,文档一共【77】页,该文档可以免费在线阅读,需要了解更多关于【phpmysql基础知识 】的内容,可以使用淘豆网的站内搜索功能,选择自己适合的文档,以下文字是截取该文章内的部分文字,如需要获得完整电子版,请下载此文档到您的设备,方便您编辑和打印。:.
PHP
PHP
PHP
PHP
PHP
PHP
1
PHP!HTML%&'()*'+,PERL/01)2!C'
(ASP%&SHELL%&7JAVASCRIPT%;<=
2?@
PHPABCDEFG)PHP(PHPHypertestPreprocessor,RSG/"PersonalHome
PageTools”,[G/"PersonalHomepages",\]"Pre-HypertestProcessor")=PHP
HTML`a'((bcIISdASP)=ePHPf'+ghCJAVAPerl,
iPUPak'+=lm,nCGI\]Perlpqrstuvw=
1994zRasmusLerdorf~=1995z,PersonalHomepagesTools(PHP
Tools)~A&=
1995zPHP=F/PHP/FI(FromInterpreter)oPHP/FI
!
mSQL)PHPtuvw~d=
1997z)bc ¡¢PHP'+£¤A&=
200z)¥PHP4o
2004z)PHP5¦§)00¨©XML«¬­®¯¯°±=
1996z)³´µ¶AWEBv¹º»PHP/FI¼
1997z)º»PHP/F1WEBv¹¬;®½¾µ´A=
1998zÀ)PHPÁÂÃÄ10000,³¯Å100000Av¹ÆÇÈɺ»PHP=
ÊË)Internetd10%WEBÍdÎl=
1999zº»v¹½¾Ïµ´ÐÐl@ÑÒÓÔÕ~)OpenSource×ØÙ
Ú¢Û)lp*ÜÝÞßà=
PHPá<â=ã2004z2äWEBÍåæ)Netcraft[]å
æëìí7173415Aî)ïðñ5205474AòóPHP=*¯Å/WEBdô³î
32%,õ*ö;÷Úø³ùúûü=
Ïz)PHPWEBÍRý~þÿ
PHP
PHP3
HTML
XML
!"#$:.
!&'(
)*+,
-.'(
PHP4
API23
4567
COM/DCOM
<PIIP3=>?
***@A
BC
DEF
JAVAIJ
00L
ZIP!"'(
PHP5
00
XML
OP'(
SOAP2RSWEBWX
YPHPZ(
PHP[\]^_`abc&defgShijkWEBWXlWXlmnjeoSj
kpqrstuPHPvwjkxayzASP/SUMy
JSP/JAVASwCGI/Perl[\]HTMLsc&fg
PHPWEBWXlPHPcmSPHPeo^S
 ¡¢£m¤¥l¦§£m¤¥l¨>[©ªHTML!&S«¬
­PHPab®[<HTMLmc&(°±JScript/VBScript)³hi´µ
¶·\¸³
°¹():
<HTML>
<TITLE>helloworld</TITLE>
<BODY>
<Hl>HelloWorld</Hl><p>
<H2>
</H2>
</BODY>
</HTML>:.
¶·\¸³
°¹():
<HTML>
<TITLE>helloworld</TITLE>
<BODY>
<Hl>IIelloWorld</Hl><p>
<H2>
<?php
$currtime=time();
$currtimestr=strftime(SZ%H:%M:%S”,$currtime);ÐÑÒÓ
echoÐÔÕ[ Ð.$currtimestr;
?>
</H2>
</BODY>
</HTML>
Ö×ØPHP
×ØMysql
×ØApacheWebWXl
×ØGD-Ü
×ØXML
×ØPHP
×ØZendBÞß
àá******@A!"
âãPHP
\×ØMysql
äåræhttp:Ð/
×Ø
#rpm-ivhMysql*
ëp
#servicemysqlstart
ìí:.
#/etc//mysqlstart
ìí
#mysqld_safe&
ìí
#safe_mysqld&
ðñ
#servicemysqlstop
#/etc//mysqlstop
âã
(1)ó&
#mysqladminversion
(2)
mysql<âãtest
#mysqlshow
×ØApacheWebWXl
äåræ http:Ð/
#tarxzvfhttpd-
#cdhttpd-
#configure-prefix=/etc/httpd-enab1e-modu1e=so
ttmake
#makeinstall
#cp/etc/httpd/bin/apachectl/usr/sbin/httpd
ìí(#cp/etc/httpd/bin/apachectll/etc//httpd):.
Y×ØGD-Ü
1JPEG¬
#
#cdjpeg_6b
#configure
#make
#mkdir-p/usr/local/man/manl
#makeinstall
#makeinstall-lib
2TTF¬úGD¬û
#tarxzvffreetype-
#configure
ftmake
#makeinstall
3zlib¬úlibpng¬û
#tarxzvfzlib-
#configure
#make
#makeinstal1
4libpng¬
#tarxzvflibpng-
#cpscript/:.
#make
#makeinstall
5GD¬
#tarxzvfgd-
#configure
#make
#makeinstall
#/
Ö×ØXML
XML¬
#tarxzvflibxml2-
#configure
#make
#makeinstall
þ×ØPHP
äåræ/
PHP5¬
#tarxzvfphp-
#./configure-prefix=/usr/local/php\
with-apxs2=/etc/httpd/bin/apxs-with-gd\
with-jpeg-dir-with-ttf-with-zlib-dir-with-png-dir\
with-mysql-enable-track-vars
#make:.
#maketest
#makeinstall
#libtool--finish/usr/local/src/php-/
#chmod755/etc/httpd/modules/
#-dist/usr/local/php/lib/
Zend(
#tarzxvfZendOptimizer--linux-glibc21-
#cdZend0ptimizer--linux-glibc21-i386
#
Apache./
#vi/etc/httpd/conf/
234567:
AddTypeapplication/x-httpd-
AddTypeapplication/x-httpd-
LoadModulephp5_modulemodules/(>?***@AB3)
,,php
FG:
#
<?phpinfo()?>
#
<HTML>
<TITLE>helloworld</TITLE>
<BODY>:.
<Hl>IIelloWorld</Hl><p>
<H2>
<?php
$currtime=time();
$currtimestr=strftime$currtime);STUV
echoSWXYZ[\$currtimestrz];
?>
</H2>
</BODY>
</HTML>
^_MYSQLbAPACHE>PHPFG:
5efghij1(
1bMYSQL
#cd/home/admin
#rpm-ivhMysql-server--
(server)
#rpm-ivhMysql-client--
(client)
#rpm-ivhMysql-devel--
(develor)
klmysql
#mysql
mysql>\usetest;
mysql>\select*fromtest;
mysql>\exit
#mysqlshow
(nopqr)
#mysqlshowmysql
snomysqlpqrtuvwx:.
2b^_webmin
#rpm-ivhwebmin-,rpm
^_yz{]|10000}~]{ROOT
6
3b^_Apache
#tarxzvfhttpd-
#cdhttpd-
ttconfigure-prefix=/etc/httpd\
>enab1e-modu1e=so
#make
#makeinstall
#vi/etc/httpd/conf/
\
:80
\wq
#/etc/httpd/bin/apachectlstart
IEkl
#cphttpd/usr/sbin/
s4|webmin./Apachex
4b^_GDr
#
#
snorx
#:.
#mvjpeg-6b//usr/local/src
#cd/usr/local/src
#cdjpeg-6b
#configure
#make
#mkdir-p/usr/local/man/manlStBUG
#makeinstall
#makeinstall-lib
#tarxzvffreetype-
#mvfreetype/usr/local/src
#cdfreetype-
#configure
#make
#makeinstall
#tarxzvfzlib-
#mvzlib-
#cdzlib-
#configure
#make
#makeinstall
#tarxzvflibpng-
#mvlibpng-:.
#cd1ibpng-
#configure
#lsscripts
#cpscripts/
#make
#makeinstall
##
#mvgd-
#cdgd-
#configure
#make
#makeinstall
#/
5b^_XMLri
#
#configure
#make
#makeinstall
6b^_PHP
#tarxzvfphp-
#cdphp-/
#configure-prefix=/usr/local/php:.
>-with-apxs2=/etc/httpd/bin/apxs-with-gd\
>-with-jpeg-dir--with-ttf--with-zlib-dir--with-png-dir\
>-with-mysql-enble-track-vars
ttmake
#make
#makeinstall
#libtool-finish/usr/local/src/php-/
#chmod775/etc/httpd/modules/
#-dist/usr/local/php/lib/
#cd/etc/httpd
#cdhtdocs/
#ls
#vi../conf/
23PHPi
AddType,23:
AddTypeapp1ication/x-h11pd-
AddTypeapplication/x-httpd-php-
Dirctorylndex,\
index,phpindex,html
7Zend
#tarxzvfZend0ptimizer--linux-glibc21-
#mvZend0ptimizer--linux-glibc21-i386/usr/local/src
#cd/usr/loca/src
#cdZend0ptimizer--1inux-glibc21-i386
#ls
#:.
 ¡^_¢£¤¥YES,¦§¨
/usr/local/php/lib/
©{^_PHPª«¬­\PHPEXPERTEDITOR
®¯°P1IP6±²³
p´µ¶·¸
¹º»º
¼·
p½
67
¾p¿
bp´µ¶·¸
1bÀp\
¼+-*/
ÂÃ10
ÄÃ012
ÂÅÃOxa
2bFp:
PHPÆÇpiÈ´ÉÊC6doubleËÌÆÇÍÎÏÐÆÇpÑ10E16,ÒÓ
ÔtÕpÖ×]ØÙÚYÛÜÀÝiÞßÙÚàáâYhãä]åiæÖçÝ[ÆÇÝÒ
Ñ[ÀÝ
ÕpwÚ±\
èéêp±\=*102
3b¶·¸\
PHPëi¶·¸µCichar*ÑÎ]åìíîPerli¶·¸PHPi¶·¸[ïðæ
ñòióôõæñòö÷øÎwÚiùÒÑ[¿C6Þúûüæñòiýôõ]þ
''0'
BufferOverflowe
!" #’HellWorld!''hi,"-./
0" #"HelloWorld!'"1234PATH=$PATH”
;"#<pwd':.
>?#\n
B?
\"0"
\;CD
\nEF
\tH
(TAB)
K<L4M34
1<L4OP
_FILE_
VWXL4PHPYZ[\]
_LINE_
VWXL4PHPYZF_"[(includearequire)cd"[\e
fL4
"[\
Fgh"i
[\F
PHP_VERSION
VWemL4PHP
YZ
nogp',
PHP0S
VWemL4stFPHPuvw
xyz{]|gp“LINUX”
TRUE
VWL4(true)
FALES
VWL4(false)
E-ERROR
VWL4s
EWARNING
VWL4s
EPARSE:.
oL4uvd
2<34OP
integerP34d32
xyz{gi
-2147483647+2147483647
16
dOx
double P34d32
xyz{gi
-308+308
string¡ 34g¢£!¤a¥
¦VW34OPp
$NESLine="EF§\n”
array¨34g©Kª<«ªa¬­ª¨g®
¯°±²³´g©
string\integer\double,µ¶array%
objectO34,p:
classfoo{
functiondo_foo(){
echo^Doingfoo.";
}
)
$bar=newfoo;
$bar->do_foo0;
¸¹P34(boolean),ºL1¡true,0false
3<34
»¼½¾¿ÀÁgpmyVarÂÃmyvar
ÄÅ34gyÃÆYZ
$CLOBALS¨ÇglobalÈÉ
p#
ÆYZ
$a=90;
Funl(){
$a=100;
):.
Funn()
ÊË#
<?php
classfoo{
functiondo_foo(){ÏÐ?¤WÑÒÓ
echoÏ<pre>ÏÕ
echozg\tV×ØfooÑÒÓdo_fooÙÚÛ
eÜ:\nÏÕ
echoÏ\t\t×ØP34
¤WËÝ\nÏÕ
echoÏ</pre>ÏÕ
)
}
$bar=newfoo;Ͼâ¤Wã
×ØP34
$bat->do_foo();Ïä×Øfoo
ÑÒÓ
php?>
4<æç34
ÓdtFÉÙèé
34gdÓÉêë§gÉìYZ
ígÓdî1g
ïðñ34dòótFôÓêë
õgæç34(staticvariable)ö÷ø§
Ë#
static$mystr;
functionmyfunc(){
static$mystr;
$mystr.=”ûÏ
echo$mystr.Ï<br>\nÏÕ
}
myfunc():Ïû
myfunc():Ïûû
myfunc():Ïûûû
$mystr34üýgþd34ý÷static,¡ÿ$mystr
myfunc()$mystr!"#$%&'()static
,-./#0123"&'45
57
$a="Hello”;
$$a="world”;//$Hello="world”
echoD$a,//Hello,world
echoD$a,${$a}DH Hello,world:.
67JKLM
<formaction==post>
STU<inputtype=textname=DusernameD><br>
WXU<inputtype=textname="sexDXbr>
<inputtypeZsubmit[
</form>
77]^_`ab
$a[0]=123;
$a[l]=234;
echo$a;
DjklArray
$b=D123abcD;
echo$b+l;
Djkl124
echo$;
Djkl123abcl23
87l^_`ab
$a=12345678901234;Dqr
$b=12345678901234;
$c=$a+$b;
$d=D123abcDs
echo$c;
Dl24691357802468
echo(float)$c;
Dl24691357802468,tu$c qr
echo(int)$c;
Dl-24691357802468,tu$cw x`
echo(int)$d;
Dl123
y7z{|
17{}z{|~z{5
|~
-:.
+"2z{
2z{
*2z{
/2z{xqr
%
++L!
L
27'|z{|
'|z{ z{|~%# ~)|
'|5
$str=" ¡¢£¤"
37¥z{|
¥z{¦§¨©ª«¬w­¦®¯°±²!"®¯³´5
|~
-
)µ¶·¸¶
+=)µ¶"·¸¶
-=)µ¶·¸¶
*=)¸¶·µ¶
/=)¸¶·µ¶
%=)¸¶¹µ¶
.=)µ¶'|"·¸¶
ºU
$a=200
$a+=10D$a=$a+10,»$@=210
47½¾z{|
½¾z{|¿À2%Á½¾5
|~
-
>ÃÄ
>=ÃÄÅÆÄ
<ÇÄ
<=ÇÄÅÆÄ:.
==ÆÄ
!=wÆÄ
57Éz{|
PHPÉz{|ËÌÍÎÏÐÑÒz5
|~
-
&z{AND
Åz{OR
Øz{NOT
ÚÅXOR
ÛܸÝÉ2
ÞܵÝÉ2
67ßàz{|
ßàz{áâãäJå^æç5
|~
-
&&Ðè(AND)
AndÐè(AND)
IIÅéOR
OrÅéOR
XorÚÅ(XOR)
[w(NOT)
77êëz{|
4ìíz{|~îïðÍz{|~ñò_5
|~
-
$
&óô"õö
->_÷2ÅéøW
=>ùúû
?Uyúz{|
ºU
$score=90;
echo$score>59?"ýþ"U"wýþ":.
7ù
PHPùÿPerl
$user[O]="”
$user[1]="";
$user[2]="!"";
$user['zs']=""
$user['1s']="”
$user['ww']="!""
$user=array
"”,
$s'=>"”
“!""
&
2'()
$user=array
arrayC',88,
arrayC'95,
array+'!"'99
&
"',-
.'/01
23PHP/4
5'/67
/89:;/<=/
PHP/C,>5?***@ABCDEFGCDEH1Pascal8I/JKL
MNOP
PHP/HQ8RST
/UVW
CDXV/Z[+XV\1,XV\2]]&
^W
Sin/:.
_`Wabcd
,eWfloatsin(floatarg);
CDEWrsE
/tXWuvd
w':;/
1'u/
numberabs(number)}~0E|x|
floatsin(float)abcdsin(x)
floatcos(float)bcdcos(x)
floatsqrt(float)
cd
floatlofloat)0cdInx
floatloglO(float)100EIgx
floatexp(float)0eEex
floatpow(floatx,floaty)xv
Code1
doublepi()
voidsrand(int)tJ
intrand([intmin],[intmax])} E
Code2
2'/
stringstrtolower(stringstr)¢£9ST
stringstrtoupper(stringstr)¢£9RT
stringtrim(stringstr)¤¥¦§¨©
stringsubstr(stringstring,intstart,int[length])}J
«/¬string2start­®}¯length°±start9²,
³9´§µd®±¶·\length¸¹º9²³»¼}½¾2length
°
´0¿
Code3
intstrlen(stringst