Rosihan Ari`s Blog

<?php
mysql_connect("namahost","dbuser","dbpass");
mysql_select_db("dbname");
 
$op = $_GET['op'];
 
if ($op == "edit")
{
 
   // proses untuk menampilkan data yang akan diedit pada form
 
   $nim = $_GET['nim'];
 
   $query = "SELECT * FROM mhs WHERE nim = '$nim'";
   $hasil = mysql_query($query);
   $data  = mysql_fetch_array($hasil);
 
   echo "<form method=\"post\" action=\"".$_SERVER['PHP_SELF'].
        "?op=update\">";
   echo "<table border=\"1\">";
   echo "<tr>
           <td>NIM</td>
           <td><input type=\"text\" name=\"nim\"
               value=\"".$data['nim']."\"></td>
         </tr>";
 
   echo "<tr>
         <td>Nama Mahasiswa</td>
         <td><input type=\"text\" name=\"namaMhs\"
              value=\"".$data['namaMhs']."\"></td></tr>";
   echo "</table>";
   echo "<input type=\"hidden\" name=\"nimLama\"
         value=\"".$data['nim']."\">";
   echo "<input type=\"submit\" name=\"submit\"
         value=\"Simpan Perubahan\">";
   echo "</form>";
}
else if ($op == "update")
     {
 
       // proses untuk updating data setelah diedit
 
        $nim = $_POST['nim'];
        $namaMhs = $_POST['namaMhs'];
        $nimLama = $_POST['nimLama'];
 
        $query = "UPDATE mhs SET nim = '$nim', namaMhs = '$namaMhs'
                  WHERE nim = '$nimLama'"; 
        $hasil = mysql_query($query);
 
        if ($hasil) echo "<p>Proses Update Sukses</p>";
        else echo "<p>Proses Update Gagal</p>";
     }
 
?><table border="1">
<tr>
    <th>No</th>
    <th>NIM</th>
    <th>Nama Mahasiswa</th>
    <th>Action</th>
</tr>
 
<?php
 
// bagian ini digunakan untuk menampilkan semua data
 
$no = 1;$query = "SELECT * FROM mhs";
$hasil = mysql_query($query);
 
while ($data = mysql_fetch_array($hasil))
{
   echo "<tr>";
   echo "<td>".$no."</td>";
   echo "<td>".$data['nim']."</td>";
   echo "<td>".$data['namaMhs']."</td>";
   echo "<td><a href=\"".$_SERVER['PHP_SELF'].
        "?op=edit&nim=".$data['nim']."\">Edit</a></td>";
   echo "</tr>";
   $no++;
}
 
?>