Txhawm rau txuas daim ntawv thov rau lub chaw khaws ntaub ntawv, nws yuav tsum xa cov txheej txheem ntawm cov lus txib kom tsim nyog hauv hom lus uas siv los ntawm DBMS tshwj xeeb no. MySQL cov ntaub ntawv tswj kev tswj hwm feem ntau siv niaj hnub no, thiab cov ntawv thov rau kev ua haujlwm nrog lawv tau sau ua lus scripting server-sab programming lus PHP. Hauv qab no yog qhov sib txawv ntawm cov kab lus ntawm cov lus txib hauv hom lus no rau kev sib txuas daim ntawv thov rau MySQL database.
Cov Lus Qhia
Kauj ruam 1
Siv PHP's built-in mysql_connect muaj nuj nqi xa cov ntaub ntawv sib txuas mus rau SQL tus neeg rau zaub mov. Txoj haujlwm no muaj peb qhov yuav tsum tau ua, ua ntej ntawm qhov yuav tsum tau qhia qhov chaw nyob ntawm pob. Feem ntau, cov neeg rau zaub mov no thiab cov ntawv nkag mus rau nws nyob rau ntawm tib lub cev server, yog li cov lus hauv zos localhost tau muab siv ua qhov chaw nyob. Qhov ntsuas ob yuav tsum muaj tus ID nkag mus ntawm cov neeg siv sib txuas, thiab tus thib peb - nws tus password. Piv txwv li:
$ DBconnection = mysql_connect ("localhost", "myName", "myPass");
Kauj ruam 2
Siv cov kev cuam tshuam built-in mysql_select_db tom qab tsim kev sib txuas tshiab rau SQL server. Txoj haujlwm no xaiv ib qho ntawm cov chaw khaws ntaub ntawv nyob ntawm tus neeg rau zaub mov rau kev ua haujlwm txuas ntxiv nrog cov ntxhuav muab tso rau hauv nws. Koj yuav tsum hla ob lub zog mus rau txoj haujlwm: thawj yuav tsum muaj lub npe ntawm cov ntaub ntawv xav tau, thiab thib ob yuav tsum muaj cov khoom txuas txuas uas koj tsim nyob rau hauv cov kauj ruam dhau los. Piv txwv li:
mysql_select_db ("myBase", $ DBconnection);
Kauj ruam 3
Qee lub sij hawm cov ntawv ntuag siv los ntawm daim ntawv thov thaum tso tawm cov ntaub ntawv tsis phim lub encoding nyob rau hauv cov ntaub ntawv sau nyob rau hauv cov ntaub ntawv database. Hauv qhov no, koj yuav tsum muab tus neeg rau zaub mov teeb tsa nyob rau hauv qhov twg encoding nws yuav tsum tau txais koj cov kev thov thiab hauv qhov twg encoding nws yuav tsum hloov nws cov lus teb. Qhov no tuaj yeem ua tiav los ntawm kev xa, tom qab xaiv cov chaw khaws ntaub ntawv, piv txwv li, cov kev nug hauv qab ntawm SQL:
mysql_query ("SET character_set_client = 'cp1251'");
mysql_query ("SET character_set_results = 'cp1251'");
mysql_query ("SET collation_connection = 'cp1251_general_ci'");
Tom qab ntawd, koj tuaj yeem pib ua haujlwm ncaj qha nrog cov ntxhuav lub rooj.
Kauj ruam 4
Siv kev ua haujlwm thiab chav nyeem ntawv tshwj xeeb tau tsim tshwj xeeb rau txuas rau PHP daim ntawv thov ua qhov nruab nrab ntawm koj cov ntawv thiab lub chaw khaws ntaub ntawv. Qhov zoo ntawm kev siv lawv yog tias tag nrho cov nuances txuam nrog cov ntaub ntawv pauv hauv cov tsev qiv ntawv zoo li no yog coj mus rau hauv tus account thiab ua tib zoo saib tsis taus. Lawv siv pab kom tsis txhob muaj qhov ua yuam kev, ua kom yooj yim sau cov ntawv sau rau kev ua haujlwm nrog databases thiab ua rau lawv muaj ntau yam. Ib qho piv txwv ntawm cov tsev qiv ntawv zoo li no yog DbSimple, raug tsim los hauv kev ua tus thawj coj ntawm Dmitry Koterov.
