Successfully setup!
Click here to upload more picture...

"; } if(isset($_REQUEST['update'])){ include("picture_upload_aof.php"); $edit_id = mysqli_escape_string($conn, $_REQUEST['edit_id']); $topic_name = mysqli_escape_string($conn, $_REQUEST['topic_name']); $topic_detail = mysqli_escape_string($conn, $_REQUEST['topic_detail']); $query5 = "UPDATE artist_on_focus SET img='$fn', title='$topic_name', content='$topic_detail' WHERE id='$edit_id'"; $result2 = mysqli_query($conn, $query5) or die(mysqli_error($conn)); $msg = "

Successfully updated!

"; } if(isset($_REQUEST['edit_id'])){ $edit_id = mysqli_escape_string($conn, $_REQUEST['edit_id']); $query = "SELECT * FROM artist_on_focus WHERE id='$edit_id'"; $result = mysqli_query($conn, $query) or die(mysqli_error($conn)); if (mysqli_num_rows($result) > 0) { $info = mysqli_fetch_array($result); $id=$info['id']; $topic_title=$info['title']; $topic_detail= $info['content']; $piks=$info['img']; $topic_detail = htmlspecialchars($topic_detail); if($piks != ""){ $upload = "
"; }else{ $upload = ''; } } } if(isset($_REQUEST['del_id'])){ $delete_id = mysqli_escape_string($conn, $_REQUEST['del_id']); $query = "DELETE FROM artist_on_focus WHERE id = '$delete_id'"; $result = mysqli_query($conn, $query) or die(mysqli_error($conn)); $msg = "

Deleted!

"; } ?>

New/Updates



Format: png, bmp, gif, jpg or jpeg
".$upload; } ?>
/>
UPDATE'; print ""; }else{ print ''; } ?>
"; while($rec = mysqli_fetch_array($result)){ $rec_id = $rec['id']; $title = $rec['title']; $content = $rec['content']; $img = $rec['img']; //count pictures.... $sql999 = "SELECT * FROM upload_gallery WHERE topic_id='$rec_id' AND course_id='aof'"; $result999 = mysqli_query($conn, $sql999) or die(mysqli_error()); $num_piks = mysqli_num_rows($result999); $num_piks_msg = "$num_piks more pictures
"; print " "; } print "
$title $num_piks_msg Edit Delete
"; ?>
<