insert.php

<html>
<?PHP
mysql_connect("localhost","root","");
mysql_select_db("akademik");
$sisip="insert into mahasiswa(NIM,Nama) values('$_POST NIM','$_POST Nama')";
  if ($_POST)
  {
    echo "Variable yang di-input : ".$NIM." | ".$Nama." telah ditambahkan di database";
    mysql_query($sisip);
  }
?>

<form action="insert.php" method="POST">
NIM  : <input type=text name="NIM" value="<?PHP echo $NIM; ?>"><br>
NAMA :<input type=text name="Nama" value="<?PHP echo $Nama; ?>">
<input type=submit name="tombol">
</form>

Menampilkan Database yang ada di Database <b>akademik</b><br>
<?PHP
  $perintahSQL="Select * from mahasiswa";
  $hasil=mysql_query($perintahSQL);
  echo "<table border=2>";
  echo "<TR><TD>NOMOR INDUK MAHASISWA</TD><TD>  NAMA MAHASISWA  </TD></TR>";
  While ($data=mysql_fetch_row($hasil))
  {
   echo "<TR><TD>$data[1]</TD><TD>$data[2]</TD></TR>";
  }
  echo "</table>";
?>

</html>
1/30/2012 08:51:00 PM | Category: | 0 komentar

Comments (0)

Posting Komentar

komentar