Entry created"; } if((isset($_REQUEST['action']))&&($_REQUEST['action']=="del")){ $del_id = mysqli_escape_string($conn, $_REQUEST['id']); $query = "DELETE FROM series WHERE id = '$del_id'"; mysqli_query($conn, $query) or die(mysqli_error($conn)); $msg="Record deleted"; $msg="Entry deleted"; } if(isset($_REQUEST['edit_id'])){ $edit_id = mysqli_escape_string($conn, $_REQUEST['edit_id']); $artist = mysqli_escape_string($conn, $_REQUEST['artist']); $title = mysqli_escape_string($conn, $_REQUEST['title']); $body = mysqli_escape_string($conn, $_REQUEST['body']); $type = mysqli_escape_string($conn, $_REQUEST['type']); $sql1 = "UPDATE series SET series_name = '$title', status = '$type', series_detail = '$body' WHERE id = '$edit_id'"; mysqli_query($conn, $sql1) or die(mysqli_error($conn)); //Update $msg="Enry updated"; } if(isset($_REQUEST['editing'])){ $select_id = mysqli_escape_string($conn, $_REQUEST['id']); $sql = "SELECT * FROM series WHERE id='$select_id'"; $result = mysqli_query($conn, $sql) or die(mysqli_error($conn)); $info = mysqli_fetch_array($result); $id=$info['id']; $series_name=$info['series_name']; $series_detail=strip_tags($info['series_detail']); $artist_id=$info['artist_id']; $cat_type=$info['status']; } ?>
Category
required />
"; } if(isset($_REQUEST['editing'])){ $select_id = mysqli_escape_string($conn, $_REQUEST['id']); print ""; print ''; }else{ print ' '; } ?>
Record
'D' AND artist_id = '$artist_id' ORDER BY id DESC"; }else{ $query = "SELECT * FROM series WHERE status <> 'D' ORDER BY id DESC"; } $result = mysqli_query($conn,$query) or die(mysqli_error($conn)); print " "; // print the random numbers while($info = mysqli_fetch_array($result)) { $id=$info['id']; $title=$info['series_name']; $body=$info['series_detail']; $status=$info['status']; print " "; } print "
Id Category Detail Type
$id $title $body $status "; if(($id==1)||($id==2)){ print "this category cannot be modify"; }else{ print "Edit | Delete"; } print "
"; ?>