Maphunziro pakupanga database ya MySQL kuyambira pachiyambi

Maphunziro pa Kupanga Database ya MySQL Kuyambira Pachiyambi

MySQL ndi imodzi mwa njira zodziwika bwino zoyendetsera ma database (RDBMS) padziko lonse lapansi. Imadziwika ndi liwiro lake, kudalirika, komanso kugwiritsa ntchito mosavuta. M'nkhaniyi, tikambirana njira zopangira database ya MySQL kuyambira pachiyambi, kuphatikizapo kukhazikitsa, kulumikizana, kupanga tebulo, ndi kusintha deta.

1. Kukhazikitsa kwa MySQL

Gawo 1: Tsitsani MySQL
Choyamba, muyenera kutsitsa MySQL. Pitani patsamba lovomerezeka la MySQL (https://dev.mysql.com/downloads/) ndikusankha mtundu wa MySQL womwe ukugwirizana ndi makina anu ogwiritsira ntchito. Onetsetsani kuti mwatsitsa mtundu waulere wa Community.

Gawo 2: Ikani MySQL
Mukatsitsa, tsatirani njira zoyikira motsatira malangizo omwe aperekedwa. Njira yoyikira nthawi zambiri imaphatikizapo:

- Gwirizanani ndi malamulo ndi zikhalidwe.
- Sankhani zigawo zomwe zikuyenera kuyikidwa (Seva, Workbench, ndi zina zotero).
- Konzani makonda a seva (doko, mawu achinsinsi a mizu, ndi zina zotero).
- Kuyambitsa ntchito ya MySQL.

Mukhoza kusankha makonda okhazikika, koma musaiwale kulemba mawu achinsinsi a mizu.

2. Kugwiritsa ntchito MySQL Workbench

MySQL Workbench ndi chida cha GUI chomwe chimapangitsa kuti kasamalidwe ka database kakhale kosavuta. Malangizo otsatirawa adzagwiritsa ntchito MySQL Workbench, koma mungagwiritsenso ntchito mzere wolamula.

Gawo 1: Tsegulani MySQL Workbench
Tsegulani MySQL Workbench ndikupanga kulumikizana kwatsopano. Lowetsani dzina la kulumikizana ndi tsatanetsatane wa seva (nthawi zambiri `localhost` kapena `127.0.0.1`), komanso mawu achinsinsi omwe mudapanga panthawi yokhazikitsa.

Gawo 2: Kupanga Database Yatsopano
Dinani kumanja pa `Schemas` mu gulu lakumanzere ndikusankha `Pangani Schema`. Lowetsani dzina la database yomwe mukufuna, mwachitsanzo `db_tutorial`.

“`sql
PANGANI DATABASE db_tutorial;
``

3. Pangani Tebulo

Tsopano tipanga tebulo mu database ya `db_tutorial`.

Gawo 1: Sankhani Database
Ngati mukugwiritsa ntchito mzere wa lamulo:
“`sql
Gwiritsani ntchito db_tutorial;
``

Ngati mukugwiritsa ntchito MySQL Workbench, dinani kawiri pa `db_tutorial` mu gulu la schemas.

Gawo 2: Kupanga Tebulo
Nayi chitsanzo cha SQL script yopangira tebulo la `ogwiritsa ntchito`:

“`sql
Pangani ogwiritsa ntchito TABLE (
id INT AUTO_INCREMENT PRIMARY KEY,
dzina lolowera VARCHAR(50) OSATI NULL,
Imelo VARCHAR(100) OSATI NULL,
adapangidwa_pa TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
``

Kufotokozera:
– `id`: Monga kiyi yayikulu yokhala ndi auto-increment.
– `dzina lolowera`: Mzere wosungira dzina lolowera.
– `imelo`: Mzere wosungira imelo ya ogwiritsa ntchito.
– `created_at`: Mzere wosungira nthawi yomwe cholemberacho chinapangidwa.

4. Kulowetsa Deta

Gawo 1: Kuwonjezera Deta
Tidzagwiritsa ntchito lamulo la `INSERT INTO` kuti tiike deta mu tebulo la `users`.

“`sql
IKANI MU Ogwiritsa Ntchito (dzina lolowera, imelo) MALIRE ('john_doe', '[imelo ndiotetezedwa]');
IKANI MU Ogwiritsa Ntchito (dzina lolowera, imelo) MIYENDO ('jane_doe', '[imelo ndiotetezedwa]');
``

Gawo 2: Tsimikizirani Deta
Kuti muwonetsetse kuti deta yalowetsedwa, mutha kugwiritsa ntchito lamulo la `SELECT`.

“`sql
SANKHANI KUCHOKERA KWA Ogwiritsa Ntchito;
``

5. Kusamalira Deta

Gawo 1: Kusintha Deta
Kuti musinthe deta mu tebulo la `users`, mutha kugwiritsa ntchito lamulo la `UPDATE`:

“`sql
SINTHA ogwiritsa ntchito KHALANI imelo = '[imelo ndiotetezedwa]'KUMENE dzina lolowera = 'john_doe';
``

Gawo 2: Kuchotsa Deta
Kuti muchotse deta patebulo, gwiritsani ntchito lamulo la `DELETE`:

“`sql
CHOTSANI KWA ogwiritsa ntchito PENE dzina lolowera = 'john_doe';
``

6. Kusunga ndi Kubwezeretsa

Kusunga Zosungira Zachinsinsi
Kuti musunge database, mutha kugwiritsa ntchito lamulo la `mysqldump` pamzere wolamula:

“`sh
mysqldump -u root -p db_tutorial > db_tutorial_backup.sql
``

Lamuloli lidzapanga fayilo ya `db_tutorial_backup.sql` yomwe ili ndi deta yonse ndi kapangidwe ka database ya `db_tutorial`.

Bwezeretsani Database
Kuti mubwezeretse database kuchokera ku fayilo yosungira, gwiritsani ntchito lamulo ili:

“`sh
mysql -u root -p db_tutorial <db_tutorial_backup.sql ``` 7. Kugwiritsa ntchito PHP kuti mulumikizane ndi MySQL

Kuti mupange mapulogalamu a pa intaneti osinthika, nthawi zambiri mumayenera kulumikiza MySQL ndi chilankhulo chopangira mapulogalamu monga PHP. Nayi chitsanzo choyambira: Gawo 1: Kulemba Khodi Yolumikizira Pangani fayilo yatsopano yotchedwa `connect.php` ndikuwonjezera khodi iyi: ```php cholumikizira_cholakwika) {
kufa ("Kulumikizana kwalephera:". $conn->connect_error);
}
echo "Yalumikizidwa bwino";
?>
``

Sinthani `password` ndi root password yanu.

Gawo 2: Pezani kudzera pa Browser
Tsegulani fayilo ya `connect.php` mu msakatuli wanu. Ngati kulumikizana kwayenda bwino, mudzawona uthenga wakuti “Kulumikizidwa bwino.”

8. Njira Zabwino Kwambiri Zoyendetsera Database

- Kugwiritsa Ntchito Ma Index: Ma Index amatha kufulumizitsa ntchito zina za SELECT, INSERT, UPDATE, ndi DELETE.
- Kusintha: Kuchepetsa kubwerezabwereza kwa deta ndikuwonetsetsa kuti deta ikugwirizana.
- Kusunga Zinthu Zosungidwa Nthawi Zonse: Nthawi zonse chitani zosunga zinthu nthawi zonse mu database yanu kuti mupewe kutayika kwa deta.
– Chitetezo: Onetsetsani kuti mukugwiritsa ntchito njira zotsimikizika mwamphamvu ndikuletsa mwayi wolowa mu database.

Mapeto

Mu phunziroli, takambirana njira zoyambira zokhazikitsira MySQL, kupanga ma database ndi matebulo, komanso kuyika ndi kuyang'anira deta. Izi zimapereka maziko olimba oyambira kugwira ntchito ndi MySQL mu mapulojekiti anu. Nthawi zonse kumbukirani kutsatira njira zabwino zoyendetsera database kuti muwonetsetse kuti ikugwira ntchito bwino komanso chitetezo. Tikukhulupirira kuti nkhaniyi yakhala yothandiza, ndipo zabwino zonse!