Koj tuaj yeem paub cov naj npawb ntawm cov ntaub ntawv khaws tseg hauv ib lub rooj database yog siv daim ntawv thov lossis programmatically. Txoj haujlwm no yog ib qho yooj yim tshaj plaws thaum ua haujlwm nrog databases, yog li qhov kev xaiv ntawm hom tshwj xeeb tsuas yog nyob ntawm hom database thiab cov cuab yeej twg yog qhov koj pov tseg. Hauv qab no yog cov kev xaiv rau ib qho ntawm DBMS feem ntau siv hnub no - MySQL.
Tsim nyog
PhpMyAdmin Ntawv Thov
Cov Lus Qhia
Kauj ruam 1
Siv, piv txwv li, PhpMyAdmin daim ntawv thov nrhiav cov naj npawb ntawm cov ntaub ntawv khaws cia hauv txhua lub rooj database uas koj xav paub txog. Cov program no feem ntau siv rau "phau ntawv" kev tswj ntawm MySQL cov ntaub ntawv vim nws yooj yim thiab ua haujlwm dav. Koj tuaj yeem tau ntim cov khoom xa tawm tshiab ntawm daim ntawv thov pub dawb rau ntawm lub khw tsim cov vev xaib -
Kauj ruam 2
Rub tawm daim ntawv thov PhpMyAdmin teeb tsa, nkag rau hauv thiab nyem qhov kab sib txuas nrog lub npe ntawm cov ntaub ntawv koj xav tau nyob hauv lub vaj huam sib luag sab laug. Qhov kev pab cuam yuav thauj mus rau hauv txoj cai pane cov npe ntawm cov ntxhuav hauv cov ntaub ntawv no, muaj cov ntaub ntawv dav dav txog lawv. Tseem yuav muaj ib kem nrog lub ncauj lus "Cov Ntaub Ntawv" uas qhia tias muaj pes tsawg leej - nrhiav cov kab ntawv uas xav tau nyob rau hauv cov npe thiab saib cov xov tooj sib xws.
Kauj ruam 3
Yog tias koj xav tau siv cov lus MySQL los txiav txim seb muaj pes tsawg tus kab hauv ib lub rooj, tom qab ntawd cov lus nug uas xav tau tuaj yeem tsim nyob hauv ntau txoj kev. Rau cov rooj me me, kev ceev ntawm kev ua tiav ntawm cov lus nug no tsis yog qhov tseem ceeb, tab sis nws yog qhov zoo dua rau lawv xaiv cov lus txib uas yuav tsum muaj kev siv nyiaj tsawg kawg ntawm kev siv computer los ntawm DBMS. Raws li qhov no, ua ib qhov lus nug, piv txwv, hauv daim ntawv hauv qab no: SELECT COUNT (*) LOS NTAWM `table_name` Ntawm no koj yuav tsum hloov lub table_name nrog lub npe ntawm qhov xav tau.
Kauj ruam 4
Siv tib PhpMyAdmin daim ntawv thov lossis cov ntawv sau hauv cov lus programming kom xa cov lus nug SQL rau lub chaw khaws ntaub ntawv. Txhawm rau ua qhov no, hauv daim ntawv thov interface, xaiv lub rooj uas xav tau los ntawm daim ntawv nyob rau sab laug pane, thiab tom qab ntawd nyem "SQL" txuas rau hauv txoj cai pane. PhpMyAdmin yuav thauj ib nplooj ntawv nrog cov lus nug piv txwv (s) hauv "Teb lus nug SQL (s) tawm tsam mysql database". Kho nws thiab nyem OK - daim ntawv thov yuav xa cov lus thov rau tus neeg rau zaub mov thiab saib cov txiaj ntsig. Thiab yog tias koj xav tau xa ib qho kev thov programmatically, siv cov lus cim hauv qhov sau ua hom lus uas qhov kev zov me nyuam sau. Piv txwv, hauv PHP nws yuav zoo li qhov no: $ countRows = mysql_query ("SELECT COUNT (*) FROM` table_name`");
