Pada artikel ini, kita akan melihat bagaimana kita dapat menampilkan record dalam tabel HTML dengan mengambilnya dari database MySQL menggunakan PHP.
Mendekati. Pastikan Anda telah menginstal server XAMPP atau WAMP di mesin Anda. Pada artikel ini, kita akan menggunakan server WAMP
WAMP Server adalah perangkat lunak sumber terbuka untuk sistem operasi Microsoft Windows, yang dikembangkan oleh Romain Bourdon. Ini terdiri dari server web Apache, OpenSSL untuk dukungan SSL, database MySQL dan bahasa pemrograman PHP. Di sini, sebelum melalui program, kita perlu membuat database MySQL di server localhost kita. Kemudian, kita harus membuat tabel HTML yang ditautkan dengan kode PHP. PHP digunakan untuk terhubung dengan server localhost dan untuk mengambil data dari tabel database yang ada di server localhost kami dengan mengevaluasi kueri MySQL. Server WAMP membantu memulai Apache dan MySQL dan menghubungkannya dengan file PHP.
Ikuti langkah-langkah yang diberikan di bawah ini
1. Membuat Basis Data. Pertama, kita akan membuat database bernama 'geeksforgeeks'. Anda dapat menggunakan database yang ada atau membuat yang baru
buat database "geeksforgeeks"
2. Buat tabel. Buat tabel bernama 'userdata'. Tabel berisi empat bidang
- nama pengguna – varchar(100)
- masalah – int(11)
- skor – int(11)
- artikel – int(11)
Struktur tabel Anda akan terlihat seperti ini
struktur tabel "userdata"
Atau Anda dapat membuat tabel dengan menyalin dan menempelkan kode berikut ke panel SQL PHPMyAdmin Anda
CREATE TABLE IF NOT EXISTS `userdata` ( `username` varchar(100) NOT NULL, `problems` int(11) NOT NULL, `score` int(11) NOT NULL, `articles` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1;Untuk melakukan ini dari panel SQL, lihat tangkapan layar berikut
buat tabel 'userdata" dari panel SQL
Sisipkan rekaman. Kami sekarang akan memasukkan beberapa catatan ke dalam tabel kami. Di sini kami memasukkan 5 catatan. Anda dapat menambahkan beberapa catatan
Atau salin dan tempel kode berikut ke panel SQL untuk menyisipkan rekaman ke dalam tabel
INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');_Untuk melakukan ini dari panel SQL, lihat tangkapan layar berikut
memasukkan catatan
Membuat folder dan file
Kami sekarang akan membuat folder proyek kami bernama "GeeksForGeeks". Buat indeks. file php. Simpan folder proyek utama Anda (misalnya di sini. GeeksForGeeks) di “C. //wamp64/www/”, jika Anda menggunakan WAMP atau “C. //xampp/htdocs/” jika Anda menggunakan server XAMPP masing-masing. Struktur folder akan terlihat seperti ini
struktur folder
Sekarang, kami memiliki database bernama geeksforgeeks, dan tabel bernama userdata. Sekarang, inilah kode PHP untuk mengambil data dari database dan menampilkannya dalam tabel HTML.
Contoh.
php
<!-- PHP code to establish connection with the localserver -->
<?php
// Username is root
$user ='root';
$password =INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');1;
INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');_3
INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');4 =INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');6;
INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');_8
INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');_9
<!-- PHP code to establish connection with the localserver -->0=<!-- PHP code to establish connection with the localserver -->2;
<!-- PHP code to establish connection with the localserver -->4 =<!-- PHP code to establish connection with the localserver -->6 <!-- PHP code to establish connection with the localserver -->7<!-- PHP code to establish connection with the localserver -->0<!-- PHP code to establish connection with the localserver -->9$user<!-- PHP code to establish connection with the localserver -->9
<?php2$password<!-- PHP code to establish connection with the localserver -->9INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');4<?php6
<?php7
<?php8 <?php9<!-- PHP code to establish connection with the localserver -->4// Username is root1
________68______2// Username is root3<?php9// Username is root5 // Username is root6
________68______2<!-- PHP code to establish connection with the localserver -->4// Username is root9$user0________68______6
// Username is root2<!-- PHP code to establish connection with the localserver -->4$user4
$user_5
$user_6
$user7 =$user9;
=1 =<!-- PHP code to establish connection with the localserver -->4=4$user7<?php6
<!-- PHP code to establish connection with the localserver -->4=8
=_9
'root'0
'root'1
'root'2'root'3'root'4
'root'5
// Username is root2'root'7'root'8'root'4
// Username is root2;1
// Username is root2;3
// Username is root2;5
;6;7
;8;9
;8$password1
;8$password3
;6$user5
;6$password7
;8$password9
;8INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');01
;8INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');03
________72______8INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');05INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');06<!-- PHP code to establish connection with the localserver -->9INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');08<!-- PHP code to establish connection with the localserver -->9
________72______8INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');11________66______9INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');13________66______9INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');15;
;6$user5
;6INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');20
;8INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');22
;8$password3
;6$user5
;6INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');28
;6INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');20
;8INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');32
;8$password3
;8INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');36
;8$password9
;6$user5
;6INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');20
;8INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');44
;6$user5
// Username is root2INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');48
INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');_49
INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');_50
// Username is root2INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');52
;6INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');54
;6INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');56
;6INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');58
;8INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');60
<?php2INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');62
<?php2INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');64
<?php2INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');66
<?php2INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');68
;8INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');70
;8INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');72
;8<?php
<?php2INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');76
<?php2INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');78________67______9INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');80==1INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');83
<?php2INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');85
;8=9
;8INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');60
<?php2INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');91
INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');_92INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');93
________67______2INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');95INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');96 INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');80INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');98INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');99<!-- PHP code to establish connection with the localserver -->00
<?php2INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');95INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');96 INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');80INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');98<!-- PHP code to establish connection with the localserver -->06<!-- PHP code to establish connection with the localserver -->00
<?php2INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');95INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');96 INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');80INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');98<!-- PHP code to establish connection with the localserver -->13<!-- PHP code to establish connection with the localserver -->00
________67______2INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');95INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');96 INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');80INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');98<!-- PHP code to establish connection with the localserver -->20<!-- PHP code to establish connection with the localserver -->00
;8INSERT INTO `userdata` (`username`, `problems`, `score`, `articles`) VALUES ('User-2', '100', '75', '30'), ('User-1', '150', '100', '30'), ('User-3', '200', '50', '10'), ('User-4', '50', '5', '2'), ('User-5', '0', '0', '1');70
;8<?php
<?php2$user5
;8=9
;6<!-- PHP code to establish connection with the localserver -->31
// Username is root2<!-- PHP code to establish connection with the localserver -->33
<!-- PHP code to establish connection with the localserver -->_34
<!-- PHP code to establish connection with the localserver -->_35
Keluaran. Terakhir, Anda harus dapat menampilkan record dalam tabel HTML dengan mengambilnya dari database
keluaran
PHP adalah bahasa skrip sisi server yang dirancang khusus untuk pengembangan web. Anda dapat mempelajari PHP dari bawah ke atas dengan mengikuti Tutorial PHP dan Contoh PHP ini