通过php访问mysql

《通过php访问mysql》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、原文： GettingPHPtoTalktoMySQlNowthatyou’recomfortableusingtheMySQLclienttoolstomanipulatedatainthedatabase,youcanbeginusingPHPtodisplayandmodifydatafromthedatabase.PHPhasstandardfunctionsforworkingwiththedatabase.First,we’regoingtodiscussPHP’sbuilt-indatabasefunctions.We’llalsoshowyouh

2、owtousetheThePHPExtensionandApplicationRepository(PEAR)databasefunctionsthatprovidetheabilitytousethesamefunctionstoaccessanysupporteddatabase.Thistypeofflexibilitycomesfromaprocesscalledabstraction.Inprogramminginterfaces,abstractionsimplifiesacomplexinteraction.Itworksbyremovingany

3、nonessentialpartsoftheinteraction,allowingyoutoconcentrateontheimportantparts.PEAR’sDBclassesareonesuchdatabaseinterfaceabstraction.Theinformationyouneedtologintoadatabaseisreducedtothebareminimum.ThisstandardformatallowsyoutointeractwithMySQL,aswellasotherdatabasesusingthesamefuncti

4、ons.Similarly,otherMySQL-specificfunctionsarereplacedwithgenericonesthatknowhowtotalktomanydatabases.Forexample,theMySQL-specificconnectfunctionis:mysql_connect($db_host,$db_username,$db_password);versusPEAR’sDBconnectfunction:$connection=DB::connect("mysql://$db_username:$db_passwor

5、d@$db_host/$db_database");Thesamebasicinformationispresentinbothcommands,butthePEARfunctionalsospecifiesthetypeofdatabasestowhichtoconnect.YoucanconnecttoMySQLorothersupporteddatabases.We’lldiscussbothconnectionmethodsindetail.Inthischapter,you’lllearnhowtoconnecttoaMySQLserverfromPH

6、P,howtousePHPtoaccessandretrievestoreddata,andhowtocorrectlydisplayinformationtotheuser.1TheProcessThebasicstepsofperformingaquery,whetherusingthemysqlcommand-linetoolorPHP,arethesame:•Connecttothedatabase.•Selectthedatabasetouse.•BuildaSELECTstatement.•Performthequery.•Displaytheres

7、ults.We’llwalkthrougheachofthesestepsforbothplainPHPandPEARfunctions.2ResourcesWhenconnectingtoaMySQLdatabase,youwillusetwonewresources.Thefirstisthelinkidentifierthatholdsalloftheinformationnecessarytoconnecttothedatabaseforanactiveconnection.Theotherresourceistheresultsresource.Itc

8、ontainsallin