Labels

Powered by Blogger.

Social Icons

Social Icons

Featured Posts


Text Widget

Friday, May 22, 2015

from untuk databases di php




//form pegawai

<html>

  <head>
   <title> input data pegawai </title>
  </head>
<html>
   <body>
      <form action = simpanpegawai.php method=get>
        <table align = center border="1px">
          <tr>
             <td colspan = 3 align=center>input data pegawai </td>
           </tr>
       <tr>
          <td width="145">kode pegawai</td>
            <td width="6">:</td>
               <td width="150"><input type=text size=5 name=txtkodepegawai maxlenght=25></td>
</tr>
<tr>
<td>nama</td>
<td>:</td>
<td><input type=text size=25 name=txtnama maxlenght=25></td>
</tr>
<tr>
<td>alamat</td>
<td>:</td>
<td><input type=text size=25 name=txtalamat maxlenght=25></td>
</tr>
<tr>
<td>tempat lahir</td>
<td>:</td>
<td><input type=text size=10 name=TempatLahir maxlenght=25> </td>
</tr>
<tr>
<td>tanggal lahir</td>
<td>:</td>
<td> <select name=slttanggal>
  <?php
for ($i=1;$i<=31;$i++)
{

echo"<option>$i</option>";

}
  ?> 
  </select>
  <select name=sltbulan>
    <?php
for ($i=1;$i<=12;$i++)
{

echo"<option>$i</option>";

}
?>
  </select>
  <select name=slttahun>
    <?php
for ($i=1960;$i<=1995;$i++)
{

echo"<option value=$i>$i</option>";

}
?>
  </select></td>
</tr>
<tr>
<td>agama</td>
<td>:</td>
<td><select name=stlagama>
<option value="1">islam</option>
<option value="2">kristen</option>
<option value="3">katolik</option>
<option value="4">hindu</option>
<option value="5">budha</option>
<option value="6">konghucu</option>
<option value="7">lainnya</option>

</select>
</td>
</tr>
<tr>
<td>jenis kelamin</td>
<td>:</td>
<td><p>
  <input type=radio name=rdjeniskelamin value=L>
  laki-laki</p>
  <p>
  <input type=radio name=rdjeniskelamin value=P>
    perempuan</p></td>
</tr>
<tr>
<td>telepon</td>
<td>:</td>
<td><input type=text size=13 name=txttelepon maxlenght=13></td>
</tr>
<tr>
<td colspan =3 align=center>
<input type=submit value=simpan>
<input type=reset value=batal>
</td>
</tr>
</table>
</form>
</body>
</html>
By at 2 comments

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
Subscribe to: Comments (Atom)