Pertama-tama sinkronkan form isian yang dibuat dengan struktur database yang kita buat...
Ok.....
Here we Go..............
<!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>Form masukan data</title>
</head>
<body>
<form name="form1" method="post" action="MhsSim.php">
<p> </p>
<table width="450" border="0" align="center" cellpadding="0" cellspacing="0">
<tr bgcolor="#ccff00">
<td colspan="2" bordercolor="#F4F4F4" bgcolor="#99ff66">
<h1 align="center"><b>Input Data Mahasiswa</b></h1></td>
</tr>
<p> </p>
<tr>
<td width="108"><b>NIM</b></td>
<td width="292"> :
<input name="TxtNim" type="text" size="15" maxlength="15">
</td>
</tr>
<tr>
<td><b>Nama</b></td>
<td>:
<input name="TxtNama" type="text" size="30" maxlength="50">
</td>
</tr>
<p></p>
<tr>
<td><b>
Jenis Kelamin </b></td>
<td> :
<input name="RbKelamin" type="radio" value="P" checked="checked">
Pria
<input name="RbKelamin" type="radio" value="W">
Wanita
</td>
</tr>
<tr>
<td><b>Tanggal lahir </b></td>
<td> :
<select name="CmbTgl">
<?php
for ($tgl=1; $tgl<=31; $tgl++) {
$tgl=(strlen($tgl)==1)?"0".$tgl:$tgl;
echo "<option value='$tgl'> $tgl </option>";
}
?>
</select> /
<select name="CmbBln">
<?php
for ($bln=1; $bln<=12; $bln++) {
$bln = (strlen($bln)==1)?"0".$bln:$bln;
echo "<option value='$bln'> $bln </option>";
}
?>
</select> /
<select name="CmbThn">
<?php
for ($thn=1960; $thn<=1999; $thn++) {
echo "<option value='$thn'> $thn </option>";
}
?>
</select>
</td>
</tr>
<tr>
<td><b>Tempat Lahir</b></td>
<td> :
<input name="TxtTmpLhr" type="text" size="30"
maxlength="40"></td>
</tr>
<tr>
<td><b>Asal Sekolah</b></td>
<td> :
<input name="TxtAslSklh" type="text" size="30"
maxlength="20"></td>
</tr>
<tr>
<td><b>Jurusan</b></td>
<td> :
<input name="TxtJurSklh" type="text" size="30"
maxlength="10"></td>
</tr>
<tr>
<td><b>Alamat</b></td>
<td> :
<input name="TxtAlmt" type="text" size="50"
maxlength="25"></td>
</tr>
<tr>
<td></td>
<td><input type="submit" name="Submit" value="Simpan"></td>
</tr>
</table>
</form>
</body>
</html>
Jangan lupa simpan dengan nama "input_data.php"
Selanjutnya yaitu membuat halaman untuk menyimpan database ke SQL Server kita.....
Here We Go............
<?php
$TxtNim =$_POST['TxtNim'];
$TxtNama =$_POST['TxtNama'];
$RbKelamin =$_POST['RbKelamin'];
$TglLahir =$_POST['CmbBln']."/".$_POST['CmbTgl']."/".$_POST['CmbThn'];
$TxtTmpLhr =$_POST['TxtTmpLhr'];
$TxtAslSklh =$_POST['TxtAslSklh'];
$TxtJurSklh =$_POST['TxtJurSklh'];
$TxtAlmt =$_POST['TxtAlmt'];
if (trim($TxtNim)=="") {
echo "Nomor Induk Mahasiswa (NIM) masih kosong";
}
else if(trim($TxtNama)=="") {
echo "Data Nama Mahasiswa masih kosong";
}
else if(trim($TxtTmpLhr)=="") {
echo "Tempat Lahir kosong";
}
else if(trim($TxtAslSklh)=="") {
echo "Asal Sekolah masih kosong";
}
else if(trim($TxtJurSklh)=="") {
echo "Jurusan bidang keahlian di SMA masih kosong";
}
else if(trim($TxtAlmt)=="") {
echo "Alamat masih kosong";
}
else {
// Connecting
include "mssql-ok.php";
$sql_mhs = "INSERT INTO mhs (nim,nama,kelamin,tanggal_lahir,tempat_lahir,asal_sma,jurusan,alamat)
VALUES('$TxtNim','$TxtNama','$RbKelamin','$TglLahir','$TxtTmpLhr','$TxtAslSklh','$TxtJurSklh','$TxtAlmt')";
$qry_mhs = mysql_query($sql_mhs);
if (! $qry_mhs) {
echo "Data tidak masuk kedalam tabel Data Mahasiswa";
mysql_close($conn);
exit();
}
mysql_close($conn);
include "MhsTampil.php";
}
?>
Ok dech....
Form Input database sudah selesai....
Selamat mencoba.............
Next >>
Post
0 komentar:
Poskan Komentar