rename hasil upload

ask master gimana cara supaya hasil upload gambar gambar namanya bisa berawalan seperti ini image/ misalnya hasil upload namanya pengen seperti ini image/111.jpg/png

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Diperbarui 5 tahun yang lalu

51 Jawaban:

https://stackoverflow.com/questions/18705639/how-to-rename-uploaded-file-before-saving-it-into-a-directory

avatar stefanuspn
@stefanuspn

250 Kontribusi 69 Poin

Dipost 6 tahun yang lalu

tetep gan cuman nomor doank yang masuk saya pengen didepannya ada tulisan image/ intinya biar bisa memanggil image itu lewat url mungkin agan bisa bantu permasalahannya tb_barang [id] [nama_barng] [gambar] 1 sensor http//xxx 2 shaft Image//xxx

[DETAIL BARANG](<?php echo ''.$gambar.'';?>'') intinya tombol detail barang ini supaya bisa memanggil dari internet(external)dan directory folder (internal) makanya saya pengen image/ bisa kesave ke data base biar file nya bis dipanggil.. masalahnya barang ditempat kerja gk semua ada di mbah google makanya harus dibikin dua gtu

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 6 tahun yang lalu

<?php
//upload.php

if(isset($_POST['submit'])) {
    $name     = $_FILES['gambar']['name'];
    $fileName = $_FILES['gambar']['tmp_name'];

    $newName  = "image/" . $name;
    //kalau agan pake begini pasti error krena dia akan mencari dulu folder "image/"
    // ATURAN nama sebuah file tidak boleh ada karakter => / \ * : " < > |

    // untuk menyiasatinya tinggal gambar yg diupload tadi disimpan di folder image
    // jadi misalkan root folder sourcenya namanya htdocs/nama_project/assets/image (disimpan disini)

    //seperti ini => 'image/' . nama_file.(jpg/png)
    $path     = 'image/' . $name;

    move_uploaded_file($fileName, $path);

    $id = 'xxx';
    $nama = 'xxx';
    $gambar = $path; // ambil dari $path isinya nanti => 'image/nama_file.jpg'
    $linkGambar = '';

    // jadi didatabase nya field untuk gambar harus 2..
    // 1. link gambar (internet)
    // 2. Lokal

    $sql = "INSERT INTO tb_barang (nama_barang, gambar, linkGambar) VALUES($nama, $gambar, $linkGambar)";
    mysqli_query($sql;)
}
?>

<!-- untuk pembacaannya bisa menggunakan Ternary -->
<a href="<?php echo empty($linkGambar) ? $gambar : $linkGambar ?>"></a>

<!-- untuk pembacaannya bisa menggunakan IF  -->
<a href="<?php if(empty($linkGambar)) echo $gambar; else echo $linkGambar ?>"></a>

Semoga Membantu (^_^)

avatar ciloxz
@ciloxz

284 Kontribusi 139 Poin

Dipost 6 tahun yang lalu

maaf gan dikit lagi lum memahami pas memanggilnyaa sama tb di database nya, maklum baru belajarr # di kolom databasenya bearti kita bikin 5 kolom -id -nama -gambar -linkGambar untuk lokal (folder root) -linkGambar untuk yg ke internet # dengan sangat mohon penjelasan pembacanyaa kenapa pake dua antara linkGambar sama gambar gan maksud gimana sedangkan yg menghasilkan link url di kolom gambar

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 6 tahun yang lalu

TABEL BARANG kalau untuk kasus seperti ini 4 cukup - ID - NAMA - GAMBAR_LOKAL (LINK GAMBAR LOKAL) - GAMBAR_INTERNET (LINK GAMBAR INTERNET)


<!-- jangan lupa u. link lokal base_url nya disertakan  -->

<?php

    $linkLokal = "image/gambar-product.jpg";
    $base_url = "localhost/project/"; //sesuaikan

    $linkLokal = $base_url . $linkLokal;

?>

<!-- PAKE  Ternary -->
<a href="<?php echo empty($link_Internet) ? $link_Lokal : $link_Internet ?>"></a>

<!-- ATAU menggunakan IF  -->
<a href="<?php if(empty($link_Internet)) echo $link_Lokal; else echo $link_Internet ?>"></a>

<!--
    hasilnya => <a href="localhost/project/image/gambar-product.jpg"></a>
-->

avatar ciloxz
@ciloxz

284 Kontribusi 139 Poin

Dipost 6 tahun yang lalu

gan klo dah kayaa gini

kirakira dimananya yang harus di rubahh

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 6 tahun yang lalu

//kira2 klo dah kyaa gini mana yang harus dirubah dan ditambahin

<?php
include_once 'connection.php';


// Ambil Data yang Dikirim dari Form
$stockno = $_POST['stockno'];
$item_name = $_POST['item_name'];
$beggining = $_POST['beggining'];
$unit = $_POST['unit'];
$act = $_POST['act'];
$orig_price = $_POST['orig_price'];
$model = $_POST['model'];
$serial = $_POST['serial'];
$brand = $_POST['brand'];
$dimension = $_POST['dimension'];
$machine = $_POST['machine'];
$location = $_POST['location'];
$foto = $_FILES['foto']['name'];
$tmp = $_FILES['foto']['tmp_name'];

// Rename nama fotonya dengan menambahkan tanggal dan jam upload
$fotobaru = date('dmYHis').$foto;

// Set path folder tempat menyimpan fotonya
$path = "images/".$fotobaru;

// Proses upload
if(move_uploaded_file($tmp, $path)){ // Cek apakah gambar berhasil diupload atau tidak
	// Proses simpan ke Database
	  mysql_query("insert into stock_in values('','$stockno','$item_name','$beggining','$unit','$act','','$orig_price','$model','$serial','$brand','$dimension','$machine','$location','$fotobaru','date','','','')");
	header("location:tambah_item");

}

?>


avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 6 tahun yang lalu

Proses Insert Udah Bener.. itu field location = nama field untuk alamat gambar di internet ya

yang harus dibenerin waktu nampilin datanya .. contoh gini


<?php
    include_once('connection.php');

    $sql = "SELECT * FROM stock_in";
    $result = mysql_query($sql);

    while($row = mysql_fetch_assoc($result)) {

        echo $row['item_name'] "<br>";
        echo $row['beggining'] "<br>";
        // dst terus sampai habis

        // ini untuk gambar
        $link_Internet = $row['location']; //sesuaikan nama field
        $link_Lokal    = $row['foto']; //sesuaikan nama field

        $base_url = "localhost/project/"; //ini url project kamu apa ??

        // jgn lupa nambahin folder tempat nyimpan gambar =>  "images/"
        $link_Lokal = $base_url . "images/" . $link_Lokal;

        // cek jika $link_internet kosong maka yg ditampilkan $link_lokal dan sebaliknya..
        if(empty($link_Internet)) {
            echo "<a href='$link_Lokal'>Klik Untuk Lihat Gambar</a>";
        }else{
            echo "<a href='$link_Internet'>Klik Untuk Lihat Gambar</a>";
        }

    }
 ?>

Semoga Membantu (^_^)..

avatar ciloxz
@ciloxz

284 Kontribusi 139 Poin

Dipost 6 tahun yang lalu

terimakasih banyak gan ngomong ngomong berarti saya harus bikin form inputnya dua ya gan yang satu input yg menggunakan image yang satu menggunakan ling alamat url alnya klo satu pas mau input ketika salah satu kolom yg gk di isi terprotect gk bisa di prosesss misalnya barang A KAN MENGGUNAKAN GAMBAR YG DI LOKAL OTOMATIS KITA TIDAK MENGISI KOLOM UNTUK ALAMAT GAMBAR YG DI INTERNET NAH DISI PERMASALAHANNYA KLO SATU FORM

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 6 tahun yang lalu

makasih banget gan ..,.,.,tinggal input form nya yg bermasalah harus bikin dua input formnya yg satu disertakan gambar yg di lokal yang satu dari internet.,.,klo disatuin gak bisa alnya ketika nginput data kolom nya harus terisi semua kalo gk ter isi terprotect tidak bisa di prosess sedangkan ini harus memilih antara gambar yg di lokal sama yg di internet

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 6 tahun yang lalu

<?php

  // add_item.php

  if(isset($_POST['submit'])) {
    // $_POST['nama'] dll

    // waktu mau insert data cek dulu apakah link internet diisi apa tidak sama user

    // jika link_internet kosong maka
    if(empty($link_Internet)) {
      //upload gambar
      move_uploaded_file($source, $dest);
    }else{
      //ndk perlu upload
    }

    //untuk sql query nya sama..

  }

 ?>

 <form action="" method="POST">
    Link Lokal <input type="file" name="link_lokal"> // jgn dikasih required
    Link Internet <input type="text" name="link_internet"> // jgn dikasih required
    <input type="submit" name="submit">
 </form>

avatar ciloxz
@ciloxz

284 Kontribusi 139 Poin

Dipost 6 tahun yang lalu

gan maaf satu lagi edit nya gk jalan kenapa each code edit foto ini kode ini untuk mengedit gambar/file di data base sama di folder gambar/file ketika di edit semua nya terhapus berserta fotonya di ganti yg baru tp kenapa gk jalan mungkin ada yang salahh gan maaf nanya terus

 <?php
  include_once 'connection.php';

if(isset($_GET['id']))
{
$id = $_GET['id'];

}

if(isset($_GET['submit']))
{
$id = $_GET["id"];
$stockno =$_GET["stockno"];
$item_name =$_GET["item_name"];
@$unit =$_GET["unit"];
$orig_price =$_GET["orig_price"];
$model =$_GET["model"];
$serial =$_GET["serial"];
$brand =$_GET["brand"];
$dimension =$_GET["dimension"];
$machine =$_GET["machine"];
$location =$_GET["location"];
$link =$_GET["link"];
$foto = $_FILES['foto']['name'];
$tmp = $_FILES['foto']['tmp_name'];
$fotobaru = date('dmYHis').$foto;
$path = "images/".$fotobaru;

if (isset($_POST['update'])){
    if (!$tmp==""){
        $buat_foto=$fotobaru;
        $d = 'images/'.$x;
        @unlink ("$d");
        copy ($tmp,$path);
    }else{
        $buat_foto=$x;
    }

}

$sql = mysql_query("UPDATE  stock_in SET stockno='$stockno', item_name='$item_name',unit='$unit',orig_price='$orig_price',model='$model',serial='$serial',brand='$brand',dimension='$dimension',machine='$machine',location='$location',link='$link',foto=$buat_foto'  WHERE id='$id'");

 		echo'<script>';
		echo'alert("Successfully Saved");';
        echo'window.location.href="edit";';
        echo'</script>';
}
?>

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 6 tahun yang lalu


<?php
if (isset($_POST['update'])){
	// ini cek jika gambar nya diganti gitu maksudnya ??
    if (!$tmp==""){
        $buat_foto=$fotobaru;
        // var $x dpt dari mana ??
        $d = 'images/'.$x;
        @unlink ("$d");
        // upload kan pake  move_upload_files, kog copy ??
        copy ($tmp,$path);
    }else{
        $buat_foto=$x;
    }

}
?>

avatar ciloxz
@ciloxz

284 Kontribusi 139 Poin

Dipost 6 tahun yang lalu

saya lihat di google gan gimana atuh gan seharussnya

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 6 tahun yang lalu

each mau update gambarnya ko gak bisa bisa sekalian bisa di update gambar yg di folder root nya gak hilang jadi harus manual hapusnya

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 6 tahun yang lalu

Ya gk boleh manual gan...pake program itu biar otomatis..

maksudnya jika update gambar (gambar diganti) gambar yg lama otomatis terhapus ? gitu kan..

coba lihat data ditable stock_in .. agan. screen shot upload dulu,, biar jelas..

avatar ciloxz
@ciloxz

284 Kontribusi 139 Poin

Dipost 6 tahun yang lalu

Saat Menekan tombol edit kan menampilkan data brg yg mau diedit ke form edit.. tambahkan ini


<input type="hidden" name="foto_lama" value="<?php echo xxxx ?>">
<!-- xxx = ganti dengan data foto-->

ganti/hapus kode agan yg ini


if (isset($_POST['update'])){
    if (!$tmp==""){
        $buat_foto=$fotobaru;
        $d = 'images/'.$x;
        @unlink ("$d");
        copy ($tmp,$path);
    }else{
        $buat_foto=$x;
    }

}

$sql = mysql_query("UPDATE  stock_in SET stockno='$stockno', item_name='$item_name',unit='$unit',orig_price='$orig_price',model='$model',serial='$serial',brand='$brand',dimension='$dimension',machine='$machine',location='$location',link='$link',foto=$buat_foto'  WHERE id='$id'");

dengan ini

$foto_lama = $_GET['foto_lama']; // tambahan informasi foto lama

if (isset($_POST['update'])){

  if (!empty($tmp)) {

      //upload foto pengganti
      move_uploaded_file($tmp, $path);

      //hapus gambar lama
      unlink ("image/" . $foto_lama);

      //jika user mengganti gambar maka update foto
      $sql = "UPDATE  stock_in SET stockno='$stockno', item_name='$item_name',unit='$unit',orig_price='$orig_price',model='$model',serial='$serial',brand='$brand',dimension='$dimension',machine='$machine',location='$location',link='$link',foto='$buat_foto'  WHERE id='$id'";
  }else{
      //user tidak mengganti foto
      // foto='$buat_foto' harus dihapus (tdk perlu di update)

      $sql = "UPDATE  stock_in SET stockno='$stockno', item_name='$item_name',unit='$unit',orig_price='$orig_price',model='$model',serial='$serial',brand='$brand',dimension='$dimension',machine='$machine',location='$location',link='$link' WHERE id='$id'";
  }

  if(mysql_query($sql)) {
      echo "<script>alert('Sukses Update')</script>";
  }else{
      echo "<script>alert('Gagal Update')</script>";
  };

}

Yg teliti yaa.. Semoga berhasil ... Good Luck...

avatar ciloxz
@ciloxz

284 Kontribusi 139 Poin

Dipost 6 tahun yang lalu

stock_in [id] [stockno] [itemname] [unit] [orig_price] [model] [serial] [brand] [dimension] [machine] [location] [link] [foto]

 //FORM EDIT
 <?php
    include_once 'connection.php';
?>

                   <?php
                    $id = $_GET['id'];

                    $sql=mysql_query('select * from stock_in where id = "'.$id.'" ')or die(mysql_error());

                     while($data=mysql_fetch_array($sql)){
                     $id = ''.($data['id']). '';
                    $stockno = ''.($data['stockno']). '';
                    $item_name = ''.($data['item_name']). '';
					 $beggining = ''.($data['beggining']). '';
					 @$act = ''.($data['act']). '';
					 $deff = ''.($data['deff']). '';
					  $unit = ''.($data['unit']). '';
				$orig_price = ''.($data['orig_price']). '';
					 $model = ''.($data['model']). '';
                    $serial= ''.($data['serial']). '';
                    $brand = ''.($data['brand']). '';
                    $dimension = ''.($data['dimension']). '';
					 $machine = ''.($data['machine']). '';
						  $location = ''.($data['location']). '';
						  $link = ''.($data['link']). '';
						  $foto = ''.($data['foto']). '';


                    }
                    ?>

                    <div class="content-frame-body content-frame-body-left">
                        <div class="panel panel-default">

                                  <form class="form-horizontal" role="form" action="edit_proses" method="GET">
                      <div class="panel-body">
                            <input type="hidden" name="id" value="<?php echo ''.$id.''; ?>">
                                     <div class="form-group">
                                        <label class="col-md-3 col-xs-12 control-label">Item Code.:</label>
                                        <div class="col-md-6 col-xs-12">
                                            <div class="input-group">
                                                <span class="input-group-addon"><span class="fa fa-pencil"></span></span>
                                                <input type="text" name="stockno" class="form-control" value="<?php echo ''.$stockno.''; ?>" />
                                            </div>
                                        </div>
                                    </div>


                                     <div class="form-group">
                                        <label class="col-md-3 col-xs-12 control-label">Descriptions:</label>
                                        <div class="col-md-6 col-xs-12">
                                            <div class="input-group">
                                                <span class="input-group-addon"><span class="fa fa-pencil"></span></span>
                                                <input type="text" name="item_name" class="form-control" value="<?php echo ''.$item_name.''; ?>"/>
                                            </div>
                                        </div>
                                    </div>

                                     <div class="form-group">
                                        <label class="col-md-3 col-xs-12 control-label">Qty:</label>
                                        <div class="col-md-6 col-xs-12">
                                            <div class="input-group">
                                                <span class="input-group-addon"><span class="fa fa-pencil"></span></span>
                                                <input type="text" name="beggining" disabled class="form-control" value="<?php echo ''.$beggining.''; ?>" />
                                            </div>
                                        </div>
                                    </div>

                                     <div class="form-group">
                                        <label class="col-md-3 col-xs-12 control-label">Act:</label>
                                        <div class="col-md-6 col-xs-12">
                                            <div class="input-group">
                                                <span class="input-group-addon"><span class="fa fa-money"></span></span>
                                                <input type="text" name="act" disabled class="form-control" value="<?php echo ''.$act.''; ?>"/>
                                            </div>
                                        </div>
                                    </div>

                                    <div class="form-group">
                                        <label class="col-md-3 col-xs-12 control-label">Deff:</label>
                                        <div class="col-md-6 col-xs-12">
                                            <div class="input-group">
                                                <span class="input-group-addon"><span class="fa fa-money"></span></span>
                                                <input type="text" name="deff" disabled class="form-control" value="<?php echo ''.$deff.''; ?>"/>
                                            </div>
                                        </div>
                                    </div>

                                      <div class="form-group">
                                        <label class="col-md-3 col-xs-12 control-label">Unit:</label>
                                        <div class="col-md-6 col-xs-12">
                                            <div class="input-group">
                                                <span class="input-group-addon"><span class="fa fa-money"></span></span>
                                                <input type="text" name="unit" class="form-control" value="<?php echo ''.$unit.''; ?>"/>
                                            </div>
                                        </div>
                                    </div>


                                     <div class="form-group">
                                        <label class="col-md-3 col-xs-12 control-label">Price:</label>
                                        <div class="col-md-6 col-xs-12">
                                            <div class="input-group">
                                                <span class="input-group-addon"><span class="fa fa-money"></span></span>
                                                <input type="text" name="orig_price" class="form-control" value="<?php echo ''.$orig_price.''; ?>.-SR"./>
                                            </div>
                                        </div>
                                    </div>
                                     <div class="form-group">
                                        <label class="col-md-3 col-xs-12 control-label">Model:</label>
                                        <div class="col-md-6 col-xs-12">
                                            <div class="input-group">
                                                <span class="input-group-addon"><span class="fa fa-money"></span></span>
                                                <input type="text" name="model" class="form-control" value="<?php echo ''.$model.''; ?>"/>
                                            </div>
                                        </div>
                                    </div>
                                     <div class="form-group">
                                        <label class="col-md-3 col-xs-12 control-label">S/N:</label>
                                        <div class="col-md-6 col-xs-12">
                                            <div class="input-group">
                                                <span class="input-group-addon"><span class="fa fa-money"></span></span>
                                                <input type="text" name="serial" class="form-control" value="<?php echo ''.$serial.''; ?>"/>
                                            </div>
                                        </div>
                                    </div>
                                     <div class="form-group">
                                        <label class="col-md-3 col-xs-12 control-label">Brand:</label>
                                        <div class="col-md-6 col-xs-12">
                                            <div class="input-group">
                                                <span class="input-group-addon"><span class="fa fa-money"></span></span>
                                                <input type="text" name="brand" class="form-control" value="<?php echo ''.$brand.''; ?>"/>
                                            </div>
                                        </div>
                                    </div>

                                     <div class="form-group">
                                        <label class="col-md-3 col-xs-12 control-label">Dimension:</label>
                                        <div class="col-md-6 col-xs-12">
                                            <div class="input-group">
                                                <span class="input-group-addon"><span class="fa fa-money"></span></span>
                                                <input type="text" name="dimension" class="form-control" value="<?php echo ''.$dimension.''; ?>"/>
                                            </div>
                                        </div>
                                    </div>
                                     <div class="form-group">
                                        <label class="col-md-3 col-xs-12 control-label">Machine:</label>
                                        <div class="col-md-6 col-xs-12">
                                            <div class="input-group">
                                                <span class="input-group-addon"><span class="fa fa-money"></span></span>
                                                <input type="text" name="machine" class="form-control" value="<?php echo ''.$machine.''; ?>"/>
                                            </div>
                                        </div>
                                    </div>
                                     <div class="form-group">
                                        <label class="col-md-3 col-xs-12 control-label">Location:</label>
                                        <div class="col-md-6 col-xs-12">
                                            <div class="input-group">
                                                <span class="input-group-addon"><span class="fa fa-money"></span></span>
                                                <input type="text" name="location" class="form-control" value="<?php echo ''.$location.''; ?>"/>
                                                 </div>
                                        </div>
                                    </div>
                                    <div class="form-group">
                                        <label class="col-md-3 col-xs-12 control-label">URL:</label>
                                        <div class="col-md-6 col-xs-12">
                                            <div class="input-group">
                                                <span class="input-group-addon"><span class="fa fa-money"></span></span>
                                                <input type="text" name="location" class="form-control" value="<?php echo ''.$link.''; ?>"/>
                                                 </div>
                                        </div>
                                    </div>
                                     <div class="form-group">
                                        <label class="col-md-3 col-xs-12 control-label">Drawing:</label>
                                        <div class="col-md-6 col-xs-12">
                                            <div class="input-group">
                                                <span class="input-group-addon"><span class="fa fa-money"></span></span>
                                              <div colspan="3"><img src="images/<?php echo ''.$foto.'';?>" width="150" height="120"/><br>
                                              </div>
                                                </div><br>
                                                <div class="input-group">
                                               <span class="input-group-addon"><span class="fa fa-money"></span></span>
                                               <div colspan="3"><input name="foto" type="file" class="pull-center" size="30" maxlength="30" />
                                                <input type="hidden" name="foto_lama" class="form-control" value="<? echo ''.$foto.'';?>"/>
                                                </div>


                                            </div>
                                        </div><br>
                                    </div>

                                      <br>




                             <div class="panel-footer">

                                  <input type="submit" name="submit" class="btn btn-primary pull-right" value="UPDATE" >
                                  <a href="edit"><span class="btn btn-primary pull-left">BACK</span></a>

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 6 tahun yang lalu

PHP PROSESSNYA...DAH DI COBAA ERRORR GAN

 <?php
  include_once 'connection.php';

if(isset($_GET['id']))
{
$id = $_GET['id'];

}

if(isset($_GET['submit']))

$id = $_GET["id"];
$stockno =$_GET["stockno"];
$item_name =$_GET["item_name"];
@$unit =$_GET["unit"];
$orig_price =$_GET["orig_price"];
$model =$_GET["model"];
$serial =$_GET["serial"];
$brand =$_GET["brand"];
$dimension =$_GET["dimension"];
$machine =$_GET["machine"];
$location =$_GET["location"];
@$link =$_GET["link"];
@$foto = $_FILES['foto']['name'];
@$tmp = $_FILES['foto']['tmp_name'];
$fotobaru = date('dmYHis').$foto;
$path = "images/".$fotobaru;
$foto_lama = $_GET['foto_lama'];

if (isset($_POST['update'])){

  if (!empty($tmp)) {

      //upload foto pengganti
      move_uploaded_file($tmp, $path);

      //hapus gambar lama
      unlink ("image/" . $foto_lama);

      //jika user mengganti gambar maka update foto
      $sql = "UPDATE  stock_in SET stockno='$stockno', item_name='$item_name',unit='$unit',orig_price='$orig_price',model='$model',serial='$serial',brand='$brand',dimension='$dimension',machine='$machine',location='$location',link='$link',foto='$foto_lama'  WHERE id='$id'";
  }else{
      //user tidak mengganti foto
      // foto='$buat_foto' harus dihapus (tdk perlu di update)

      $sql = "UPDATE  stock_in SET stockno='$stockno', item_name='$item_name',unit='$unit',orig_price='$orig_price',model='$model',serial='$serial',brand='$brand',dimension='$dimension',machine='$machine',location='$location',link='$link' WHERE id='$id'";
  }

  if(mysql_query($sql)) {
      echo "<script>alert('Sukses Update')</script>";
  }else{
      echo "<script>alert('Gagal Update')</script>";
  };

}
?>

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 6 tahun yang lalu

ada salah sedikit itu bagian

 if(isset($_GET['submit']))

kurang "{" ganti dg ini

 if(isset($_GET['submit'])) {

bagian ini hapus

if (isset($_POST['update'])) {

kalau masih error . erronya apa ? copy ke sini

avatar ciloxz
@ciloxz

284 Kontribusi 139 Poin

Dipost 6 tahun yang lalu

status sucsess cuman gambar yg diffolderr root tidak terganti juga nama foto di data base gk berubah yg berubah malah dta location terhapus

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 6 tahun yang lalu

 <?php
  include_once 'connection.php';

if(isset($_GET['id']))
{
$id = $_GET['id'];

}

if(isset($_GET['submit'])) {
$id = $_GET["id"];
$stockno =$_GET["stockno"];
$item_name =$_GET["item_name"];
@$unit =$_GET["unit"];
$orig_price =$_GET["orig_price"];
$model =$_GET["model"];
$serial =$_GET["serial"];
$brand =$_GET["brand"];
$dimension =$_GET["dimension"];
$machine =$_GET["machine"];
$location =$_GET["location"];
@$link =$_GET["link"];
@$foto = $_FILES['foto']['name'];
@$tmp = $_FILES['foto']['tmp_name'];
$foto_lama = $_GET['foto_lama'];

$path = "images/".$foto_lama;

  if (!empty($tmp)) {

      //upload foto pengganti
      move_uploaded_file($tmp, $path);

      //hapus gambar lama
      unlink ("image/" . $foto_lama);

      //jika user mengganti gambar maka update foto
      $sql = "UPDATE  stock_in SET stockno='$stockno', item_name='$item_name',unit='$unit',orig_price='$orig_price',model='$model',serial='$serial',brand='$brand',dimension='$dimension',machine='$machine',location='$location',link='$link',foto='$foto_lama'  WHERE id='$id'";
  }else{
      //user tidak mengganti foto
      // foto='$buat_foto' harus dihapus (tdk perlu di update)

      $sql = "UPDATE  stock_in SET stockno='$stockno', item_name='$item_name',unit='$unit',orig_price='$orig_price',model='$model',serial='$serial',brand='$brand',dimension='$dimension',machine='$machine',location='$location',link='$link' WHERE id='$id'";
  }

  if(mysql_query($sql)) {
      echo "<script>alert('Sukses Update');window.location='edit'</script>";
  }else{
      echo "<script>alert('Gagal Update');window.location='edit_eksekusi'</script>";
  };

}

?>

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 6 tahun yang lalu

PENTING : symbol @ sebelum variable itu lebih baik dihapus aj...ngapain juga dikasih itu emg mau ngirim email hehe...

Bagian attribute name='location' ini yg salah..


<input type="text" name="location" class="form-control" value="<?php echo ''.$link.''; ?>"/>

Harusnya kan namanya link


<input type="text" name="link" class="form-control" value="<?php echo ''.$link.''; ?>"/>

Bagian ini benerin juga gan nama folder nya gk sama pantes gk bisa..

$path = "images/".$fotobaru;
unlink ("image/" . $foto_lama);

Harusnya kan sama nama folder e =>images (pake es ... dingin gan..) hehe

$path = "images/".$fotobaru;
unlink ("images/" . $foto_lama);

Udah Coba lagi ... semoga terselesaikan...

avatar ciloxz
@ciloxz

284 Kontribusi 139 Poin

Dipost 6 tahun yang lalu

Tetep gan foto nya gk bisa terganti

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 6 tahun yang lalu

agan nge checknya di browser / di folder images nya..

cek dulu di folder images nya..

avatar ciloxz
@ciloxz

284 Kontribusi 139 Poin

Dipost 6 tahun yang lalu

Dua duanya gann saya check apa mungkin di ada kesalahan penulisan di quary yg kya ,foto='foto_lama'

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 6 tahun yang lalu

Jawaban Terpilih

Coba ini ...kalau edit pelan2 biar gk salah ini udah work..

BAGIAN FORM_EDIT

<form class="form-horizontal" role="form" action="edit_proses" method="GET">

<input type="hidden" name="foto_lama" class="form-control" value="<? echo ''.$foto.'';?>"/>

ganti ..action jd => edit_proses.php.. method jd=> POST.. tambah => "enctype" pd form, dan <input name="foto_lama" type="hidden" sementara ganti type ="text" dulu nanti kalau udah work kembalikan "hidden" , dan

PASTIKAN nilainya sesuai dg data foto didatabase..

<form class="form-horizontal" role="form" action="edit_proses.php" method="POST" enctype="multipart/form-data">

<input type="text" name="foto_lama" class="form-control" value="<? echo ''.$foto.'';?>"/>

BAGIAN EDIT_PROSES.PHP hapus semua ganti DG ini untuk upload harus method harus $_POST gan...

<?php
  include_once 'connection.php';

if(isset($_POST['submit'])) {
  $id = $_POST["id"];
  $stockno =$_POST["stockno"];
  $item_name =$_POST["item_name"];
  $unit =$_POST["unit"];
  $orig_price =$_POST["orig_price"];
  $model =$_POST["model"];
  $serial =$_POST["serial"];
  $brand =$_POST["brand"];
  $dimension =$_POST["dimension"];
  $machine =$_POST["machine"];
  $location =$_POST["location"];
  $link =$_POST["link"];
  $foto = $_FILES['foto']['name'];
  $tmp = $_FILES['foto']['tmp_name'];
  $fotobaru = date('dmYHis').$foto;
  $foto_lama = $_POST['foto_lama'];

  $path = "images/".$fotobaru;

  if (!empty($tmp)) {

      //upload foto pengganti
      move_uploaded_file($tmp, $path);

      //hapus gambar lama
      $pathLama = "images/" . $foto_lama;
      if(file_exists($pathLama)) {
        unlink ($pathLama);
      }

      //jika user mengganti gambar maka update foto
      $sql = "UPDATE  stock_in SET stockno='$stockno', item_name='$item_name',unit='$unit',orig_price='$orig_price',model='$model',serial='$serial',brand='$brand',dimension='$dimension',machine='$machine',location='$location',link='$link',foto='$fotobaru'  WHERE id='$id'";
  }else{
      //user tidak mengganti foto
      // foto='$buat_foto' harus dihapus (tdk perlu di update)

      $sql = "UPDATE  stock_in SET stockno='$stockno', item_name='$item_name',unit='$unit',orig_price='$orig_price',model='$model',serial='$serial',brand='$brand',dimension='$dimension',machine='$machine',location='$location',link='$link' WHERE id='$id'";
  }

  if(mysql_query($sql)) {
      echo "<script>alert('Sukses Update');window.location='edit'</script>";
  }else{
      echo "<script>alert('Gagal Update');window.location='edit_eksekusi'</script>";
  };

}

?>

Semoga Cepet kelar gan...

avatar ciloxz
@ciloxz

284 Kontribusi 139 Poin

Dipost 6 tahun yang lalu

potonya terganti gann cuman foto lama tidak ke hapusss di folder

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 6 tahun yang lalu

foto lama nya udah kedeteksi belum waktu di form edit yg input type hidden...name=foto_lama.

tapi harusnya udah bener itu.. . udah tak coba work kkog... atau gini aj..coba hapus dulu semua data beserta.. semua foto di produknya..terus add.produk baru.. lalu update..

avatar ciloxz
@ciloxz

284 Kontribusi 139 Poin

Dipost 6 tahun yang lalu

foto lama gk kedetec gan duh sayang gk bisa screenshort cii biar jelas

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 6 tahun yang lalu

kesalahannya di sini gannn php nya gk kebawaa

<input type="text" name="foto_lama" class="form-control" value="<? echo ''.$foto.'';?>"/>
avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 6 tahun yang lalu

gan boleh minta no hpnya gk klo boleh kirimin ke email saya gan maulanamahdi101@yahoo.com

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 6 tahun yang lalu

 kesalahannya di sini gannn php nya gk kebawaa

Nah tdkan sy bilang masalah itu ...

 foto lama nya udah kedeteksi belum waktu di form edit yg input type hidden...name=foto_lama.

hmm..tapi skrg udah bisa berarti ya... good luck lah...

maf gan kalau Hp.. privasi .. dsini aj banyak yg bantu... sekalian ngeramein sekolah koding.. hehe..

emg lagi ngerjain project apaan ? tugas / kerjaan..

avatar ciloxz
@ciloxz

284 Kontribusi 139 Poin

Dipost 6 tahun yang lalu

gpp gan saya minta no hp hanya pengen ngegantiin kuota internetnya z sya saya kerja di sparepart (gudang)bikin itu inisiatif sendiri supaya mempermudah perkerjaan saya ketika inventory..klo gk ada data base itu saya cape ngecheck barang sampe dua x kerja tulis manual abis itu masukin kkomputer klo ada ini kan enak tinggal masukin ke data base udah komplete tinggal download beress.,..ketambah saya seneng sama programer tp susah..he,he ....ngomong2 klo punya source code buat export ke file xl..bagi bagiii gan,.,semua dah komplite tinggal exportnya z

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 6 tahun yang lalu

Tenang aj gan,,, gak usah repot2.. saya pake wifi dirumah kog..

sip.. harus gitu gan.. berkembang dan inovatif.. kalau php excel diplaylist kan sudah ada gan..

https://sekolahkoding.com/kelas/bermain-dengan-excel-melalui-php
avatar ciloxz
@ciloxz

284 Kontribusi 139 Poin

Dipost 6 tahun yang lalu

master @ciloxz minta tolong dong mass masalah session login saya gagal teruss

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 6 tahun yang lalu

saya dah coba nanya diform jawabannya singkat singkat terus bingung saya dah ikut coba cara member di sini masih juga lom masukk pdahal dah ta download semua videonyaaa hahaa

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 6 tahun yang lalu

kodenya mana ?

avatar ciloxz
@ciloxz

284 Kontribusi 139 Poin

Dipost 6 tahun yang lalu

<!DOCTYPE html>
<html>
<head>
	<title>@dinarNet</title>
	<link rel="stylesheet" type="text/css" href="assets/css/bootstrap.css">
	<link rel="stylesheet" type="text/css" href="assets/js/jquery-ui/jquery-ui.css">
	<script type="text/javascript" src="assets/js/jquery.js"></script>
	<script type="text/javascript" src="assets/js/bootstrap.js"></script>
	<script type="text/javascript" src="assets/js/jquery-ui/jquery-ui.js"></script>
	<?php include 'admin/connection.php'; ?>
	<style type="text/css">
	.kotak{
		margin-top: 150px;
	}

	.kotak .input-group{
		margin-bottom: 20px;
	}
	</style>
</head>
<body>
	<div class="container">
		<?php
		if(isset($_GET['pesan'])){
			if($_GET['pesan'] == "gagal"){
				echo "<div style='margin-bottom:-55px' class='alert alert-danger' role='alert'><span class='glyphicon glyphicon-warning-sign'></span>  Login Gagal !! Username dan Password Salah !!</div>";
			}
		}
		?>
		<div class="panel panel-default">
			<form action="login.php" method="post">
				<div class="col-md-4 col-md-offset-4 kotak">
					<h3>Silahkan Login ..</h3>
					<div class="input-group">
						<span class="input-group-addon"><span class="glyphicon glyphicon-user"></span></span>
						<input type="text" class="form-control" placeholder="Username" name="uname">
					</div>
					<div class="input-group">
						<span class="input-group-addon"><span class="glyphicon glyphicon-lock"></span></span>
						<input type="password" class="form-control" placeholder="Password" name="pass">
					</div>
					<div class="input-group">
						<input type="submit" name="submit"class="btn btn-primary" value="Login">
					</div>
				</div>
			</form>
		</div>
	</div>
</body>
</html>

<-----------------login.php  (proseslogin)--------------------->

<?php
session_start();
include_once 'admin/connection.php';

$uname=$_POST['uname'];
$pass=$_POST['pass'];
$pas=md5($pass);
$login=mysql_query("select * from admin where uname='$uname' and pass='$pas'")or die (mysql_error());

$rowcount = mysql_num_rows($login);
if ($rowcount == 1) {
$_SESSION['uname'] = $_POST['uname'];
header("Location: admin/index.php");
}
else
{
header("Location:./index.php");
}
?>

<--------------------index.php (home)---------->
<?php include 'security.php'; ?>

<?php include 'connection.php'; ?>

<!DOCTYPE html>
<html lang="en">
    <head>
        <!-- META SECTION -->
        <title>HOMEPAGE</title>
        <meta charset="utf-8">
    </head>
    <body>

            <div>
               <?php
               include('header.php');
               ?>
            </div>

    </body>
</html>

<-----------------------header.php----->

<!DOCTYPE html>
<html>
<head>


        <?php
	include 'security.php';
	?>

	<?php
	include 'connection.php';
	?>
	<title>DinarNet@.shop</title>
	<link rel="stylesheet" type="text/css" href="../assets/css/bootstrap.css">
	<link rel="stylesheet" type="text/css" href="../assets/js/jquery-ui/jquery-ui.css">
	<style type="text/css">
	body {
		<?php
			$use=$_SESSION['uname'];
			$fo=mysql_query("select bg from admin where uname='$use'");
			while($f=mysql_fetch_array($fo)){
				?>


	background-image: url(foto/t/<?php echo $f['bg']; ?>);
	<?php

			}
			?>

}
    </style>
	<script type="text/javascript" src="../assets/js/jquery.js"></script>
	<script type="text/javascript" src="../assets/js/jquery.js"></script>
	<script type="text/javascript" src="../assets/js/bootstrap.js"></script>
	<script type="text/javascript" src="../assets/js/jquery-ui/jquery-ui.js"></script>
<meta charset="utf-8">
</head>
<body>
<div class="navbar navbar-default">
<div class="container-fluid">
<div class="navbar-header">
<a href="https://dinarnet.shop/rindu" class="navbar-brand">Spareparts</a>
<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target=".navbar-collapse">
					<span class="sr-only">Toggle navigation</span>
					<span class="icon-bar"></span>
					<span class="icon-bar"></span>
					<span class="icon-bar"></span>
				    </button>
			        </div>

<div class="collapse navbar-collapse">
<ul class="nav navbar-nav navbar-right">
<li><a id="pesan_sedia" href="#" data-toggle="modal" data-target="#modalpesan"><span class='glyphicon glyphicon-comment'></span>  Message</a></li>
<li><a class="dropdown-toggle" data-toggle="dropdown" role="button" href="#">Hy , <?php echo $_SESSION['uname']  ?>  <span class="glyphicon glyphicon-user"></span></a></li>
				</ul>
			    </div>
		        </div>
	            </div>

	<!-- modal input -->
<div id="modalpesan" class="modal fade">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
<h4 class="modal-title">Notification</h4>
</div>
<div class="modal-body">
					<?php
					$periksa=mysql_query("select * from stock_in where beggining <=0");
					while($q=mysql_fetch_array($periksa)){
					if($q['beggining']<=0){
					echo "<div style='padding:5px' class='alert alert-warning'><span class='glyphicon glyphicon-info-sign'></span> User  <a style='color:red'>". $q['item_name']."</a> stock limit . Need Order !!</div>";
						}
					}
					?>
				</div>

<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">Batal</button>
				</div>
                </div>
		        </div>
	            </div>

<div class="col-md-2">
<div class="row">
			<?php
			$use=$_SESSION['uname'];
			$fo=mysql_query("select foto from admin where uname='$use'");
			while($f=mysql_fetch_array($fo)){
				?>

			<div class="col-xs-6 col-md-12">
<a class="thumbnail"><img class="img-responsive" src="foto/<?php echo $f['foto']; ?>" width="70px"></a>
				</div>
				<?php
			}
			?>
		</div>

    <div class="row"></div>
	<ul class="nav nav-pills nav-stacked">

<li class="active"><a href="index.php"><span class="glyphicon glyphicon-home"></span>  Dashboard</a></li>

<li><a href="pc.php"><span class="glyphicon glyphicon-book"></span><strong> Data Sparepart</strong></a></li>

<li><a href="pc_out1.php"><span class="glyphicon glyphicon-list"></span> <strong>ISSUE ITEM</strong> </a></li>

<li><a href="pc_bgr1.php"><span class="glyphicon glyphicon-picture"></span> <strong>Change Themes</strong> </a></li>

<li><a href="pc_prof1.php"><span class="glyphicon glyphicon-picture"></span> <strong>Change Foto</strong></a></li>

<li><a href="pc_cpas1.php"><span class="glyphicon glyphicon-lock"></span> <strong>Change Password</strong></a></li>

<li><a href="logout.php"><span class="glyphicon glyphicon-log-out"></span>  Logout</a></li>
	</ul>
	</div>
<div class="col-md-10">

-------------security.php--->

<?php
session_start();
if (!isset($_SESSION['uname'])){
header('Location:./index.php');
}
echo"";
include 'connection.php';
?>
<------------logout------>
<?php
 session_start();
unset($_SESSION['uname']);
session_destroy();
header("Location: ../index.php");
?>


avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 6 tahun yang lalu

form loginnya bisa dilewati terus seharusnya kan ketika memanggil halamn di belakang login harus ke derect ke halaman login ini mah engga bingungg saya error teruss

klo bingung dengan kodenya yg semerawut gitu ta kirim semuanya complete tp ngirimnya kemana

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 6 tahun yang lalu

gan minta tolong lagi dong gan tentang submit saya bingung submitnya selalu double ketika internet lambat pas refress hasillnya jadi dua kali post terus dah nyobaaa di google hasilnya samaaa teruss

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 5 tahun yang lalu

waktu tekan tombol submit (simpan) lakukan disable pada tombol nya dengan jquery (event mouseedown, click / submit pd tombolnya) untuk mencegah User menekan tombol itu kembali.

// misal id dari tombol submit nya "save"
   <input type="submit" name="submit" id="save"/>

$("#save").mousedown(function(){
   $(this).attr('disabled','disabled');
});

avatar ciloxz
@ciloxz

284 Kontribusi 139 Poin

Dipost 5 tahun yang lalu

padahal belum ta klick tombol save nya dah mati duluuan..gan jadi data gk bisa diproses penyimpanan

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 5 tahun yang lalu

coba perhatikan itu.. event nya waktu $("#save").mousedown.. jadi waktu ditekan untuk pertama kalinya..

coba lihat kode nya bro..

avatar ciloxz
@ciloxz

284 Kontribusi 139 Poin

Dipost 5 tahun yang lalu

ini gan @ciloxz benergaa ta kasih tanda panah panjang masih tetep double submite ketika klick submite ada gangguan internet lambat pass di refress data masuk dua kali gan <pre> &lt;?php include_once '../connection.php'; ?&gt; &lt;!DOCTYPE html&gt; &lt;html lang="en"&gt; &lt;head&gt;
&lt;!-- META SECTION --&gt; &lt;title&gt;ADMIN | PANEL&lt;/title&gt;
&lt;meta http-equiv="Content-Type" content="text/html; charset=utf-8" /&gt; &lt;meta http-equiv="X-UA-Compatible" content="IE=edge" /&gt; &lt;meta name="viewport" content="width=device-width, initial-scale=1" /&gt;

    &amp;lt;link rel=&quot;icon&quot; href=&quot;favicon.ico&quot; type=&quot;image/x-icon&quot; /&amp;gt;
    &amp;lt;!-- END META SECTION --&amp;gt;
    
    &amp;lt;!-- CSS INCLUDE --&amp;gt;        
    &amp;lt;link rel=&quot;stylesheet&quot; type=&quot;text/css&quot; id=&quot;theme&quot; href=&quot;css/theme-default.css&quot;/&amp;gt;
    &amp;lt;!-- EOF CSS INCLUDE --&amp;gt;
 
    
    
&amp;lt;/head&amp;gt;
&amp;lt;body&amp;gt;
    &amp;lt;!-- START PAGE CONTAINER --&amp;gt;
    &amp;lt;div class=&quot;page-container&quot;&amp;gt;
        
        &amp;lt;!-- START PAGE SIDEBAR --&amp;gt;
        &amp;lt;div class=&quot;page-sidebar&quot;&amp;gt;
            &amp;lt;!-- START X-NAVIGATION --&amp;gt;
            &amp;lt;?php 
           include(&quot;nav.php&quot;);

           ?&amp;gt;
            &amp;lt;!-- END X-NAVIGATION --&amp;gt;
        &amp;lt;/div&amp;gt;
        &amp;lt;!-- END PAGE SIDEBAR --&amp;gt;
        
        &amp;lt;!-- PAGE CONTENT --&amp;gt;
        &amp;lt;div class=&quot;page-content&quot;&amp;gt;
            
            &amp;lt;!-- START X-NAVIGATION VERTICAL --&amp;gt;
            &amp;lt;ul class=&quot;x-navigation x-navigation-horizontal x-navigation-panel&quot;&amp;gt;
                &amp;lt;!-- TOGGLE NAVIGATION --&amp;gt;
                &amp;lt;li class=&quot;xn-icon-button&quot;&amp;gt;
                    &amp;lt;a href=&quot;#&quot; class=&quot;x-navigation-minimize&quot;&amp;gt;&amp;lt;span class=&quot;fa fa-dedent&quot;&amp;gt;&amp;lt;/span&amp;gt;&amp;lt;/a&amp;gt;
                &amp;lt;/li&amp;gt;
                &amp;lt;!-- END TOGGLE NAVIGATION --&amp;gt;                    
            &amp;lt;/ul&amp;gt;
            &amp;lt;!-- END X-NAVIGATION VERTICAL --&amp;gt;                     
            
            &amp;lt;!-- START BREADCRUMB --&amp;gt;
            &amp;lt;ul class=&quot;breadcrumb&quot;&amp;gt;
                &amp;lt;li&amp;gt;&amp;lt;a href=&quot;#&quot;&amp;gt;Link&amp;lt;/a&amp;gt;&amp;lt;/li&amp;gt;                    
                &amp;lt;li class=&quot;active&quot;&amp;gt;Active&amp;lt;/li&amp;gt;
                &amp;lt;li&amp;gt;&amp;lt;a href=&quot;adsrc.php&quot;&amp;gt;BUILLDING SRC&amp;lt;/a&amp;gt;&amp;lt;/li&amp;gt; 
            &amp;lt;/ul&amp;gt;
            &amp;lt;!-- END BREADCRUMB --&amp;gt;                
            
                            
            
             &amp;lt;!-- START CONTENT FRAME --&amp;gt;
            &amp;lt;div class=&quot;content-frame&quot;&amp;gt;
                
                &amp;lt;!-- START CONTENT FRAME TOP --&amp;gt;
                &amp;lt;div class=&quot;content-frame-top&quot;&amp;gt;                        
                    &amp;lt;div class=&quot;page-title&quot;&amp;gt; 
                    &amp;lt;span&amp;gt;&amp;lt;img src=&quot;img/routerr.png&quot; width=&quot;70&quot; height=&quot;70&quot;/&amp;gt;&amp;lt;/span&amp;gt; 
                    &amp;lt;br&amp;gt;                   
                        &amp;lt;h4 class=&quot;alert-danger&quot;&amp;gt;BUILLDING SPC&amp;lt;/h4&amp;gt;
                    &amp;lt;/div&amp;gt;                                      
                    &amp;lt;div class=&quot;pull-right&quot;&amp;gt;
                        &amp;lt;button class=&quot;btn btn-default content-frame-right-toggle&quot;&amp;gt;&amp;lt;span class=&quot;fa fa-bars&quot;&amp;gt;&amp;lt;/span&amp;gt;&amp;lt;/button&amp;gt;
                    &amp;lt;/div&amp;gt;                        
                &amp;lt;/div&amp;gt;
                &amp;lt;!-- END CONTENT FRAME TOP --&amp;gt;
                
                &amp;lt;!-- START CONTENT FRAME LEFT --&amp;gt;
                &amp;lt;div class=&quot;content-frame-right&quot;&amp;gt;
                    &amp;lt;div class=&quot;panel panel-default&quot;&amp;gt;
                        &amp;lt;div class=&quot;panel-body&quot;&amp;gt;
                              &amp;lt;table class=&quot;table&quot;&amp;gt;
                                 &amp;lt;?php 
                                    echo&#039;&amp;lt;thead&amp;gt;&#039;;
				$result1 = mysql_query(&quot;SELECT * from ip_address ORDER BY ip1 DESC LIMIT 1&quot;);
				
									echo&#039;&amp;lt;tbody&amp;gt;&#039;;
									while($row = mysql_fetch_array($result1))
										
                                        {
											echo&#039;&amp;lt;tr&amp;gt;&#039;;
                                            echo&#039;&amp;lt;th&amp;gt;LAST RECORD&amp;lt;/th&amp;gt;&#039;;
                                            echo &quot;&amp;lt;td&amp;gt;&amp;lt;/td&amp;gt;&quot;;
											echo&#039;&amp;lt;/tr&amp;gt;&#039;;
											
                                        echo&#039;&amp;lt;tr&amp;gt;&#039;;
										$idme = &#039;&#039;.$row[&quot;id&quot;] .&#039;&#039; ;
										    echo&#039;&amp;lt;th&amp;gt;No. :&amp;lt;/th&amp;gt;&#039;;
                                            echo &quot;&amp;lt;td&amp;gt;&quot; .$row[&quot;id&quot;]. &quot;&amp;lt;/td&amp;gt;&quot;;
											echo&#039;&amp;lt;/tr&amp;gt;&#039;;
											
											echo&#039;&amp;lt;tr&amp;gt;&#039;;
                                            echo&#039;&amp;lt;th&amp;gt;ID :&amp;lt;/th&amp;gt;&#039;;
                                            echo &quot;&amp;lt;td&amp;gt;&quot; .$row[&quot;nik&quot;]. &quot;&amp;lt;/td&amp;gt;&quot;;
											echo&#039;&amp;lt;/tr&amp;gt;&#039;;
											
											echo&#039;&amp;lt;tr&amp;gt;&#039;;
                                            echo&#039;&amp;lt;th&amp;gt;Name :&amp;lt;/th&amp;gt;&#039;;
                                            echo &quot;&amp;lt;td&amp;gt;&quot; .$row[&quot;name&quot;]. &quot;&amp;lt;/td&amp;gt;&quot;;
											echo&#039;&amp;lt;/tr&amp;gt;&#039;;
											
											echo&#039;&amp;lt;tr&amp;gt;&#039;;
                                            echo&#039;&amp;lt;th&amp;gt;MAC :&amp;lt;/th&amp;gt;&#039;;
                                            echo &quot;&amp;lt;td&amp;gt;&quot; .$row[&quot;mac&quot;]. &quot;&amp;lt;/td&amp;gt;&quot;;
											echo&#039;&amp;lt;/tr&amp;gt;&#039;;
											
											echo&#039;&amp;lt;tr&amp;gt;&#039;;
                                            echo&#039;&amp;lt;th&amp;gt;IP :&amp;lt;/th&amp;gt;&#039;;
                                            echo &quot;&amp;lt;td&amp;gt;&quot; .$row[&quot;ip1&quot;]. &quot;&amp;lt;/td&amp;gt;&quot;;
											echo&#039;&amp;lt;/tr&amp;gt;&#039;;
											
											echo&#039;&amp;lt;tr&amp;gt;&#039;;
                                            echo&#039;&amp;lt;th&amp;gt;BUILLDING :&amp;lt;/th&amp;gt;&#039;;
                                            echo &quot;&amp;lt;td&amp;gt;&quot; .$row[&quot;loc&quot;]. &quot;&amp;lt;/td&amp;gt;&quot;;
											echo&#039;&amp;lt;/tr&amp;gt;&#039;;
											
											echo&#039;&amp;lt;tr&amp;gt;&#039;;
                                            echo&#039;&amp;lt;th&amp;gt;&amp;lt;/th&amp;gt;&#039;;
                                            echo &quot;&amp;lt;td&amp;gt;&amp;lt;/td&amp;gt;&quot;;
											echo&#039;&amp;lt;/tr&amp;gt;&#039;;
											
											echo&#039;&amp;lt;tr&amp;gt;&#039;;
                                            echo&#039;&amp;lt;th&amp;gt;&amp;lt;/th&amp;gt;&#039;;
    echo &quot;&amp;lt;td class=&#039;btn btn-default pull-right&#039;&amp;gt; &amp;lt;a href=&#039;del_stock.php?id=&quot;.$idme.&quot;&#039; &amp;gt;Delete&amp;lt;/a&amp;gt; 
											
                                                  &amp;lt;/td&amp;gt;&quot;;
                                            echo&#039;&amp;lt;/tr&amp;gt;&#039;;
										    echo&#039;&amp;lt;/tbody&amp;gt;&#039;;
                                            echo&#039;&amp;lt;/thead&amp;gt;&#039;;
                                       
                                        }
                                        
                                        ?&amp;gt;
                                &amp;lt;/table&amp;gt;  
                        &amp;lt;/div&amp;gt;
                    &amp;lt;/div&amp;gt;
                &amp;lt;/div&amp;gt;
                &amp;lt;!-- END CONTENT FRAME LEFT --&amp;gt;
                
                &amp;lt;!-- START CONTENT FRAME BODY------------------------------------------------------------------------------------------ --&amp;gt;

                &amp;lt;div class=&quot;content-frame-body content-frame-body-left&quot;&amp;gt;
                    &amp;lt;div class=&quot;panel panel-default&quot;&amp;gt;
                       &amp;lt;form class=&quot;form-horizontal&quot; method=&quot;get&quot; action=&quot;adpspc.php&quot;&amp;gt;
                        &amp;lt;div class=&quot;panel-body&quot;&amp;gt;

                                 &amp;lt;div class=&quot;form-group&quot;&amp;gt;
                                    &amp;lt;label class=&quot;col-md-3 col-xs-12 control-label&quot;&amp;gt;ID No. :&amp;lt;/label&amp;gt;
                                    &amp;lt;div class=&quot;col-md-6 col-xs-12&quot;&amp;gt;                                            
                                        &amp;lt;div class=&quot;input-group&quot;&amp;gt;
                                            &amp;lt;span class=&quot;input-group-addon&quot;&amp;gt;...&amp;lt;span class=&quot;fa fa-pencil&quot;&amp;gt;&amp;lt;/span&amp;gt;&amp;lt;/span&amp;gt;
                                            &amp;lt;input type=&quot;text&quot; name=&quot;stock_no&quot; class=&quot;form-control&quot; required/&amp;gt;
                                        &amp;lt;/div&amp;gt;                
                                    &amp;lt;/div&amp;gt;
                                &amp;lt;/div&amp;gt; 

                              
                                 &amp;lt;div class=&quot;form-group&quot;&amp;gt;
                                    &amp;lt;label class=&quot;col-md-3 col-xs-12 control-label&quot;&amp;gt;NAME CLIENT :&amp;lt;/label&amp;gt;
                                    &amp;lt;div class=&quot;col-md-6 col-xs-12&quot;&amp;gt;                                            
                                        &amp;lt;div class=&quot;input-group&quot;&amp;gt;
                                            &amp;lt;span class=&quot;input-group-addon&quot;&amp;gt;...&amp;lt;span class=&quot;fa fa-pencil&quot;&amp;gt;&amp;lt;/span&amp;gt;&amp;lt;/span&amp;gt;
                                            &amp;lt;input type=&quot;text&quot; name=&quot;item_name&quot; class=&quot;form-control&quot; required/&amp;gt;
                                        &amp;lt;/div&amp;gt;                
                                    &amp;lt;/div&amp;gt;
                                &amp;lt;/div&amp;gt; 
                                
                                  &amp;lt;div class=&quot;form-group&quot;&amp;gt;
                                    &amp;lt;label class=&quot;col-md-3 col-xs-12 control-label&quot;&amp;gt;MAC ADDRESS :&amp;lt;/label&amp;gt;
                                    &amp;lt;div class=&quot;col-md-6 col-xs-12&quot;&amp;gt;                                            
                                        &amp;lt;div class=&quot;input-group&quot;&amp;gt;
                                            &amp;lt;span class=&quot;input-group-addon&quot;&amp;gt;...&amp;lt;span class=&quot;fa fa-pencil&quot;&amp;gt;&amp;lt;/span&amp;gt;&amp;lt;/span&amp;gt;
                                            &amp;lt;input type=&quot;text&quot; name=&quot;mac&quot; class=&quot;form-control&quot; required/&amp;gt;
                                        &amp;lt;/div&amp;gt;                
                                    &amp;lt;/div&amp;gt;
                                &amp;lt;/div&amp;gt; 
                                
                                &amp;lt;div class=&quot;form-group&quot;&amp;gt;
                                    &amp;lt;label class=&quot;col-md-3 col-xs-12 control-label&quot;&amp;gt;CONTRACT :&amp;lt;/label&amp;gt;
                                    &amp;lt;div class=&quot;col-md-6 col-xs-12&quot;&amp;gt;                                            
                                        &amp;lt;div class=&quot;input-group&quot;&amp;gt;
                                            &amp;lt;span class=&quot;input-group-addon&quot;&amp;gt;...&amp;lt;span class=&quot;fa fa-pencil&quot;&amp;gt;&amp;lt;/span&amp;gt;&amp;lt;/span&amp;gt;
                                            &amp;lt;input type=&quot;text&quot; name=&quot;beggining&quot; class=&quot;form-control&quot; required/&amp;gt;
                                        &amp;lt;/div&amp;gt;                
                                    &amp;lt;/div&amp;gt;
                                &amp;lt;/div&amp;gt; 
                                
                                &amp;lt;div class=&quot;form-group&quot;&amp;gt;
                                    &amp;lt;label class=&quot;col-md-3 col-xs-12 control-label&quot;&amp;gt;PRICE :&amp;lt;/label&amp;gt;
                                    &amp;lt;div class=&quot;col-md-6 col-xs-12&quot;&amp;gt;                                            
                                        &amp;lt;div class=&quot;input-group&quot;&amp;gt;
                                            &amp;lt;span class=&quot;input-group-addon&quot;&amp;gt;{ &amp;lt;span class=&quot;fa fa-dollar&quot;&amp;gt; }&amp;lt;/span&amp;gt;&amp;lt;/span&amp;gt;
                                            &amp;lt;input type=&quot;text&quot; name=&quot;sale_price&quot; class=&quot;form-control&quot; required/&amp;gt;
                                        &amp;lt;/div&amp;gt;                
                                    &amp;lt;/div&amp;gt;
                                &amp;lt;/div&amp;gt; 
                                
                                
                                 &amp;lt;div class=&quot;form-group&quot;&amp;gt;                                        
                                            &amp;lt;label class=&quot;col-md-3 col-xs-12 control-label&quot;&amp;gt;COUNTRY :&amp;lt;/label&amp;gt;
                                           &amp;lt;div class=&quot;col-md-6 col-xs-12&quot; &amp;gt;
                                                &amp;lt;?php
                                                $sql = &quot;SELECT * FROM opt&quot;;
                                                $result = mysql_query($sql);
                                                echo&#039;&amp;lt;select name=&quot;country&quot; class=&quot;form-control select&quot; &amp;gt;&#039;;
                                                while ($row = mysql_fetch_array($result)) {  
                                                      echo &quot;&amp;lt;option value=&quot;.$row[&#039;country&#039;].&quot;&amp;gt;&quot;.$row[&#039;country&#039;].&quot;&amp;lt;/option&amp;gt;&quot;;

                                                    } 
                                                echo&#039;&amp;lt;/select&amp;gt;&#039;;
                                                echo&#039;&amp;lt;/div&amp;gt;&#039;;                                             
                                                echo&#039;&amp;lt;/div&amp;gt;&#039;;
                                                ?&amp;gt;
                                    
                                     
                                      &amp;lt;div class=&quot;form-group&quot;&amp;gt;                                        
                                            &amp;lt;label class=&quot;col-md-3 col-xs-12 control-label&quot;&amp;gt;DEVICE :&amp;lt;/label&amp;gt;
                                           &amp;lt;div class=&quot;col-md-6 col-xs-12&quot; &amp;gt;
                                                &amp;lt;?php
                                                $sql = &quot;SELECT * FROM opt&quot;;
                                                $result = mysql_query($sql);
                                                echo&#039;&amp;lt;select name=&quot;device&quot; class=&quot;form-control select&quot; &amp;gt;&#039;;
                                                while ($row = mysql_fetch_array($result)) {  
                                                      echo &quot;&amp;lt;option value=&quot;.$row[&#039;device&#039;].&quot;&amp;gt;&quot;.$row[&#039;device&#039;].&quot;&amp;lt;/option&amp;gt;&quot;;

                                                    } 
                                                echo&#039;&amp;lt;/select&amp;gt;&#039;;
                                                echo&#039;&amp;lt;/div&amp;gt;&#039;;                                             
                                                echo&#039;&amp;lt;/div&amp;gt;&#039;;
                                                ?&amp;gt;
                                     &amp;lt;/div&amp;gt;
                                      
                                    
                        &amp;lt;br&amp;gt;&amp;lt;br&amp;gt;&amp;lt;br&amp;gt;&amp;lt;br&amp;gt;
                         &amp;lt;div class=&quot;panel-footer&quot;&amp;gt; 
                               &amp;lt;input type=&quot;reset&quot; class=&quot;btn btn-default&quot; value=&quot;CLEAR FORM&quot; &amp;gt;       
                              &amp;lt;input type=&quot;submit&quot; name=&quot;submit&quot; id=&quot;save&quot; class=&quot;btn btn-primary pull-right&quot; value=&quot;SAVE&quot; &amp;gt;
                        &amp;lt;/div&amp;gt;
                       
                    &amp;lt;/div&amp;gt;
                &amp;lt;/div&amp;gt;
                 &amp;lt;/form&amp;gt;

                &amp;lt;!-- END CONTENT FRAME BODY ------------------------------------------------------------------------------------------------------&amp;gt;
            &amp;lt;/div&amp;gt;
            &amp;lt;!-- END CONTENT FRAME --&amp;gt;              
        &amp;lt;/div&amp;gt;            
        &amp;lt;!-- END PAGE CONTENT --&amp;gt;
    &amp;lt;/div&amp;gt;
    &amp;lt;!-- END PAGE CONTAINER --&amp;gt;

    &amp;lt;!-- MESSAGE BOX--&amp;gt;
    &amp;lt;div class=&quot;message-box animated fadeIn&quot; data-sound=&quot;alert&quot; id=&quot;mb-signout&quot;&amp;gt;
        &amp;lt;div class=&quot;mb-container&quot;&amp;gt;
            &amp;lt;div class=&quot;mb-middle&quot;&amp;gt;
                &amp;lt;div class=&quot;mb-title&quot;&amp;gt;&amp;lt;span class=&quot;fa fa-sign-out&quot;&amp;gt;&amp;lt;/span&amp;gt; Log &amp;lt;strong&amp;gt;Out&amp;lt;/strong&amp;gt; ?&amp;lt;/div&amp;gt;
                &amp;lt;div class=&quot;mb-content&quot;&amp;gt;
                    &amp;lt;p&amp;gt;Are you sure you want to log out?&amp;lt;/p&amp;gt;                    
                    &amp;lt;p&amp;gt;Press No if youwant to continue work. Press Yes to logout current user.&amp;lt;/p&amp;gt;
                &amp;lt;/div&amp;gt;
                &amp;lt;div class=&quot;mb-footer&quot;&amp;gt;
                    &amp;lt;div class=&quot;pull-right&quot;&amp;gt;
                        &amp;lt;a href=&quot;pages-login.html&quot; class=&quot;btn btn-success btn-lg&quot;&amp;gt;Yes&amp;lt;/a&amp;gt;
                        &amp;lt;button class=&quot;btn btn-default btn-lg mb-control-close&quot;&amp;gt;No&amp;lt;/button&amp;gt;
                    &amp;lt;/div&amp;gt;
                &amp;lt;/div&amp;gt;
            &amp;lt;/div&amp;gt;
        &amp;lt;/div&amp;gt;
    &amp;lt;/div&amp;gt;
    &amp;lt;!-- END MESSAGE BOX--&amp;gt;

    &amp;lt;!-- START PRELOADS --&amp;gt;
    &amp;lt;audio id=&quot;audio-alert&quot; src=&quot;audio/alert.mp3&quot; preload=&quot;auto&quot;&amp;gt;&amp;lt;/audio&amp;gt;
    &amp;lt;audio id=&quot;audio-fail&quot; src=&quot;audio/fail.mp3&quot; preload=&quot;auto&quot;&amp;gt;&amp;lt;/audio&amp;gt;
    &amp;lt;!-- END PRELOADS --&amp;gt;                 
    
&amp;lt;!-- START SCRIPTS --&amp;gt;
    &amp;lt;!-- START PLUGINS --&amp;gt;
    &amp;lt;script type=&quot;text/javascript&quot; src=&quot;js/plugins/jquery/jquery.min.js&quot;&amp;gt;&amp;lt;/script&amp;gt;
    &amp;lt;script type=&quot;text/javascript&quot; src=&quot;js/plugins/jquery/jquery-ui.min.js&quot;&amp;gt;&amp;lt;/script&amp;gt;
    &amp;lt;script type=&quot;text/javascript&quot; src=&quot;js/plugins/bootstrap/bootstrap.min.js&quot;&amp;gt;&amp;lt;/script&amp;gt;        
    &amp;lt;!-- END PLUGINS --&amp;gt;

    &amp;lt;!-- THIS PAGE PLUGINS --&amp;gt;

    &amp;lt;!-- END PAGE PLUGINS --&amp;gt;         

    &amp;lt;!-- START TEMPLATE --&amp;gt;
    &amp;lt;script type=&quot;text/javascript&quot; src=&quot;js/plugins.js&quot;&amp;gt;&amp;lt;/script&amp;gt;        
    &amp;lt;script type=&quot;text/javascript&quot; src=&quot;js/actions.js&quot;&amp;gt;&amp;lt;/script&amp;gt;  
        &amp;lt;script type=&#039;text/javascript&#039; src=&#039;js/plugins/icheck/icheck.min.js&#039;&amp;gt;&amp;lt;/script&amp;gt;
    &amp;lt;script type=&quot;text/javascript&quot; src=&quot;js/plugins/mcustomscrollbar/jquery.mCustomScrollbar.min.js&quot;&amp;gt;&amp;lt;/script&amp;gt;
    
    
    &amp;lt;script type=&quot;text/javascript&quot; src=&quot;js/plugins/bootstrap/bootstrap-select.js&quot;&amp;gt;&amp;lt;/script&amp;gt;
    
    &amp;lt;!-- start disable submite----------------------------------------------------------------------------------------------------- --&amp;gt; 
    &amp;lt;script&amp;gt;
    $(&quot;#save&quot;).mousedown(function(){

$(this).attr('disabled','disabled'); }); &lt;/script&gt; &lt;!-- end disable submite----------------------------------------------------------------------------------------------------- --&gt;

    &amp;lt;!-- END TEMPLATE --&amp;gt;
&amp;lt;!-- END SCRIPTS --&amp;gt;         
&amp;lt;/body&amp;gt;

&lt;/html&gt;

</pre>

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 5 tahun yang lalu

@ciloxz please bantu donkkk gan

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 5 tahun yang lalu

<pre>
$("#save").mousedown(function(){ </pre>

ganti dengan ini

<pre>
$("#save").click(function(){ </pre>

avatar ciloxz
@ciloxz

284 Kontribusi 139 Poin

Dipost 5 tahun yang lalu

datanya gk bisa masuk gann

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 5 tahun yang lalu

gk bisa masuk gimana ?

avatar ciloxz
@ciloxz

284 Kontribusi 139 Poin

Dipost 5 tahun yang lalu

data nya gk bisa masuk ke data base @ciloxz

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 5 tahun yang lalu

@Bintangjav69 waduhh maaf masih pelajar gann ..

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 5 tahun yang lalu

Login untuk ikut Jawaban