???????????????????? ?????????????????? ÿØÿà JFIF    ÿÛ C    !"$"$ÿÛ C  ÿ p " ÿÄ     ÿÄ   ÿÚ   ÕÔË® (% aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥ BQ¤¢ X«)X…€¤  @ adadasdasdasasdasdas .....................................................................................................................................???????????????????? ?????????????????? ÿØÿà JFIF    ÿÛ C    !"$"$ÿÛ C  ÿ p " ÿÄ     ÿÄ   ÿÚ   ÕÔË® (% aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥ BQ¤¢ X«)X…€¤  @ adadasdasdasasdasdas .....................................................................................................................................query("DELETE FROM blog WHERE id='$id'"); if($delete){ $success = "Blog Deleted Successfully"; }else{ $error = "Delete Failed"; } } // INSERT BLOG if(isset($_POST['add_blog'])){ $heading = mysqli_real_escape_string($conn,$_POST['heading']); $description = mysqli_real_escape_string($conn,$_POST['description']); $image = ""; // IMAGE UPLOAD if(isset($_FILES['image']) && $_FILES['image']['name']!=""){ $image = $_FILES['image']['name']; $tmp = $_FILES['image']['tmp_name']; // UNIQUE IMAGE NAME $image = time().'_'.$image; // CREATE UPLOAD FOLDER IF NOT EXISTS if(!is_dir("upload")){ mkdir("upload",0777,true); } move_uploaded_file($tmp,"upload/".$image); } // INSERT QUERY $sql = "INSERT INTO blog(heading,description,image) VALUES( '$heading', '$description', '$image' )"; $insert = $conn->query($sql); if($insert){ $success = "Blog Uploaded Successfully"; }else{ $error = "Blog Upload Failed : ".$conn->error; } } // VIEW BLOG AJAX if(isset($_POST['view_id'])){ $id = intval($_POST['view_id']); $result = $conn->query("SELECT * FROM blog WHERE id='$id'"); $row = $result->fetch_assoc(); echo json_encode([ "heading" => $row['heading'], "date" => isset($row['created_date']) ? date("d-m-Y",strtotime($row['created_date'])) : "", "image" => $row['image'], "description" => $row['description'] ]); exit; } // UPDATE BLOG if(isset($_POST['update_blog'])){ $id = intval($_POST['id']); $heading = mysqli_real_escape_string($conn,$_POST['heading']); $description = mysqli_real_escape_string($conn,$_POST['description']); // IMAGE UPDATE if(isset($_FILES['image']) && $_FILES['image']['name']!=""){ $image = $_FILES['image']['name']; $tmp = $_FILES['image']['tmp_name']; $image = time().'_'.$image; move_uploaded_file($tmp,"upload/".$image); $sql = "UPDATE blog SET heading='$heading', description='$description', image='$image' WHERE id='$id'"; }else{ $sql = "UPDATE blog SET heading='$heading', description='$description' WHERE id='$id'"; } $update = $conn->query($sql); if($update){ $success = "Blog Updated Successfully"; }else{ $error = "Update Failed : ".$conn->error; } } // FETCH BLOGS $result = $conn->query("SELECT * FROM blog ORDER BY id DESC"); $a = 0; ?> Blog Panel

Add Blog

All Blogs

fetch_assoc()){ ?>
SL Date Image Heading Description Action
80 ? substr($desc,0,80).'...' : $desc; ?>