Pada
postingan saya kali ini saya akan memposting tentang MODUL 8 KKPI :
PENGENALAN INTERNET. pada modul ini saya akan membuat sebuah program php
yang terhubung dengan MySql data base. Berikut ini adalah skema dan
tutorial nya.
SKEMA
Tabel Anggota
Tabel Siswa
2. Lalu kita buat skrip
sepeti berikut
1.koneksi.php
<?php
$host="localhost";
$user="root";
$pass="123456";
$db="mahasiswa";
$koneksi=mysql_connect($host,$user,$pass)
or die ("tidak dapat melakukan koneksi".mysql_error());
$konekdb=mysql_select_db($db)
or die ("Database tidak ditemukan".mysql_error());
?>
|
2. connect.php
<?php
$host =
"localhost";
$user = "root";
$pass = "123456";
$db =
"mahasiswa";
$konek =
mysql_connect($host, $user, $pass) or die ('Koneksi Gagal!');
mysql_select_db($db);
?>
|
3. login.php
<?php
session_start();
if(isset($_SESSION['userid'])) {
header('location:tampil.php'); }
require_once("connect.php");
?>
<html>
<head>
<title>Login
& Register » didinsino.co.cc</title>
<meta
http-equiv="Content-Type" content="text/html;
charset=iso-8859-1"><style type="text/css">
<!--
a:link {
color: #00FF00;
}
a:visited {
color: #66FF00;
}
.style1 {color: #FFFF99}
body {
background-image:
url(Kari%20wet%20medium%20background%20class.JPG);
}
.style2 {
color: #00FF00;
font-weight: bold;
}
-->
</style></head>
<body>
<p align="center"
class="style2">LOGIN ADMIN SMKN 3 BUDURAN </p>
<table
width="448" height="219" border="0"
align="center" cellpadding="7" cellspacing="1"
bgcolor="#333333" style="margin-top:50px;">
<form action="proseslogin.php"
method="post">
<tr bgcolor="#CCCCCC">
<td colspan="2"
align="center" bgcolor="#FF0000"><b>Admin
Login</b></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="60"
bordercolor="#FFFFFF" bgcolor="#0066FF">User ID
</td>
<td width="202"
bordercolor="#FFFFFF" bgcolor="#66FFFF"><input
name="userid" type="text"/></td>
</tr>
<tr bgcolor="#FFFFFF">
<td bordercolor="#FFFFFF"
bgcolor="#3366FF">Password</td>
<td bordercolor="#FFFFFF"
bgcolor="#66FFFF"><input name="password"
type="password"/></td>
</tr>
<tr bgcolor="#FFFFFF">
<td colspan="2"
align="center" bgcolor="#CCFF99"><input
type="submit" name="Submit" value="Login"
/></td>
</tr>
<tr bgcolor="#FFFFFF">
<td colspan="2"
align="center" bgcolor="#6633CC"><span
class="style1">Belum Jadi Admin?</span><font
color="#0000FF"> <a
href="register.php">Daftar</a></font></td>
</tr>
</form>
</table>
<div
align="center"></div>
</body>
</html>
|
Dan hasil nya akan seperti
berikut.
4. proseslogin.php
<?php
session_start();
require_once("connect.php");
$user = $_POST['userid'];
$pass = $_POST['password'];
$cekuser = mysql_query("SELECT * FROM
anggota WHERE userid = '$user'");
$jumlah = mysql_num_rows($cekuser);
$hasil = mysql_fetch_array($cekuser);
if($jumlah == 0) {
echo "User ID Belum
Terdaftar!<br/>";
echo "<a
href=\"login.php\">« Back</a>";
} else {
if($pass <> $hasil['password']) {
echo "Password
Salah!<br/>";
echo "<a
href=\"login.php\">« Back</a>";
} else {
$_SESSION['userid'] =
"$user";
header('location:tampil.php');
}
}
?>
|
5.tampil.php
<?php
session_start();
if(!isset($_SESSION['userid'])) {
header('location:login.php'); }
else { $usr = $_SESSION['userid']; }
require_once("connect.php");
$query = mysql_query("SELECT * FROM
anggota WHERE userid = '$usr'");
$hasil = mysql_fetch_array($query);
?>
<html>
<head>
<title>Halaman
Utama</title>
</head>
<body>
<center>
<?php
echo "<h2>Selamat Datang,
$usr</h2>";
echo "Nama Lengkap : " .
$hasil['nama'] . "<br/>";
echo "Email : " . $hasil['email'] .
"<p>";
?>
<a
href="logout.php"><b>Logout</b></a>
<style
type="text/css">
<!--
body,td,th {
font-family: Comic Sans MS;
font-size: 16px;
color: #FF0000;
}
body {
background-image: url(Web%20Background.jpg);
background-repeat: repeat;
}
a:link {
color: #00FF33;
}
a:visited {
color: #66FF00;
}
-->
</style><?php
include
"koneksi.php";
echo "<h2 align=center>Data Siswa
SMKN 3 BUDURAN</h2>
<table align=center border=1
cellpadding=20>
<tr><th>NIS</th>
<th>Nama</th>
<th>Jurusan</th>
<th>Jenis Kelamin</th>
<th>Alamat</th>
<th>Aksi</th>
</tr>";
$tampil=mysql_query("SELECT * FROM
siswa ORDER BY NIS");
$no=1;
while ($data=mysql_fetch_array($tampil)){
echo "<tr><td>$data[NIS]</td>
<td>$data[nama]</td>
<td>$data[jurusan]</td>
<td>$data[jenkel]</td>
<td>$data[alamat]</td>
<td><a
href=edit.php?id=$data[id]>Edit</a> |
<a href=\"hapus.php?id=$data[id]\" onClick=\"return
confirm('Apakah Anda benar-benar akan menghapus
$data[nama]?')\">Hapus</a></td>
</tr>";
$no++;
}
echo "</table>";
echo "<h2
align=center><form method=POST action=input.php>
<input type=submit value='Tambah
Data' align=center>
</form></h2>";
?>
|
Hasil dari tampil.php seperti
berikut.
6.edt.php
<html>
<title>Edit data
siswa</title>
<style
type="text/css">
<!--
body,td,th {
color: #CC0099;
font-family: fantasy;
}
body {
background-image: url(web-background.gif);
}
-->
</style><body>
<?php
include
"koneksi.php";
$edit = mysql_query("SELECT * FROM
siswa WHERE id='$_GET[id]'");
$data = mysql_fetch_array($edit);
echo "<h2 align=center>Edit
Absen </h2>
<form method=POST
action=update.php>
<input type=hidden name=id
value='$data[id]'>
<table align=center border=0
cellpadding=20>
<tr><td>NIS
</td><td> : <input type='text' name='NIS'
value='$data[NIS]'></td></tr>
<tr><td>Nama </td><td> : <input
type='text' name='nama' value='$data[nama]'></td></tr>
<tr><td>Jurusan </td><td> : <select
name='jurusan'>
<option selected>--Pilih Jurusan</option>
<option>Teknik Komputer dan Jaringan
I</option>
<option>Teknik Komputer dan Jaringan II</option>
<option>Gambar Rancang Bangun I</option>
<option>Gambar
Rancang Bangun II</option
<option>Listrik Kapal</option>
<option>Instalasi Permesinan
Kapal</option>
<option>Teknik Kendaraan Ringan</option>
<option>Teknik Las
Kapal</option>
<option>Teknik Perkakas
Mesin</option>
<option>Teknik Las
Kapal</option>
<option>Konstruksi Kapal
Baja</option>
<option>Interior
Kapal</option>
</select>
</td></tr>
<tr><td>Jenis
Kelamin</td><td> : <input type='radio' name='jenkel' value
=Pria>Pria
<input type=radio name='jenkel'
value =Wanita>Wanita
</td></tr>
<tr><td>Alamat </td><td> : <input
type='text' name=alamat
value='$data[alamat]'></td></tr></table>
<h2 align=center>
<input type=submit
value=Update>
<input type=button value=Batal
onclick=self.history.back()>
</form></h2>";
?>
</body>
</html>
|
Hasil edit.php
7.update.php
<?php
include
"koneksi.php";
$update=mysql_query("UPDATE
siswa SET NIS = '$_POST[NIS]',nama=
'$_POST[nama]',jurusan='$_POST[jurusan]',jenkel='$_POST[jenkel]'
,alamat='$_POST[alamat]'
WHERE id='$_POST[id]'");
if($update){
header('location:tampil.php');
}
else
{
echo "data gagal di update";
}
?>
|
8. hapus.php
<?php
include
"koneksi.php";
$hapus=mysql_query("DELETE
FROM siswa WHERE id='$_GET[id]'");
header('location:tampil.php');
?>
|
9.input.php
<style
type="text/css">
<!--
body {
background-image: url(web-page-backgrounds-2.jpg);
}
body,td,th {
color: #FF0000;
font-family: Times New Roman, Times, serif;
font-size: 16px;
font-weight: bold;
}
.style1 {
font-family: "Franklin Gothic Heavy";
color: #FF6666;
font-size: 18px;
}
-->
</style><title>Input
data</title>
<div align="center"><strong><span
class="style1">MASUKKAN DATA DIRI
</span></strong></div>
<?php
echo "
<form method=POST
action=simpan.php>
<table align=center border=0
cellpadding=20>
<tr><td>NIS
</td><td> : <input type=text name=NIS></td></tr>
<tr><td>nama </td><td> : <input
type=text name=nama></td></tr>
<tr><td>jurusan </td><td> : <select
name=jurusan>
<option selected>--Pilih Jurusan</option>
<option>Teknik Komputer dan Jaringan
I</option>
<option>Teknik Komputer dan Jaringan II</option>
<option>Gambar Rancang Bangun I</option>
<option>Gambar Rancang Bangun
II</option
<option>Listrik Kapal</option>
<option>Instalasi Permesinan
Kapal</option>
<option>Teknik Kendaraan Ringan</option>
<option>Teknik Las
Kapal</option>
<option>Teknik Perkakas
Mesin</option>
<option>Teknik Las
Kapal</option>
<option>Konstruksi Kapal
Baja</option>
<option>Interior
Kapal</option>
</select>
</td></tr>
<tr><td>Jenis
Kelamin</td><td> : <input type=radio name=jenkel
value=Pria>Pria
<input type=radio name=jenkel value=Wanita>Wanita
</td></tr>
<tr><td>Alamat </td><td> : <input
type=text name=alamat rows=10 cols=5></tr></td>
<tr><td
colspan=2><input type=submit value=Simpan>
<input
type=button value=Batal onclick=self.history.back()></td></tr>
</table></form>";
?>
|
Hasil dari input.php
10. simpan.php
<?php
include
"koneksi.php";
$simpan=mysql_query("INSERT
INTO siswa(NIS,nama,jurusan,jenkel,alamat)
VALUES('$_POST[NIS]','$_POST[nama]','$_POST[jurusan]','$_POST[jenkel]','$_POST[alamat]')");
if($simpan){
header ('location:tampil.php');
}
else{
echo "Data gagal tersimpan kedatabase";
}
?>
|
11. register.php
<?php
session_start();
if(isset($_SESSION['userid'])) {
header('location:tampil.php'); }
?>
<html>
<head>
<title>Login
& Register » didinsino.co.cc</title>
</head>
<body>
<table
border="0" align="center" cellpadding="10"
cellspacing="1" bgcolor="#333333"
style="margin-top:30px;">
<form
action="prosesregister.php" method="post">
<tr bgcolor="#CCCCCC">
<td colspan="2"
align="center"><strong>Pendaftaran Anggota
</strong></td>
</tr>
<tr bgcolor="#FFFFFF">
<td>Nama Lengkap </td>
<td><input name="nama"
type="text" size="40" /></td>
</tr>
<tr bgcolor="#FFFFFF">
<td>Email</td>
<td><input
name="email" type="text" size="40"
/></td>
</tr>
<tr bgcolor="#FFFFFF">
<td>User ID </td>
<td><input type="text"
name="userid" /></td>
</tr>
<tr bgcolor="#FFFFFF">
<td>Password</td>
<td><input
type="password" name="password" /></td>
</tr>
<tr bgcolor="#FFFFFF">
<td colspan="2"
align="center"><input name="Submit"
type="submit" value="Daftar"/></td>
</tr>
<tr bgcolor="#FFFFFF">
<td colspan="2"
align="center"><font color="#0000FF">Sudah Jadi
Anggota? <a
href="login.php">Login</a></font></td>
</tr>
</form>
</table>
</body>
</html>
|
12. prosesregister.php
<?php
require_once("connect.php");
$nama = $_POST['nama'];
$mail = $_POST['email'];
$user = $_POST['userid'];
$pass = $_POST['password'];
$cekuser = mysql_query("SELECT * FROM
anggota WHERE userid = '$user'");
if(mysql_num_rows($cekuser) <> 0) {
echo "User ID Sudah Terdaftar!<br/>";
echo "<a
href=\"register.php\">« Back</a>";
} else {
if(!$nama || !$mail || !$user || !$pass) {
echo "Masih ada data yang
kosong!<br/>";
echo "<a
href=\"register.php\">« Back</a>";
} else {
$simpan = mysql_query("INSERT INTO anggota
VALUES('$nama','$mail','$user','$pass')");
if($simpan) {
echo "Pendaftaran Berhasil, Silahkan <a
href=\"login.php\">Login</a>";
} else {
echo
"Proses Gagal!";
}
}
}
?>
|
13. logout.php
<?php
session_start();
unset($_SESSION['userid']);
?>
<center>
<h2>Anda telah
berhasil logout..</h2>
Silahkan klik <a
href="login.php"><b>disini</b></a> untuk login
kembali
</center>
|
Sekian Postingan saya tentang MODUL 8 KKPI : PENGENALAN INTERNET.
TERIMA KASIH.
No comments:
Post a Comment