Senin, 08 Juni 2015

user

Edit
Posted by with No comments
<?php
$koneksi = mysql_connect("localhost", "root", "") or die("Gagal koneksi ke server.");
mysql_select_db("warnas") or die("Gagal membuka database.");
?>
<html>
<head>
</head>
<body>
<tr>
        <td><div align="center">
          <p><a href="form_user.php">Form User</a>          </p>
          <table width="800" border="1" align="center">
            <tr>
      <td width="104" align="center">Id User</td>
      <td width="168" align="center">Username</td>
      <td width="112" align="center">Level User</td>
      <td width="108" align="center">Password</td>
 <td width="100" align="center">Email</td>
      <td width="95" align="center">Phone</td>
 <td width="100" align="center">Address</td>
      <td width="95" align="center">Status</td>
 <td width="95" align="center">Action</td>
    </tr>
<?php
$query = "select * from tb_user";
$hasil = mysql_query($query, $koneksi) or die("Gagal melakukan query.");
while ($buff = mysql_fetch_array($hasil)) {
?>
    <tr>
      <td><?php echo $buff['id_user']; ?></td>
      <td><?php echo $buff['username']; ?></td>
      <td><?php echo $buff['level_user']; ?></td>
      <td><?php echo $buff['password']; ?></td>
 <td><?php echo $buff['email'];?></td>
 <td><?php echo $buff['phone'];?></td>
 <td><?php echo $buff['address'];?></td>
 <td><?php echo $buff['status'];?></td>
      <td align="center">
    <a href="edit_user.php?id_mobil=<?php echo $buff['id_user']; ?>">Edit</a>
<a href="hapus_user.php?id_mobil=<?php echo $buff['id_user']; ?>">Hapus</a></td>
    </tr>
<?php
};
mysql_close($koneksi);
?>
</body>
</html>

contoh form input user

Edit
Posted by with No comments
<html>
<head>
<title></title>
</head>

<body>
<h1>Form Input User</h1>

<form name="form_user" action="data_user.php" method="post">
<table border="0" cellpadding="5" cellspacing="0">
    <tbody>
        <tr>
            <td>Username</td>
            <td>:</td>
            <td><input type="text" name="username" /></td>
        </tr>
<tr>
            <td>Level_User</td>
            <td>:</td>
            <td><input type="text" name="level_user"  /></td>
        </tr>
        <tr>
            <td>Password</td>
            <td>:</td>
            <td><input type="password" name="password"  /></td>
        </tr>
        <tr>
            <td>Email</td>
            <td>:</td>
            <td><input type="text" name="email"  /></td>
        </tr>
        <tr>
            <td>Phone</td>
            <td>:</td>
            <td><input type="text" name="phone" /></td>
        </tr>
        <tr>
            <td>Address</td>
            <td>:</td>
            <td><input type="text" name="address"  /></td>
        </tr>
    <tr>
            <td>Status</td>
            <td>:</td>
            <td><input type="text" name="status"  /></td>
        </tr>
        <tr>
            <td align="right" colspan="3"><input type="submit" name="submit" value="Simpan" /></td>
        </tr>
    </tbody>
</table>
</form>
</body>
</html>

halaman

Edit
Posted by with No comments
index

 <html>
<head>
<title>Halaman Administrator</title>
</head>

<body>
<table width="1024" border="1" align="center">
  <tr>
    <td height="137"><table width="100%" border="0">
      <tr>
        <td><img src="images/rental1_01.jpg" width="1024" height="268" /></td>
      </tr>
      <tr>
        <td><div align="center">
<h3>SELAMAT DATANG</h3>
<p>&nbsp;</p>
<p>&nbsp;</p>
        </div></td>
      </tr>
    </table></td>
  </tr>
</table>
</body>
</html>

======================================

admin

 <html>
<head>
<title>Halaman Administrator</title>
</head>

<body>
<table width="1024" border="1" align="center">
  <tr>
    <td height="137"><table width="100%" border="0">
      <tr>
        <td><img src="images/rental1_01.jpg" width="1024" height="268" /></td>
      </tr>
      <tr>
        <td><table width="100%" border="1" align="center">
           <tr>
            <td width="16%"><div align="center"><a href="mobil.php"><h4>MOBIL</h4></a></div></td>
            <td width="23%"><div align="center"><a href="pelanggan.php"><h4>PELANGGAN</h4></a></div></td>
            <td width="16%"><div align="center"><a href="penyewaan.php"><h4>PENYEWAAN</h4></a></div></td>
            <td width="18%"><div align="center"><a href="pengembalian.php"><h4>PENGEMBALIAN</h4></a></div></td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td><div align="center">
<h1>SELAMAT DATANG DI HALAMAN ADMIN</h1>
<p>&nbsp;</p>
<form id="form1" name="form1" method="post" action="index.php">
  <input type="submit" name="button" id="button" value="Logout" />
</form>
<p>&nbsp;</p>
        </div></td>
      </tr>
    </table></td>
  </tr>
</table>
</body>

</html>

delete

Edit
Posted by with No comments
<html>
<head>
<title>Hapus</title>
</head>
<?php
$koneksi = mysql_connect("localhost", "root", "") or die("Gagal konek ke server.");
mysql_select_db("rental") or die("Gagal membuka database.");
$id_mobil = $_GET['id_mobil'];
mysql_query("delete from mobil where id_mobil='$id_mobil'") or die("Gagal menghapus data.");
mysql_close($koneksi);
?>
<p>Data telah dihapus. Silakan dicek di <a href="mobil.php">mobil.php</a></p>
</body>
</html>

insert1

Edit
Posted by with No comments
<html>
<head>
<title>Tambah</title>
</head>
<?php
$koneksi = mysql_connect("localhost", "root", "") or die("Gagal koneksi ke server.");
mysql_select_db("rental") or die("Gagal membuka database.");
$id_mobil = $_POST['id_mobil'];
$jenis_mobil = $_POST['jenis_mobil'];
$no_polisi = $_POST['no_polisi'];
$tarif_sewa = $_POST['tarif_sewa'];
$keterangan = $_POST['keterangan'];
$query = mysql_query("insert into mobil values ('$id_mobil', '$jenis_mobil', '$no_polisi' , '$tarif_sewa', '$keterangan')");
mysql_close($koneksi);
?>
<p>Data sudah tersimpan. Silakan dicek di <a href="../rental/mobil.php">mobil.php</a></p>
</body>
</html>

insert

Edit
Posted by with No comments
<html>
<head>
<title>Untitled Document</title>

</head>

<body>
<table width="1024" border="1" align="center">
  <tr>
    <td height="137"><table width="100%" border="0">
      <tr>
        <td><img src="images/rental1_01.jpg" width="1024" height="268" /></td>
      </tr>
      <tr>
        <td><table width="100%" border="1" align="center">
          <tr>
            <td width="16%"><div align="center"><a href="mobil.php"><h4>MOBIL</h4></a></div></td>
            <td width="23%"><div align="center"><a href="pelanggan.php"><h4>PELANGGAN</h4></a></div></td>
            <td width="16%"><div align="center"><a href="penyewaan.php"><h4>PENYEWAAN</h4></a></div></td>
            <td width="18%"><div align="center"><a href="pengembalian.php"><h4>PENGEMBALIAN</h4></a></div></td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td><div align="center">
          <form name="form1" method="post" action="tambah_mobil1.php">
<p><b>Tambah Mobil</b></p>
<table border="0" align="center">
<tr>
<td>Id Mobil</td>
<td>:</td>
<td><input name="id_mobil" type="text" /></td>
</tr>
<tr>
<td>Jenis Mobil</td>
<td>:</td>
<td><input name="jenis_mobil" type="text" /></td>
</tr>
<tr>
<td>No Polisi</td>
<td>:</td>
<td><input name="no_polisi" type="text" /></td>
</tr>
<tr>
<td>Tarif Sewa</td>
<td>:</td>
<td><input name="tarif_sewa" type="text" /></td>
</tr>
<tr>
<td>Keterangan</td>
<td>:</td>
<td><select class="keterangan" name="keterangan" id="keterangan"><option value=''>pilih</option>
                    <option value="Ada">Ada</option>
                    <option value="Tidak ada">Tidak ada</option></select></td>
</tr>
<tr>
<td colspan="3"><input type="submit" name="submit" value="Simpan" /></td>
</tr>
</table>
</form>
          <p>Batal menambah data. Kembali ke <a href="mobil.php">data mobil</a></p>
        </div></td>
      </tr>
    </table></td>
  </tr>
</table>
</body>
</html>

edit1

Edit
Posted by with No comments
<html>
<head>
<title>Edit</title>
</head>
<?php
$koneksi = mysql_connect("localhost", "root", "") or die("Gagal koneksi ke server.");
mysql_select_db("rental") or die("Gagal membuka database.");
$id_mobil = $_POST['id_mobil'];
$jenis_mobil = $_POST['jenis_mobil'];
$no_polisi = $_POST['no_polisi'];
$tarif_sewa = $_POST['tarif_sewa'];
$keterangan = $_POST['keterangan'];
$query = mysql_query("update mobil set  jenis_mobil='$jenis_mobil', no_polisi='$no_polisi', tarif_sewa='$tarif_sewa', keterangan='$keterangan' where id_mobil='$id_mobil'");
mysql_close($koneksi);
?>
<p>Data sudah ter-update. Silakan dicek di <a href="../rental/mobil.php">mobil.php</a></p>
</body>
</html>

edit

Edit
Posted by with No comments
<html>
<head>
<title>Untitled Document</title>
</head>

 <body>
<table width="1024" border="1" align="center">
  <tr>
    <td height="137"><table width="100%" border="0">
      <tr>
        <td><img src="images/rental1_01.jpg" width="1024" height="268" /></td>
      </tr>
      <tr>
        <td><table width="100%" border="1" align="center">
         <tr>
            <td width="16%"><div align="center"><a href="mobil.php"><h4>MOBIL</h4></a></div></td>
            <td width="23%"><div align="center"><a href="pelanggan.php"><h4>PELANGGAN</h4></a></div></td>
            <td width="16%"><div align="center"><a href="penyewaan.php"><h4>PENYEWAAN</h4></a></div></td>
            <td width="18%"><div align="center"><a href="pengembalian.php"><h4>PENGEMBALIAN</h4></a></div></td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td><div align="center">
          <?php
$koneksi = mysql_connect("localhost", "root", "") or die("Gagal koneksi ke server.");
mysql_select_db("rental") or die("Gagal membuka database.");
$id_mobil = $_GET['id_mobil'];
$query = "select * from mobil where id_mobil='$id_mobil'";
$hasil = mysql_query($query, $koneksi) or die("Gagal melakukan query.");
$buff = mysql_fetch_array($hasil);
mysql_close($koneksi);
?>
<form name="form1" method="post" action="edit_mobil1.php">
<input type="hidden" name="id_mobil" value="<?php echo $buff['id_mobil']; ?>" />
<table border="0">
<p><b>Edit Mobil</b></p>
<tr>
<td>Id Mobil</td>
<td>:</td>
<td><?php echo $buff['id_mobil']; ?></td>
</tr>
<tr>
<td>Jenis Mobil</td>
<td>:</td>
<td><input name="jenis_mobil" type="text" value="<?php echo $buff['jenis_mobil']; ?>" /></td>
</tr>
<tr>
<td>No Polisi</td>
<td>:</td>
<td><input name="no_polisi" type="text" value="<?php echo $buff['no_polisi']; ?>" /></td>
</tr>
<tr>
<td>Tarif Sewa</td>
<td>:</td>
<td><input name="tarif_sewa" type="text" value="<?php echo $buff['tarif_sewa']; ?>" /></td>
</tr>
<tr>
<td>Keterangan</td>
<td>:</td>
<td><select class="form-control" name='keterangan' id='keterangan'>
                                <option value='value='<?php echo $buff['keterangan']; ?>><?php echo $buff['keterangan']; ?></option>
                                <option value='Ada'>Ada</option>
                                <option value='Tidak ada'>Tidak ada</option></td>
<tr>
<td colspan="3"><input type="submit" name="submit" value="Simpan" /></td>
</tr>
</table>
</form>
<p>Batal mengedit data. Kembali ke <a href="mobil.php">mobil.php</a></p>
    </td> </div></td>
      </tr>
    </table></td>
  </tr>
</table>
</body>
</html>

Read

Edit
Posted by with No comments
<?php
$koneksi = mysql_connect("localhost", "root", "") or die("Gagal koneksi ke server.");
mysql_select_db("rental") or die("Gagal membuka database.");
?>
<html>
<head>
</head>

<body>
<table width="1024" border="1" align="center">
  <tr>
    <td><table width="100%" border="0">
      <tr>
        <td align="center"><h3>Selamat Datang</h3></td>
      </tr>
        </table></td>
      </tr>
      <tr>
     
        <td><div align="center">
 
          <p><a href="tambah_mobil.php"><strong>Tambah Data</strong></a>          </p>
          <table width="800" border="1" align="center">
            <tr>
   <td width="104" align="center"><h4>No.</h4></td>
      <td width="104" align="center"><h4>Id Mobil</h4></td>
      <td width="168" align="center"><h4>Jenis Mobil</h4></td>
      <td width="112" align="center"><h4>No Polisi</h4></td>
      <td width="108" align="center"><h4>Tarif Sewa</h4></td>
   <td width="100" align="center"><h4>Keterangan</h4></td>
      <td width="95" align="center"><h4>Action</h4></td>
    </tr>
   
    <?php
$query = "select * from mobil";
$hasil = mysql_query($query, $koneksi) or die("Gagal melakukan query.");
$no=1;
while ($buff = mysql_fetch_array($hasil)) {
?>
    <tr align=center>
 <td height="26"><?php echo $no; ?></td>
      <td height="26"><?php echo $buff['id_mobil']; ?></td>
      <td><?php echo $buff['jenis_mobil']; ?></td>
      <td><?php echo $buff['no_polisi']; ?></td>
      <td><?php echo $buff['tarif_sewa']; ?></td>
   <td><?php echo $buff['keterangan'];?></td>
      <td align="center">
    <a href="edit_mobil.php?id_mobil=<?php echo $buff['id_mobil']; ?>">Edit</a>
 <a href="hapus_mobil.php?id_mobil=<?php echo $buff['id_mobil']; ?>">Hapus</a></td>
    </tr>

<?php
$no++;
};
mysql_close($koneksi);
?>

          <p>&nbsp;</p>
        </div></td>
      </tr>

    </table></td>

  </tr>

</table>

</table>
 <form id="form1" name="form1" method="post" action="admin.php">
  <input type="submit" name="button" id="button" value="Back" />
</form>

</body>


</html>

Validasi Login

Edit
Posted by with No comments
<?php
session_start();
include "koneksi.php";
$username = $_POST['username'];
$password = $_POST['password'];
$mysql = mysql_query("SELECT * FROM login WHERE username='$username' AND password='$password'");
$xxx=mysql_num_rows($mysql);
if($xxx==TRUE){
$_SESSION['username'] = $username;
echo "<script>window.alert('Login Berhasil');
window.location=('admin.php')
</script>";
}else{
echo "<script>window.alert('Username atau Password Salah');
</script>";
}
?>


Login

Edit
Posted by with No comments
<html>
<head>
<title>Halaman Login</title>
</head>

<body>
<table width="800" align="center">
  <tr>
    <td><table width="800">
 <center>
 <br>
 <h2>Manajemen Data</h2>
      <tr>
        <td><div align="center"><h3>Silakan Login</h3></div></td>
      </tr>
      <tr>
        <td>
        <form id="form2" name="form2" method="post" action="admin.php">
            <table width="312" border="0" align="center" cellpadding="0" cellspacing="0">
              <tr>
                <td width="96"><strong>Username</strong></td>
                <td width="17"><div align="center">:</div></td>
                <td width="199"><label for="textfield"></label>
                  <input type="text" name="username" id="username" /></td>
              </tr>
              <tr>
                <td><strong>Password</strong></td>
                <td><div align="center">:</div></td>
                <td><label for="textfield2"></label>
                  <input type="password" name="password" id="password" /></td>
              </tr>
              <tr>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
                <td><input type="submit" name="button2" id="button2" value="Login" /></td>
              </tr>
            </table>
          </form>
        </td>
      </tr>
      <tr>
        <td>&nbsp;</td>
      </tr>
    </table></td>
  </tr>
  </center>
</table>
</body>

</html>
Langganan: Postingan (Atom)