Postingan lainnya
Kelas Premium!
Belajar bikin website dari nol sekarang
Gunakan kupon "lebihcepat" untuk diskon 25%!
Aksi Hapus Tidak Berfungsi
Malam Agan agan, ane mau minta bantuan nih, jadi operasi hapus saya tidak berfungsi dan menampilkan error seperti ini
Dan ini Kodingan nya, bisa dilihat di bagian hapusData, mohon pencerahan nya ya agan agan
<?php
session_start();
if(isset($_SESSION['username']) AND isset($_SESSION['password'])){
$p=$_GET['p'];
$action=$_GET['action'];
include"appConfig/conn.php";
if($p=="boking" AND $action=="tambah-boking"){
$validasi = mysql_query("SELECT * FROM tbl_bokingstd WHERE id_session='$_SESSION[username]'");
$ketemu=mysql_num_rows($validasi);
if($ketemu > 0){
echo"
<script language='javascript'>
window.alert('Maaf, Anda Hanya Dapat Melakukan 1 Kali Boking Studio ');
window.location=('frame.php?p=keranjang-boking')
</script>
";
}else{
$jadwal=mysql_query("SELECT * FROM tbl_jadwal,tbl_studio,tbl_jam WHERE
tbl_jadwal.kode_studio=tbl_studio.kode_studio AND
tbl_jadwal.kode_jam=tbl_jam.kode_jam AND tbl_jadwal.kode_jadwal='$_GET[id]'")or die(mysql_error());
$_data=mysql_fetch_array($jadwal);
$subtotal=$_data['harga'] *1;
$SQL="INSERT INTO tbl_bokingstd (kode_jadwal,no_studio,tgl_bokingstudio,
jam_bokingstudio,harga_studio,sub_totalstudio,id_session)
VALUES('$_data[kode_jadwal]','$_data[no_studio]','$_data[tgl_jadwal]','$_data[jam]','$_data[harga]',
'$subtotal','$_SESSION[username]')";
mysql_query($SQL) or die(mysql_error());
echo"
<script language='javascript'>
window.alert('Data Berhasil Disimpan');
window.location=('frame.php?p=keranjang-boking')
</script>
";
}
}elseif($p=="boking" AND $action=="hapusData"){
mysql_query("DELETE FROM tbl_bokingstd WHERE id_session='$_SESSION[username]'");
echo"
<script language='javascript'>
window.alert('Data Berhasil Disimpan');
window.location=('index.php')
</script>
";
4 Jawaban:
itu $_GET['p'] nya undefined, coba cek apa benar dengan method get?
Coba cek methodnya pake get apa post di formnya. Klo pake get, cek di urlnya bener gk nama keynya p.
ini kodingan di form keranjang boking nya di liat dari url nya sih bener gan. <pre> <div class="container"> <div class="jumbotron text-center bg-transparent margin-none"> <h1>KERANJANG BOKING ANDA</h1> <p></p> </div> <div class="page-section"> <div class="row"> <div class="col-md-12 col-lg-12"> <h4 class="page-section-heading"> DAFTAR RINCIAN KERANJANG BOKING</h4> <div class="panel panel-default"> <!-- Data table --> <table class="table"> <tbody> <tr> <td colspan="6" align="left"> <?php $query=mysql_query("SELECT MAX(no_invoice) As no_invoice FROM tbl_boking"); $kode=mysql_fetch_array($query); $kodeJadi=$kode["no_invoice"]; $noOrder=(int)substr($kodeJadi,4,6); $noOrder++; $char = "INV-"; $newID = $char . sprintf("%06s", $noOrder); echo"<label class='label label-danger'><h5><font color='#FFFFFF'>INVOICE : <strong># $newID </font></strong></h5></label>"; ?>
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;No&lt;/td&gt;
&lt;td&gt;Tgl Jadwal&lt;/td&gt;
&lt;td&gt;Nomor Studio&lt;/td&gt;
&lt;td&gt;Jam&lt;/td&gt;
&lt;td&gt;Harga&lt;/td&gt;
&lt;td&gt;Aksi&lt;/td&gt;
&lt;/tr&gt;
&lt;?php
$boking=mysql_query("SELECT * FROM tbl_bokingstd WHERE id_session='$_SESSION[username]'");
$no=1;
while($_data=mysql_fetch_array($boking)){
$tgl=region($_data['tgl_bokingstudio']);
$harga=idr_f($_data['harga_studio']);
echo"
&lt;tr&gt;
&lt;td&gt;$no&lt;/td&gt;
&lt;td&gt;$tgl&lt;/td&gt;
&lt;td&gt;$_data[no_studio]&lt;/td&gt;
&lt;td&gt;$_data[jam_bokingstudio]&lt;/td&gt;
&lt;td&gt;$harga&lt;/td&gt;
&lt;td&gt; &lt;a href='prosesBoking.php?load=boking&action=hapusData&id=$_data[kode_bokingstd]' tclass='btn btn-danger btn-xs' data-toggle='tooltip' data-placement='top' title='' data-original-title='Delete'&gt;&lt;i class='fa fa-times'&gt;&lt;/i&gt;&lt;/a&gt;&lt;/td&gt;
&lt;/tr&gt;g
";
}
?&gt;
&lt;tr&gt;
&lt;td colspan="3"&gt;&nbsp;&lt;/td&gt;
&lt;td&gt;&lt;h3&gt;&lt;strong&gt;TOTAL BAYAR&lt;/strong&gt;&lt;/h3&gt;&lt;/td&gt;
&lt;?php
$Total = mysql_query("SELECT SUM(sub_totalstudio) AS subtotal FROM tbl_bokingstd WHERE id_session='$_SESSION[username]'");
$tot=mysql_fetch_array($Total);
$tott=$tot['subtotal'];
$totRp=idr_f($tott);
echo"&lt;td colspan='2'&gt;&lt;label class='label label-primary'&gt;&lt;h4&gt;&lt;strong&gt;Rp. $totRp&lt;/strong&gt;&lt;/h4&gt;&lt;/label&gt;&lt;/td&gt;";
?&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td colspan="6" align="right"&gt;
&lt;a href='?p=rincian-data-boking'&gt; &lt;button class="btn btn-success"&gt;Lanjutkan Transaksi&lt;/button&gt; &lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;/div&gt;
</pre>
Jawaban Terpilih
itu agan di querynya salah <pre> $tot=mysql_fetch_array($Total); $tott=$tot['subtotal']; // harusnya $tot=mysql_fetch_assoc($Total); $tott=$tot['subtotal']; </pre> sama semuanya yg pake mysql_fetch_array ganti jadi mysql_fetch_assoc semoga membantu ^^