<body>
<form action="simpan.php" method="post">
<table width="45%" border="1">
<tr>
<td colspan="3"><div align="center">Biodata</div></td>
</tr>
<tr>
<td width="33%">nim</td>
<td width="5%">:</td>
<td width="62%"><input name="tnim" type="text" id="tnim" size="12" maxlength="8">
</td>
</tr>
<tr>
<td>Nama</td>
<td>:</td>
<td><input name="tnama" type="text" id="tnama" size="35" maxlength="35">
</td>
</tr>
<tr>
<td>Jurusan</td>
<td>:</td>
<td><select name="jurusan" size="1" id="jurusan">
<option value="KA" selected>KA</option>
<option value="MI">MI</option>
</select>
</td>
</tr>
<tr>
<td colspan="3"><input type="submit" name="Submit" value="SIMPAN">
<input type="reset" name="Submit2" value="BATAL"></td>
</tr>
</table>
</form>
</body>
Langkah 2 beri nama filenya dengan nama koneksi.php
<?
$koneksi=mysql_connect("localhost","root","password")or die("gagal koneksi".mysql_error());
mysql_select_db("kelas_c",$koneksi)or die("gagal koneksi".mysql_error());
echo"terhubung ke php myaldmin";
?>
Langkah 3 beri nama filenya dengan nama simpan.php
<body><?
include"koneksi.php";
$nim=$_POST['tnim'];
$nama=$_POST['tnama'];
$jurusan=$_POST['jurusan'];
$sql=mysql_query("insert into biodata values('$nim','$nama','$jurusan')",$koneksi)or die("gagal disimpan".mysql_error());
if($sql)
{
echo"Data tersimpan";
}
else
{
echo"Data tidak tersimpan";
exit;
}
?>
<br>
<a href="tampil.php">lihat data</a>
</body>
Langkah 4 beri nama filenya dengan nama uotput.php
<body>
<table width="100%" border="1">
<tr>
<td colspan="3"><div align="center">Biodata</div></td>
</tr>
<tr>
<td width="36%">Nim</td>
<td width="29%">Nama</td>
<td width="35%">Jurusan</td>
</tr>
<?
include "koneksi.php";
if (koneksi){mysql_select_db("kelas_c",$koneksi)or die("gagal koneksi".mysql_error());
$sql=mysql_query("SELECT*FROM biodata",$koneksi)or die("query gagal".mysql_error());
while($data=mysql_fetch_array($sql)){
?>
<tr>
<td><? echo $data['nim'];?></td>
<td><? echo $data['nama'];?></td>
<td><? echo $data['jurusan'];?></td>
</tr>
<? }}?>
</table>
<br>
<a href="input.php">kembali input</a>
</body>
Tidak ada komentar:
Posting Komentar