外文翻译-accessing mysql using php通过php访问mysql

毕业设计外文文献原文及译文ACCESSINGMYSQLUSINGPHP通过PHP访问MYSQL学生姓名学号系别专业指导教师2015年5月计算机系计算机科学与技术ACCESSINGMYSQLUSINGPHPNOWTHATYOURECOMFORTABLEUSINGTHEMYSQLCLIENTTOOLSTOMANIPULATEDATAINTHEDATABASE,YOUCANBEGINUSINGPHPTODISPLAYANDMODIFYDATAFROMTHEDATABASEPHPHASSTANDARDFUNCTIONSFORWORKINGWITHTHEDATABASEFIRST,WEREGOINGTODISCUSSPHPSBUILTINDATABASEFUNCTIONSWELLALSOSHOWYOUHOWTOUSETHETHEPHPEXTENSIONANDAPPLICATIONREPOSITORYPEARDATABASEUNCTIONSTHATPROVIDETHEABILITYTOUSETHESAMEFUNCTIONSTOACCESSANYSUPPORTEDDATABASETHISTYPEOFFLEXIBILITYCOMESFROMAPROCESSCALLEDABSTRACTIONINPROGRAMMINGINTERFACES,ABSTRACTIONSIMPLIFIESACOMPLEXINTERACTIONITWORKSBYREMOVINGANYNONESSENTIALPARTSOFTHEINTERACTION,ALLOWINGYOUTOCONCENTRATEONTHEIMPORTANTPARTSPEARSDBCLASSESAREONESUCHDATABASEINTERFACEABSTRACTIONTHEINFORMATIONYOUNEEDTOLOGINTOADATABASEISREDUCEDTOTHEBAREMINIMUMTHISSTANDARDFORMATALLOWSYOUTOINTERACTWITHMYSQL,ASWELLASOTHERDATABASESUSINGTHESAMEFUNCTIONSSIMILARLY,OTHERMYSQLSPECIFICFUNCTIONSAREREPLACEDWITHGENERICONESTHATKNOWHOWTOTALKTOMANYDATABASESTHEREASONFORUSINGPHPASANNTERFACETOMYSQLISTOFORMATTHERESULTSOFSQLQUERIESINAFORMVISIBLEINAWEBPAGEASLONGASYOUCANLOGINTOYOURMYSQLINSTALLATIONUSINGYOURUSERNAMEANDPASSWORD,YOUCANALSODOSOFROMPHPHOWEVER,INSTEADOFUSINGMYSQLSCOMMANDLINETOENTERINSTRUCTIONSANDVIEWOUTPUT,YOUWILLCREATEQUERYSTRINGSTHATAREPASSEDTOMYSQLWHENMYSQLRETURNSITSRESPONSE,ITWILLCOMEASADATASTRUCTURETHATPHPCANRECOGNIZEINSTEADOFTHEFORMATTEDOUTPUTYOUSEEWHENYOUWORKONTHECOMMANDLINEFURTHERPHPCOMMANDSCANRETRIEVETHEDATAANDFORMATITFORTHEWEBPAGEMOSTWEBSITESDEVELOPEDWITHPHPCONTAINMULTIPLEPROGRAMFILESTHATWILLREQUIREACCESSTOMYSQLANDWILLTHEREFORENEEDTHELOGINANDPASSWORDDETAILSTHEREFORE,ITSSENSIBLETOCREATEASINGLEFILETOSTORETHESEANDTHENINCLUDETHATFILEWHEREVERITSNEEDEDEXAMPLE101SHOWSSUCHAFILE,WHICHIVECALLEDLOGINPHPTYPEITIN,REPLACINGVALUESSUCHASUSERNAMEWITHTHEACTUALVALUESYOUUSEFORYOURMYSQLDATABASE,ANDSAVEITTOTHEWEBDEVELOPMENTDIRECTORYYOUSETUPINCHAPTER2WELLBEMAKINGUSEOFTHEFILESHORTLYTHEHOSTNAMELOCALHOSTSHOULDWORKASLONGASYOUREUSINGAMYSQLDATABASEONYOURLOCALSYSTEM,ANDTHEDATABASEPUBLICATIONSSHOULDWORKIFYOURETYPINGINTHEEXAMPLESIVEUSEDSOFARNOWTHATYOUHAVETHELOGINPHPFILESAVED,YOUCANINCLUDEITINANYPHPFILESTHATWILLNEEDTOACCESSTHEDATABASEBYUSINGTHEREQUIRE_ONCESTATEMENTTHISHASBEENCHOSENINPREFERENCETOANINCLUDESTATEMENT,ASITWILLGENERATEAFATALERRORIFTHEFILEISNOTFOUNDANDBELIEVEME,NOTFINDINGTHEFILECONTAININGTHELOGINDETAILSTOYOURDATABASEISAFATALERRORALSO,USINGREQUIRE_ONCEINSTEADOFREQUIREMEANSTHATTHEFILEWILLBEREADINONLYWHENITHASNOTPREVIOUSLYBEENINCLUDED,WHICHPREVENTSWASTEFULDUPLICATEDISKACCESSESEXAMPLE102SHOWSTHECODETOUSEFIRST,THEVARIABLEQUERYISSETTOTHEQUERYTOBEMADEINTHISCASEITISASKINGTOSEEALLROWSINTHETABLECLASSICSNOTETHAT,UNLIKEUSINGMYSQLSCOMMANDLINE,NOSEMICOLONISREQUIREDATTHETAILOFTHEQUERY,BECAUSETHEMYSQL_QUERYFUNCTIONISUSEDTOISSUEACOMPLETEQUERY,ANDCANNOTBEUSEDTOQUERYBYSENDINGMULTIPLEPARTS,ONEATATIMETHEREFORE,MYSQLKNOWSTHEQUERYISCOMPLETEANDDOESNTLOOKFORASEMICOLONTHISFUNCTIONRETURNSARESULTTHATWEPLACEINTHEVARIABLERESULTHAVINGUSEDMYSQLATTHECOMMANDLINE,YOUMIGHTTHINKTHATTHECONTENTSOFRESULTWILLBETHESAMEASTHERESULTRETURNEDFROMACOMMANDLINEQUERY,WITHHORIZONTALANDVERTICALLINES,ANDSOONHOWEVER,THISISNOTTHECASEWITHTHERESULTRETURNEDTOPHPINSTEAD,UPONSUCCESS,RESULTWILLCONTAINARESOURCETHATCANBEUSEDTOEXTRACTTHERESULTSOFTHEQUERYYOULLSEEHOWTOEXTRACTTHEDATAINTHENEXTSECTIONUPONFAILURE,RESULTCONTAINSFALSESOTHEEXAMPLEFINISHESBYCHECKINGRESULTIFITSFALSE,ITMEANSTHATTHEREWASANERRORANDTHEDIECOMMANDISEXECUTEDONCEYOUHAVEARESOURCERETURNEDFROMAMYSQL_QUERYFUNCTION,YOUCANUSEITTORETRIEVETHEDATAYOUWANTTHESIMPLESTWAYTODOTHISISTOFETCHTHECELLSYOUWANT,ONEATATIME,USINGTHEMYSQL_RESULTFUNCTIONEXAMPLE105COMBINESANDEXTENDSTHEPREVIOUSEXAMPLESINTOAPROGRAMTHATYOUCANTYPEINANDRUNYOURSELFTORETRIEVETHERETURNEDRESULTSISUGGESTTHATYOUSAVEITINTHESAMEFOLDERASLOGINPHPANDGIVEITTHENAMEQUERYPHPITFIRSTCHECKSFORANYINPUTSTHATMAYHAVEBEENMADEANDTHENEITHERINSERTSNEWDATAINTOTHECLASSICSTABLEOFTHEPUBLICATIONSDATABASEORDELETESAROWFROMIT,ACCORDINGTOTHEINPUTSUPPLIEDREGARDLESSOFWHETHERTHEREWASINPUT,THEPROGRAMTHENOUTPUTSALLROWSINTHETABLETOTHEBROWSERSOLETSSEEHOWITWORKSTHEFIRSTSECTIONOFNEWCODESTARTSBYUSINGTHEISSETFUNCTIONTOCHECKWHETHERVALUESFORALLTHEFIELDSHAVEBEENPOSTEDTOTHEPROGRAMUPONSUCHCONFIRMATION,EACHOFTHEFIRSTSIXLINESWITHINTHEIFSTATEMENTCALLTHEFUNCTIONGET_POST,WHICHAPPEARSATTHEENDOFTHEPROGRAMTHISFUNCTIONHASONESMALLBUTCRITICALJOBFETCHINGTHEINPUTFROMTHEBROWSERIMENTIONEDINANEARLIERCHAPTERTHATABROWSERSENDSUSERINPUTTHROUGHEITHERAGETREQUESTORAPOSTREQUESTTHEPOSTREQUESTISUSUALLYPREFERRED,ANDWEUSEITHERETHEWEBSERVERBUNDLESUPALLTHEUSERINPUTEVENIFTHEFORMWASFILLEDOUTWITHAHUNDREDFIELDSANDPUTSITINTOANARRAYNAMED_POST_POSTISANASSOCIATIVEARRAY,WHICHYOUENCOUNTEREDINCHAPTER6DEPENDINGONWHETHERAFORMHASBEENSETTOUSETHEPOSTORTHEGETMETHOD,EITHERTHE_POSTORTHE_GETASSOCIATIVEARRAYWILLBEPOPULATEDWITHTHEFORMDATATHEYCANBOTHBEREADINEXACTLYTHESAMEWAYEACHFIELDHASANELEMENTINTHEARRAYNAMEDAFTERTHATFIELDSOIFAFORMCONTAINEDAFIELDNAMEDISBN,THE_POSTARRAYCONTAINSANELEMENTKEYEDBYTHEWORDISBNTHEPHPPROGRAMCANREADTHATFIELDBYREFERRINGTOEITHER_POSTISBNOR_POST“ISBN“SINGLEANDDOUBLEQUOTESHAVETHESAMEEFFECTINTHISCASEIFTHE_POSTSYNTAXSTILLSEEMSCOMPLEXTOYOU,RESTASSUREDTHATYOUCANJUSTUSETHECONVENTIONIVESHOWNINEXAMPLE108,COPYTHEUSERSINPUTTOOTHERVARIABLES,ANDFORGETABOUT_POSTAFTERTHATTHISISNORMALINPHPPROGRAMSTHEYRETRIEVEALLTHEFIELDSFROM_POSTATTHEBEGINNINGOFTHEPROGRAMANDTHENIGNOREITTHEREISNOREASONTOWRITETOANELEMENTINTHE_POSTARRAYITSONLYPURPOSEISTOCOMMUNICATEINFORMATIONFROMTHEBROWSERTOTHEPROGRAM,ANDYOUREBETTEROFFCOPYINGDATATOYOUROWNVARIABLESBEFOREALTERINGITSO,BACKTOTHEGET_POSTFUNCTION,WHICHPASSESEACHITEMITRETRIEVESTHROUGHTHEMYSQL_REAL_ESCAPE_STRINGFUNCTIONTOSTRIPOUTANYCHARACTERSTHATAHACKERMAYHAVEINSERTEDINORDERTOBREAKINTOORALTERYOURDATABASEDELETINGARECORDHAVINGLOADEDUPTHEVARIOUSPOSSIBLEVARIABLESTHATCOULDHAVEBEENPOSTEDWITHANYVALUESTHATWEREPASSED,THEPROGRAMTHENCHECKSWHETHERTHEARIABLE_POSTDELETEHASAVALUEIFSO,THEUSERHASCLICKEDONADELETERECORDBUTTONTOERASEARECORDINTHISCASE,THEVALUEOFISBNWILLALSOHAVEBEENPOSTEDASYOULLRECALL,THEISBNUNIQUELYIDENTIFIESEACHRECORDTHEHTMLFORMAPPENDSTHEISBNTOTHEDELETEFROMQUERYSTRINGCREATEDINTHEVARIABLEQUERY,WHICHISTHENPASSEDTOTHEMYSQL_QUERYFUNCTIONTOISSUEITTOMYSQLMYSQL_QUERYRETURNSEITHERTRUEORFALSE,ANDFALSECAUSESANERRORMESSAGETOBEDISPLAYEDEXPLAININGWHATWENTWRONGIFDELETEDIDNTCONTAINTHEWORD“YES,”THENTHEFOLLOWINGELSESTATEMENTISEXECUTEDQUERYISSETTOANINSERTINTOCOMMAND,FOLLOWEDBYTHEFIVEVALUESTOBEINSERTEDTHEVARIABLEISTHENPASSEDTOMYSQL_QUERY,WHICHUPONCOMPLETIONRETURNSEITHERTRUEORFALSEIFFALSEISRETURNED,ANERRORMESSAGEISDISPLAYEDTHEHTMLFORMSECTIONSIMPLYSETSTHEFORMSACTIONTOSQLTESTPHPTHISMEANSTHATWHENTHEFORMISSUBMITTED,THECONTENTSOFTHEFORMFIELDSWILLBESENTTOTHEFILESQLTESTPHP,WHICHISTHEPROGRAMITSELFTHEFORMISALSOSETUPTOSENDTHEFIELDSASAPOSTRATHERTHANAGETREQUESTTHISISBECAUSEGETREQUESTSAREAPPENDEDTOTHEURLBEINGSUBMITTEDANDCANLOOKMESSYINYOURBROWSERTHEYALSOALLOWUSERSTOEASILYMODIFYSUBMISSIONSANDTRYTOHACKYOURSERVERTHEREFORE,WHENEVERPOSSIBLE,YOUSHOULDUSEPOSTSUBMISSIONS,WHICHALSOHAVETHEBENEFITOFHIDINGTHEPOSTEDDATAFROMVIEWHAVINGOUTPUTTHEFORMFIELDS,THEHTMLDISPLAYSASUBMITBUTTONWITHTHENAMEADDRECORDANDCLOSESTHEFORMNOTETHEUSEOFTHEANDTAGSHERE,WHICHHAVEBEENUSEDTOFORCEAMONOSPACEDFONTANDALLOWALLTHEINPUTSTOLINEUPNEATLYTHECARRIAGERETURNSATTHEENDOFEACHLINEAREALSOOUTPUTWHENINSIDETAGSNOWLETSLOOKATHOWDELETINGARECORDWORKSBYCREATINGADUMMYRECORDSOTRYENTERINGJUSTTHENUMBER1INEACHOFTHEFIVEFIELDSANDCLICKONTHEADDRECORDBUTTONIFYOUNOWSCROLLDOWN,YOULLSEEANEWRECORDCONSISTINGJUSTOF1SOBVIOUSLYTHISRECORDISNTUSEFULINTHISTABLE,SONOWCLICKONTHEDELETERECORDBUTTONANDSCROLLDOWNAGAINTOCONFIRMTHATTHERECORDHASBEENDELETEDASSUMINGTHATEVERYTHINGWORKED,YOUARENOWABLETOADDANDDELETERECORDSATWILLTRYDOINGTHISAFEWTIMES,BUTLEAVETHEMAINRECORDSINPLACEINCLUDINGTHENEWONEFORMOBYDICK,ASWELLBEUSINGTHEMLATERYOUCOULDALSOTRYADDINGTHERECORDWITHALL1SAGAINACOUPLEOFTIMESANDNOTETHEERRORMESSAGETHATYOURECEIVETHESECONDTIME,INDICATINGTHATTHEREISALREADYANISBNWITHTHENUMBER1YOUARENOWREADYTOLOOKATSOMEPRACTICALTECHNIQUESTHATYOUCANUSEINPHPTOACCESSTHEMYSQLDATABASE,INCLUDINGTASKSSUCHASCREATINGANDDROPPINGTABLES,INSERTING,UPDATING,ANDDELETINGDATA,ANDPROTECTINGYOURDATABASEANDWEBSITEFROMMALICIOUSUSERSNOTETHATTHEFOLLOWINGEXAMPLESASSUMETHATYOUVECREATEDTHELOGINPHPPROGRAMDISCUSSEDEARLIERINTHISCHAPTERLETSASSUMETHATYOUAREWORKINGFORAWILDLIFEPARKANDNEEDTOCREATEADATABASETOHOLDDETAILSABOUTALLTHETYPESOFCATSITHOUSESYOUARETOLDTHATTHEREARENINEFAMILIESOFCATSLION,TIGER,JAGUAR,LEOPARD,COUGAR,CHEETAH,LYNX,CARACAL,ANDDOMESTIC,SOYOULLNEEDACOLUMNFORTHATTHENEACHCATHASBEENGIVENANAME,SOTHATSANOTHERCOLUMN,ANDYOUALSOWANTTOKEEPTRACKOFTHEIRAGES,WHICHISANOTHEROFCOURSE,YOUWILLPROBABLYNEEDMORECOLUMNSLATER,PERHAPSTOHOLDDIETARYREQUIREMENTS,INOCULATIONS,ANDOTHERDETAILS,BUTFORNOWTHATSENOUGHTOGETGOINGAUNIQUEIDENTIFIERISALSONEEDEDFOREACHANIMAL,SOYOUALSODECIDETOCREATEACOLUMNFORTHATCALLEDIDPHPINCLUDESFREEANDOPENSOURCELIBRARIESWITHTHECOREBUILDPHPISAFUNDAMENTALLYINTERNETAWARESYSTEMWITHMODULESBUILTINFORACCESSINGFTPSERVERS,MANYDATABASESERVERS,EMBEDDEDSQLLIBRARIESSUCHASEMBEDDEDPOSTGRESQL,MYSQLANDSQLITE,LDAPSERVERS,ANDOTHERSMANYFUNCTIONSFAMILIARTOCPROGRAMMERSSUCHASTHOSEINTHESTDIOFAMILYAREAVAILABLEINTHESTANDARDPHPBUILDPHPHASTRADITIONALLYUSEDFEATURESSUCHAS“MAGIC_QUOTES_GPC“AND“MAGIC_QUOTES_RUNTIME“WHICHATTEMPTTOESCAPEAPOSTROPHESANDQUOTES“INSTRINGSINTHEASSUMPTIONTHATTHEYWILLBEUSEDINDATABASES,TOPREVENTSQLINJECTIONATTACKSTHISLEADSTOCONFUSIONOVERWHICHDATAISESCAPEDANDWHICHISNOT,ANDTOPROBLEMSWHENDATAISNOTINFACTUSEDASINPUTTOADATABASEANDWHENTHEESCAPINGUSEDISNOTCOMPLETELYCORRECT68TOMAKECODEPORTABLEBETWEENSERVERSWHICHDOANDDONOTUSEMAGICQUOTES,DEVELOPERSCANPREFACETHEIRCODEWITHASCRIPTTOREVERSETHEEFFECTOFMAGICQUOTESWHENITISAPPLIEDPHPALLOWSDEVELOPERSTOWRITEEXTENSIONSINCTOADDFUNCTIONALITYTOTHEPHPLANGUAGETHESECANTHENBECOMPILEDINTOPHPORLOADEDDYNAMICALLYATRUNTIMEEXTENSIONSHAVEBEENWRITTENTOADDSUPPORTFORTHEWINDOWSAPI,PROCESSMANAGEMENTONUNIXLIKEOPERATINGSYSTEMS,MULTIBYTESTRINGSUNICODE,CURL,ANDSEVERALPOPULARCOMPRESSIONFORMATSSOMEMOREUNUSUALFEATURESINCLUDEINTEGRATIONWITHINTERNETRELAYCHAT,DYNAMICGENERATIONOFIMAGESANDADOBEFLASHCONTENT,ANDEVENSPEECHSYNTHESISTHEPHPEXTENSIONCOMMUNITYLIBRARYPECLPROJECTISAREPOSITORYFOREXTENSIONSTOTHEPHPLANGUAGEZENDPROVIDESACERTIFICATIONEXAMFORPROGRAMMERSTOBECOMECERTIFIEDPHPDEVELOPERSACCESSINGMYSQLUSINGPHP通过PHP访问MYSQL现在你已经可以熟练地使用MYSQL客户端软件来操作数据库里的数据，我们也可以开始学习如何使用PHP来显示和修改数据库里的数据了。PHP有标准的函数用来操作数据库。我们首先学习PHP内建的数据库函数，然后会学习PHP扩展和应用程序库（PEAR，PHPEXTENSIONANDAPPLICATIONREPOSITORY）中的数据库函数，我们可以使用这些函数操作所有支持的数据库。这种灵活性源自于抽象。对于编程接口而言，抽象简化了复杂的交互过程。它将交互过程中无关紧要的部分屏蔽起来，让你关注于重要的部分。PEAR的DB类就是这样一种数据库接口的抽象。你登录一个数据库所需要提供的信息被减少到最少。这种标准的格式可以通过同一个函数来访问MYSQL以及其他的数据库。同样，一些MYSQL特定的函数被更一般的、可以用在很多数据库上的函数所替代。在使用MYSQL的接口作为PHP的原因是格式化的形式在网页中可见的SQL查询的结果。只要你可以登录到您的MYSQLSTALLATION使用用户名和密码，你也可以这样做，从PHP。然而，而不是使用MYSQL的命令行来输入指令，查看输出，您将创建传递给MYSQL查询字符串。当MYSQL返回其响应它会作为一种数据结构，而不是PHP可以识别的格式的输出，你看当你在命令行工作。此外PHP命令可以检索的网页数据和格式。用PHP开发的网站大多包含多个程序文件，需要访问MYSQL，因此将需要登录名和密码的细节。因此，明智的做法建立一个单一的文件来存储这些，然后包括，凡是有需要的文件。例101显示了这样一个文件，这是我打过电话LOGINPHP。输入自己，重新把值与实际值你为你的MYSQL大TABASE使用，（如用户名）保存到WEB开发目录设置在第2章注册。我们将利用短期内的文件的使用。主机名LOCALHOST应该工作，只要你使用本地系统上的一个MYSQL数据库，该数据库出版物应的工作，如果你在我使用至今的例子打字。现在，你有LOGINPHP文件保存，你可以在任何PHP文件，将需要访问使用REQUIRE_ONCE语句的数据库中。这已被选定优先于INCLUDE语句，因为它会产生一个致命错误，如果该文件不发现。相信我，没有找到该文件包含到你的数据库登陆信息是一个致命的错误。此外，而不是使REQUIRE_ONCE要求该文件将被读取意味着只有当它以前没有被列入，防止重复浪费的磁盘访问。首先，将变量设置为查询要作出查询。在这种情况下，要见的经典表中的所有行。请注意，与采用MYSQL的命令行，没有分号，在查询的尾巴必需的，因为在MYSQL_QUERY函数用于发出一个完整的查询，并不能用来发送多个部分，一来查询一次。因此，MYSQL知道查询是否完整，不查找一个分号。这个函数返回一个结果，我们在变量结果的地方。经使用MYSQL在命令行，你可能认为导致美元的内容，作一个命令行查询与水平和垂直线，返回的结果相同，等等。但是，这不是与PHP的结果返回情况。相反，如果成功，结果将包含一个可用于提取查询结果的资源。你将看到如何在下一节中提取的数据。如果失败，结果包含虚假。因此，例如通过检查完成的结果。如果是FALSE，它意味着有一个错误，并且死命令被执行。一旦你有一个资源从一个请求MYSQL_QUERY函数返回的，你可以用它来检索所需的数据。最简单的方式做，这是你想要提取的细胞，一次一个，使用MYSQL_RESULT功能。示例105结合，并延伸到一个程序前面的例子，你可以输入并运行自己的检索返回结果。我建议你保存在同一文件夹作为LOGINPHP，并给它的名字QUERYPHP。它首先检查任何可能已输入，然后要么插入到经典的出版物数据库表的新数据或删除了一排，根据在输入供应。不管是否有输入，然后输出该方案在向浏览器表的所有行。所以让我们看看它是如何工作。新代码的第一部分开始使用使用ISSET函数来检查是否所有字段的值已被张贴到该程序。当这种确认，第一个六行的IF语句在每个调用函数GET_POST，这是在节目的最后出现。这个函数有一个小而关键的工作从浏览器获取输入。我刚才在前面的章节，浏览器的用户输入或者通过发送一个GET请求或POST请求。POST请求通常是首选，我们这里使用它。该网站的注册用户输入的所有（即使形式是充满了百场出）并将其放入到一个数组服务器捆绑命名的_POST的_POST是一个关联数组。根据表单是否已被设置为使用POST或GET方法，要么了_POST或_GET这个关联数组的形式将与数据填充。他们都在读完全相同的方式。每个领域都有一个名为后该领域的数组元素。因此，如果一个表单包含名为ISBN的领域，_POST数组包含了字书号键的元素。PHP的程序可以参照阅读_POST或书号或领域的_POST“书号“（单引号和双引号在这种情况下有相同的效果）。如果变量_POST复杂的语法似乎仍然对你放心，你可以只使用了我在例108所示公约，复制用户的输入到其他变数，而忘记后，大约的_POST。这是正常的PHP程序它们检索在程序开始的_POST所有的字段，然后忽略它。我们没有理由写入一个在_POST数组元素。它的唯一目的是交流信息，从浏览器亲克，你最好修改之前复制到你自己的变量数据。所以，回到GET_POST功能，穿过MYSQL_REAL_ESCAPE_STRING函数每个项目剥离出它检索到的任何字符，一个黑客可能已插入，以打破或改变成一个记录您的DATABASEDELETING经装了，本来是可以与任何人通过各种可能的变量值张贴，然后程序检查是否变量的_POST删除有值。如果是这样，用户点击了一个删除记录BUTTONTO删除一个记录。在这种情况下，美元的书号也将被POSTEDAS你还记得值，书号唯一标识每个记录。HTML表单追加到删除从查询字符串变量查询，然后将其传递给在MYSQL_QUERY函数创建到MYSQL的问题，它的ISBN。请求MYSQL_QUERY返回TRUE或FALSE，假导致错误消息将显示解释了什么WRONGIF删除不包含单词“是”，那么下面的ELSE语句被执行。查询设置为一个INSERTINTO命令，随后的五要插入的值。该变量然后传递到请求MYSQL_QUERY，而于完工后返回TRUE或FALSE。如果返回FALSE，错误信息显示。部分简单的HTML表单设置形式的行动，SQLTESTPHP。这意味着，当表