//EDIT 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_connect($host,$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");
//ambil nilai
variabel kode pegawai
$kodepegawai=$_GET["kodepegawai"];
//buat
perintah sql untuk mencari kode pegawai dari tblpegawai
$sql="select
* form tblpegawai where kdpegawai='$kodepegawai'";
//eksekusi
perintah sql
$hasil=mysql_query($db,$konekds)
or die ("perintah sql gagal dieksekusi");
//ambil rekord
dari perintah sql
$baris=mysql_fetch_row($hasil);
//tampilkan
data pegawai dalam format formulir
?>
<form
action="editpegawaisimpan.php" method="get">
<table
align="center">
<tr>
<td
colspan="3" align="center">edit pegawai</td>
</tr>
<tr>
<tr>
<td>kode
pegawai </td>
<td>:</td>
<td><input
type=text size=5 name=txtkodepegawai maxlength=5 value=<?php echo
$baris[0];?> readonly></td>
</tr>
<tr>
<td>nama
</td>
<td>:</td>
<td><input
type="text" size="25" name="txtnama"
maxlength="25" value=<?php echo $baris[1];?>> </td>
</tr>
<tr>
<td>alamat
</td>
<td>:</td>
<td><input
type="text" size="30" name="txtalamat"
maxlength="30" value=<?php echo $baris[2];?>></td>
</tr>
<tr>
<td>tempat
lahir </td>
<td>:</td>
<td><input
type="text" size="5" name="txttempatlahir"
maxlength="25">
<select
name="slttanggal">
<?php
for
($i=1;$i=31;$i++)
{
if($i==strcopy($baris[3],9,2))
echo
"<option value=$i selected>$i</option>";
else
echo
"<option value=$i >$i</option>";
}
?>
</select>
<select
name="sltbulan">
<?php
for
($i=1;$i=12;$i++)
{
if($i==strcopy($baris[4],6,2))
echo
"<option value=$i selected>$i</option>";
else
echo
"<option value=$i >$i</option>";
}
?>
</select>
<select name="slttahun">
<?php
for
($i=1960;$i=1995;$i++)
{
if($i==strcopy($baris[4],1,4))
echo
"<option value=$i selected>$i</option>";
else
echo
"<option value=$i >$i</option>";
}
?>
</select>
</td>
</tr>
<tr>
<td>agama</td>
<td> : </td>
<td><select>
<?php
$agama=array
("agama","kristen","katolik","hindu","buddha","agama","konghucu","lainnya",);
for($i=1;$i<7;$i++)
{
if($i==$baris[5])
echo "<option value=$i
selected>$i</option>";
else
echo
"<option value=$i >$i</option>";
}
?>
</select>
</td>
</tr>
<tr>
<td>jenis
kelamin </td>
<td>:</td>
<td>
<?php
if
($baris[6]="L")
{
echo
"<input type=radio name=rdojeniskelamin value=L selected>";
echo
"<input type=radio name=rdojeniskelamin value=P >";
}
else
{
echo
"<input type=radio name=rdojeniskelamin value=L >";
echo
"<input type=radio name=rdojeniskelamin value=P selected >";
}
?>
</td>
</tr>
<tr>
<td>telepon</td>
<td>:</td>
<td><input type="text"
size="13" name="txttelepon" maxlength="13"
value="<?php echo $baris [7] ?>"></td>
</tr>
<tr>
<td colspan="3"
align="center">
<input type="submit"
value="simpan">
<input type="reset"
value="batal">
</td>
</tr>
</table>
</form>
</body>
</html>
Borgata Hotel Casino and Spa - Mapyro
ReplyDeleteA full service casino 당진 출장안마 hotel, spa, and conference facility, 충주 출장마사지 Borgata Hotel Casino and Spa 상주 출장샵 is 보령 출장마사지 located in the heart of Atlantic City, 공주 출장샵 and it is owned by the