Labels

Powered by Blogger.

Social Icons

Social Icons

Featured Posts


Text Widget

Sunday, June 29, 2014

database simpan di php



// SIMPAN PEGAWAI

<!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=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>
<?php
$koneksi=mysql_connect("localhost","root","")or die("koneksi ke database server gagal ");
$koneksidb=mysql_select_db("db toko",$koneksi)or die("koneksi ke DBtoko gagal");
$kdPegawai=$_GET["txtkodepegawai"];
$Nama=$_GET["txtnama"];
$Alamat=$_GET["txtalamat"];
$TempatLahir=$_GET["TempatLahir"];
$TanggalLahir=$_GET["slttahun"]."/".$_GET["sltbulan"]."/".$_GET["slttanggal"];
$Agama=$_GET["stlagama"];
$JenisKelamin=$_GET["rdjeniskelamin"];
$Telepon=$_GET["txttelepon"];
$sql="insert into pegawai values('$kdPegawai','$Nama','$Alamat','$TempatLahir','$TanggalLahir','$Agama','$JenisKelamin','$Telepon')";
$query=mysql_query($sql,$koneksi) or die ("Perintah Gagal Dieksekusi");
echo"Data Anda Sudah Disimpan....<br>";
echo"Jika Anda ingin Menambah Data maka ";
echo"<a href=pegawai.php>Klik Disini</a>";
?>
</body>
</html>
By at 0 comments

tampil database




//TAMPIL PEGAWAIII

<!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=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>
<?php
$host="localhost";
$user="root";
$pass="";

//koneksi kedatabase server
$konekds=mysql_select_db($db,$user,$pass) or die ("koneksi ke database server gagal");
$db="dbtoko";

//koneksi ke database dbtoko
$konekdb=mysql_select_db($db,$konekds) or die ("koneksi ke database server gagal");

//buat perintah sql untuk menampilkan data pegawai
$sql="select * from tblpegawai";

//eksekusi perintah sql
$hasil=mysql_query($db,$konekds) or die ("koneksi ke database server gagal");

//uji apakah da record di tabel pegawai
if (mysql_num_rows($hasil)<1)
{
die("tabel pegawai masih kosong");
}

//tampilkan rekord pegwai dalam format table
echo "<table align = center>";
echo "<tr><td>kode</td><td>nama</td><td>alamat</td><td>tempat lahir</td>";
echo "<td>tanggal lahir</td><td>agama</td><td>jenis kelamin</td><td>telepon</td>";
echo "<td></td></tr>";

while ($baris=mysql_fetch_row($hasi))
{
echo "<tr><td>$baris[0]</td><td>$baris[0]</td><td>$baris[0]</td><td>$baris[0]</td>";
echo "<td>$baris[0]</td><td>$baris[0]</td><td>$baris[0]</td><td>$baris[0]</td>";
echo "<a href=editpegawai.php"?kodepegawai=$baris[0]>edit</a>&nbsp;
echo "<a href=hapuspegawai.php"?kodepegawai=$baris[0]>hapus</a></tr>;
}
echo "</table>";
?>
</body>
</html>
By at 0 comments

databasae hapus di php




//HAPUS PEGAWAI


!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=iso-8859-1" />
<title>Untitled Document</title>
</head>
<?php
$host="localhost";
$user="root";
$pass="";
//koneksi kedatabse sever
$konekds=mysql_connect($host,$user,$pass)or die("koneksi ke database server gagal ");
$koneksidb=mysql_select_db($db,$konekds)or die("koneksi ke DBtoko gagal");
//ambil nilai variabel form dari editpegawai.php
$kdPegawai=$_GET["kodepegawai"];

// buat perintah sql untuk menghapus data pegawai berdasarkan kodepegawai
$sql="delete from tblpegawai where kodepegawai='$kodepegawai'";

//eksekusi perintah sql
$hasil=mysql_query($sql,$konekds) or die ("perintah sql gagal dieksekusi");

//tampilkan dialog informasi dari javascript dan kembali ke halaman tampilpegawai.php
?>
<script>
window.alert("rekord pegawai sudah di hapus");
window.document('tampilpegawai.php');
</script>
?>
<body>
</body>
</html>




By at 0 comments

database edit di php



//EDIT PEGAWAI SIMPAN


<!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=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>
<?php
$host="localhost";
$user="root";
$pass="";
//koneksi kedatabse sever
$konekds=mysql_connect($host,$user,$pass)or die("koneksi ke database server gagal ");
$koneksidb=mysql_select_db($db,$konekds)or die("koneksi ke DBtoko gagal");
//ambil nilai variabel form dari editpegawai.php
$kdPegawai=$_GET["txtkodepegawai"];
$Nama=$_GET["txtnama"];
$Alamat=$_GET["txtalamat"];
$TempatLahir=$_GET["TempatLahir"];
$TanggalLahir=$_GET["slttahun"]."/".$_GET["sltbulan"]."/".$_GET["slttanggal"];
$Agama=$_GET["stlagama"];
$JenisKelamin=$_GET["rdjeniskelamin"];
$Telepon=$_GET["txttelepon"];
//buat perintah untuk mengupdate record pegawai
$sql="insert into pegawai values('$kdPegawai','$Nama','$Alamat','$TempatLahir','$TanggalLahir','$Agama','$JenisKelamin','$Telepon')";
$query=mysql_query($sql,$koneksi) or die ("Perintah Gagal Dieksekusi");
echo"Data Anda Sudah Disimpan....<br>";
echo"Jika Anda ingin Menambah Data maka ";
echo"<a href=pegawai.php>Klik Disini</a>";
?>
</body>
By at 0 comments
Subscribe to: Comments (Atom)