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>";
    }

    ?>

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Diperbarui 4 tahun yang lalu

4 Jawaban:

Pada saat loop gambar dan checkboxnya, anggaplah strukturnya seperti ini:

<pre> &lt;div class="checkbox-wrapper"&gt; &lt;input type="checkbox" name="value"/&gt; &lt;img src="img.png"/&gt; &lt;/div&gt; </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

avatar hilmanski
@hilmanski

2670 Kontribusi 2132 Poin

Dipost 4 tahun yang lalu

<pre> &lt;?php echo '&lt;div class="panel-body"&gt;'; $result1 = mysql_query("SELECT * from data_barang");

                                        echo &#039;&amp;lt;br&amp;gt; &#039;;
       echo &#039;&amp;lt;form name=&quot;form&quot; action=&quot;hapus_barang&quot; method=&quot;post&quot; onsubmit=&quot;return deleteConfirm();&quot;/&amp;gt;&#039;;
										echo &#039;&amp;lt;div class=&quot;table_container&quot;&amp;gt;&#039;;
                                        echo &#039;&amp;lt;table class=&quot;table datatable&quot;&amp;gt;&#039;;
                                        echo &#039;&amp;lt;thead&amp;gt;&#039;;
                                        echo &#039;&amp;lt;tr&amp;gt;&#039;;
              echo &#039;&amp;lt;th&amp;gt;&amp;lt;input type=&quot;checkbox&quot; name=&quot;select_all&quot; id=&quot;select_all&quot; value=&quot;&quot;/&amp;gt;&amp;lt;/th&amp;gt;&#039;;
                                        echo &#039;&amp;lt;th width=&quot;7%&quot;&amp;gt;No.&amp;lt;/th&amp;gt;&#039;;
                                        echo &#039;&amp;lt;th width=&quot;10%&quot;&amp;gt;ITEM CODE&amp;lt;/th&amp;gt;&#039;;
                                        echo &#039; &amp;lt;th width=&quot;38%&quot;&amp;gt;DESCRIPTION&amp;lt;/th&amp;gt;&#039;;
                                        echo &#039;&amp;lt;th width=&quot;10%&quot;&amp;gt;MODEL&amp;lt;/th&amp;gt; &#039;;
                                        echo &#039;&amp;lt;th width=&quot;10%&quot;&amp;gt;CATEGORY&amp;lt;/th&amp;gt; &#039;;
										echo &#039;&amp;lt;th width=&quot;5%&quot;&amp;gt;QTY&amp;lt;/th&amp;gt; &#039;;
                                        echo &#039;&amp;lt;th width=&quot;5%&quot;&amp;gt;UNIT&amp;lt;/th&amp;gt; &#039;;
										echo &#039;&amp;lt;th width=&quot;8%&quot;&amp;gt;LOCATION&amp;lt;/th&amp;gt; &#039;;
                                        echo &#039;&amp;lt;th width=&quot;7%&quot;&amp;gt;ACTION&amp;lt;/th&amp;gt; &#039;;
                                        echo &#039;&amp;lt;/tr&amp;gt;&#039;;
                                        echo &#039;&amp;lt;/thead&amp;gt;&#039;;
                                        echo &#039;&amp;lt;tbody&amp;gt;&#039;;
                                        while($row = mysql_fetch_array($result1)){
                                        echo &#039;&amp;lt;tr&amp;gt;&#039;;

echo "&lt;td&gt;&lt;input type='checkbox' name='checked_id[]' class='checkbox' value='".$row['id']."'/&gt;&lt;/td&gt;";

                                        echo &quot;&amp;lt;td &amp;gt;&quot; . $row[&quot;id&quot;] . &quot;&amp;lt;/td&amp;gt;&quot;; 
                                        echo &quot;&amp;lt;td&amp;gt;&quot; . $row[&quot;new_code&quot;] . &quot;&amp;lt;/td&amp;gt;&quot;; 
                                        echo &quot;&amp;lt;td&amp;gt;&quot; . $row[&quot;description&quot;] . &quot;&amp;lt;/td&amp;gt;&quot;;
										echo &quot;&amp;lt;td&amp;gt;&quot; . $row[&quot;model&quot;] . &quot;&amp;lt;/td&amp;gt;&quot;; 
										echo &quot;&amp;lt;td&amp;gt;&quot; . $row[&quot;category&quot;] .&quot;&amp;lt;/td&amp;gt;&quot;;
										echo &quot;&amp;lt;td&amp;gt;&quot; . $row[&quot;qty&quot;] .&quot;&amp;lt;/td&amp;gt;&quot;;
										echo &quot;&amp;lt;td&amp;gt;&quot; . $row[&quot;unit&quot;] .&quot;&amp;lt;/td&amp;gt;&quot;;
										echo &quot;&amp;lt;td&amp;gt;&quot; . $row[&quot;location&quot;] .&quot;&amp;lt;/td&amp;gt;&quot;;

echo "&lt;td&gt;

&lt;a href='#myModal'id='custId' data-toggle='modal' data-id=".$row['new_code']."&gt;&lt;span class='btn btn-success' data-toggle='tooltip' data-placement='top' title='detail item'&gt;Detail&lt;/span&gt;&lt;/a&gt;

&lt;/td&gt;"; echo'&lt;/tr&gt;'; } echo'&lt;/tbody&gt;'; echo'&lt;/table&gt;'; echo'&lt;input type="submit" class="btn btn-danger" name="delete_submit" value="Hapus"/&gt;';

							echo&#039;&amp;lt;/form&amp;gt;&#039;;
						 echo&#039;&amp;lt;/div&amp;gt;&#039;;
                        echo&#039;&amp;lt;/div&amp;gt;&#039;;
                       echo&#039;&amp;lt;/div&amp;gt;&#039;;
                        ?&amp;gt;

</pre>

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 4 tahun yang lalu

hapus.php

<pre> &lt;?php require_once"kon.php";

 if(isset($_POST[&#039;delete_submit&#039;])){
	
    $idArr = $_POST[&#039;checked_id&#039;];
	$foto_lama = $_POST[&#039;foto_lama&#039;]; 
	
	$files = glob(&#039;../images/*&#039;.$foto_lama);
	foreach($files as $file){
		if(is_file($file))
		unlink ($file);
	}
	
	
    foreach($idArr as $id){
     mysqli_query($conn,&quot;DELETE FROM data_barang WHERE id=&quot;.$id);
    } 

    #mengurutkan kembali no yang dihapus
 #start code
 $h=&quot;SELECT * FROM data_barang ORDER BY id&quot;;
 $hasil= mysql_query($h);
 $no=1;
 while ($dataa = mysql_fetch_array($hasil))
 {
 $id=$dataa[&#039;id&#039;];
 $h2=&quot;UPDATE data_barang SET id=$no WHERE id= $id&quot;;
 mysql_query($h2);
 $no++;
 }
 $h=&quot;ALTER TABLE data_barang AUTO_INCREMENT = $no&quot;;
 mysql_query($h);
 #end code
 

echo '&lt;script&gt;'; echo "alert('Removed');"; echo'window.location.href="barang";'; echo "&lt;/script&gt;"; }

?&amp;gt;

</pre>

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 4 tahun yang lalu

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

avatar maulanamahdi
@maulanamahdi

109 Kontribusi 0 Poin

Dipost 4 tahun yang lalu

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

Login untuk ikut Jawaban