cara mengatasi double submit ketika refress

mohon bantuannya gimna cara mengatasi double imput data ketika internet lemot dan refress dah nyoba cara di google hasilnya error teruss form

 <div class="form-group">
   <label class="col-md-3 col-xs-12 control-label">SAP 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 name="stockno" type="text" onkeyup='autoComplete();' id="inputan" class="form-control" placeholder="......" required><div id='hasil'></div>
                                            </div>
                                        </div>
                                    </div>


  <div class="form-group">
  <label class="col-md-3 col-xs-12 control-label">DESCRIPTION :</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"  class="form-control" id="item_name" placeholder="......" required>
                                            </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-pencil"></span></span>
<input type="text"  class="form-control" id="location" placeholder="......" required>
                                            </div>
                                        </div>
                                    </div>


                                      <div class="form-group">
  <label class="col-md-3 col-xs-12 control-label">STOCK :</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"  class="form-control" id="sap" placeholder="......" required>
                                            </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-pencil"></span></span>
<input type="text"  class="form-control" id="unit" placeholder="......" required>
                                            </div>
                                        </div>
                                    </div>



<div class="form-group">
<label class="col-md-3 col-xs-12 control-label">QTY ACT :</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="act" class="form-control"  placeholder="......" required>
                                            </div>
                                        </div>
                                    </div>



<div class="panel-footer">

<input type="submit" name='submit' class="btn btn-primary pull-right" value="ADD STOCK" >

                                        </div>
                                      </div>
                                    </div>
                                  </form>
                    <!-- END CONTENT FRAME BODY -->

prosess



<?php

    include_once '../connection.php';    //memanggil data base
if(isset($_GET['stockno']))             //memanggil menggunakan stockno
{
$stockno= $_GET['stockno'];

$act = $_GET['act'];
$qq = $act;


}

                                    // Set path folder tempat menyimpan fotonya

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

                             //memanggil isi data kolom sap and act berdasarkan stockno di tb stock_in

$result1 = mysql_query("SELECT * from stock_in where stockno = ".$stockno." ");
while($row = mysql_fetch_array($result1))
{
$update=$row['act'];




}

}

                                 //menjumlahkan nilai qty yg ada dengan qty yang baru

$sql = mysql_query("UPDATE  stock_in SET act=($qq + $update) WHERE stockno='$stockno'");

                                //alrm jika data sudah masuk

        $retval = mysql_query( $sql);
              echo'<script>';
              echo'alert("DONE...!");';
              echo'window.location.href="sp_inv.php";';
              echo'</script>';



              $result3 = mysql_query("SELECT * from stock_in where stockno = ".$stockno." ");
while($row = mysql_fetch_array($result3))
{
$ac=$row['act'];
$sa=$row['sap'];
$deff=$ac - $sa;


}

mysql_query("UPDATE  stock_in SET deff=$deff WHERE stockno='$stockno'");


?>

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Diperbarui 5 tahun yang lalu

2 Jawaban:

pakai ajax untuk disable button before send atau kalau tetap mau pakai php, buat session random dan unset setiap submit

avatar willeylim
@willeylim

3 Kontribusi 0 Poin

Dipost 5 tahun yang lalu

beri contoh gan alnya saya baru belajar gk begituu pahamm

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 5 tahun yang lalu

Login untuk ikut Jawaban