Postingan lainnya
Cara menghapus file/gambar lebih dari satu menggunakan checkbox
master nanya ni kenapa file/gambarnya tidak dihapus sesuai permintaan contoh ada 4 item ketika dihapus menggunakan all checkbox file/gambarnya yg di foldernya hanya satu terhapus klo datanya normal bisa terhapus semua di data base
<!-- form.php-->
<?php
echo '<div class="panel-body">';
$result1 = mysql_query("SELECT * from data_barang");
echo '<br> ';
echo '<form name="form" action="hapus_barang" method="post" onsubmit="return deleteConfirm();"/>';
echo '<div class="table_container">';
echo '<table class="table datatable">';
echo '<thead>';
echo '<tr>';
echo '<th><input type="checkbox" name="select_all" id="select_all" value=""/></th>';
echo '<th width="7%">No.</th>';
echo '<th width="10%">ITEM CODE</th>';
echo ' <th width="38%">DESCRIPTION</th>';
echo '<th width="10%">MODEL</th> ';
echo '<th width="10%">CATEGORY</th> ';
echo '<th width="5%">QTY</th> ';
echo '<th width="5%">UNIT</th> ';
echo '<th width="8%">LOCATION</th> ';
echo '<th width="7%">ACTION</th> ';
echo '</tr>';
echo '</thead>';
echo '<tbody>';
while($row = mysql_fetch_array($result1)){
echo '<tr>';
echo "<td><input type='checkbox' name='checked_id[]' class='checkbox' value='".$row['id']."'/></td>";
echo "<td >" . $row["id"] . "</td>";
echo "<td>" . $row["new_code"] . "</td>";
echo "<td>" . $row["description"] . "</td>";
echo "<td>" . $row["model"] . "</td>";
echo "<td>" . $row["category"] ."</td>";
echo "<td>" . $row["qty"] ."</td>";
echo "<td>" . $row["unit"] ."</td>";
echo "<td>" . $row["location"] ."</td>";
echo "<td>
<a href='#myModal'id='custId' data-toggle='modal' data-id=".$row['id']."><span class='btn btn-success' data-toggle='tooltip' data-placement='top' title='detail item'>Detail</span></a>
</td>";
echo'</tr>';
}
echo'</tbody>';
echo'</table>';
echo'<input type="submit" class="btn btn-danger" name="delete_submit" value="Hapus"/>';
echo'</form>';
echo'</div>';
echo'</div>';
echo'</div>';
?>
<!-- proses.php-->
<?php
require_once"kon.php";
if(isset($_POST['delete_submit'])){
$idArr = $_POST['checked_id'];
$foto_lama = $_POST['foto_lama'];
$files = glob('../images/*'.$foto_lama);
foreach($files as $file){
if(is_file($file))
unlink ($file);
}
foreach($idArr as $id){
mysqli_query($conn,"DELETE FROM data_barang WHERE id=".$id);
}
#mengurutkan kembali no yang dihapus
#start code
$h="SELECT * FROM data_barang ORDER BY id";
$hasil= mysql_query($h);
$no=1;
while ($dataa = mysql_fetch_array($hasil))
{
$id=$dataa['id'];
$h2="UPDATE data_barang SET id=$no WHERE id= $id";
mysql_query($h2);
$no++;
}
$h="ALTER TABLE data_barang AUTO_INCREMENT = $no";
mysql_query($h);
#end code
echo '<script>';
echo "alert('Removed');";
echo'window.location.href="barang";';
echo "</script>";
}
?>
4 Jawaban:
Pada saat loop gambar dan checkboxnya, anggaplah strukturnya seperti ini:
<pre> <div class="checkbox-wrapper"> <input type="checkbox" name="value"/> <img src="img.png"/> </div> </pre>
Bikin "value" dari checkbox nya punya nilai yang sama dengan gambarnya, jadi nanti pada saat formnya disubmit, kamu ambil value dari checkbox yang tercheck, seperti form biasa, dan nanti menghapus gambar berdasarkan nama dari value itu
<pre> <?php echo '<div class="panel-body">'; $result1 = mysql_query("SELECT * from data_barang");
echo '&lt;br&gt; ';
echo '&lt;form name="form" action="hapus_barang" method="post" onsubmit="return deleteConfirm();"/&gt;';
echo '&lt;div class="table_container"&gt;';
echo '&lt;table class="table datatable"&gt;';
echo '&lt;thead&gt;';
echo '&lt;tr&gt;';
echo '&lt;th&gt;&lt;input type="checkbox" name="select_all" id="select_all" value=""/&gt;&lt;/th&gt;';
echo '&lt;th width="7%"&gt;No.&lt;/th&gt;';
echo '&lt;th width="10%"&gt;ITEM CODE&lt;/th&gt;';
echo ' &lt;th width="38%"&gt;DESCRIPTION&lt;/th&gt;';
echo '&lt;th width="10%"&gt;MODEL&lt;/th&gt; ';
echo '&lt;th width="10%"&gt;CATEGORY&lt;/th&gt; ';
echo '&lt;th width="5%"&gt;QTY&lt;/th&gt; ';
echo '&lt;th width="5%"&gt;UNIT&lt;/th&gt; ';
echo '&lt;th width="8%"&gt;LOCATION&lt;/th&gt; ';
echo '&lt;th width="7%"&gt;ACTION&lt;/th&gt; ';
echo '&lt;/tr&gt;';
echo '&lt;/thead&gt;';
echo '&lt;tbody&gt;';
while($row = mysql_fetch_array($result1)){
echo '&lt;tr&gt;';
echo "<td><input type='checkbox' name='checked_id[]' class='checkbox' value='".$row['id']."'/></td>";
echo "&lt;td &gt;" . $row["id"] . "&lt;/td&gt;";
echo "&lt;td&gt;" . $row["new_code"] . "&lt;/td&gt;";
echo "&lt;td&gt;" . $row["description"] . "&lt;/td&gt;";
echo "&lt;td&gt;" . $row["model"] . "&lt;/td&gt;";
echo "&lt;td&gt;" . $row["category"] ."&lt;/td&gt;";
echo "&lt;td&gt;" . $row["qty"] ."&lt;/td&gt;";
echo "&lt;td&gt;" . $row["unit"] ."&lt;/td&gt;";
echo "&lt;td&gt;" . $row["location"] ."&lt;/td&gt;";
echo "<td>
<a href='#myModal'id='custId' data-toggle='modal' data-id=".$row['new_code']."><span class='btn btn-success' data-toggle='tooltip' data-placement='top' title='detail item'>Detail</span></a>
</td>"; echo'</tr>'; } echo'</tbody>'; echo'</table>'; echo'<input type="submit" class="btn btn-danger" name="delete_submit" value="Hapus"/>';
echo'&lt;/form&gt;';
echo'&lt;/div&gt;';
echo'&lt;/div&gt;';
echo'&lt;/div&gt;';
?&gt;
</pre>
hapus.php
<pre> <?php require_once"kon.php";
if(isset($_POST['delete_submit'])){
$idArr = $_POST['checked_id'];
$foto_lama = $_POST['foto_lama'];
$files = glob('../images/*'.$foto_lama);
foreach($files as $file){
if(is_file($file))
unlink ($file);
}
foreach($idArr as $id){
mysqli_query($conn,"DELETE FROM data_barang WHERE id=".$id);
}
#mengurutkan kembali no yang dihapus
#start code
$h="SELECT * FROM data_barang ORDER BY id";
$hasil= mysql_query($h);
$no=1;
while ($dataa = mysql_fetch_array($hasil))
{
$id=$dataa['id'];
$h2="UPDATE data_barang SET id=$no WHERE id= $id";
mysql_query($h2);
$no++;
}
$h="ALTER TABLE data_barang AUTO_INCREMENT = $no";
mysql_query($h);
#end code
echo '<script>'; echo "alert('Removed');"; echo'window.location.href="barang";'; echo "</script>"; }
?&gt;
</pre>
gimana gan cara loop gambarnya msalah nya ketika di hapus lebih dari satu gambarnya hanya satu yg terhapuss....contoh 4 item mau dihapus menggunakan check all ketika diproses gambar yg di foldernya hanya kehapus satu seharusnya ke hapus semua sesuai permintaann klo data yg di data basenya sih normal kehapus semua sesuai permintaaann..saya coba lagi 4 item saya selecsi hanya no 2 dan tiga dihapus masih juga kaya gitu gambarnya hanya satu terhapus data nya sih normal gak masalah
Tanggapan
halo, coba forumnya dibikin rapi ya.. masukkan info pertanyaan ke baian "pertanyaan" gunakan "jawaban" khusus untuk menjawab
maksudnya gimanaa gan...
ada kolom "jawaban" ada kolom "pertanyaan".. kalau kamu mau bertanya atau mengubah pertanyaan klik "edit pertanyaan" di atas, bukan di jawaban
maaf gan..mohon bantu gan.. gak ketemu ketemuu ni
mohon dibantu dong gan
silahkan dirapikan gan pertnayaannya, biar mudah dibaca, tolong baca catatan sebelumnya