pertemuan 8 - report tabel

Report: TabelAdi Triyatmoko, S.Kom.

Prak. Sistem Basis Data Pertemuan Ke 8

Sistem Informasi Rabu, 12 Mei 2010

Tujuan• Koneksi ke MySQL• Melakukan Query dalam PHP• Hiasan Tabel warna• Query untuk Pencarian

Report: Tabel Halaman 2

Koneksi ke MySQL• Melakukan sambungan koneksi ke dalam

database MySQL menggunakan Sintaks PHP.

• mysql_connect()attempts to establish a connection to a MySQL database engine running on host• Sintaks:mysql_connect(char host, char user, char pass)



<?php$hostname = "localhost";$username= "root";$password = "";$connect = mysql_pconnect($hostname, $username, $password) or trigger_error(mysql_error(),E_USER_ERROR);

$database = “kuliah”;mysql_select_db($database, $connect) or die(" database tidak ditemukan");?>

config.php

Melakukan Query dalam PHP• Executes the SQL statement. the string

must consist of a single SQL statement and you should not add a terminating semicolon (“;”).

• mysql_query()• Sintaks:int mysql_query(char *statement_string)

• Return Values (int):Zero if the statement was successful. Nonzero if an error occurred.



<?phprequire_once('config.php');

$query = "select * from mhs";$meta = mysql_query($query, $koneksi) or die(mysql_error());

while($hasil=mysql_fetch_array($meta)){echo “Nama : $hasil[namamhs] <br>”;echo “Nim : $hasil[nim] <br><br>”;}?>

tabel.php

Bentuk Tabel



$query = "select * from mhs";$meta = mysql_query($query, $connect) or die(mysql_error());

echo "<table border=\“1\" cellspacing=\"1\" cellpadding=\"3\">\n";echo "<tr><td>No</td><td>Nama</td><td>Alamat</td></tr>\n";

while($hasil = mysql_fetch_array($meta)){echo "<tr><td>$hasil[nim]</td><td>$hasil[namamhs]</td><td>$hasil[alamat]</td></tr>";}echo "</table>";?>

tabel2.php


<html><head><style>.tabeldata { border: 1px solid #909090; font-size : 12px }.judul { font-weight: bold; text-align: center; background: #C0C0C0 }.terang { background: #E8E8E8 }.gelap { background: #D8D8D8 }.sorot { background: #E6B016 }</style></head><body><?phprequire_once('config.php');

$query = "select * from mhs";$meta = mysql_query($query, $connect) or die(mysql_error());echo "Tabel Mahasiswa";$terang = true;echo "<table border=\"0\“ cellspacing=\"1\“ cellpadding=\"3\“ class=\"tabeldata\">\n";echo "<tr class=\"judul\"><td>Nim</td><td>Nama</td><td>Alamat</td></tr>\n";

tabel3.php


while($hasil = mysql_fetch_array($meta)){if ($terang) {echo "<tr class=\"terang\"onMouseOver=\"this.className='sorot'\"onMouseOut=\"this.className='terang'\">";} else {echo "<tr class=\"gelap\"onMouseOver=\"this.className='sorot'\"onMouseOut=\"this.className='gelap'\">";}echo "<td align=\"center\">" . $hasil[nim] . "</td>" ."<td>" . $hasil[namamhs] . "</td>" ."<td>" . $hasil[alamat] . "</td></tr>\n";$terang = !$terang;}echo "</table>\n";?></body></html>

Query Pencarian• Metode pencarian dengan menginput

Nama lalu melakukan query “like” kedalam database.

• File yang dibuat:Form Input Nama.Hasil Query.



<html><head>

<body><form action="hasilcari.php" method="get"><label>Masukkan pencarian Nama : </label><input name="nama" /><br><input type="submit" name="submit" value="Cari" /></body></html>

formcari.php



$query = "select * from mhs where namamhs like '%$_GET[nama]%'";$meta = mysql_query($query, $connect) or die(mysql_error());echo "Nama: $_GET[nama]";echo "<table border=\"1\" cellspacing=\"1\" cellpadding=\"3\">\n";echo "<tr><td>Nim</td><td>Nama</td><td>Alamat</td></tr>\n";

while($hasil = mysql_fetch_array($meta)){echo "<tr><td>$hasil[nim]</td><td>$hasil[namamhs]</td><td>$hasil[alamat]</td></tr>";}echo "</table>";?>

hasilcari.php

Terima Kasih

Informasi Lengkap: My Blog Aladiw.us

pertemuan 8 - report tabel

Documents