{"id":14463,"date":"2016-08-22T12:15:18","date_gmt":"2016-08-22T09:15:18","guid":{"rendered":"http:\/\/www.webcodegeeks.com\/?p=14463"},"modified":"2016-08-18T22:59:31","modified_gmt":"2016-08-18T19:59:31","slug":"creating-complete-blog-crud-using-mysql-and-php-part2","status":"publish","type":"post","link":"https:\/\/www.webcodegeeks.com\/php\/creating-complete-blog-crud-using-mysql-and-php-part2\/","title":{"rendered":"Creating a complete blog (CRUD) using MySQL and PHP – Part 2"},"content":{"rendered":"

In the previous part<\/a>, we created a Post Class which will handle our article request and perform CRUD operation on it. In this tutorial, we are going to use the same class and will insert, update and delete articles.<\/p>\n

We are going to make forms for insert and update article, create a view for article and a page where all the articles will be listed and can be deleted. I will be using bootstrap for styling. Let\u2019s get started:<\/p>\n

Header & Footer For View<\/h2>\n

First we are going to create a header and a footer for our pages. Now in the same folder, create a new file header.php<\/strong> and paste the following code in it.<\/p>\n

<!DOCTYPE html PUBLIC \"-#W3C#DTD XHTML 1.0 Transitional#EN\" \"http:#www.w3.org\/TR\/xhtml1\/DTD\/xhtml1-transitional.dtd\">\r\n\r\n<!--\r\nTo change this license header, choose License Headers in Project Properties.\r\nTo change this template file, choose Tools | Templates\r\nand open the template in the editor.\r\n-->\r\n<html xmlns=\"http:#www.w3.org\/1999\/xhtml\">\r\n    <head>\r\n        <meta http-equiv=\"Content-Type\" content=\"text\/html; charset=utf-8\">\r\n         <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\r\n        <title>Blog System<\/title>\r\n        <!-- Latest compiled and minified CSS -->\r\n<link rel=\"stylesheet\" href=\"https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.7\/css\/bootstrap.min.css\" integrity=\"sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz\/K68vbdEjh4u\" crossorigin=\"anonymous\">\r\n\r\n<!-- Optional theme -->\r\n<link rel=\"stylesheet\" href=\"https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.7\/css\/bootstrap-theme.min.css\" integrity=\"sha384-rHyoN1iRsVXV4nD0JutlnGaslCJuC7uwjduW9SVrLvRYooPp2bWYgmgJQIXwl\/Sp\" crossorigin=\"anonymous\">\r\n        \r\n        \r\n    <\/head>\r\n    <body class=\"container-fluid\">\r\n            <div class=\"container-fluid\"><\/pre>\n
Now create a new file footer.php<\/strong> and paste the following code in it.<\/p>\n
<script src=\"https:\/\/code.jquery.com\/jquery-3.1.0.min.js\"><\/script>\r\n<!-- Latest compiled and minified JavaScript -->\r\n<script src=\"https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.7\/js\/bootstrap.min.js\" integrity=\"sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa\" crossorigin=\"anonymous\"><\/script>\r\n\r\n\r\n\r\n<\/div>\r\n\r\n<\/body>\r\n<\/html><\/pre>\n
Insert A New Post<\/h2>\n
Now lets create a form which will insert a new post into database and connect it with Post Class. Before creating form create a new folder in the same directory and name it postimages<\/strong> in order to save all the images in it. Now create a new file and name it index.php<\/strong> and post the following code in it.<\/p>\n
<?php\r\ninclude 'header.php';\r\n\r\necho 'Posted';\r\n\r\ninclude 'footer.php';\r\n\r\n?>\r\n<\/pre>\n
In this file we will redirect the user when the post is published successfully. Now lets create a new file creatpost.php<\/strong> and paste the following code in it.<\/p>\n
<?php\r\n\r\ninclude 'header.php';\r\ninclude 'postclass.php';\r\n        \r\n$crud   = new Post();\r\n$errors = [\r\n    'article_name'     => null,\r\n    'article_category' => null,\r\n    'article_content'  => null,\r\n    'article_img'      => null,\r\n    'form'             => null,\r\n];\r\n\r\n$conne         = '';\r\n$form          = true;\r\n$target_dir    = \"postimages\/\";\r\n$target_file   = null;\r\n$imageFileType = null;\r\nif (!empty($_POST)) {\r\n\r\n    $target_file   = $target_dir . basename($_FILES[\"article_img\"][\"name\"]);\r\n    $imageFileType = pathinfo($target_file, PATHINFO_EXTENSION);\r\n    $check         = getimagesize($_FILES[\"article_img\"][\"tmp_name\"]);\r\n    if (empty($_POST['a_name'])) {\r\n        $errors['article_name'] = \"Please Enter Your Title\";\r\n        $form                   = false;\r\n    }\r\n    if ($check === false) {\r\n        $errors['article_img'] = 'Image is required';\r\n        $form                  = false;\r\n    } elseif ($imageFileType != \"jpg\" && $imageFileType != \"png\" && $imageFileType != \"jpeg\" && $imageFileType != \"gif\") {\r\n        $errors['article_img'] = 'Sorry, only JPG, JPEG, PNG & GIF files are allowed.';\r\n        $form                  = false;\r\n    }\r\n\r\n    if (empty($_POST['article_content'])) {\r\n        $errors['article_content'] = \"Please Fill Your Content\";\r\n        $form                      = false;\r\n    }\r\n\r\n    if ($form) {\r\n\r\n        $articlename = $_POST['a_name'];\r\n        $articlecont = $_POST['article_content'];\r\n        \r\n        $image       = rand(1, 100);\r\n        $imgname     = $image . \".\" . $imageFileType;\r\n        $result      = $crud->insertpost($articlename, $articlecont, $imgname);\r\n\r\n        if ($result == 'true') {\r\n            move_uploaded_file($_FILES[\"article_img\"][\"tmp_name\"], $target_dir . $imgname);\r\n            header('Location: index.php');\r\n            return;\r\n        } else {\r\n            $errors['form'] = $result;\r\n        }\r\n\r\n    }\r\n\r\n} else {\r\n    $errors['form'] = \"Kindly Fill All the Fields\";\r\n}\r\n\r\n?>\r\n<!--<script type=\"text\/javascript\" src=\"tinymce\/tinymce.min.js\"><\/script>-->\r\n<script src=\"http:\/\/js.nicedit.com\/nicEdit-latest.js\" type=\"text\/javascript\"><\/script>\r\n    <script type=\"text\/javascript\">\r\n        \/\/ tinymce.init({\r\n        \/\/     selector: \"#article_content\"\r\n        \/\/ });\r\n\r\nbkLib.onDomLoaded(function() {\r\n  new nicEditor().panelInstance('article_content');\r\n\r\n});\r\n    <\/script>\r\n\r\n<form class=\"form-horizontal\" method=\"post\" enctype=\"multipart\/form-data\" action=\"<?php echo htmlspecialchars($_SERVER[\"PHP_SELF\"]); ?>\">\r\n<fieldset>\r\n\r\n<!-- Form Name -->\r\n<legend>Create Post<\/legend>\r\n\r\n<!-- Text input-->\r\n<div class=\"form-group col-md-10\">\r\n  <label class=\"control-label\" for=\"a_name\">Create Post<\/label>\r\n\r\n  <input id=\"a_name\" name=\"a_name\" type=\"text\" placeholder=\"Enter Title For Your Article\" class=\"form-control input-md\"  value=\"<?php if (isset($_POST['a_name'])) {echo $_POST['a_name'];}\r\n?>\" required>\r\n    <p class=\"text-danger\"><?php echo $errors['article_name'] ?><\/p>\r\n\r\n<\/div>\r\n\r\n<!-- File Button -->\r\n<div class=\"form-group col-md-10\">\r\n  <label class=\"control-label\" for=\"article_img\">Upload Image<\/label>\r\n\r\n    <input id=\"article_img\" name=\"article_img\" class=\"input-file\" type=\"file\" required>\r\n\r\n     <p class=\"text-danger\"><?php echo $errors['article_img'] ?><\/p>\r\n\r\n<\/div>\r\n\r\n<!-- Textarea -->\r\n<div class=\"form-group col-md-10\" >\r\n  <label class=\"control-label\" for=\"article_content\">Content<\/label>\r\n\r\n    <textarea class=\"form-control\" id=\"article_content\" name=\"article_content\" rows=\"13\"><?php if (isset($_POST['article_content'])) {echo $_POST['article_content'];}\r\n?><\/textarea>\r\n    <p class=\"text-danger\"><?php echo $errors['article_content'] ?><\/p>\r\n\r\n<\/div>\r\n\r\n<!-- Button -->\r\n<div class=\"form-group col-md-10\">\r\n  <label class=\"control-label\" for=\"submit\"><\/label>\r\n\r\n    <button id=\"submit\" name=\"submit\" type=\"submit\" class=\"btn btn-success\">Publish<\/button>\r\n    <p class=\"text-danger\"><?php echo $errors['form'] ?><\/p>\r\n\r\n<\/div>\r\n\r\n<\/fieldset>\r\n<\/form>\r\n\r\n\r\n<?php include 'footer.php';?><\/pre>\n
In the above code we have created a form and also done its validation so that it doesn\u2019t send empty data in database. Then if the data is submitted to database we will upload its image on our server.<\/p>\n
Now run it on your browser by going to your root folder and then to createpost.php.It will look like this:<\/p>\n
\"image00\"<\/a><\/p>\n
Try sending a post, if it has no error you will be transferred to the succeed page and you can also check on your database to verify that your post is edited.<\/p>\n
\"image01\"<\/a><\/p>\n
Now let\u2019s create a page where these posts will be listed.<\/p>\n
View Publish Post<\/h2>\n
Now go to the file in your directory and name it postview.php<\/strong> and paste the following code in it.<\/p>\n
<?php\r\ninclude 'header.php';\r\ninclude 'postclass.php';\r\n\r\n$postid = $_GET['postid'];\r\n\r\n$article = new Post();\r\n$result  = $article->getarticle($postid);\r\n\r\n?>\r\n<div class='row'>\r\n<?php\r\nwhile ($row = $result->fetch_assoc()) {\r\n    ?>\r\n  <div class=\"panel panel-default\">\r\n  <div class=\"panel-heading back\">\r\n    <h2> <?php echo $row['article_name'];?> <\/h2>\r\n    <h5><span class=\"glyphicon glyphicon-time\"><\/span> Posted On <?php echo $row['dates'];?><\/h5>\r\n      \r\n  <\/div>\r\n  <div class=\"panel-body\">\r\n    <div class=\"col-md-3 pull-right\">\r\n    <img class='img-responsive img-rounded center' src=\"postimages\/<?php echo $row['img'];?>\">\r\n    <\/div>\r\n   <?php echo $row['article_content'];?>\r\n  <\/div>\r\n<\/div>\r\n<?php\r\n}\r\n?>\r\n<\/div>\r\n\r\n\r\n  <?php\r\ninclude 'footer.php';\r\n?>\r\n<\/pre>\n
What we did in this code is that we get the ID of the post and then call our getarticle()<\/strong> method and view the article on the browser.<\/p>\n
Give it a try by running the above file and pass your postid<\/strong> in it by url and you will get a view of your post<\/p>\n
\"image02\"<\/a><\/p>\n
Now that we have viewed our post, let\u2019s update it.<\/p>\n
Updating A Post<\/h2>\n
Now let\u2019s edit our post. We will get the id of the post and paste it to our getarticle()<\/strong> method to get the previous article and view it in the editor to use. Then when clicked on update the article we will call updatearticle()<\/strong> method.<\/p>\n
Now create a new file updatepost.php<\/strong> in the same directory and paste the following code:<\/p>\n
<?php\r\ninclude 'header.php';\r\ninclude 'postclass.php';\r\n$user = $_SESSION[\"username\"];\r\n$aid = null;\r\n\r\nif(empty($_POST))\r\n{\r\n  $aid = $_GET['postid'];\r\n}\r\nelse{\r\n  $aid = $_POST['postid'];\r\n}\r\n\r\n\r\n$crud = new Post();\r\n$errors = [\r\n        'article_name' => null,\r\n        'article_category' => null,\r\n        'article_content' => null,\r\n        'article_img' => null,\r\n        'form' => null\r\n    ];\r\n$article = [\r\n        'a_id' => $aid,\r\n        'a_name' => null,\r\n        'a_con' => null,\r\n        'a_img' => null,\r\n        'form' => null\r\n    ];\r\n\r\n    $result = $crud->getarticle($aid);\r\n\r\n    while($row = $result->fetch_assoc())\r\n        {\r\n          $article['a_name'] = $row['article_name'];\r\n          $article['a_con'] = $row['article_content'];\r\n          $article['a_img'] = $row['img'];\r\n        }\r\n\r\n    $conne='';\r\n    $form = true;\r\n    $target_dir = \"postimages\/\";\r\n    $target_file = null;\r\n    $imageFileType = null;\r\n    $Upload = false;\r\n\r\n  \/\/  var_dump($article);\r\nif(!empty($_POST))\r\n{\t\r\n\t\r\n\t$target_file = $target_dir . basename($_FILES[\"article_img\"][\"name\"]);\r\n\t$imageFileType = pathinfo($target_file,PATHINFO_EXTENSION);\r\n  $check = false;\r\n\t$check = getimagesize($_FILES[\"article_img\"][\"tmp_name\"]);\r\n\r\n\tif($_POST['a_name'] !== $article['a_name'])\r\n\t{\r\n\t\t$article['a_name'] = $_POST['a_name'];\r\n\t\r\n\t}\r\n\tif ($check !== false)\r\n\t{\r\n  \t$Upload = true;\r\n\tif($imageFileType != \"jpg\" && $imageFileType != \"png\" && $imageFileType != \"jpeg\"&& $imageFileType != \"gif\" ) \r\n\t{\r\n\t   $errors['article_img'] = 'Sorry, only JPG, JPEG, PNG & GIF files are allowed.';\r\n\t   $form =false;\r\n\t}\r\n  }\r\n\r\n\tif($_POST['article_content'] !== $article['a_con'])\r\n\t{\r\n\t\t$article['a_con'] = $_POST['article_content'];\r\n\t\t\r\n\t}\r\n\r\nif($form)\r\n{\r\n  \r\n  \r\n  if($Upload)\r\n  {\r\n            $image = rand(1,100);\r\n            $imgname = $image .\".\".$imageFileType;\r\n            $result = $crud->updatearticle($article['a_id'],$article['a_con'],$article['a_name'],$imgname);\r\n          if($result == 'true')\r\n              {\r\n                move_uploaded_file($_FILES[\"article_img\"][\"tmp_name\"], $target_dir.$imgname);\r\n                          header(\"Location: postview.php?postid=$aid\");\r\n                               return;\r\n              }\r\n          else\r\n              {\r\n                $errors['form'] = $result;\r\n              }\r\n  }\r\n  else\r\n  {\r\n          var_dump($article);\r\n          $result =  $crud->updatearticle($article['a_id'],$article['a_con'],$article['a_name'],$article['a_img']);\r\n          if($result == 'true')\r\n              {\r\n                \r\n               header(\"Location: postview.php?postid=$aid\");\r\n                               return;\r\n              }\r\n          else\r\n              {\r\n                $errors['form'] = $result;\r\n              }\r\n  }\r\n\r\n  \r\n\t\r\n}\r\n\r\n}\r\nelse\r\n{\r\n\t$errors['form'] = \"Kindly Fill All the Fields\";\r\n}\r\n\r\n\r\n?>\r\n<!--<script type=\"text\/javascript\" src=\"tinymce\/tinymce.min.js\"><\/script>-->\r\n<script type=\"text\/javascript\" src=\"style\/js\/nicEdit.js\"><\/script>\r\n    <script type=\"text\/javascript\">\r\n        \/\/ tinymce.init({\r\n        \/\/     selector: \"#article_content\"\r\n        \/\/ });\r\n\r\nbkLib.onDomLoaded(function() {\r\n  new nicEditor().panelInstance('article_content');\r\n  \r\n});\r\n    <\/script>\r\n\r\n<form class=\"form-horizontal\" method=\"post\" enctype=\"multipart\/form-data\" action=\"<?php echo htmlspecialchars($_SERVER[\"PHP_SELF\"]);?>\">\r\n<fieldset>\r\n<input type=\"hidden\" name=\"postid\" value=\"<?php echo $_GET['postid']?>\">\r\n<!-- Form Name -->\r\n<legend>Update Article<\/legend>\r\n\r\n<!-- Text input-->\r\n<div class=\"form-group col-md-10\">\r\n  <label class=\"control-label\" for=\"a_name\">Title<\/label>  \r\n  \r\n  <input id=\"a_name\" name=\"a_name\" type=\"text\" placeholder=\"Enter Title For Your Article\" class=\"form-control input-md\"  value=\"<?php echo $article['a_name'];  ?>\" required>\r\n    <p class=\"text-danger\"><?php echo $errors['article_name']?><\/p>\r\n  \r\n<\/div>\r\n\r\n<!-- File Button --> \r\n<div class=\"form-group col-md-10\">\r\n  <label class=\"control-label\" for=\"article_img\">Upload Image<\/label>\r\n  \r\n    <input id=\"article_img\" name=\"article_img\" class=\"input-file\" type=\"file\" value=\"<?php echo $article['a_img']?>\">\r\n\r\n     <p class=\"text-danger\"><?php echo $errors['article_img']?><\/p>\r\n  \r\n<\/div>\r\n\r\n<!-- Textarea -->\r\n<div class=\"form-group col-md-10\" >\r\n  <label class=\"control-label\" for=\"article_content\">Content<\/label>\r\n                      \r\n    <textarea class=\"form-control\" id=\"article_content\" name=\"article_content\" rows=\"13\"><?php echo $article['a_con'];  ?><\/textarea>\r\n    <p class=\"text-danger\"><?php echo $errors['article_content']?><\/p>\r\n  \r\n<\/div>\r\n\r\n<!-- Button -->\r\n<div class=\"form-group col-md-10\">\r\n  <label class=\"control-label\" for=\"submit\"><\/label>\r\n \r\n    <button id=\"submit\" name=\"submit\" class=\"btn btn-success\">Update<\/button>\r\n    <a href=\"articlelist\" id=\"cancel\" name=\"cancel\" class=\"btn btn-danger\">Cancel<\/a>\r\n    <p class=\"text-danger\"><?php echo $errors['form']?><\/p>\r\n  \r\n<\/div>\r\n\r\n<\/fieldset>\r\n<\/form>\r\n\r\n\r\n<?php include 'footer.php';?>\r\n<\/pre>\n
As I\u2019ve said before, we get the postid, <\/strong>update it and then we redirect it to postview if it is successfully updated. Give it a try!<\/p>\n
Delete A Post<\/h2>\n
Deleting a post is quite easy. We just get the postid,<\/strong> paste it to our deletearticle()<\/strong> method and delete the post. Now create a new file in the the same directory and name it delete.php<\/strong> and paste the following code in it:<\/p>\n
<?php \r\ninclude 'postclass.php';\r\n\r\n$ids = $_GET['postid'];\r\n\r\n$del = new Post();\r\n\r\n$result = $del->deletearticle($ids);\r\n\r\nif($result === true)\r\n{\r\n\techo \"Post Is Deleted Successfully\";\r\n}\r\nelse\r\n{\r\n\techo $result;\r\n}\r\n\r\n\r\n\r\n\r\n?><\/pre>\n
Give it a try and delete your post.<\/p>\n
Conclusion<\/h2>\n
This is the 2nd and last part of the tutorial series in which we used our postclass<\/strong> to perform crud operations on our blog. All the codes can be found in the github repository<\/a>. Fork it and feel free to add more things in it or clone it to use it in your projects.<\/p>\n","protected":false},"excerpt":{"rendered":"
In the previous part, we created a Post Class which will handle our article request and perform CRUD operation on it. In this tutorial, we are going to use the same class and will insert, update and delete articles. We are going to make forms for insert and update article, create a view for article …<\/p>\n","protected":false},"author":174,"featured_media":930,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[381],"class_list":["post-14463","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php","tag-mysql"],"yoast_head":"\nCreating a complete blog (CRUD) using MySQL and PHP - Part 2 - Web Code Geeks - 2026<\/title>\n<meta name=\"description\" content=\"In the previous part, we created a Post Class which will handle our article request and perform CRUD operation on it. In this tutorial, we are going to\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.webcodegeeks.com\/php\/creating-complete-blog-crud-using-mysql-and-php-part2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating a complete blog (CRUD) using MySQL and PHP - Part 2 - Web Code Geeks - 2026\" \/>\n<meta property=\"og:description\" content=\"In the previous part, we created a Post Class which will handle our article request and perform CRUD operation on it. In this tutorial, we are going to\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.webcodegeeks.com\/php\/creating-complete-blog-crud-using-mysql-and-php-part2\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Code Geeks\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/webcodegeeks\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/ahmedkhannn\" \/>\n<meta property=\"article:published_time\" content=\"2016-08-22T09:15:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/10\/php-logo.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"150\" \/>\n\t<meta property=\"og:image:height\" content=\"150\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Ahmed Khan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ahmed0627\" \/>\n<meta name=\"twitter:site\" content=\"@webcodegeeks\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ahmed Khan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.webcodegeeks.com\/php\/creating-complete-blog-crud-using-mysql-and-php-part2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/php\/creating-complete-blog-crud-using-mysql-and-php-part2\/\"},\"author\":{\"name\":\"Ahmed Khan\",\"@id\":\"https:\/\/www.webcodegeeks.com\/#\/schema\/person\/39826783730ea673ddc3383fe3bcf855\"},\"headline\":\"Creating a complete blog (CRUD) using MySQL and PHP – Part 2\",\"datePublished\":\"2016-08-22T09:15:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/php\/creating-complete-blog-crud-using-mysql-and-php-part2\/\"},\"wordCount\":630,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/php\/creating-complete-blog-crud-using-mysql-and-php-part2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/10\/php-logo.jpg\",\"keywords\":[\"MySQL\"],\"articleSection\":[\"PHP\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.webcodegeeks.com\/php\/creating-complete-blog-crud-using-mysql-and-php-part2\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.webcodegeeks.com\/php\/creating-complete-blog-crud-using-mysql-and-php-part2\/\",\"url\":\"https:\/\/www.webcodegeeks.com\/php\/creating-complete-blog-crud-using-mysql-and-php-part2\/\",\"name\":\"Creating a complete blog (CRUD) using MySQL and PHP - Part 2 - Web Code Geeks - 2026\",\"isPartOf\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/php\/creating-complete-blog-crud-using-mysql-and-php-part2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/php\/creating-complete-blog-crud-using-mysql-and-php-part2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/10\/php-logo.jpg\",\"datePublished\":\"2016-08-22T09:15:18+00:00\",\"description\":\"In the previous part, we created a Post Class which will handle our article request and perform CRUD operation on it. In this tutorial, we are going to\",\"breadcrumb\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/php\/creating-complete-blog-crud-using-mysql-and-php-part2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.webcodegeeks.com\/php\/creating-complete-blog-crud-using-mysql-and-php-part2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.webcodegeeks.com\/php\/creating-complete-blog-crud-using-mysql-and-php-part2\/#primaryimage\",\"url\":\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/10\/php-logo.jpg\",\"contentUrl\":\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/10\/php-logo.jpg\",\"width\":150,\"height\":150},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.webcodegeeks.com\/php\/creating-complete-blog-crud-using-mysql-and-php-part2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.webcodegeeks.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PHP\",\"item\":\"https:\/\/www.webcodegeeks.com\/category\/php\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Creating a complete blog (CRUD) using MySQL and PHP – Part 2\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.webcodegeeks.com\/#website\",\"url\":\"https:\/\/www.webcodegeeks.com\/\",\"name\":\"Web Code Geeks\",\"description\":\"Web Developers Resource Center\",\"publisher\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.webcodegeeks.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.webcodegeeks.com\/#organization\",\"name\":\"Exelixis Media P.C.\",\"url\":\"https:\/\/www.webcodegeeks.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.webcodegeeks.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png\",\"contentUrl\":\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png\",\"width\":864,\"height\":246,\"caption\":\"Exelixis Media P.C.\"},\"image\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/webcodegeeks\",\"https:\/\/x.com\/webcodegeeks\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.webcodegeeks.com\/#\/schema\/person\/39826783730ea673ddc3383fe3bcf855\",\"name\":\"Ahmed Khan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.webcodegeeks.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9c0240c8a389a58b007699e24a2d7e937f6d150934678d723fb7037e3e5d5d56?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9c0240c8a389a58b007699e24a2d7e937f6d150934678d723fb7037e3e5d5d56?s=96&d=mm&r=g\",\"caption\":\"Ahmed Khan\"},\"description\":\"Ahmed Khan is the PHP Community Manager at Cloudways, a hosting company that specializes in optimized PHP hosting services. He writes about PHP, MySQL and covers different tips and tricks related to PHP. He is currently active on Cloudways and other different blogs. When he is not writing about PHP, he likes watching The Flash, Game Of Thrones and is a die-hard fan of DC Comics.\",\"sameAs\":[\"https:\/\/www.facebook.com\/ahmedkhannn\",\"https:\/\/x.com\/ahmed0627\"],\"url\":\"https:\/\/www.webcodegeeks.com\/author\/ahmed-khan\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Creating a complete blog (CRUD) using MySQL and PHP - Part 2 - Web Code Geeks - 2026","description":"In the previous part, we created a Post Class which will handle our article request and perform CRUD operation on it. In this tutorial, we are going to","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.webcodegeeks.com\/php\/creating-complete-blog-crud-using-mysql-and-php-part2\/","og_locale":"en_US","og_type":"article","og_title":"Creating a complete blog (CRUD) using MySQL and PHP - Part 2 - Web Code Geeks - 2026","og_description":"In the previous part, we created a Post Class which will handle our article request and perform CRUD operation on it. In this tutorial, we are going to","og_url":"https:\/\/www.webcodegeeks.com\/php\/creating-complete-blog-crud-using-mysql-and-php-part2\/","og_site_name":"Web Code Geeks","article_publisher":"https:\/\/www.facebook.com\/webcodegeeks","article_author":"https:\/\/www.facebook.com\/ahmedkhannn","article_published_time":"2016-08-22T09:15:18+00:00","og_image":[{"width":150,"height":150,"url":"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/10\/php-logo.jpg","type":"image\/jpeg"}],"author":"Ahmed Khan","twitter_card":"summary_large_image","twitter_creator":"@ahmed0627","twitter_site":"@webcodegeeks","twitter_misc":{"Written by":"Ahmed Khan","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.webcodegeeks.com\/php\/creating-complete-blog-crud-using-mysql-and-php-part2\/#article","isPartOf":{"@id":"https:\/\/www.webcodegeeks.com\/php\/creating-complete-blog-crud-using-mysql-and-php-part2\/"},"author":{"name":"Ahmed Khan","@id":"https:\/\/www.webcodegeeks.com\/#\/schema\/person\/39826783730ea673ddc3383fe3bcf855"},"headline":"Creating a complete blog (CRUD) using MySQL and PHP – Part 2","datePublished":"2016-08-22T09:15:18+00:00","mainEntityOfPage":{"@id":"https:\/\/www.webcodegeeks.com\/php\/creating-complete-blog-crud-using-mysql-and-php-part2\/"},"wordCount":630,"commentCount":1,"publisher":{"@id":"https:\/\/www.webcodegeeks.com\/#organization"},"image":{"@id":"https:\/\/www.webcodegeeks.com\/php\/creating-complete-blog-crud-using-mysql-and-php-part2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/10\/php-logo.jpg","keywords":["MySQL"],"articleSection":["PHP"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.webcodegeeks.com\/php\/creating-complete-blog-crud-using-mysql-and-php-part2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.webcodegeeks.com\/php\/creating-complete-blog-crud-using-mysql-and-php-part2\/","url":"https:\/\/www.webcodegeeks.com\/php\/creating-complete-blog-crud-using-mysql-and-php-part2\/","name":"Creating a complete blog (CRUD) using MySQL and PHP - Part 2 - Web Code Geeks - 2026","isPartOf":{"@id":"https:\/\/www.webcodegeeks.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.webcodegeeks.com\/php\/creating-complete-blog-crud-using-mysql-and-php-part2\/#primaryimage"},"image":{"@id":"https:\/\/www.webcodegeeks.com\/php\/creating-complete-blog-crud-using-mysql-and-php-part2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/10\/php-logo.jpg","datePublished":"2016-08-22T09:15:18+00:00","description":"In the previous part, we created a Post Class which will handle our article request and perform CRUD operation on it. In this tutorial, we are going to","breadcrumb":{"@id":"https:\/\/www.webcodegeeks.com\/php\/creating-complete-blog-crud-using-mysql-and-php-part2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.webcodegeeks.com\/php\/creating-complete-blog-crud-using-mysql-and-php-part2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webcodegeeks.com\/php\/creating-complete-blog-crud-using-mysql-and-php-part2\/#primaryimage","url":"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/10\/php-logo.jpg","contentUrl":"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/10\/php-logo.jpg","width":150,"height":150},{"@type":"BreadcrumbList","@id":"https:\/\/www.webcodegeeks.com\/php\/creating-complete-blog-crud-using-mysql-and-php-part2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.webcodegeeks.com\/"},{"@type":"ListItem","position":2,"name":"PHP","item":"https:\/\/www.webcodegeeks.com\/category\/php\/"},{"@type":"ListItem","position":3,"name":"Creating a complete blog (CRUD) using MySQL and PHP – Part 2"}]},{"@type":"WebSite","@id":"https:\/\/www.webcodegeeks.com\/#website","url":"https:\/\/www.webcodegeeks.com\/","name":"Web Code Geeks","description":"Web Developers Resource Center","publisher":{"@id":"https:\/\/www.webcodegeeks.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.webcodegeeks.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.webcodegeeks.com\/#organization","name":"Exelixis Media P.C.","url":"https:\/\/www.webcodegeeks.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webcodegeeks.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png","contentUrl":"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png","width":864,"height":246,"caption":"Exelixis Media P.C."},"image":{"@id":"https:\/\/www.webcodegeeks.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/webcodegeeks","https:\/\/x.com\/webcodegeeks"]},{"@type":"Person","@id":"https:\/\/www.webcodegeeks.com\/#\/schema\/person\/39826783730ea673ddc3383fe3bcf855","name":"Ahmed Khan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webcodegeeks.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/9c0240c8a389a58b007699e24a2d7e937f6d150934678d723fb7037e3e5d5d56?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9c0240c8a389a58b007699e24a2d7e937f6d150934678d723fb7037e3e5d5d56?s=96&d=mm&r=g","caption":"Ahmed Khan"},"description":"Ahmed Khan is the PHP Community Manager at Cloudways, a hosting company that specializes in optimized PHP hosting services. He writes about PHP, MySQL and covers different tips and tricks related to PHP. He is currently active on Cloudways and other different blogs. When he is not writing about PHP, he likes watching The Flash, Game Of Thrones and is a die-hard fan of DC Comics.","sameAs":["https:\/\/www.facebook.com\/ahmedkhannn","https:\/\/x.com\/ahmed0627"],"url":"https:\/\/www.webcodegeeks.com\/author\/ahmed-khan\/"}]}},"_links":{"self":[{"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/posts\/14463","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/users\/174"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/comments?post=14463"}],"version-history":[{"count":0,"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/posts\/14463\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/media\/930"}],"wp:attachment":[{"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/media?parent=14463"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/categories?post=14463"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/tags?post=14463"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}