Ini adalah contoh coding sederhana menggunakan PHP dan mySQL
pertama buatlah database dengan nama db_hardware di xampp localhost
dan nama table tb_hardware
buatlah file dengan nama koneksi.php
Coding ini berguna untuk pengaturan database
<?php
$server="localhost";
$username="root";
$pwd="";
$db="db_hardware";
mysql_connect($server,$username,$pwd) or die("Gagal mengakses Database");
mysql_select_db($db) or die ("database tidak ada");
?>
Lalu untuk membuat tampilan web buatlah file dengan nama index.php
<?php
include("koneksi.php");
?>
<!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>
<link href="style.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="wrapper">
<div id="header"> <h1>Belajar Web Desain</h1>
</div><!--ini akhiran header-->
<div id="menu">
<marquee><h2>Belajar HTML dan PHP Bersama Adiya SMKN 4 Banjarmasin</h2></marquee>
</div><!--ini akhiran menu-->
<div id="main">
<div id="kiri">
<ul>
<li><a href="index.php?menu=home">Home</a></li>
<li><a href="index.php?menu=hardware">hardware</a></li>
</ul>
</div><!--ini akhiran kiri-->
<div id="kanan">
<?php include("menu.php");?>
</div><!--ini akhiran kanan-->
</div><!--ini akhiran main-->
<div id="halat">
</div><!--ini akhiran halat-->
<div id="footer">
<h2>Copyright © created By Adiya Rachman</h2>
</div><!--ini akhiran footer-->
</div><!--ini akhiran wrapper-->
</body>
</html>
Dan untuk mempercantik tampilan web buatlah file dengan nama style.css
@charset "utf-8";
/* CSS Document */
body{
background-image:url(gambar/background.jpg);
}
h1{
margin:0;
text-align:center;
font-family:Arial, Helvetica, sans-serif;
font-style:oblique;
font-size:66px;
}
#menu h1{
margin:0px;
text-align:center;
font-family:Arial, Helvetica, sans-serif;
font-style:oblique;
}
h2{
margin:0;
text-align:center;
}
#wrapper{
border:#CC6600 solid 10px;
border-radius:10px;
width: 960px;
margin: 0 auto;
}
#header{
background:url(gambar/header.jpg);
height:150px;
}
#menu{
background:#FF9900;
padding:1px;
}
#main{
overflow:hidden;
background:green;
}
#kiri{
float: left;
min-height:400px;
width:200px;
}
#kanan{
border-left:1px solid #CCCCCC;
float:right;
min-height:400px;
width:750px;
}
#halat{
background:#CCCCCC;
height:40px;
}
#footer{
clear:both;
padding: 20px;
background:#FF3300
}#kiri ul{
margin:1px;
padding:0;
list-style:none;
}
#kiri ul li{
display:block;
margin:15px;
}
#kiri a{
display:block;
background:#ff9900;
text-decoration:none;
color:#CC0000;
padding: 3px 15px;
border:1px solid #006699;
border-radius:10px;
}
#kiri a:hover{
background-color:#ff8400;
}
Dan ini adalah gambar untuk tampilan Web nya
Lalu ini tampilan coding untuk form siswa
Buatlah file dengan nama hardware.php
<!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>
<body>
<p><a href="index.php?menu=tambah_hardware">Tambah hardware</a></p>
<form id="form1" name="form1" method="post" action="">
<p>Cari Berdasarkan:
<select name="cmbCari" id="cmbCari">
<option value="id_hardware">ID hardware</option>
<option value="nama_hardware">Nama hardware</option>
</select>
<input type="text" name="txtCari" id="txtCari" />
<input type="submit" name="button" id="button" value="Submit" />
</p>
<p> </p>
</form>
<table width="730" border="0">
<tr bgcolor="#FF9900">
<td width="82">ID hardware</td>
<td width="293">Nama hardware</td>
<td colspan="2">AKSI</td>
</tr>
<?php
@$cmbCari=$_POST['cmbCari'];
@$txtCari=$_POST['txtCari'];
if(!empty($txtCari)){
$query=mysql_query("select * from tb_hardware where $cmbCari like '%$txtCari%'");
}else{
$query=mysql_query("select * from tb_hardware");
}
while($data=mysql_fetch_array($query)){
?>
<tr valign="top" bgcolor="#CCCCCC">
<td height="39"><?php echo $data['id_hardware'];?></td>
<td><?php echo $data['nama_hardware'];?></td>
<td width="94"><a href="index.php?menu=ubah_hardware&id=<?php echo $data['id_hardware']?>">Edit</a></td>
<td width="89"><a href="index.php?menu=hapus_hardware&id=<?php echo $data['id_hardware']?>">Delete</a></td>
</tr>
<?php }?>
</table>
</body>
</html>
Dan ini contoh coding untuk menghubungkan dari form ke form
Buatlah file dengan menu .php
<?php
@$menu=$_GET['menu'];
if($menu=='home'){
include('home.php');
}elseif($menu=='hardware'){
include('hardware.php');
}elseif($menu=='tambah_hardware'){
include('tambah_hardware.php');
}elseif($menu=='insert_hardware'){
include('insert_hardware.php');
}elseif($menu=='hapus_hardware'){
include('hapus_hardware.php');
}elseif($menu=='ubah_hardware'){
include('ubah_hardware.php');
}elseif($menu=='update_hardware'){
include('update_hardware.php');
}else{
include('home.php');
}
?>
Dan ini adalah gambar tampilan untuk form hardware
Coding untuk menjalankan link Tambah Hardware
Buatlah file dengan nama tambah_hardware.php
<!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>
<body>
<form id="form1" name="form1" method="post" action="index.php?menu=insert_hardware">
<table width="706" border="0">
<tr>
<td colspan="3"><h1>Tambah hardware</h1></td>
</tr>
<tr>
<td width="100">Id hardware</td>
<td width="7">:</td>
<td width="577"><input name="id_hardware" type="text" id="id_hardware" size="90" /></td>
</tr>
<tr>
<td width="100">Nama hardware</td>
<td width="7">:</td>
<td width="577"><input name="nama_hardware" type="text" id="nama_hardware" size="90" /></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><input type="submit" name="button" id="button" value="Simpan" /></td>
</tr>
</table>
</form>
</body>
</html>
Dan inilah coding untuk insert data atau menambah data
Buatlah file dengan insert_hardware.php
<?php
$query=mysql_query("insert into tb_hardware values ('$_POST[id_hardware]', '$_POST[nama_hardware]')");
if($query){
echo "<script>
alert(\"Data Berhasil Ditambah\")
document.location=\"index.php?menu=hardware\"
</script>";
}else{
echo "<script>
alert(\"Data Berhasil Ditambah\")
document.location=\"index.php?menu=hardware\"
</script>";
}
?>
jika diklik tambah data maka akan tampil form seperti ini
Dan inilah tampilan jika tombol edit diklik
Dan inilah coding untuk update data atau mengubah data
Buatlah file dengan ubah_hardware.php
<?php
$query=mysql_query("select * from tb_hardware where id_hardware='$_GET[id]'");
while($data=mysql_fetch_array($query)){
?>
<form id="form1" name="form1" method="post" action="index.php?menu=update_hardware&id=<?php echo $data['id_hardware']?>">
<table width="716" border="0">
<tr>
<td colspan="3"><h1>Ubah hardware</h1></td>
</tr>
<tr>
<td width="151">Id hardware</td>
<td width="3">:</td>
<td width="540"><input name="id_hardware" type="text" id="id_hardware" size="90" value="<?php echo $data['id_hardware']?>"/></td>
</tr>
<tr>
<td width="151">Nama hardware</td>
<td width="3">:</td>
<td width="540"><input name="nama_hardware" type="text" id="nama_hardware" size="90" value="<?php echo $data['nama_hardware']?>"/></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><input type="submit" name="button" id="button" value="Simpan" /></td>
</tr>
</table>
<?php }?>
</form>
Dan inilah coding untuk update data atau menambah data
Buatlah file dengan update_hardware.php
<?php
$query=mysql_query("update tb_hardware set nama_hardware='$_POST[nama_hardware]' where id_hardware='$_GET[id]'");
if($query){
echo "<script>
alert(\"Data Berhasil DiUbah\")
document.location=\"index.php?menu=hardware\"
</script>";
}else{
echo "<script>
alert(\"Data Gagal DiUbah\")
document.location=\"index.php?menu=hardware\"
</script>";
}
?>
Dan inilah coding untuk delet data atau menghapus data
Buatlah file dengan hapus_hadware.php
<?php
$query=mysql_query("delete from tb_hardware where id_hardware='$_GET[id]'");
if($query){
echo "<script>
alert(\"Data Berhasil DiHapus\")
document.location=\"index.php?menu=hardware\"
</script>";
}else{
echo "<script>
alert(\"Data Gagal DiHapus\")
document.location=\"index.php?menu=hardware\"
</script>";
}
?>
Tidak ada komentar:
Posting Komentar