06.18
ASEP SOLEHUDIN
Input:
<?php
$host="localhost";
$user="root";
$pass="";
$db="tugas";
$sambung=mysql_connect($host,$user,$pass);
mysql_select_db($db,$sambung);
?>
<html
xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta
http-equiv="Content-Type" content="text/html;
charset=utf-8" />
<title>Untitled
Document</title>
</head>
<style
type: "text/css">
#wrapper
{
width:800px;
height: auto;
margin-left:auto;
margin-right: auto;
padding: 25px;
}
table
{
margin-left: auto;
margin-right: auto;
}
</style>
<body>
<div
id="wrapper">
<center>FORUM
SISWA</center>
<p> </p>
<?php
if($_POST['doSimpan']
== 'Simpan')
{
$nm_lgkp=$_POST['nm_lgkp'];
$nm_pgl=$_POST['nm_pgl'];
$kelas=$_POST['kelas'];
$alamat=$_POST['alamat'];
$agama=$_POST['agama'];
$j_kel=$_POST['j_kel'];
$hobi=$_POST['hobi'];
if(empty($err))
{
$sql_insert
= "INSERT into `tb_tugas`
(nm_lgkp,nm_pgl,kelas,alamat,agama,j_kel,hobi) values
('$nm_lgkp','$nm_pgl','$kelas','$alamat','$agama','$j_kel','$hobi')";
mysql_query($sql_insert)
or die("Insertion Failed:" . mysql_error());
echo
"<div align='center'><strong><font color=red size=5>Data
berhasil disimpan</font></strong></div>";
}
}
?>
<form
method="post" action="tugas_2.php">
<table>
<?php
if(!empty($err)) {
echo "<div
class=\"msg\">";
foreach ($err as $e) {
echo "* $e <br>";
}
echo "</div>";
}
?>
<tr>
<td>
Nama lengkap :</td><td> <input type="text"
name="nm_lgkp" style="width:150px; height:30px; border: #ccc 1px
solid;" />
</td>
</tr>
<tr>
<td>
Nama Panggilan :</td><td> <input type="text"
name="nm_pgl" style="width:150px; height:30px; border: #ccc 1px
solid;" />
</td>
</tr>
<tr>
<td>
Kelas :</td><td> <input type="text"
name="kelas" style="width:150px; height:30px; border: #ccc 1px
solid;" />
</td>
</tr>
<tr>
<td>
Alamat :</td><td> <textarea name="alamat"
id="textarea" cols="45" rows="5"
style="border: #ccc 1px solid;"></textarea>
</td>
</tr>
<tr>
<td>Agama
:</td><td>
<select
name="agama" id="select" style="width:150px;
height:30px; border: #ccc 1px solid;">
<option>Islam</option>
<option>Kristen</option>
<option>Hindu</option>
<option>Budha</option>
</select>
</td>
</tr>
<tr>
<td>
Jenis
kelamin :</td><td>
<input type="radio"
name="j_kel" value="Laki" />Laki-laki
<input type="radio"
name="j_kel" value="Perempuan" />Perempuan
</td>
</tr>
<tr>
<td>
Hobi :</td><td>
<input type="checkbox"
name="hobi" id="checkbox" value="Futsal" />
Futsal
<input type="checkbox"
name="hobi" id="checkbox" value="Game" /> Game
<p></p>
<input type="checkbox"
name="hobi" id="checkbox" value="Berenang" />
Berenang
<input type="checkbox"
name="hobi" id="checkbox" value="browsing" />
Browsing
</td>
</tr>
<tr>
<td>
<input
name="doSimpan" type="submit" id="doSimpan"
value="Simpan" style="width:125px; height:30px;
text-align:center; background:#06F; color:#fff;" />
</td>
<td></td>
</tr>
</table>
</form>
<p> </p>
<table
style="margin-left:0px; margin-top:50px;">
<tr>
<th>Nama
lengkap</th>
<th>Nama
Panggilan</th>
<th>Kelas</th>
<th>Alamat</th>
<th>Agama</th>
<th>Jenis
kelamin</th>
<th>Hobi</th>
<th>aksi</th>
</tr>
<?php
$query
= "select * from tb_tugas order by id desc limit 10";
$hasil
= mysql_query($query, $sambung) or die(mysql_error());
//$no
= 0;
while
($buff = mysql_fetch_array($hasil)){
//$no++;
?>
<tr>
<td><?php
echo $buff['nm_lgkp']; ?></td>
<td><?php
echo $buff['nm_pgl']; ?></td>
<td><?php
echo $buff['kelas']; ?></td>
<td><?php
echo $buff['alamat']; ?></td>
<td><?php
echo $buff['agama']; ?></td>
<td><?php
echo $buff['j_kel']; ?></td>
<td><?php
echo $buff['hobi']; ?></td>
<td><a
href="delete.php?id=<?php echo $buff['id']; ?>"
onclick="return confirm('Apakah anda
yakin?')">Delete</a></td>
</tr>
<?php
};
mysql_close($sambung);
?>
</table>
</form>
</div>
</body>
</html>
Output:
Nama :
Asep Solehudin
NPM :
31111244
Kelas :
2DB09
