MySQL II - Menampilkan Data

Import Terlebih dahulu Database berikut :

CREATE TABLE IF NOT EXISTS `kehadiran` (

  `idKehadiran` int(11) NOT NULL AUTO_INCREMENT,

  `idMatakuliah` int(11) NOT NULL,

  `idMahasiswa` int(11) NOT NULL,

  `hadirKehadiran` varchar(255) NOT NULL,

  PRIMARY KEY (`idKehadiran`)

) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--

-- Dumping data for table `kehadiran`

--

INSERT INTO `kehadiran` (`idKehadiran`, `idMatakuliah`, `idMahasiswa`, `hadirKehadiran`) VALUES

(1, 2, 1, 'HADIR'),

(2, 2, 3, 'HADIR'),

(3, 2, 2, 'TIDAK HADIR');

-- --------------------------------------------------------

--

-- Table structure for table `mahasiswa`

--

CREATE TABLE IF NOT EXISTS `mahasiswa` (

  `idMahasiswa` int(11) NOT NULL AUTO_INCREMENT,

  `nimMahasiswa` varchar(8) NOT NULL,

  `namaMahasiswa` varchar(255) NOT NULL,

  PRIMARY KEY (`idMahasiswa`)

) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--

-- Dumping data for table `mahasiswa`

--

INSERT INTO `mahasiswa` (`idMahasiswa`, `nimMahasiswa`, `namaMahasiswa`) VALUES

(1, '14010001', 'Florincia'),

(2, '14010038', 'Munadirin ABC'),

(3, '14010120', 'Marto Rangga'),

(4, '14010119', 'Rahmi Syafitri');

-- --------------------------------------------------------

--

-- Table structure for table `matakuliah`

--

CREATE TABLE IF NOT EXISTS `matakuliah` (

  `idMatakuliah` int(11) NOT NULL AUTO_INCREMENT,

  `namaMatakuliah` varchar(255) NOT NULL,

  `kodeMatakuliah` varchar(255) NOT NULL,

  PRIMARY KEY (`idMatakuliah`)

) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--

-- Dumping data for table `matakuliah`

--

INSERT INTO `matakuliah` (`idMatakuliah`, `namaMatakuliah`, `kodeMatakuliah`) VALUES

(1, 'PHP', 'MK-0001'),

(2, 'MySQL', 'MK-0002'),

(3, 'HTML', 'MK-0003'),

(4, 'ASP', 'MK-0004');

Source Code tampilan diatas adalah :

<?php

//Konfigurasi Database Server

$server = "127.0.0.1";

$username = "root";

$password = ""; 

$database = "absensi";

// Koneksi dan memilih database di server

mysql_connect($server,$username,$password) or die("Koneksi gagal");

mysql_select_db($database) or die("Database tidak bisa dibuka");

echo"<h2 align=center>Data Mahasiswa</h2>

<table width=90% align=center border=1>

            <thead style='background-color:gray;'>

                <tr>

<th width=5>No</th>

<th width=200>NIM</th>

<th>Nama Mahasiswa</th>

                </tr>

            </thead>

            <tbody>";

$tampil = mysql_query(" SELECT *

FROM mahasiswa

ORDER BY mahasiswa.nimMahasiswa ASC ");

$jml = mysql_num_rows($tampil);

if($jml==0){

echo"<tr>

<td colspan=9 align=center><blink> Data Is Empty </blink></td>

</tr>";

}else{

$no=0;

while ($r=mysql_fetch_array($tampil)){

$no++;

echo"<tr>

<td align=center>$no.</td>

<td>$r[nimMahasiswa]</td>

<td>$r[namaMahasiswa]</td>

</tr>";

}

}

        echo"</tbody>

        </table>

<h2 align=center>Data Mata Kuliah</h2>

<table width=90% align=center border=1>

            <thead style='background-color:gray;'>

                <tr>

<th width=5>No</th>

<th width=200>Kode Mata Kuliah</th>

<th>Nama Mata Kuliah</th>

                </tr>

            </thead>

            <tbody>";

$tampil = mysql_query(" SELECT *

FROM matakuliah

ORDER BY matakuliah.kodeMatakuliah ASC ");

$jml = mysql_num_rows($tampil);

if($jml==0){

echo"<tr>

<td colspan=9 align=center><blink> Data Is Empty </blink></td>

</tr>";

}else{

$no = 0;

while ($r=mysql_fetch_array($tampil)){

$no++;

echo"<tr>

<td>$no.</td>

<td>$r[kodeMatakuliah]</td>

<td>$r[namaMatakuliah]</td>

</tr>";

}

}

        echo"</tbody>

        </table>";

?>