MySQL yog qhov feem ntau siv cov ntaub ntawv tswj hwm kev lag luam hauv kev tsim kho web niaj hnub no. Server-sab sau cov lus PHP yog cov nquag siv thaum tsim cov khoom siv Is Taws Nem thiab, ntawm chav kawm, nws muab tag nrho cov haujlwm rau kev ua haujlwm nrog MySQL. Ntawm lawv, muaj cov uas siv rau hauv PHP scripts los txuas mus rau lub database.
Cov Lus Qhia
Kauj ruam 1
Tsim qhov sib txawv tshiab hauv php tsab ntawv thiab muab nws txoj kab txuas rov qab los ntawm cov kab hauv mysql_connect. Txoj haujlwm no yuav tsum dhau peb kab: sql-server address, username thiab password. Qhov chaw nyob tuaj yeem yog qhov txuas tag nrho pib nrog cov txheej txheem kev sib txuas thiab xaus nrog tus naj npawb chaw nres nkoj ntawm cov neeg rau zaub mov rau tej thaj chaw deb - piv txwv li,
Kauj ruam 2
Yog hais tias tsab ntawv raug tua rau tib lub server hauv zos uas MySQL DBMS nyob, ces hloov chaw nyob tag nrho, nkag mus hauv thaj chaw tsim qauv tshwj tseg. Piv txwv li, txoj hlua uas muaj qhov hloov pauv tshiab uas tau muab ua haujlwm pov thawj xa rov qab los ntawm txoj haujlwm no yuav zoo li no:
$ connectToDB = mysql_connect ("localhost", "MySQLuserName", "MySQLuserPass");
Yog tias qhov txuas tsis ua tiav, qhov sib txuas ntawm $ connectToDB yuav yog qhov tsis tseeb.
Kauj ruam 3
Hauv kauj ruam dhau los, koj tsim kev sib cuag nrog SQL server, thiab tom qab ntawd koj yuav tsum xa ib qho kev thov xaiv ib qho ntawm cov ntaub ntawv khaws cia muaj rau tus neeg siv uas nws nkag mus rau koj lub mysql_connect muaj nuj nqi. Txhawm rau ua qhov no, siv lwm tus tsim PHP hauv kev ua haujlwm - mysql_select_db. Nws yuav tsum tau muaj qhov yuav tsum tau taw qhia ntawm ob lub tsis sib haum - lub npe ntawm cov ntaub ntawv koj nyiam thiab ib qhov txuas rau kev tsim kev sib txuas rau SQL server. Piv txwv, yog tias cov ntxhuav koj xav tau nyob hauv ib qho chaw hu ua SiteBase, tom qab ntawd txhawm rau txuas los ntawm cov kauj ruam dhau los, kev hu mus rau txoj haujlwm no yuav tsum tau sau raws li hauv qab no:
mysql_select_db ("SiteBase", $ connectToDB);
Kauj ruam 4
Qhov encoding ntawm cov ntxhuav database tsis yeej ib txwm ua ke nrog qhov encoding siv los ntawm daim ntawv thov lub web, yog li nws yuav tsum tau hais tam sim tom qab xaiv cov database muab rau SQL server ncaj qha cov lus qhia nyob rau hauv uas encoding nws yuav tau txais thiab xa cov ntaub ntawv mus rau lub web application, thiab nyob rau hauv uas nws yuav tsum sau thiab nyeem los ntawm cov ntaub ntawv ntxhuav. Txhawm rau ua qhov no, siv qhov ua muaj mysql_query muaj nuj nqi, dhau nws qhov yuav tsum tau MySQL cov lus txib. Nws yog txaus kom xa ib pawg ntawm peb cov lus txib, piv txwv li:
mysql_query ("SET character_set_client = 'cp1251'");
mysql_query ("SET character_set_results = 'cp1251'");
mysql_query ("SET collation_connection = 'cp1251_general_ci'");
