Bahan Ajar Agung

Delete Form Berita


<!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>Untitled Document</title>
</head>
<?php
//Koneksi
mysql_connect("localhost","root","salha") or die ("Koneksi Gagal");
mysql_select_db("cobaa") or die ("Database Gagal");
?>
<?php
$delete=mysql_query("DELETE FROM berita where id_berita='$_GET[hapus]'");
echo"<script language=\"javascript\"> 
       alert(\"Data Berhasil Di Hapus\"); 
       document.location=\"lihat.php\"; 
     </script>"; 
?>
<body>
</body>
</html>

Form Edit dan Update Berita

Edit Form Berita


<!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>Form Berita</title>
</head>
<?php
//Koneksi
mysql_connect("localhost","root","salha") or die ("Koneksi Gagal");
mysql_select_db("cobaa") or die ("Database Gagal");
?>
<?php
$edit=mysql_query("SELECT * FROM berita WHERE id_berita='$_GET[edit]'");
$hasil=mysql_fetch_array($edit);
?>

<body>
<form id="formberita" name="formberita" method="post" action="update.php">
  <table width="446" border="0">
    <tr>
      <td height="42" colspan="3"><div align="center">Aplikasi Form Berita</div></td>
    </tr>
    <tr>
      <td width="111">Judul Berita</td>
      <td width="5">:</td>
      <td width="316"><input name="judul" type="text" id="judul" size="30" maxlength="30" value="<?php echo"$hasil[judul]"; ?>" /></td>
    </tr>
    <tr>
      <td valign="top">Isi Berita</td>
      <td valign="top">:</td>
      <td><textarea name="isi" id="isi" cols="40" rows="5"><?php echo"$hasil[isi]"; ?>

Update Form Berita

<?php
//Koneksi
mysql_connect("localhost","root","salha") or die ("Koneksi Gagal");
mysql_select_db("cobaa") or die ("Database Gagal");
?>
<?php
mysql_query("update berita set id_berita='$_POST[id_berita]', judul='$_POST[judul]',isi='$_POST[isi]'");
echo"<script language=\"javascript\"> 
       alert(\"Data Berhasil Di Simpan\"); 
       document.location=\"lihat.php\"; 
     </script>"; 
?>

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>

Form Input Berita

Koneksi Database

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

Simpan Database

	mysql_query("INSERT INTO berita(id_berita,judul,isi) VALUES    ('$_POST[id_berita]','$_POST[judul]','$_POST[isi]')");

Validasi Data

if(!empty($_POST['judul']) && !empty($_POST['judul']))
{

Java Script

	echo"
	<script language=\"javascript\">
	alert(\"Data Telah tersimpan\");
	document.location=\"lihat.php\";
	</script>
	";

Keseluruhan

<!-- Koneksi Database -->
<?php
	mysql_connect("localhost","root","salha") or die ("Koneksi gagal");
	mysql_select_db("cobaa") or die ("Database Gagal");
?>
<!-- simpan dan tambha validasi -->
<?php
if(!empty($_POST['judul']) && !empty($_POST['judul']))
{
	mysql_query("INSERT INTO berita(id_berita,judul,isi) VALUES    ('$_POST[id_berita]','$_POST[judul]','$_POST[isi]')");
	echo"
	<script language=\"javascript\">
	alert(\"Data Telah tersimpan\");
	document.location=\"lihat.php\";
	</script>
	";
}else{
	echo"
	<script language=\"javascript\">
	alert(\"Maaf! Data masih ada yang kosong\");
	document.location=\"berita.php\";
	</script>
	";
}
?>

	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

Delete Form Berita

Form Edit dan Update Berita

Form View Berita

Form Input Berita

Blog Archive

My BOOK

Popular Posts

Total Pageviews