Download to read offline
![<html> <head><title>Latihan 4 - Table Heading</title></head> <body> <table border='1' cellpadding='2' cellspacing='2' align='center' width='70%'> <tr><th>No</th><th>Nama</th><th>Pemilik</th><th>Lokasi</th></ tr> <!-- awal bagian dinamis php --> <?php $servername = "localhost"; $username = "root"; $password = ""; $databasename = "perusahaanxyz"; $koneksi = mysql_connect($servername, $username, $password); $pilihdatabase = mysql_select_db($databasename, $koneksi); if ($pilihdatabase) echo "Berhasil"; else echo "Gagal Koneksi"; $tampilkan_isi = "select * from toko"; $tampilkan_isi_sql = mysql_query($tampilkan_isi); while ($isi = mysql_fetch_array($tampilkan_isi_sql)) { $no = $isi['id']; $nama = $isi['nama_toko']; $pemilik = $isi['pemilik_toko']; $lokasi = $isi['lokasi_toko']; echo "<tr align='center'> <td>$no</td> <td>$nama</td> <td>$pemilik</td> <td>$lokasi</td></tr>"; } ?> <!-- tutup bagian dinamis php --> </table> </body> </html>](https://image.slidesharecdn.com/8-171122030040/75/Pemrograman-Web-8-MySQL-7-2048.jpg)
Uploaded byNur Fadli Utomo
Pemrograman Web 8 - MySQL
The document contains PHP code to connect to a MySQL database, create a database and table, insert sample data, and display the data in an HTML table. It establishes a database connection, checks for errors, creates a database called "test_db" and table called "toko", inserts a sample record, and then displays the table data on an HTML page by connecting to the database and looping through the records.
Pemrograman Web 8 - MySQL
- 2. <?php $servername = "localhost"; $username= "root"; $password = ""; # Check Database $db = new mysqli($servername, $username, $password); if($db->connect_error){ die('Koneksi Gagal: ' . $db->connect_error); } else { echo 'Koneksi berhasil'; } ?>
- 3. <?php # variable koneksike server mysql $servername = "localhost"; $username = "root"; $password = ""; # Cek koneksi ke Database $db = new mysqli($servername, $username, $password); if($db->connect_error){ die('Koneksi Gagal: ' . $db->connect_error); } # Membuat database dan query $sql = "CREATE DATABASE test_db"; if ($db->query($sql) === TRUE) { echo "Database Sukses Dibuat"; } else { echo "Database Gagal Dibuat: " . $db->error; } ?>
- 4. <?php $servername = "localhost"; $username= "root"; $password = ""; $databasename = "test_db"; # Check Database $db = new mysqli($servername, $username, $password, $databasename); if($db->connect_error){ die('Koneksi Gagal: ' . $db- >connect_error); } # Create a new table $sql = "CREATE TABLE IF NOT EXISTS toko ( id int NOT NULL AUTO_INCREMENT PRIMARY KEY, nama_toko varchar(255) NOT NULL, pemilik_toko varchar(255) NOT NULL, lokasi_toko varchar(255) NOT NULL )"; # Execute Query if ($db->query($sql) === TRUE) { echo "Tabel berhasil dibuat"; } else { echo "Tabel gagal dibuat: " . $db->error; } ?>
- 5. <?php # Variables $servername ="localhost"; $username = "root"; $password = ""; $databasename = “test_db"; # Check Database $db = new mysqli($servername, $username, $password, $databasename); if($db->connect_error){ die('Koneksi Gagal: ' . $db->connect_error); } # Query insert data $sql = "INSERT INTO toko (nama_toko, pemilik_toko, lokasi_toko) VALUES ('Toko Susi', 'Susi Adinda', 'Jakarta')"; # Execute Query if ($db->query($sql) === TRUE) { echo "Data berhasil di input"; } else { echo "Data gagal di input: " . $db->error; } ?>
- 6. <?php $servername = "localhost";$username = "root"; $password = ""; $databasename = “test_db"; $koneksi = mysql_connect($servername, $username, $password); $pilihdatabase = mysql_select_db($databasename, $koneksi); if ($pilihdatabase) echo "Berhasil"; else echo "Gagal Koneksi"; ?>
- 7. <html> <head><title>Latihan 4 -Table Heading</title></head> <body> <table border='1' cellpadding='2' cellspacing='2' align='center' width='70%'> <tr><th>No</th><th>Nama</th><th>Pemilik</th><th>Lokasi</th></ tr> <!-- awal bagian dinamis php --> <?php $servername = "localhost"; $username = "root"; $password = ""; $databasename = "perusahaanxyz"; $koneksi = mysql_connect($servername, $username, $password); $pilihdatabase = mysql_select_db($databasename, $koneksi); if ($pilihdatabase) echo "Berhasil"; else echo "Gagal Koneksi"; $tampilkan_isi = "select * from toko"; $tampilkan_isi_sql = mysql_query($tampilkan_isi); while ($isi = mysql_fetch_array($tampilkan_isi_sql)) { $no = $isi['id']; $nama = $isi['nama_toko']; $pemilik = $isi['pemilik_toko']; $lokasi = $isi['lokasi_toko']; echo "<tr align='center'> <td>$no</td> <td>$nama</td> <td>$pemilik</td> <td>$lokasi</td></tr>"; } ?> <!-- tutup bagian dinamis php --> </table> </body> </html>