Minggu, 25 Desember 2016

Program CRUD dalam PHP

edit.php
<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<center>
<p><a href="tampil.php">Tampil database</a> / <a href="tambah.php">Tambah Data</a></p>

<h1>Edit Data Mahasiswa

<?php
include('koneksi.php');
$id = $_GET['id'];
$show = mysql_query("SELECT * FROM addmahasiswa WHERE mhs_id='$id'");
if(mysql_num_rows($show) == 0){
echo '<script>window.history.back()</script>';
}else{
$data = mysql_fetch_assoc($show);
}
?>

<form action="edit-proses.php" method="post">
<input type="hidden" name="id" value="<?php echo $id; ?>">
<table cellpadding="3" cellspacing="0">
<tr bgcolor="#FF1493">
<td>NIM</td>
<td>:</td>
<td><input type="text" name="nim" value="<?php echo $data['nim']; ?>" required></td>
</tr>
<tr bgcolor="#1E90FF">
<td>Nama</td>
<td>:</td>
<td><input type="text" name="nama" value="<?php echo $data['nama']; ?>" required></td>
</tr>
<tr bgcolor="#B22222">
<td>Alamat</td>
<td>:</td>
<td><input type="text" name="alamat" value="<?php echo $data['alamat']; ?>" required></td>
</tr>
<tr bgcolor="#1E90FF">
<td>Email</td>
<td>:</td>
<td><input type="text" name="email" value="<?php echo $data['email']; ?>" required></td>
</tr>
<tr>
<td>&nbsp;</td>
<td></td>
<td><input type="submit" name="simpan" value="Simpan"></td>
</tr>
</table>
</form></h1>
</body>

</html>



edit-proses.php
<?php
if(isset($_POST['simpan'])){
include('koneksi.php');
$id = $_POST['id'];
$nim = $_POST['nim'];
$nama = $_POST['nama'];
$alamat = $_POST['alamat'];
$email = $_POST['email'];

$update = mysql_query("UPDATE addmahasiswa SET nim='$nim', nama='$nama', alamat='$alamat', email='$email' WHERE mhs_id='$id'") or die(mysql_error());
if($update){
echo '<center><h1>Data berhasil di simpan! ';
echo '<a href="edit.php?id='.$id.'">Kembali</a>';
}else{
echo 'Gagal menyimpan data! ';
echo '<a href="edit.php?id='.$id.'">Kembali</a>';
}
}else{
echo '<script>window.history.back()</script>';

}

?>


hapus.php
<?php
if(isset($_GET['id'])){
include('koneksi.php');
$id = $_GET['id'];
$cek = mysql_query("SELECT mhs_id FROM addmahasiswa WHERE mhs_id='$id'") or die(mysql_error());

if(mysql_num_rows($cek) == 0){
echo '<script>window.history.back()</script>';
}else{
$del = mysql_query("DELETE FROM addmahasiswa WHERE mhs_id='$id'");
if($del){
echo '<center><h1>Data mahasiswa berhasil di hapus! ';
echo '<a href="tampil.php">Kembali</a>';
}else{
echo 'Gagal menghapus data! ';
echo '<a href="tampil.php">Kembali</a>';
}
}
}else{
echo '<script>window.history.back()</script>';

}

?>


koneksi.php
<?php
$host = "localhost";
$user = "root";
$pass = "";
$name = "databasepwd5";

$koneksi = mysql_connect($host, $user, $pass) or die("Koneksi ke database gagal!");
mysql_select_db($name, $koneksi) or die("Tidak ada database yang dipilih!");

?>


tambah.php
<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<center>
<p> <a href="tampil.php">Tampil Database gan!</a><br>
<a href="tambah.php">Tambah Data gan!</a>
</p>
<br>
<h1>Tambah Data Mahasiswa

<form action="tambah-proses.php" method="post">
<table cellpadding="3" cellspacing="0">
<tr bgcolor="#FF1493">
<td>Nim</td>
<td>:</td>
<td><input type="text" name="nim" required></td>
</tr>
<tr bgcolor="#1E90FF">
<td>Nama</td>
<td>:</td>
<td><input type="text" name="nama" required></td>
</tr>
<tr bgcolor="#B22222">
<td>Alamat</td>
<td>:</td>
<td><input type="text" name="alamat" required></td>
</tr>
<tr bgcolor="#1E90FF">
<td>Email</td>
<td>:</td>
<td><input type="text" name="email" required></td>
</tr>
<tr>
<td>&nbsp;</td>
<td></td>
<td><input type="submit" name="tambah" value="Tambah"></td>
</tr>
</table>
</form></h1>
</body>

</html>



tambah-proses.php
<?php
if(isset($_POST['tambah'])){
include('koneksi.php');
$nim = $_POST['nim'];
$nama = $_POST['nama'];
$alamat = $_POST['alamat'];
$email = $_POST['email'];

$input = mysql_query("INSERT INTO addmahasiswa VALUES(NULL, '$nim', '$nama', '$alamat', '$email')") or die(mysql_error());

if($input){
echo '<center><h1>Data berhasil di tambahkan! ';
echo '<a href="tambah.php"><h1>Kembali</h1></a>';
}else{
echo '<h1>Gagal menambahkan data! </h1>';
echo '<a href="tambah.php"><h1>Kembali</a></h1>';
}
}else{
echo '<script>window.history.back()</script>';
}

?>


tampil.php
<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<center>
<p> <a href="tampil.php">Tampil Database gan!</a><br>
<a href="tambah.php">Tambah Data gan! </a>
</p>
<br>
<h1>Data Mahasiswa

<table border="2" class="table">
<tr bgcolor="#FF1493">
<th>No</th>
<th>Nim</th>
<th>Nama</th>
<th>Alamat</th>
<th>Email</th>
<th>Opsi</th>
</tr></h1>
<?php
include "koneksi.php";
$query_mysql=mysql_query("SELECT * FROM addmahasiswa")or die(mysql_error());
$no=1;
while($data = mysql_fetch_assoc($query_mysql)){
?>
<tr bgcolor="#E9967A">
<td><?php echo $no++; ?></td>
<td><?php echo $data['nim']; ?></td>
<td><?php echo $data['nama']; ?></td>
<td><?php echo $data['alamat']; ?></td>
<td><?php echo $data['email']; ?></td>
<td>
<a class="edit" href="edit.php?id=<?php echo $data['mhs_id'];?>">Edit</a> |
<a class="hapus" href="hapus.php?id=<?php echo $data['mhs_id'];?>">Hapus</a>
</td>
</tr>
<?php }?>
</table>
</body>

</html>
Diposting oleh di Tidak ada komentar:

Program PHP Rental Mobil

Langsung saja ketik source code dibawah ini:


deletemobil.php
<?php
include ("koneksi.php");

$no_mobil =@$_GET['id'];
$sql="DELETE from mobil where no_mobil=$no_mobil";
mysql_query($sql);
if($sql){
?>
<script type="text/javascript">
alert("Terhapus");

</script>
<?php
header("Location: tampilmobil.php");
}


?>


deletepelanggan.php
<?php 
include ("koneksi.php");
$ktp =@$_GET['id'];
$sql="DELETE from pelanggan where ktp=$ktp";
mysql_query($sql);
if($sql){
?>
<script type="text/javascript">
alert("Terhapus");
</script>
<?php
header("Location: tampilpelanggan.php");
}

?>



deletepesanan.php
<?php 
include ("koneksi.php");
$id_pesan = @$_GET['id'];
$sql="DELETE from pesan where id_pesan=$id_pesan";
mysql_query($sql);
if($sql){
?>
<script type="text/javascript">
alert("Terhapus");
</script>
<?php
header("Location: tampilpesanan.php");
}

?> 


editmobil.php
<?php 
include "koneksi.php";
$no_mobil=$_GET['id'];
$sql = "SELECT * from mobil where no_mobil=$no_mobil";
$query = mysql_query($sql);
$data = mysql_fetch_array ($query);
 ?>

<html>
<head>
<title>Pelanggan</title>
</head>
<body>
<table>
<form action="editmobillagi.php" method="POST">
<tr>
<td>Nomor Mobil</td>
<td>:</td>
<td><input type="text" name="no_mobil" value="<?php echo $data['no_mobil'] ?>"></td>
</tr>
<tr>
<td>Merk</td>
<td>:</td>
<td>
<select name="type">
<option value="Toyota">Toyota</option>
<option value="Honda">Honda</option>
<option value="Suzuki">Suzuki</option>
<option value="Nissan">Nissan</option>
<option value="Isuzu">Isuzu</option>
<option value="Chevrolet">Chevrolet</option>
<option value="BMW">BMW</option>
<option value="Marcedes Bens">Marcedes Bens</option>
<option value="KIA">KIA</option>
</select>
</td>
</tr>
<tr>
<td>Harga sewa</td>
<td>:</td>
<td><input type="text" name="harga" value="<?php echo $data['harga'] ?>"></td>
</tr>
<tr>
<td></td>
<td></td>
<td><input type="submit" name="save" value="Save"></td>
</tr>
</form>
</table>
</body>
</html>


editmobillagi.php
<?php 
include "koneksi.php";

$save = @$_POST['save'];
if(isset($save)){
$no_mobil = @$_POST['no_mobil'];
$type = @$_POST['type'];
$harga = @$_POST['harga'];

$sql = "UPDATE mobil set no_mobil='$no_mobil', type='$type', harga='$harga' where no_mobil=$no_mobil";
$query = mysql_query($sql) or die (mysql_error());
if ($query){
echo "Berhasil di edit";
header("Location: tampilmobil.php");
}else{
echo "Gagal di edit";
header("Location: editmobil.php");
}
}
 ?>



editpelanggan.php
<?php
include "koneksi.php";
$ktp = @$_GET['id'];

$sql = "SELECT * from pelanggan where ktp='$ktp'";
$query = mysql_query($sql) or die (mysql_error());
$data = mysql_fetch_array ($query) or die (mysql_error());
?>
<html>
<head>
<title>Pelanggan</title>
</head>
<body>
<h1>Edit Data Pelangan</h1>
<table>
<form action="editpelangganlagi.php" method="POST">
<tr>
<td>No KTP</td>
<td>:</td>
<td><input type="text" name="ktp" value="<?php echo $data['ktp'] ?>"></td>
</tr>
<tr>
<td>Nama</td>
<td>:</td>
<td><input type="text" name="nama" value="<?php echo $data['nama'] ?>"></td>
</tr>
<tr>
<td>Alamat</td>
<td>:</td>
<td><input type="text" name="alamat" value="<?php echo $data['alamat'] ?>"></u></td>
</tr>
<tr>
<td>No HP</td>
<td>:</td>
<td><input type="text" name="no_hp" value="<?php echo $data['no_hp'] ?>"></td>
</tr>
<?php  ?>
<tr>
<td></td>
<td></td>
<td><input type="submit" name="save" value="Save"></td>
</tr>
</form>
</table>
</body>
</html>


editpelangganlagi.php
<?php 
include "koneksi.php";

$save = @$_POST['save'];
if(isset($save)){
$nama = @$_POST['nama'];
$ktp = @$_POST['ktp'];
$alamat = @$_POST['alamat'];
$no_hp = @$_POST['no_hp'];

$sql = "UPDATE pelanggan set ktp='$ktp', nama='$nama', alamat='$alamat', no_hp='$no_hp'  where ktp='$ktp'";
$query = mysql_query($sql) or die (mysql_error());
if ($query){
echo "Berhasil di edit";
header("Location: tampilpelanggan.php");
}else{
echo "Gagal di edit";
header("Location: editpelanggan.php");
}
}
 ?>


editpesanan.php
<?php 
include "koneksi.php";
$id_pesan=@$_GET['id_pesan'];
$sql = "SELECT * from pesan where id_pesan='$id_pesan'";
$query = mysql_query($sql);
$x = mysql_fetch_array ($query);
 ?>
<html>
<head>
<title>Edit Pemesanan mobil</title>
</head>
<body>
<h1>Edit Pesan mobil</h1>
<form method="GET" action="editpesananlagi.php">
<table>
<tr>
<td>ID pemesanan</td>
<td>:</td>
<td><input type="text" name="id_pesan" value="<?php echo $x['id_pesan'] ?>"></td>
</tr>
<tr>
<td>pilih KTP pelanggan</td>
<td>:</td>
<td>
<select name="ktp">
<?php 
include "koneksi.php";
$sql = "SELECT * from pelanggan";
$query = mysql_query($sql);
while($data = mysql_fetch_array ($query)){
?>
<option value="<?php echo $data['ktp']; ?>"><?php echo $data['ktp'] ?> (<?php echo $data['nama'] ?>)
</option>
<?php } ?>
</select>
</td>
</tr>
<tr>
<td>pilih No Mobil</td>
<td>:</td>
<td>
<select name="no_mobil">
<?php 
include "koneksi.php";
$sql = "SELECT * from mobil";
$sql1 = "SELECT * from pesan";
$query = mysql_query($sql);
$query1 = mysql_query($sql1);
while($data1 = mysql_fetch_array ($query1)){ //pesan
while ($data = mysql_fetch_array($query)) { //mobil
if ($data['no_mobil'] != $data1['no_mobil']){
?>
<option value="<?php echo $data['no_mobil']; ?>"><?php echo $data['no_mobil'] ?> (<?php echo $data['type'] ?>)
</option>
<?php 

}
}
}
?>
</select>
</td>
</tr>
<tr>
<td>Lama meminjam</td>
<td>:</td>
<td><input type="text" name="hari" value="<?php echo $x['hari'] ?>"></td>
</tr>
<tr>
<td>Tanggal</td>
<td>:</td>
<td><input type="date" name="tgl" value="<?php echo $x['tgl'] ?>"></td>
</tr>
<tr>
<td></td>
<td></td>
<td><input type="Submit" name="save" value="SIMPAN"></td>
</tr>
</table>
</form>
</body>
</html>


editpesananlagi.php
<?php 
include "koneksi.php";

$save = @$_GET['save'];

if(isset($save)){
$id_pesan = @$_GET['id_pesan'];
$ktp = @$_GET['ktp'];
$no_mobil = @$_GET['no_mobil'];
$hari = @$_GET['hari'];
$tgl = @$_GET['tgl'];
$sql = "UPDATE pesan set id_pesan='$id_pesan', ktp='$ktp', no_mobil='$no_mobil', hari='$hari', tgl='$tgl' where id_pesan='$id_pesan'";
$query = mysql_query($sql);
if ($query){
echo "Berhasil di edit";
header("Location: tampilpesanan.php");
}else{
echo "Gagal di edit";
header("Location: editpesanan.php");
}
}

 ?>



index.php
<!DOCTYPE html>
<html>
<head>
<title>POSTTEST 6</title>
</head>
<body>
<h1>Sewa Mobil Mewah</h1>

<h3>Menu</h3>
<form action="tampilmobil.php" method="POST">
<input type="submit" name="4" value="Tabel Mobil"></form><br/>
<form action="tampilpelanggan.php" method="POST">
<input type="submit" name="5" value="Tabel Pelanggan"></form><br/>
<form action="tampilpesanan.php" method="POST">
<input type="submit" name="6" value="Tabel Pesanan"></form><br/>
<br>

</body>
</html>


koneksi.php
<?php 
mysql_connect("localhost","root","");
mysql_select_db("mobilan");

 ?>



mobil.php
<?php 
include "koneksi.php";
 ?>

<html>
<head>
<title>Pelanggan</title>
</head>
<body>
<table>
<form action="simpanmobil.php" method="POST">
<tr>
<td>Nomor Mobil</td>
<td>:</td>
<td><input type="text" name="no_mobil" ></td>
</tr>
<tr>
<td>Merk</td>
<td>:</td>
<td>
<select name="type">
<option value="Toyota">Toyota</option>
<option value="Honda">Honda</option>
<option value="Suzuki">Suzuki</option>
<option value="Nissan">Nissan</option>
<option value="Isuzu">Isuzu</option>
<option value="Chevrolet">Chevrolet</option>
<option value="BMW">BMW</option>
<option value="Marcedes Bens">Marcedes Bens</option>
<option value="KIA">KIA</option>
</select>
</td>
</tr>
<tr>
<td>Harga sewa</td>
<td>:</td>
<td><input type="text" name="harga" ></td>
</tr>
<tr>
<td></td>
<td></td>
<td><input type="submit" name="save" value="Save"></td>
</tr>
</form>
</table>
</body>
</html>



pelanggan.php
<?php 
include "koneksi.php";
 ?>

<html>
<head>
<title>Pelanggan</title>
</head>
<body>
<table>
<form action="simpanpelanggan.php" method="POST">
<tr>
<td>Nama</td>
<td>:</td>
<td><input type="text" name="nama" ></td>
</tr>
<tr>
<td>Alamat</td>
<td>:</td>
<td><input type="text" name="alamat" ></u></td>
</tr>
<tr>
<td>Nomor HP</td>
<td>:</td>
<td><input type="text" name="no_hp" ></td>
</tr>
<tr>
<td>No KTP</td>
<td>:</td>
<td><input type="text" name="ktp" ></td>
</tr>
<tr>
<td></td>
<td></td>
<td><input type="submit" name="save" value="Save"></td>
</tr>
</form>
</table>
</body>
</html>


pesanmobil.php
<!DOCTYPE html>
<html>
<head>
<title>Pesan Mobil</title>
</head>
<body>
<h1>Pesan Mobil</h1>
<form method="POST" action="simpanpesan.php">
<table>
<tr>
<td>ID pemesanan</td>
<td>:</td>
<td><input type="text" name="id_pesan" placeholder="ID"></td>
</tr>
<tr>
<td>pilih KTP pelanggan</td>
<td>:</td>
<td>
<select name="ktp">
<?php 
include "koneksi.php";
$sql = "SELECT * from pelanggan";
$query = mysql_query($sql);
while($data = mysql_fetch_array ($query)){
?>
<option value="<?php echo $data['ktp']; ?>"><?php echo $data['ktp'] ?> (<?php echo $data['nama'] ?>)
</option>
<?php } ?>
</select>
</td>
</tr>
<tr>
<td>Pilih nomor mobil</td>
<td>:</td>
<td>
<select name="no_mobil">
<option value="belum dipilih" selected="">-Pilih mobil-</option>
<?php 
include "koneksi.php";
$sql = "SELECT * from mobil";
$sql1 = "SELECT * from pesan";
$query = mysql_query($sql);
$query1 = mysql_query($sql1);
while($data1 = mysql_fetch_array ($query1)){ //pesan
while ($data = mysql_fetch_array($query)) { //mobil
if ($data['no_mobil'] != $data1['no_mobil']){
?>
<option value="<?php echo $data['no_mobil']; ?>"><?php echo $data['no_mobil'] ?> (<?php echo $data['type'] ?>)
</option>
<?php 

}
}
}
?>
</select>
</td>
</tr>
<tr>
<td>Lama pinjam</td>
<td>:</td>
<td><input type="text" name="hari"></td>
</tr>
<tr>
<td>Tanggal</td>
<td>:</td>
<td><input type="date" name="tgl"></td>
</tr>
<tr>
<td></td>
<td></td>
<td><input type="Submit" name="save" value="SIMPAN"></td>
</tr>
</table>
</form>
</body>
</html>


simpanmobil.php
<?php 
include "koneksi.php";

$save = @$_POST['save'];
if(isset($save)){
$no = @$_POST['no_mobil'];
$type = @$_POST['type'];
$harga = @$_POST['harga'];

$query = mysql_query("INSERT into mobil values ('$no','$harga','$type')") or die (mysql_error());
if ($query){
header("Location: tampilmobil.php");
}else{
header("Location: mobil.php");
}
}

 ?>


simpanpelanggan.php
<?php 
include "koneksi.php";

$save = @$_POST['save'];
if(isset($save)){
$nama = @$_POST['nama'];
$ktp = @$_POST['ktp'];
$alamat = @$_POST['alamat'];
$no_hp = @$_POST['no_hp'];

$query = mysql_query("INSERT into pelanggan values ('$ktp','$nama','$alamat','$no_hp')") or die (mysql_error());
if ($query){
?>
<script type="text/javascript">
alert ("Success");
</script>
<?php
header("Location: tampilpelanggan.php");
}else{
?>
<script type="text/javascript">
alert ("Failed");
</script>
<?php
header("Location: pelanggan.php");
}
}
 ?>


simpanpesan.php
<?php 
include "koneksi.php";

$save = @$_POST['save'];

if(isset($save)){
$id_pesan = @$_POST['id_pesan'];
$ktp = @$_POST['ktp'];
$no_mobil = @$_POST['no_mobil'];
$hari = @$_POST['hari'];
$tgl = @$_POST['tgl'];

$query = mysql_query("INSERT into pesan values ('$id_pesan','$ktp','$no_mobil','$hari','$tgl')");
if ($query){
header("Location: tampilpesanan.php");
}else{
header("Location: pesanmobil.php");
}
}

 ?>



tampilmobil.php
<?php include "koneksi.php"; ?>
<html>
<head>
<title>Tampil Mobil</title>
</head>
<body>
<h1>Tampil Data Mobil</h1>
<a href="mobil.php"><button>Tambah Data Mobil</button></a>
<a href="index.php"><button>Menu</button></a>
<br/><br/>
<table border="1">
<tr>
<td>No mobil</td>
<td>Merk</td>
<td>Harga</td>
<td>Option</td>
</tr>
<tr>
<?php 
$sql = "SELECT * from mobil";
$query = mysql_query($sql);
while($data = mysql_fetch_array ($query)){
?>
<td><?php echo $data['no_mobil']; ?></td>
<td><?php echo $data['type']; ?></td>
<td><?php echo $data['harga']; ?></td>
<td>
<a href="deletemobil.php?id=<?php echo $data['no_mobil'];?>">Delete</a> | 
<a href="editmobil.php?id=<?php echo $data['no_mobil'];?>">Edit
</td>
</tr>
<?php } ?>
</table>
</body>
</html>



tampilpelanggan.php
<?php include "koneksi.php"; ?>
<html>
<head>
<title>Tampil Pelanggan</title>
</head>
<body>
<h1>Tampil Data Pelanggan</h1>
<a href="pelanggan.php"><button>Tambah Data Pelanggan</button></a>
<a href="index.php"><button>Menu</button></a>
<br/><br/>
<table border="1">
<tr>
<td>Nama</td>
<td>Alamat</td>
<td>No HP</td>
<td>KTP</td>
<td>Option</td>
</tr>
<tr>
<?php 
$sql = "SELECT * from pelanggan";
$query = mysql_query($sql);
while($data = mysql_fetch_array ($query)){
?>
<td><?php echo $data['nama']; ?></td>
<td><?php echo $data['alamat']; ?></td>
<td><?php echo $data['no_hp']; ?></td>
<td><?php echo $data['ktp']; ?></td>
<td>
<a href="deletepelanggan.php?id=<?php echo $data['ktp'];?>">Delete</a> | 
<a href="editpelanggan.php?id=<?php echo $data['ktp'];?>">Edit
</td>
</tr>
<?php } ?>
</table>
</body>
</html>



tampilpesanan.php
<?php include "koneksi.php"; ?>
<html>
<head>
<title>Tampil Pesanan</title>
</head>
<body>
<h1>Tampil Data Pemesan Mobil</h1>
<a href="pesanmobil.php"><button>Tambah Data Pemesan Mobil</button></a>
<a href="index.php"><button>Menu</button></a>
<br/><br/>
<table border="2">
<tr>
<td>ID</td>
<td>Nama</td>
<td>Nomor mobil</td>
<td>Tanggal pinjam</td>
<td>Hari</td>
<td>Total biaya</td>
<td>Option</td>
</tr>
<tr>

<?php 
$sql = "SELECT pesan.id_pesan, pelanggan.nama, mobil.no_mobil, pesan.tgl, pesan.hari, mobil.harga from pesan, pelanggan, mobil where pelanggan.ktp=pesan.ktp and mobil.no_mobil=pesan.no_mobil";
$query = mysql_query($sql) or die(mysql_error());
while($data = mysql_fetch_array ($query)){
?>
<td><?php echo $data['id_pesan']; ?></td>
<td><?php echo $data['nama']; ?></td>
<td><?php echo $data['no_mobil']; ?></td>
<td><?php echo $data['tgl']; ?></td>
<td><?php echo $data['hari']; ?></td>
<?php 
$hari = $data['hari'];
$harga = $data['harga'];
$total = $hari*$harga ?>
<td><?php echo $total; ?></td>
<td>
<a href="deletepesanan.php?id=<?php echo $data['id_pesan'];?>">Delete</a> | 
<a href="editpesanan.php?id_pesan=<?php echo $data['id_pesan'];?>">Edit
</td>
</tr>
<?php } ?>
</table>
</body>
</html>




Lumayan banyak ya kodingannya hehe. . 

database bernama "mobilan"
tabel ada 3 buah yaitu "mobil" , "pelanggan" , "pesan"
dibawah ini lebih jelasnya:







































Semoga bermanfaat.
Diposting oleh di 3 komentar:

Koding Upload Foto dalam PHP

index.php
<html>
<head>
<title>kodingan upload php</title>
</head>
<body>
<h1>Upload Gambar</h1>
<form action="upload.php" method="post" enctype="multipart/form-data">
<table>
<tr>
<td>nama</td>

<td><input type="text" name="nama"></td>
</tr>
<tr>
<td>upload</td>
<td><input type="file" name="gambar"></td>
</tr>
<tr>
<td><button type="submit">simpan</button></td>
</tr>
</body>

</html>



upload.php
<?php
$gambar=$_FILES["gambar"]["tmp_name"];
$nama=$_POST['nama'];

move_uploaded_file($_FILES['gambar']['tmp_name'],"gambar/".$_FILES['gambar']['name']);
echo "berhasil <br>";
echo $nama."<br>";
echo "<img src='gambar/".$gambar."' width='100px' height='100px'/>";

?>


format file dibawah ini


Diposting oleh di Tidak ada komentar:

Session dalam PHP

index.php
<?php
include('login.php'); // Includes Login Script

if(isset($_SESSION['login_user'])){
header("location: profile.php");
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Login Form in PHP with Session</title>
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body>
<div id="main">
<div id="login">
<h2>Login Form</h2>
<form action="" method="post">
<label>UserName :</label>
<input id="name" name="username" placeholder="username" type="text">
<label>Password :</label>
<input id="password" name="password" placeholder="**********" type="password">
<input name="submit" type="submit" value=" Login ">
<span><?php echo $error; ?></span>
</form>
</div>
</div>
</body>

</html>


login.php
<?php
session_start(); // Starting Session
$error=''; // Variable To Store Error Message
if (isset($_POST['submit'])) {
if (empty($_POST['username']) || empty($_POST['password'])) {
$error = "Username or Password is invalid";
}
else
{
// Define $username and $password
$username=$_POST['username'];
$password=$_POST['password'];
// Establishing Connection with Server by passing server_name, user_id and password as a parameter
$connection = mysql_connect("localhost", "root", "");
// To protect MySQL injection for Security purpose
$username = stripslashes($username);
$password = stripslashes($password);
$username = mysql_real_escape_string($username);
$password = mysql_real_escape_string($password);
// Selecting Database
$db = mysql_select_db("company", $connection);
// SQL query to fetch information of registerd users and finds user match.
$query = mysql_query("select * from login where password='$password' AND username='$username'", $connection);
$rows = mysql_num_rows($query);
if ($rows == 1) {
$_SESSION['login_user']=$username; // Initializing Session
header("location: profile.php"); // Redirecting To Other Page
} else {
$error = "Username or Password is invalid";
}
mysql_close($connection); // Closing Connection
}
}

?>


logout.php
<?php
session_start();
if(session_destroy()) // Destroying All Sessions
{
header("Location: index.php"); // Redirecting To Home Page
}

?>


profile.php
<?php
include('session.php');
?>
<!DOCTYPE html>
<html>
<head>
<title>Your Home Page</title>
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body>
<div id="profile">
<b id="welcome">Welcome : <i><?php echo $login_session; ?></i></b>
<b id="logout"><a href="logout.php">Log Out</a></b>
</div>
</body>

</html>



session.php
<?php
// Establishing Connection with Server by passing server_name, user_id and password as a parameter
$connection = mysql_connect("localhost", "root", "");
// Selecting Database
$db = mysql_select_db("company", $connection);
session_start();// Starting Session
// Storing Session
$user_check=$_SESSION['login_user'];
// SQL Query To Fetch Complete Information Of User
$ses_sql=mysql_query("select username from login where username='$user_check'", $connection);
$row = mysql_fetch_assoc($ses_sql);
$login_session =$row['username'];
if(!isset($login_session)){
mysql_close($connection); // Closing Connection
header('Location: index.php'); // Redirecting To Home Page
}

?>








Diposting oleh di Tidak ada komentar:

Validasi dalam PHP

Langsung saja kodingannya seperti berikut:
database.php
<?php
include('simpan_data.php');
$host = "localhost";
$user = "root";
$password = "";
$name = "p8";
$connect = mysql_connect($host, $username, $password) or die("Koneksi ke database gagal!");
mysql_select_db($name, $connect) or die("Tidak ada database yang dipilih!");

?>


simpan_data.php
<?php
if(isset($_POST['submit'])){
include "database.php";
$username = $_POST['username'];
$password = $_POST['password'];
$email = $_POST['email'];
$tgllhr = $_POST['tgllhr'];
$jk = $_POST['jk'];
$input = mysql_query("INSERT INTO form VALUES(NULL, '$username', '$password', '$email', '$tgllhr', '$jk')") or die(mysql_error());

if($input){
echo '<center><h1>Data berhasil di tambahkan! ';
echo '<a href="validasi.php"><h1>Kembali</h1></a>';
}else{
echo '<h1>Gagal menambahkan data! </h1>';
echo '<a href="validasi.php"><h1>Kembali</a></h1>';
}
}

?>



validasi.php
<html>
<head><title>form postest </title></head>
<body>
<form name="form" action="simpan_data.php" method="POST" onSubmit="return validasi()">
<table border="2" align="center" height="1" width="20" cellpadding="1">
<td>
<b><font color="black" size="6"> Form mahasiswa</font></b>
<p>
<input type="text" id="username" name="username" size="50" placeholder=" username anda ">
<br><br><br>
<input type="password" id="password" name="password" size="50" placeholder=" password anda ">
<br><br><br>
<input type="text" id="email" name="email" size="50" placeholder=" email anda ">
<br><br><br>
<input type="text" id="tgl" name="tgllhr" size="50" placeholder=" tanggal lahir anda">
<br><br>
<h3><p><b> Jenis Kelamin : </h3>
<h4><input type="radio" name="jk" value="Laki Laki" id="pria">Laki Laki</h4>
<h4><input type="radio" name="jk" value="Perempuan" id="wanita">Perempuan</h4>
<input type="submit" value="Submit" id="Submit" name="submit" onClick="validasi()">
</table>
</form>
<script type="text/javascript">
function validasi(){
var numbers=/^[0-9]+$/;
var huruf=/^[a-zA-Z ]+$/;
var email = document.getElementById('email').value;
pola_email=/^[a-zA-Z0-9._-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,4}$/;
var username = document.getElementById('username').value;
var password = document.getElementById('password').value;
var pria=form.jk[0].checked;
var wanita=form.jk[1].checked;
var validtanggal=/^(0[1-9]|[12][0-9]|3[01])\-(0[1-9]|1[012])\-[0-9]{4}/;
var tgl=document.getElementById('tgl').value;

if (username==null || username==""){
        alert("Username harus di isi !!!");
       }else if (username.length <6 || username.length>19){
        alert ("Username Harus Antara 6 sampai 19 karakter !!!");
       }
       if (password==null || password==""){
        alert("Password harus di isi");
        return false;
       }else if (password.length<6 || password.length>19){
        alert ("Password Harus Antara 6 sampai 19 karakter !!!");
       }else if (password==username){
        alert ("Password dan Username harus beda !!!");
       }
       if (email==null || email==""){
        alert("Email harus di isi !!!");
       }else if (email.length<5){
        alert ("Panjang Email Harus Lebih Dari 4 Karakter !!! ")
       }else if (!pola_email.test(email)){
        alert ("Format Email yang Anda Masukkan Salah !!!");
        return false;
       }
       if (!tgl.match(validtanggal)) {
        alert ("Format Tanggal Harus dd-mm-yyyy ");
        ("document.getElementById").focus(tgl);
        return false;
       }
       if (pria==false && wanita==false){
        alert ("Pilih Jenis Kelamin anda !!!");
       }
   }
</script>
</body>
</html>

Nama databasenya "p8"
tabelnya "form"

Semoga bermanfaat.
Diposting oleh di Tidak ada komentar:
Langganan: Postingan (Atom)