Form View Berita

Koneksi Database

	mysql_connect("localhost","root","salha") or die ("Koneksi gagal");
	mysql_select_db("cobaa") or die ("Database Gagal");

Lihat Data

<?php
 $no=1;
 $tampil=mysql_query("SELECT * FROM berita ORDER BY id_berita DESC");
 while($data=mysql_fetch_array($tampil)){
 echo"
<tr>
 <td>$no</td>
 <td>$data[judul]</td>
 <td>$data[isi]</td>
 </tr>
";
  $no++;
 }
?>

Setelah Di modifikasi

<?php
//Koneksi Database
mysql_connect("localhost","root","salha") or die ("Koneksi Database Gagal");
mysql_select_db("cobaa") or die ("Database Gagal");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Lihat</title>
<script>
function decision(message, url){
if(confirm(message)) {
location.href = url;
}
}
</script>
</head>
<body>
<table width="995" border="0">
<tr>
    <td height="42" colspan="5">
      <a href="berita.php"><input type="submit" name="button" id="button" value="TAMBAH DATA" /></a>
    </td>
  </tr>
<tr>
    <td width="159" height="41" bgcolor="#00FF00"><div align="center">
No</div>
</td>
    <td width="267" bgcolor="#00FF00"><div align="center">
Judul</div>
</td>
    <td width="376" bgcolor="#00FF00"><div align="center">
Isi</div>
</td>
    <td width="175" colspan="2" bgcolor="#00FF00"><div align="center">
Aksi</div>
</td>
  </tr>
<?php 
 $no=1;
// $tampil=mysql_query(" select siswa.nilai,if((siswa.nilai)>=70,'lulus','gagal') as ket from siswa;");
$tampil=mysql_query(" select * from berita ");
 while ($data=mysql_fetch_array($tampil)){
 echo"
<tr>
		<td> <div align=center>
$no</div>
</td>
		<td> $data[judul]</td>
		<td> $data[isi]</td>
		<td> <a href=edit.php?edit=$data[id_berita]>Edit</a></td>
		<td> <a href=\"javascript:decision('Yakin Mau Di Hapus','hapus.php?hapus=$data[id_berita] ;?>')\">Hapus</a></td>
	</tr>
";
 $no++;
 }
?>
</table>
</body>
</html>

My BOOK

	Multimedia ISBN: 978-623-7110-96-5 Penerbit:Teknosain
	Analisa Perancangan Sistem Informasi ISBN: 978-623-2284-18-0 Penerbit:Graha Ilmu
	Web Programming ISBN: 978-623-2284-14-2 Penerbit:Graha Ilmu
	Dasar Pemrograman Web ISBN:978-602-5650-54-3 Penerbit: CV Sarnu Untung
	Dasar Pemrograman Web dan Framework Laravel ISBN: 978-623-91820-3-8 Penerbit Makmood Jurnaling
	Cara Cepat Membangun Website Dari Nol ISBN: 978-979-29-2397-1 Penerbit: Penerbit Andi
	Buku Saku Panduan Seorang Reviewer ISBN: - Penerbit: -

Bahan Ajar Agung

Search This Blog

Form View Berita

0 komentar:

Blog Archive

My BOOK

Popular Posts

Total Pageviews