Record added "; } if((isset($_REQUEST['action']))&&($_REQUEST['action']=="del")){ $id = mysqli_escape_string($conn, $_REQUEST['id']); // DELETE PHYSICAL FILE $query = "SELECT filename FROM post_more_picture WHERE id ='$id'"; $result = mysqli_query($conn, $query) or die(mysqli_error($conn)); $info = mysqli_fetch_array($result); $f_name= $info['filename']; if(file_exists("piks/".$f_name)) { unlink("piks/".$f_name); }else{ } $query = "DELETE FROM post_more_picture WHERE id = '$id'"; mysqli_query($conn, $query) or die(mysqli_error($conn)); $msg="Record deleted"; } if(isset($_REQUEST['editing'])){ $select_id = mysqli_escape_string($conn, $_REQUEST['id']); $sql = "SELECT * FROM post_more_picture WHERE id='$select_id'"; $result = mysqli_query($conn, $sql) or die(mysqli_error($conn)); $info = mysqli_fetch_array($result); $id=$info['id']; $title=$info['detail']; $url_link=$info['art_cat']; } if(isset($_REQUEST['edit_id'])){ $edit_id = mysqli_escape_string($conn, $_REQUEST['edit_id']); $url = mysqli_escape_string($conn, $_REQUEST['url']); $title = mysqli_escape_string($conn, $_REQUEST['title']); $sql1 = "UPDATE post_more_picture SET detail = '$title', art_cat='$url' WHERE id = '$edit_id'"; mysqli_query($conn, $sql1) or die(mysqli_error($conn)); //Update $msg="EDITING WAS SUCCESSFUL"; } ?>
Document
required />
Format: PDF, DOC, PPT
OR
/>
"; print ''; }else{ print ' '; } ?>
Record
Title Link/URL File name "; // print the random numbers while($info = mysqli_fetch_array($result)) { $id=$info['id']; $detail=$info['detail']; $filename=$info['filename']; $url_text=$info['art_cat']; print " $detail $url_text $filename Delete | Edit "; } //close up ther table print "

"; ?>