Advertisement
GWibisono

isset

Mar 29th, 2014
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.40 KB | None | 0 0
  1. <?php
  2. $myHost = "localhost";
  3. $myUser = "root";
  4. $myPass = "";
  5. $myDbs = "siswadb";
  6.  
  7. //Konek ke server MySQL
  8. $koneksiDbs = mysql_connect($myHost, $myUser, $myPass)
  9.               or die("Gagal koneksi...!").mysql_error();
  10.  
  11. //Buka database siswadb
  12. mysql_select_db($myDbs)
  13. or die("Database $myDbs tidak ada").mysql_error();
  14.  
  15. if($_GET){
  16.     //Baca variable URL (browser)
  17.     $IdJurusan = $_GET['id'];
  18.    
  19.     //Baca data didalam tabel jurusan sesuai ID yang didapat
  20.     $sql = "SELECT * FROM jurusan
  21.            WHERE id_jurusan = '$IdJurusan'";
  22.     $query = mysql_query($sql, $koneksiDbs)
  23.              or die("Query salah : ").mysql_error();
  24.     $data = mysql_fetch_array($query);}
  25. ?>
  26. <html>
  27. <head>
  28. <title>Ubah Jurusan</title>
  29. </head>
  30. <body>
  31. <form name="form1" method="post" action="jurusanUbahSave.php">
  32.     <table width="600" border="0" cellpadding="1" cellspacing="2">
  33.         <tr>
  34.             <td colspan="2" bgcolor="FFFFCC"><b>TAMBAH JURUSAN</b></td>
  35.         </tr>
  36.         <tr>
  37.             <td width="107"><b>Nama Jurusan</b></td>
  38.             <td width="483">:
  39.             <input name="txtNmJurusan" type="text"
  40.             value="<?php isset($data['nm_jurusan'])?echo $data['nm_jurusan']:echo ''; ?>" size="50" maxlength="60">
  41.             <input name="txtIdJurusan" type="hidden"
  42.             value="<?php echo isset($data['id_jurusan'])?$data['id_jurusan']:''; ?>"></td>
  43.         </tr>
  44.         <tr>
  45.         <td>&nbsp;</td>
  46.         <td><input type="submit" name="Submit" value="Simpan"></td>
  47.         </tr>
  48.     </table>
  49. </form>
  50. </body>
  51. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement