Senin, 08 April 2019

Proyek PAW SI-1 Pertemuan 6

Anggota Yg Hadir :
1. Afriza Dwi Nurrochim

#6 Membuat form input data master

 Tampilan sebelum diinput Master data kue :

    Pindah ke halaman input_kue.php

   


   Hasil input data :



    Kode program file input_kue.php :
    <!DOCTYPE html>
   <html>
   <head>
    <title>BORNEO BAKERY's</title>
    <meta name="viewport" content="width=device-width, minimum-scale=1.0, initial-scale=1.0, user-scalable=yes">
    <link rel="stylesheet" type="text/css" href="css/style.css">
   </head>

<body>
<div id="wrapper">
  <div id="header">
    <div id="header_top">
      <div id="logo">
        <h1>Input Data Kue</h1>
      </div>
    </div>
    <div id="header_center">
      <div id="menu_wrapper">
        <ul id="menu">
          <li><a href="#">Home</a></li>
          <li><a href="#">Profil</a></li>
          <li><a href="#">Contact</a></li>
          <li><a href="#">About</a></li>
        </ul>
      </div>
    </div>
    <div id="header_bottom"></div>
  </div>
  <div id="content">
      <form action="input_aksi.php" method="POST" enctype="multipart/form-data">
          <table>
              <tr>
                  <td>Nama Kue :</td>
                  <td><input type="text" name="nm_kue"></td>
              </tr>
              <tr>
                  <td>Harga Satuan :</td>
                  <td><input type="number" name="hrg_satuan"></td>
              </tr>
              <tr>
                  <td>Stok :</td>
                  <td><input type="number" name="stok"></td>
              </tr>
              <tr>
                  <td>Gambar :</td>
                  <td><input type="file" name="gambar"></td>
              </tr>
              <tr>
                  <td>Keterangan :</td>
                  <td><textarea type="text" name="keterangan" cols="40" rows="4" placeholder="Resep Kue..."></textarea></td>
              </tr>
              <tr>
                  <td></td>
                  <td><input type="submit" name="submit" value="SIMPAN"></td>
              </tr>
          </table>
      </form>
  </div>
  <div id="footer">
    <h2>Check Our Social Media</h2>
    <a href="https://facebook.com" target="_blank"><img src="gambar/fb.png" width="12px"> Facebook</img></a>
    <a href="https://instagram.com" target="_blank"><img src="gambar/ig.jpg" width="13px" > Instagram</img></a>
  </div>
</div>
</body>
</html>

-------------------------------------------------------------------------------------------------------------------------------


    Kode program file input_aksi.php

<?php
  include 'koneksi.php';

  $nm_kue     = $_POST['nm_kue'];
  $hrg_satuan = $_POST['hrg_satuan'];
  $stok       = $_POST['stok'];
  $gambar     = setGambar();
  $keterangan = $_POST['keterangan'];
 
  mysqli_query($koneksi,"INSERT INTO kue VALUES(null,'$nm_kue','$hrg_satuan','$stok','$gambar','$keterangan')");

  header("location:index.php");


  function setGambar(){
      $namaFile = $_FILES['gambar']['name'];
      $error      = $_FILES['gambar']['error'];
      $tmpFile  = $_FILES['gambar']['tmp_name'];

      $exeGambarValid = ['jpg','jpeg','png'];
      $exeGambar      = explode('.', $namaFile);
      $exeGambar      = strtolower(end($exeGambarValid));
          if(!in_array($exeGambar, $exeGambarValid)){
              echo "<script>
                  alerts('Bukan gambar itu...');
                  </script>";
                  return false;
          }
          $gambarBaru = uniqid();
          $gambarBaru .='.';
          $gambarBaru .=$exeGambar;
          move_uploaded_file($tmpFile, 'gambar/'.$gambarBaru);
          return $gambarBaru;
  }
 
?>




Selasa, 02 April 2019

Proyek PAW SI-1 Pertemuan 5

Anggota Yg Hadir :
1. Afriza Dwi Nurrochim

Progress : #5 Melanjutkan membuat form master input kue

<?php
  if(isset($_POST['submit'])) {
    $target   = "gambar/".basename($_FILES['image']['name']);

    $db       = mysql_connect("localhost","root","","bb");

    $gambar   = $_FILES['image']['name'];
    $nm_kue   = $_POST['nm_kue'];
    $hrg_satuan = $_POST['hrg_satuan'];
    $stok     = $_POST['stok'];
    $Keterangan = $_POST['keterangan'];

    $sql      = "INSERT INTO kue(null,$nm_kue,$hrg_satuan,$stok,$gambar,$keterangan,)";

    if(move_uploaded_file($_FILES['tmp_name']['name'], $target)){
      echo "Berhasil Tambah Data";
    }

  }

?>

<!DOCTYPE html>
<html>
<head>
    <title>BORNEO BAKERY's</title>
    <meta name="viewport" content="width=device-width, minimum-scale=1.0, initial-scale=1.0, user-scalable=yes">
    <link rel="stylesheet" type="text/css" href="css/style.css">
</head>

<body>
<div id="wrapper">
  <div id="header">
    <div id="header_top">
      <div id="logo">
        <h1>Input Data Kue</h1>
      </div>
    </div>
    <div id="header_center">
      <div id="menu_wrapper">
        <ul id="menu">
          <li><a href="#">Home</a></li>
          <li><a href="#">Profil</a></li>
          <li><a href="#">Contact</a></li>
          <li><a href="#">About</a></li>
        </ul>
      </div>
    </div>
    <div id="header_bottom"></div>
  </div>
  <div id="content">
      <form action="index.php" method="POST" enctype="multipart/form-data">
        <input type="hidden" name="size" value="1000000">
          <table>
              <tr>
                  <td>Nama Kue :</td>
                  <td><input type="text" name="nm_kue"></td>
              </tr>
              <tr>
                  <td>Harga Satuan :</td>
                  <td><input type="number" name="hrg_satuan"></td>
              </tr>
              <tr>
                  <td>Stok :</td>
                  <td><input type="number" name="stok"></td>
              </tr>
              <tr>
                  <td>Gambar :</td>
                  <td><input type="file" name="gambar"></td>
              </tr>
              <tr>
                  <td>Keterangan :</td>
                  <td><textarea name="text" cols="40" rows="4" placeholder="Resep Kue..."></textarea></td>
              </tr>
              <tr>
                  <td></td>
                  <td><input type="submit" name="submit" value="SIMPAN"></td>
              </tr>
          </table>
      </form>
  </div>
  <div id="footer">
    <h2>Check Our Social Media</h2>
    <a href="https://facebook.com" target="_blank"><img src="gambar/fb.png" width="12px"> Facebook</img></a>
    <a href="https://instagram.com" target="_blank"><img src="gambar/ig.jpg" width="13px" > Instagram</img></a>
  </div>
</div>
</body>
</html>



Hasil :