Script PHP

Contoh Script

 PROJECT
1. Pembuatan Database
- Buatlah database dengan nama “smk” kalau anda mau nama lain ya gak pa pa?
- Didalam database tersebut, buat tabel “siswa”

2. Script
a. koneksi.php
<?php
$server = "localhost";
$username = "root";
$password = "";
$database = "smk";
mysql_connect($server,$username,$password) or die ("gagal");
mysql_select_db ($database) or die ("Database tidak ditemukan");
?>
b. tampil_siswa.php
<?php
echo "<h2>TAMPIL SISWA</h2>
<form method=POST action=finput_siswa.php>
<input type=submit value='Tambah Siswa'>
</form>
<table border=1>
<tr><td>No</td><td>NIS</td><td>Nama</td><td>Tgl Lahir</td><td>Alamat</td><td colspan=2 align=center>Action</td></tr>";
include "koneksi.php";
$tampil=mysql_query("SELECT * FROM siswa ORDER BY nis");
$no=1;
while ($r=mysql_fetch_array($tampil)){
echo"<tr><td>$no</td>
<td>$r[nis]</td>
<td>$r[nm_siswa]</td>
Modul Mapel Web Dasar – Kelas XI TKJ
Computer Engineering and Network – SMK Tunas Harapan Pati 88
<td>$r[tgl_lahir]</td>
<td>$r[alamat]</td>
<td><a href=hapus_siswa.php?nis=$r[nis]>Hapus</a></td>
<td><a href=fedit_siswa.php?nis=$r[nis]>Edit</a></td>
</tr>";
$no++;
}
echo "</table>";
?>
c. finput_siswa.php
<?php
echo"<h2>INPUT SISWA</h>
<form method=POST action=input_siswa.php>
<table>
<tr>
<td>NIS</td><td>:</td><td><input type=text name='nis'></td>
</tr>
<tr>
<td>Nama</td><td>:</td><td><input type=text name='nm_siswa'></td>
</tr>
<tr>
<td>Tgl Lahir</td><td>:</td><td><input type=text name='tgl_lhr'></td></tr>
<tr>
<td>Alamat</td><td>:</td><td><input type=text name='alamat'></td>
</tr>
<tr>
<td>Agama</td><td>:</td><td><input type=text name='agama'></td></tr>
<tr>
<td>Email</td><td>:</td><td><input type=text name='email'></td></tr>
<tr>
<td>No Telp</td><td>:</td><td><input type=text name='telp_siswa'></td></tr>
<tr>
<td>Username</td><td>:</td><td><input type=text name='user'></td></tr>
<tr>
<td>Password</td><td>:</td><td><input type=text name='pass'></td></tr>
<tr><td>.</td><td>.</td><td><input type=submit value=Simpan></td></tr>
</table>
</form>";
?>
d. input_siswa.php
<?php
include "koneksi.php";
mysql_query ("INSERT INTO siswa(nis,nm_siswa,tgl_lahir,alamat,agama,email,telp_siswa,user,pass)
VALUES('$_POST[nis]','$_POST[nm_siswa]','$_POST[tgl_lahir]','$_POST[alamat]','$_POST[agama]','$_POST[email]','$_POST[telp_siswa]','$_POST[user]') ,'$_POST[pass]'");
header('location:tampil_siswa.php');
?>

e. hapus_siswa.php
<?php
include "koneksi.php";
mysql_query("DELETE FROM siswa WHERE nis='$_GET[nis]'");
header('location:tampil_siswa.php');
?>
f. fedit_siswa.php
<?php
include "koneksi.php";
$edit=mysql_query("SELECT * FROM siswa WHERE nis='$_GET[nis]'");
$r =mysql_fetch_array($edit);
echo"<h2>EDIT SISWA</h2>
<form method=POST action=edit_siswa.php>
<input type=hidden name=nis value='$r[nis]'>
<table>
<tr><td>NIS</td><td>:</td><td><input type=text name=nis value='$r[nis]' disabled='disabled'></td></tr>
<tr><td>Nama</td><td>:</td><td><input type=text name=nm_siswa value='$r[nm_siswa]'></td></tr>
<tr><td>Tgl Lahir</td><td>:</td><td><input type=date name=tgl_lahir value='$r[tgl_lahir]'></td></tr>
<tr><td>Alamat</td><td>:</td><td><input type=text name=alamat name value='$r[alamat]'></td></tr>
<tr><td>Agama</td><td>:</td><td><input type=text name=agama value='$r[agama]'></td></tr>
<tr><td>Email</td><td>:</td><td><input type=text name=email value='$r[email]'></td></tr>
<tr><td>No Telp</td><td>:</td><td><input type=text name=telp_siswa value='$r[telp_siswa]'></td>
<tr><td>Username</td><td>:</td><td><input type=text name=user value='$r[user]'></td></tr>
<tr><td>Password</td><td>:</td><td><input type=password name=pass value='$r[pass]'></td></tr>
<tr><td>.</td><td>.</td><td><input type=submit value=Update></td></tr>
</table>
</form>";
?>
g. edit_siswa.php
<?php
include "koneksi.php";
mysql_query("UPDATE siswa SET nis='$_POST[nis]',
nm_siswa='$_POST[nm_siswa]',
tgl_lahir='$_POST[tgl_lahir]',
alamat='$_POST[alamat]',
agama='$_POST[agama]',
email='$_POST[email]',
telp_siswa='$_POST[telp_siswa]',
user='$_POST[user]',
pass='$_POST[pass]'
WHERE nis='$_POST[nis]'");
header('location:tampil_siswa.php');
?>
h. flogin.php
<?php
echo "<h2>Login</h2>
<form method=POST action=login.php>
<table>
<tr><td>Username</td><td>:</td><td><input type=text name=user></td></tr>
<tr><td>Password</td><td>:</td><td><input type=password name=pass></td></tr>
<tr><td></td><td></td><td><input type=submit value=Login></td></tr>
</table>
</form>";
?>
i. login.php
<?php
// memulai session
session_start();
include "koneksi.php";
$user = $_POST['user'];
$pass = $_POST['pass'];
// query untuk mendapatkan record dari username
$hasil = mysql_query("SELECT * FROM siswa WHERE user = '$user'");
$data = mysql_fetch_array($hasil);
// cek kesesuaian password
if ($pass == $data['pass'])
{
echo "<h1>Login Sukses</h1>";
// menyimpan username dan level ke dalam session
$_SESSION['level'] = $data['level'];
$_SESSION['user'] = $data['user'];
// tampilkan menu
include "admin.php";
echo "<br>";
echo "<a href='logout.php'>LOGOUT</a>";
}
else { echo "<h1>Login gagal</h1>";
echo "<p><a href='flogin.php'>Login Kembali</a></p>";
}
?>
j. admin.php
<?php
echo "ANDA MASUK HALAMAN ADMIN";
?>

k. logout.php
<?php
session_start();
session_destroy();
echo "<h1>Anda sudah logout</h1>";
echo "<p><a href='flogin.php'>Login Kembali</a></p>";
?>
l. index.php
Insert – Table
Buatlah sedemikian rupa table tersebut, sehingga menjadi seperti tampilan dibawah :
m. home.php
Ketikkan tulisan : “SELAMAT DATANG DI WEBSITE KAMI”
<?php
$link=$_GET[link];
$link="$link.php";
if(file_exists($link))
include"$link";
else
include"home.php";
?>
Home = ?link=home
Profil = ?link=profil
Login = ?link=login

Demikian Contoh Script PHP
Kalau ada kekurangan di Script nya Mohon Maaf


SEMOGA BERMANFAAT.............