Chirurgia cranio-cerebrală minim invazivă
Tehnicile minim invazive impun utilizarea unei tehnologii ultramoderne. Endoscoapele operatorii de diverse tipuri, microscopul operator dedicat, neuronavigația, neuroelectrofiziologia, tehnicile avansate de anestezie, chirurgia cu pacientul treaz reprezintă armamentarium fără de care neurochirurgia prin "gaura cheii" nu ar fi posibilă. Folosind tehnicile de mai sus, tratăm un spectru larg de patologii cranio-cerebrale. www.neurohope.ro |
Problema sterge iteme din database PHP
Last Updated: Dec 29 2021 14:56, Started by
d3v1l500
, Dec 29 2021 13:52
·
0
#1
Posted 29 December 2021 - 13:52
Buna ziua, incep prin a spune ca sunt incepator si ca nu reusesc sa sterg date din baza de date cu php...
Acesta este codul meu... cand apas pe stergere item ma redirectioneaza la http://localhost/inc...g_id=586&do=yes eu fiind in http://localhost/inc...=slider_options ... in mod normal nu ar trebuie sa imi apara primul url ci doar sa-si dea refres pagina si sa stearga itemul... mentionez ca nu intra in nici un else... din partea asta de cod... if($_GET["section"] == "remove_img") { if(isset($_GET["img_id"]) && !empty($_GET["img_id"])) { $img_id = $_GET["img_id"]; if(isset($_GET["do"]) && $_GET["do"] == "yes") { $get_img_data = mysqli_query($con, "SELECT * FROM slider_imgs WHERE id='$img_id' LIMIT 1"); if(mysqli_num_rows($get_img_data) == 1) { $a = mysqli_fetch_assoc($get_img_data); $file_name = $a["file_name"]; $file_location = "admin/images/documente/$file_name"; if (file_exists($file_location)) { if(unlink($file_location)) { $delete_query = mysqli_query($con, "DELETE from slider_imgs WHERE id='$img_id'"); if($delete_query) { redirect("index.php?sb=documente&action=slider_options"); } else { echo mysqli_error($con); } } else { echo "<div class='text-center'>Nu sunt permisiuni de ștergere! (777 needed) <hr><a href='index.php?sb=documente&action=slider_options'>Înapoi</a></div>"; } } else { echo "<div class='text-center'>Imagine negăsită în folder! <hr><a href='index.php?sb=documente&action=slider_options'>Înapoi</a></div>"; } } else { echo "<div class='text-center'>Imagine negăsită! <hr><a href='index.php?sb=documente&action=slider_options'>Înapoi</a></div>"; } } } else { redirect("index.php?sb=documente&action=slider_options"); } } else { echo "<div class='text-center'>Secțiunea selectată nu există!</div>"; } <?php $logged = $_SESSION["user_id"]; if(isset($_GET["action"]) && !empty($_GET["action"])) { if($_GET["action"] == "slider_options") { ?> <?php if(!isset($_GET["section"]) && empty($_GET["section"])) { if(!isset($_POST["upload_imgs"])) { //arată formularul de încărcare + manager de fișiere ?> <form action="<?php echo $_SERVER["REQUEST_URI"];?>" method="POST" enctype="multipart/form-data"> <center> <select id='pagina' name="pagina" onchange="remember(this.selectedIndex);"> <option value="Acasa">Acasa</option> <option value="Noutati">Noutati</option> <option value="Istoric">Istoric</option> <option value="Invatamant_Liceal">Invatamant Liceal</option> <option value="Invatamant_Profesional">Invatamant Profesional</option> <option value="Invatamant_Profesional_Dual">Invatamant Profesional-Dual</option> <option value="Invatamant_postliceal">Invatamant Postliceal</option> <option value="Consiliul_de_Administratie">Consiliul de Administratie</option> <option value="Conducere_Liceu">Conducere Liceu</option> <option value="personal_didactic">Consiliul Profesoral</option> <option value="Documente_Manageriale">Documente Manageriale</option> <option value="Proceduri">Proceduri</option> <option value="Declaratii_de_Avere">Declaratii de Avere</option> <option value="Resurse_Educationale">Resurse Educationale</option> <option value="Documente_Profesori">Documente Profesori</option> <option value="Documente_Elevi">Documente Elevi</option> <option value="ROSE">R O S E</option> <option value="Let's_craft_what_we_think">Let's craft what we think</option> <option value="Eco_provocarea">Eco provocarea</option> <option value="Fii_Responsabil">Fii Responsabil</option> <option value="ERASMUS">ERASMUS</option> <option value="Examene">Examene</option> <option value="Revista">Revista</option> </select> </center> <script type="text/javascript"> if(localStorage!=null) { if(localStorage["sel"]!=null) { document.getElementById("pagina").selectedIndex = localStorage["sel"]; } } //alert("d"); function remember(index) { if(localStorage!=null) { localStorage["sel"] = index; } } </script> </br> <div class="custom-file" id="customFile" lang="ro"> <input name="imgs[]" type="file" class="custom-file-input" id="product_upload_file" aria-describedby="fileHelp"> <label class="custom-file-label" for="product_upload_file"> Alege documentul sau trage-l cu drag and drop </label> </div> <div id="preview"> </div> <script> function previewImages() { var preview = document.querySelector('#preview'); if (this.files) { [].forEach.call(this.files, readAndPreview); } function readAndPreview(file) { // Make sure `file.name` matches our extensions criteria if (!/\.(jpeg|jpg|png|gif|doc|docx|pdf|xls|txt|xlsx|rar|zip)$/i.test(file.name)) { return alert(file.name + " nu este un document suportat! "); } // else... var reader = new FileReader(); reader.addEventListener("load", function() { var image = new Image(); image.height = 100; image.width = 100; image.className = "img-thumbnail"; image.title = file.name; image.src = this.result; preview.appendChild(image); }); reader.readAsDataURL(file); } } document.querySelector('#product_upload_file').addEventListener("change", previewImages); </script> </br> <div class="text-center"> <button type="submit" name="upload_imgs" class="btn btn-sm btn-primary">Încarcă</button> </div> </form> </br> <?php $get_images = mysqli_query($con, "SELECT * FROM slider_imgs ORDER by id DESC "); if(mysqli_num_rows($get_images) > 0) { ?> <table> <thead> <tr> <th><label>#</label></th> <th><label>Nume fisier</label></th> <th><label>Pagina</label></th> <th><label>Incarcat de</label></th> <th><label>Data</label></th> <th><label>Sterge</label></th> <tbody> </tr> </thead> <?php while($a = mysqli_fetch_assoc($get_images)) { $img_id = $a["id"]; $file_name = $a["file_name"]; $img_name = $a["img_name"]; $date = $a["date"]; $ext = $a["ext"]; $loc = $a["loc"]; $uploaded_by = $a["uploaded_by"]; ?> <tr> <td data-label="#"><img src="images/documente/imagini/<?php echo $ext ?>.png " style="width: 50px; height:50px; object-fit: contain;"/></td> <td data-label="Nume Fisier"><a href="images/documente/<?php echo $file_name;?>"><?php echo $img_name;?></span></a></td> <td data-label="Pagina"><?php echo $loc;?></td> <td data-label="Incarcat de"><?php echo $uploaded_by;?></td> <td data-label="Data"><?php echo $date;?></td> <td data-label="Sterge"><button class="btn-invoice"><a href="index.php?sb=documente&action=slider_options§ion=remove_img&img_id=<?php echo $img_id;?>&do=yes"><span>Șterge rapid</span></a></button></td> </tr> <?php } ?> </table> <?php } else { echo "<div class='text-center'>Nu sunt documente! Încarcă!</div>"; } ?> </div> <?php } else { //Încarcare imagini ?> <div class="text-center"><a href="index.php?sb=documente&action=slider_options"></br><button type="button" class="btn btn-secondary"><center>Înapoi</center></button></a></div> <hr /> <div class="row text-center"> <?php function getExtension($str) { $i = strrpos($str,"."); if (!$i) { return ""; } $l = strlen($str) - $i; $ext = substr($str,$i+1,$l); return $ext; } define ("MAX_SIZE","9000"); //set the image extentions $valid_formats = array("jpg", "png", "gif", "bmp","jpeg","txt","doc","docx","xlsx","pdf","csv","rar","zip",); $directory = "admin/images/documente/"; $filecount = 0; $files = glob($directory . "*"); if ($files){ $filecount = count($files); } $uploaddir = "admin/images/documente/"; //image upload directory foreach ($_FILES['imgs']['name'] as $name => $value) { $filename = stripslashes($_FILES['imgs']['name'][$name]); $size=filesize($_FILES['imgs']['tmp_name'][$name]); //get the extension of the file in a lower case format $ext = getExtension($filename); $ext = strtolower($ext); $target = $uploaddir.$filecount."_".$filename; if(!file_exists($target)) { if(in_array($ext,$valid_formats)) { if ($size < (MAX_SIZE*10000)) { $img_name= $filename; $image_name= $filename; $image_name = str_replace(" ","-",$filecount."_".$image_name); echo "<div class='col-md-4'>"; echo "<img src='$uploaddir"."$image_name' style='width: 300px;height;300px; object-fit:contain;' class='img-thumbnail'>"; $newname=$uploaddir.$image_name; if (move_uploaded_file($_FILES['imgs']['tmp_name'][$name], $newname)) { $date = date("d-m-y"); $loc = "resurse_educationale_interne"; if(!isset($_POST["save"])) { $get_info = mysqli_query($con, "SELECT * from users WHERE id='$logged'"); $a = mysqli_fetch_assoc($get_info); $username = $a["username"]; $email = $a["email"]; $nume = $a["nume"]; $prenume = $a["prenume"]; $nr_tel = $a["nr_tel"]; $creat = $a["created_at"]; $modificat = $a["updated_at"]; $loged_user = $a["nume"]." ".$a["prenume"]; } //ouput status and insert inside the database $insert_to_db = mysqli_query($con, "INSERT into slider_imgs (file_name,img_name,loc,ext,uploaded_by,date) VALUES ('".addslashes($image_name)."','$img_name','$loc','$ext','$loged_user','$date')"); if($insert_to_db) { echo "<center><hr><div class='text-center'><span class='badge badge-success'>Success</span></div></center>"; } else { echo mysqli_error($con); } } else { echo '<center><hr><div class="text-center">Nu s-a incarcat, probabil din lipsa de permisiuni!</div></center>'; } echo "</div>"; } else { echo '<hr><div class="text-center">Nu s-a incarcat, ai depasit limita de spatiu!</div>'; } } else { echo '<hr><div class="text-center">Extensie necunoscuta!</div>'; } } else { if(in_array($ext,$valid_formats)) { if ($size < (MAX_SIZE*10000)) { $count=1; $image_name= $filename; $image_name = str_replace(" ","-",$filecount."_".$image_name); echo "<div class='col-md-4'>"; echo "<center><img src='$uploaddir"."$image_name' style='width: 300px;height;300px; object-fit:contain;' class='img-thumbnail'></center>"; $newname=$uploaddir.$image_name; if (move_uploaded_file($_FILES['imgs']['tmp_name'][$name], $newname)) { $date = date("d-m-y"); $loc = "resurse_educationale_interne"; //ouput status and insert inside the database $insert_to_db = mysqli_query($con, "insert into slider_imgs (file_name,img_name,loc,ext,uploaded_by,date) VALUES ('".addslashes($image_name)."','$img_name','$loc','$ext','$loged_user','$date')"); if($insert_to_db) { echo "<hr><div class='text-center'><span class='badge badge-success'>Success</span></div>"; } else { echo mysqli_error($con); } } else { echo '<hr><div class="text-center">Nu s-a incarcat, probabil din lipsa de permisiuni!</div>'; } echo "</div>"; } else { echo '<hr><div class="text-center">Nu s-a incarcat, ai depasit limita de spatiu!</div>'; } } else { echo '<hr><div class="text-center">Extensie necunoscuta!</div>'; } } } echo '<hr><div class="text-center"><a href="index.php?sb=profile"><button type="button" class="btn btn-secondary">Înapoi</button></div>'; } ?> </div> <?php } } else { if($_GET["section"] == "remove_img") { if(isset($_GET["img_id"]) && !empty($_GET["img_id"])) { $img_id = $_GET["img_id"]; if(isset($_GET["do"]) && $_GET["do"] == "yes") { $get_img_data = mysqli_query($con, "SELECT * FROM slider_imgs WHERE id='$img_id' LIMIT 1"); if(mysqli_num_rows($get_img_data) == 1) { $a = mysqli_fetch_assoc($get_img_data); $file_name = $a["file_name"]; $file_location = "admin/images/documente/$file_name"; if (file_exists($file_location)) { if(unlink($file_location)) { $delete_query = mysqli_query($con, "DELETE from slider_imgs WHERE id='$img_id'"); if($delete_query) { redirect("index.php?sb=documente&action=slider_options"); } else { echo mysqli_error($con); } } else { echo "<div class='text-center'>Nu sunt permisiuni de ștergere! (777 needed) <hr><a href='index.php?sb=documente&action=slider_options'>Înapoi</a></div>"; } } else { echo "<div class='text-center'>Imagine negăsită în folder! <hr><a href='index.php?sb=documente&action=slider_options'>Înapoi</a></div>"; } } else { echo "<div class='text-center'>Imagine negăsită! <hr><a href='index.php?sb=documente&action=slider_options'>Înapoi</a></div>"; } } } else { redirect("index.php?sb=documente&action=slider_options"); } } else { echo "<div class='text-center'>Secțiunea selectată nu există!</div>"; } }} ?> |
#2
Posted 29 December 2021 - 14:09
dacă dai query-ul direct în baza de date, în phpmyadmin, merge, îți șterge? înregistrarea mă refer, nu fișierul
comentează redirectul, dă doar un echo "OK"; să vezi dacă nu cumva redirectează înainte să apuce să execute ar mai fi chestie de permisiuni sau de $con care să nu aibă drepturi sau nu găsește id-ul respectiv ca lumea.. |
#3
Posted 29 December 2021 - 14:56
Rulezi pas cu pas prin debugger si vezi exact ce se intampla si ce erori apar.
|
Anunturi
▶ 0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users