{"id":3021,"date":"2018-12-10T09:31:41","date_gmt":"2018-12-10T04:01:41","guid":{"rendered":"https:\/\/blog.pheonixsolutions.com\/?p=3021"},"modified":"2019-03-30T10:32:46","modified_gmt":"2019-03-30T05:02:46","slug":"php-script-for-crud-application","status":"publish","type":"post","link":"https:\/\/pheonixsolutions.com\/blog\/php-script-for-crud-application\/","title":{"rendered":"PHP Script for CRUD Application"},"content":{"rendered":"<h2>PHP Script for CRUD Application<\/h2>\n<h4><strong>Date :06\/12\/2018<\/strong><\/h4>\n<h3>What is CRUD?<\/h3>\n<p>CRUD refers to the four basic types of Database operations: Create, Read, Update, Delete. Most applications and projects perform\u00a0 CRUD functionality.<\/p>\n<p>This is a important script for all PHP beginners.\u00a0Once you learn about these CRUD operations, you can use them for many projects.<\/p>\n<h3><strong>Executing a CRUD Script<\/strong><\/h3>\n<p>Step by step procedure are as follows;<\/p>\n<h5><strong>STEP 1:<\/strong><\/h5>\n<ul>\n<li>In this script, I have taken a example as testimonial section for CRUD usage.<\/li>\n<li>In a<strong> PHPMYADMIN\u00a0<\/strong> , create a database Name &#8220;<strong>testimonials<\/strong>&#8220;<\/li>\n<li>Create a table name as &#8220;<strong>users<\/strong>&#8220;<\/li>\n<li>Create a table structure of rows having\u00a0 <strong>id<\/strong> , <strong>rating<\/strong>, <strong>clientname<\/strong>, <strong>reviews.\u00a0<\/strong> I have attached a snapshot below,<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/blog.pheonixsolutions.com\/wp-content\/uploads\/2018\/12\/crud1-1024x291.png\" alt=\"This image has an empty alt attribute; its file name is crud1-1024x291.png\" \/><\/p>\n<h5><strong>STEP 2:<\/strong><\/h5>\n<p>Create a <strong>connection.php<\/strong> file in your favorite text editor and execute the below script to make connection with your DB.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">&lt;?php\n\n$databaseHost = 'localhost';\n$databaseName = 'testimonials';\n$databaseUsername = 'root';\n$databasePassword = '';\n\n$mysqli = mysqli_connect($databaseHost, $databaseUsername, $databasePassword, $databaseName); \n \n?&gt;\n<\/pre>\n<h5><strong>Step 3:<\/strong><\/h5>\n<p>Create<strong> add.php<\/strong> file and execute the below script for adding the Information and to insert a queries in to DB.<\/p>\n<p>The programming script is with Enhanced CSS quality. Take a look on it and make use of it,<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">&lt;html&gt;\n&lt;style&gt;\ninput[type=text] {\n    color: #777;\n    padding-left: 10px;\n    margin: 10px;\n    margin-top: 12px;\n    margin-left: 18px;\n    width: 290px;\n    height: 35px;\n    border: 1px solid #c7d0d2;\n    border-radius: 2px;\n    box-shadow: inset 0 1.5px 3px rgba(190, 190, 190, .4), 0 0 0 5px #f5f7f8;\n}\n\n  \n   input[type=submit] {\n    float: left;\n    margin-right: 20px;\n \n    width: 100px;\n    height: 30px;\n    font-size: 14px;\n    font-weight: bold;\n    color: #fff;\n    background-color: #acd6ef; \/*IE fallback*\/\n    background-image: -webkit-gradient(linear, left top, left bottom, from(#acd6ef), to(#6ec2e8));\n    background-image: -moz-linear-gradient(top left 90deg, #acd6ef 0%, #6ec2e8 100%);\n    background-image: linear-gradient(top left 90deg, #acd6ef 0%, #6ec2e8 100%);\n    border-radius: 30px;\n    border: 1px solid #66add6;\n    box-shadow: 0 1px 2px rgba(0, 0, 0, .3), inset 0 1px 0 rgba(255, 255, 255, .5);\n    cursor: pointer;\n   }\n&lt;\/style&gt;\n&lt;body&gt;\n  &lt;a href=\"list.php\"&gt;&lt;input type=\"submit\" value=\"&lt;&lt; Added \" name=\"Go Back\" \/&gt;&lt;\/a&gt;\n  &lt;br\/&gt;&lt;br\/&gt;\n\n  &lt;form action=\"add.php\" method=\"post\" name=\"form1\"&gt;\n    &lt;table width=\"25%\" border=\"0\"&gt;\n      &lt;tr&gt; \n        &lt;td&gt;&lt;span style=\"color:blue\"&gt;rating&lt;\/span&gt;&lt;\/td&gt;\n        &lt;td&gt;&lt;input type=\"text\" name=\"rating\"&gt;&lt;\/td&gt;\n      &lt;\/tr&gt;\n      &lt;tr&gt; \n        &lt;td&gt;&lt;span style=\"color:blue\"&gt;clientname&lt;\/span&gt;&lt;\/td&gt;\n        &lt;td&gt;&lt;input type=\"text\" name=\"clientname\"&gt;&lt;\/td&gt;\n      &lt;\/tr&gt;\n      &lt;tr&gt; \n          &lt;td&gt;&lt;span style=\"color:blue\"&gt;reviews&lt;\/span&gt;&lt;\/td&gt;\n        &lt;td&gt;&lt;input type=\"text\" name=\"reviews\"&gt;&lt;\/td&gt;\n      &lt;\/tr&gt;\n      &lt;tr&gt; \n        \n        &lt;td&gt;&lt;input type=\"submit\" name=\"Submit\" value=\"Add &gt;&gt;\"&gt;&lt;\/td&gt;\n      &lt;\/tr&gt;\n      \n    &lt;\/table&gt;\n  &lt;\/form&gt;\n  \n  &lt;?php\n\n  \/\/ Check If form submitted, insert form data into users table.\n   if(isset($_POST['Submit'])) {\n    $rating = $_POST['rating'];\n    $clientname = $_POST['clientname'];\n    $reviews = $_POST['reviews'];\n    \n    \/\/ include database connection file\n    include_once(\"connection.php\");\n        \n    \/\/ Insert user data into table\n    $result = mysqli_query($mysqli, \"INSERT INTO users(rating,clientname,reviews) VALUES('$rating','$clientname','$reviews')\");\n    \n    \n  }\n  \n     ?&gt;\n  \n&lt;\/body&gt;\n&lt;\/html&gt;<br \/><br \/><br \/><\/pre>\n<p>Once You execute this in XAMPP , the output will be like this.<\/p>\n\n\n<ul class=\"wp-block-gallery columns-1 is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\"><li class=\"blocks-gallery-item\"><figure><img loading=\"lazy\" decoding=\"async\" width=\"662\" height=\"337\" src=\"https:\/\/blog.pheonixsolutions.com\/wp-content\/uploads\/2018\/12\/crud2.png\" alt=\"\" data-id=\"3030\" data-link=\"https:\/\/blog.pheonixsolutions.com\/?attachment_id=3030\" class=\"wp-image-3030\" srcset=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2018\/12\/crud2.png 662w, https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2018\/12\/crud2-300x153.png 300w\" sizes=\"auto, (max-width: 662px) 100vw, 662px\" \/><\/figure><\/li><\/ul>\n\n\n\n<p><strong>STEP 4:<\/strong><\/p>\n\n\n\n<p>Create<strong>&nbsp;edit.php<\/strong> file and execute the below script .Once you edited, You will see changes in DB and you can modify the added contents.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n&amp;lt;?php\n\/\/ include database connection file\ninclude_once(&quot;connection.php&quot;);\n\n\/\/ Check if form is submitted for user update, then redirect to homepage after update\nif(isset($_POST&#x5B;'update']))\n{\t\n\t\n\t$id = $_POST&#x5B;'id'];\n\t\n\t$rating=$_POST&#x5B;'rating'];\n\t$clientname=$_POST&#x5B;'clientname'];\n\t$reviews=$_POST&#x5B;'reviews'];\n\t\t\n\t\/\/ update user data\n\t$result = mysqli_query($mysqli, &quot;UPDATE users SET rating='$rating',clientname='$clientname',reviews='$reviews' WHERE id=$id&quot;);\n\t\n\t\/\/ Redirect to homepage to display updated user in list\n\theader(&quot;Location: list.php&quot;);\n}\n?&amp;gt;\n&amp;lt;?php\n\/\/ Display selected user data based on id\n\/\/ Getting id from url\n$id = $_GET&#x5B;'id'];\n\n\/\/ Fetech user data based on id\n$result = mysqli_query($mysqli, &quot;SELECT * FROM users WHERE id=$id&quot;);\n\nwhile($user_data = mysqli_fetch_array($result))\n{\n\t$rating = $user_data&#x5B;'rating'];\n\t$clientname = $user_data&#x5B;'clientname'];\n\t$reviews = $user_data&#x5B;'reviews'];\n\t\n}\n?&amp;gt;\n&amp;lt;html&amp;gt;\n&amp;lt;head&amp;gt;\t\n\t&amp;lt;title&amp;gt;Edit User Data&amp;lt;\/title&amp;gt;\n&amp;lt;\/head&amp;gt;\n &amp;lt;style&amp;gt;\n    input&#x5B;type=text] {\n    color: #777;\n    padding-left: 10px;\n    margin: 10px;\n    margin-top: 12px;\n    margin-left: 18px;\n    width: 290px;\n    height: 35px;\n    border: 1px solid #c7d0d2;\n    border-radius: 2px;\n    box-shadow: inset 0 1.5px 3px rgba(190, 190, 190, .4), 0 0 0 5px #f5f7f8;\n}\n  input&#x5B;type=submit] {\n    float: left;\n    margin-right: 20px;\n    width: 180px;\n    height: 30px;\n    font-size: 14px;\n    font-weight: bold;\n    color: #fff;\n    background-color: #acd6ef; \/*IE fallback*\/\n    background-image: -webkit-gradient(linear, left top, left bottom, from(#acd6ef), to(#6ec2e8));\n    background-image: -moz-linear-gradient(top left 90deg, #acd6ef 0%, #6ec2e8 100%);\n    background-image: linear-gradient(top left 90deg, #acd6ef 0%, #6ec2e8 100%);\n    border-radius: 30px;\n    border: 1px solid #66add6;\n    box-shadow: 0 1px 2px rgba(0, 0, 0, .3), inset 0 1px 0 rgba(255, 255, 255, .5);\n    cursor: pointer;\n   }\n   &amp;lt;\/style&amp;gt;\n   &amp;lt;body&amp;gt;\n   \n\t&amp;lt;a href=&quot;list.php&quot;&amp;gt;&amp;lt;input type=&quot;submit&quot; name=&quot;Submit&quot; value=&quot;Home Listings&quot;&amp;gt;&amp;lt;\/a&amp;gt;\n\t&amp;lt;br\/&amp;gt;&amp;lt;br\/&amp;gt;\n\t\n\t&amp;lt;form name=&quot;update_user&quot; method=&quot;post&quot; action=&quot;edit.php&quot;&amp;gt;\n\t\t&amp;lt;table border=&quot;0&quot;&amp;gt;\n\t\t\t&amp;lt;tr&amp;gt; \n\t\t\t\t&amp;lt;td&amp;gt;&amp;lt;span style=&quot;color:blue&quot;&amp;gt;rating&amp;lt;\/span&amp;gt;&amp;lt;\/td&amp;gt;\n\t\t\t\t&amp;lt;td&amp;gt;&amp;lt;input type=&quot;text&quot; name=&quot;rating&quot; value=&amp;lt;?php echo $rating;?&amp;gt;&amp;gt;&amp;lt;\/td&amp;gt;\n\t\t\t&amp;lt;\/tr&amp;gt;\n\t\t\t&amp;lt;tr&amp;gt; \n\t\t\t\t&amp;lt;td&amp;gt;&amp;lt;span style=&quot;color:blue&quot;&amp;gt;clientname&amp;lt;\/span&amp;gt;&amp;lt;\/td&amp;gt;\n\t\t\t\t&amp;lt;td&amp;gt;&amp;lt;input type=&quot;text&quot; name=&quot;clientname&quot; value=&amp;lt;?php echo $clientname;?&amp;gt;&amp;gt;&amp;lt;\/td&amp;gt;\n\t\t\t&amp;lt;\/tr&amp;gt;\n\t\t\t&amp;lt;tr&amp;gt; \n\t\t\t\t&amp;lt;td&amp;gt;&amp;lt;span style=&quot;color:blue&quot;&amp;gt;reviews&amp;lt;\/span&amp;gt;&amp;lt;\/td&amp;gt;\n\t\t\t\t&amp;lt;td&amp;gt;&amp;lt;input type=&quot;text&quot; name=&quot;reviews&quot; value=&amp;lt;?php echo $reviews;?&amp;gt;&amp;gt;&amp;lt;\/td&amp;gt;\n\t\t\t&amp;lt;\/tr&amp;gt;\n\t\t\t&amp;lt;tr&amp;gt;\n\t\t\t\t&amp;lt;td&amp;gt;&amp;lt;input type=&quot;hidden&quot; name=&quot;id&quot; value=&amp;lt;?php echo $_GET&#x5B;'id'];?&amp;gt;&amp;gt;&amp;lt;\/td&amp;gt;\n\t\t\t\t&amp;lt;td&amp;gt;&amp;lt;input type=&quot;submit&quot; name=&quot;update&quot; value=&quot;Update&quot;&amp;gt;&amp;lt;\/td&amp;gt;\n\t\t\t&amp;lt;\/tr&amp;gt;\n\t\t&amp;lt;\/table&amp;gt;\n\t&amp;lt;\/form&amp;gt;\n&amp;lt;\/body&amp;gt;\n&amp;lt;\/html&amp;gt;\n\n\n<\/pre><\/div>\n\n\n<p><strong>STEP 5:<\/strong><\/p>\n\n\n\n<p>Create a file called&nbsp; <strong>delete.php<\/strong>&nbsp; , This will delete the content and directly delete in DB.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n&amp;lt;?php\n\/\/ include database connection file\n\ninclude_once(&quot;connection.php&quot;);\n\n\/\/ Get id from URL to delete that user\n$id = $_GET&#x5B;'id'];\n\n\/\/ Delete user row from table based on given id\n$result = mysqli_query($mysqli, &quot;DELETE FROM users WHERE id=$id&quot;);\n\n\/\/ After delete redirect to Home, so that latest user list will be displayed.\nheader(&quot;Location:list.php&quot;);\n?&amp;gt;\n<\/pre><\/div>\n\n\n<p>The output will look like this,<\/p>\n\n\n\n<p><strong>You can Edit \/ Delete a content&nbsp; Both in UI and DB<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-gallery columns-1 is-cropped wp-block-gallery-2 is-layout-flex wp-block-gallery-is-layout-flex\"><li class=\"blocks-gallery-item\"><figure><img loading=\"lazy\" decoding=\"async\" width=\"537\" height=\"225\" src=\"https:\/\/blog.pheonixsolutions.com\/wp-content\/uploads\/2018\/12\/crud-4.png\" alt=\"\" data-id=\"3044\" data-link=\"https:\/\/blog.pheonixsolutions.com\/?attachment_id=3044\" class=\"wp-image-3044\" srcset=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2018\/12\/crud-4.png 537w, https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2018\/12\/crud-4-300x126.png 300w\" sizes=\"auto, (max-width: 537px) 100vw, 537px\" \/><\/figure><\/li><\/ul>\n\n\n\n<p><strong>Step 6:<\/strong><\/p>\n\n\n\n<p>I named a file as &#8220;<strong>list.php<\/strong>&#8221; , this is index\u00a0 page for a total crud.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n&amp;lt;?php\n\/\/ Create database connection using config file\ninclude_once(&quot;connection.php&quot;);\n\n\/\/ Fetch all users data from database\n$result = mysqli_query($mysqli, &quot;SELECT * FROM users ORDER BY id DESC&quot;);\n?&amp;gt;\n\n&amp;lt;html&amp;gt;\n&amp;lt;head&amp;gt;    \n    &amp;lt;title&amp;gt;Homepage&amp;lt;\/title&amp;gt;\n&amp;lt;\/head&amp;gt;\n&amp;lt;style&amp;gt;\n&amp;lt;style&amp;gt;\n#rating {\n    font-family: &quot;Trebuchet MS&quot;, Arial, Helvetica, sans-serif;\n    border-collapse: collapse;\n    width: 100%;\n}\n\n#rating td, #rating th {\n    border: 1px solid #ddd;\n    padding: 8px;\n}\n\n#rating tr:nth-child(even){background-color: #f2f2f2;}\n\n#rating tr:hover {background-color: #ddd;}\n\n#rating th {\n    padding-top: 12px;\n    padding-bottom: 12px;\n    text-align: left;\n    background-color: blue;\n    color: white;\n}\n\ninput&#x5B;type=submit] {\n    float: left;\n    margin-right: 20px;\n    width: 180px;\n    height: 30px;\n    font-size: 14px;\n    font-weight: bold;\n    color: #fff;\n    background-color: #acd6ef; \/*IE fallback*\/\n    background-image: -webkit-gradient(linear, left top, left bottom, from(#acd6ef), to(#6ec2e8));\n    background-image: -moz-linear-gradient(top left 90deg, #acd6ef 0%, #6ec2e8 100%);\n    background-image: linear-gradient(top left 90deg, #acd6ef 0%, #6ec2e8 100%);\n    border-radius: 30px;\n    border: 1px solid #66add6;\n    box-shadow: 0 1px 2px rgba(0, 0, 0, .3), inset 0 1px 0 rgba(255, 255, 255, .5);\n    cursor: pointer;\n   }\n&amp;lt;\/style&amp;gt;\n&amp;lt;\/style&amp;gt;\n\n&amp;lt;body&amp;gt;\n&amp;lt;a href=&quot;add.php&quot;&amp;gt;&amp;lt;input type=&quot;submit&quot; name=&quot;Submit&quot; value=&quot;Add Ratings&quot;&amp;gt;&amp;lt;\/a&amp;gt;&amp;lt;br\/&amp;gt;&amp;lt;br\/&amp;gt;\n\n   \n\t&amp;lt;table id = &quot;rating&quot;&amp;gt;\n\n    &amp;lt;tr&amp;gt;\n        &amp;lt;th&amp;gt;rating&amp;lt;\/th&amp;gt; &amp;lt;th&amp;gt;clientname&amp;lt;\/th&amp;gt; &amp;lt;th&amp;gt;reviews&amp;lt;\/th&amp;gt; &amp;lt;th&amp;gt;Update&amp;lt;\/th&amp;gt;\n    &amp;lt;\/tr&amp;gt;\n    &amp;lt;?php  \n    while($user_data = mysqli_fetch_array($result)) {         \n        echo &quot;&amp;lt;tr&amp;gt;&quot;;\n        echo &quot;&amp;lt;td&amp;gt;&quot;.$user_data&#x5B;'rating'].&quot;&amp;lt;\/td&amp;gt;&quot;;\n        echo &quot;&amp;lt;td&amp;gt;&quot;.$user_data&#x5B;'clientname'].&quot;&amp;lt;\/td&amp;gt;&quot;;\n        echo &quot;&amp;lt;td&amp;gt;&quot;.$user_data&#x5B;'reviews'].&quot;&amp;lt;\/td&amp;gt;&quot;;    \n        echo &quot;&amp;lt;td&amp;gt;&amp;lt;a href='edit.php?id=$user_data&#x5B;id]'&amp;gt;Edit&amp;lt;\/a&amp;gt; | &amp;lt;a href='delete.php?id=$user_data&#x5B;id]'&amp;gt;Delete&amp;lt;\/a&amp;gt;&amp;lt;\/td&amp;gt;&amp;lt;\/tr&amp;gt;&quot;;        \n    }\n    ?&amp;gt;\n    &amp;lt;\/table&amp;gt;\n&amp;lt;\/body&amp;gt;\n&amp;lt;\/html&amp;gt;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"486\" height=\"265\" src=\"https:\/\/blog.pheonixsolutions.com\/wp-content\/uploads\/2018\/12\/image.png\" alt=\"\" class=\"wp-image-3048\" srcset=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2018\/12\/image.png 486w, https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2018\/12\/image-300x164.png 300w\" sizes=\"auto, (max-width: 486px) 100vw, 486px\" \/><\/figure>\n\n\n\n<p>In the above example, the effective usage of\u00a0 crud is explained clearly, you can modify the script according to your\u00a0 application and make benefit of it.\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>PHP Script for CRUD Application Date :06\/12\/2018 What is CRUD? CRUD refers to the four basic types of Database operations: Create, Read, Update, Delete. Most applications and projects perform\u00a0 CRUD functionality. This is a important script for all PHP beginners.\u00a0Once you learn about these CRUD operations, you can use them&hellip; <a href=\"https:\/\/pheonixsolutions.com\/blog\/php-script-for-crud-application\/\" class=\"more-link read-more\" rel=\"bookmark\">Continue Reading <span class=\"screen-reader-text\">PHP Script for CRUD Application<\/span><i class=\"fa fa-arrow-right\"><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[386,484,387,357,1],"tags":[504,503,506,505,273,339,507],"class_list":{"0":"post-3021","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-database","7":"category-html-css","8":"category-mysql-database","9":"category-php-windows-server","10":"category-uncategorized","11":"tag-create","12":"tag-crud","13":"tag-delete","14":"tag-edit","15":"tag-php","16":"tag-phpmyadmin","17":"tag-update","18":"h-entry","20":"h-as-article"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Pheonix Solutions - We Empower Your Business Growth<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/pheonixsolutions.com\/blog\/php-script-for-crud-application\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pheonix Solutions - We Empower Your Business Growth\" \/>\n<meta property=\"og:description\" content=\"PHP Script for CRUD Application Date :06\/12\/2018 What is CRUD? CRUD refers to the four basic types of Database operations: Create, Read, Update, Delete. Most applications and projects perform\u00a0 CRUD functionality. This is a important script for all PHP beginners.\u00a0Once you learn about these CRUD operations, you can use them&hellip; Continue Reading PHP Script for CRUD Application\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pheonixsolutions.com\/blog\/php-script-for-crud-application\/\" \/>\n<meta property=\"og:site_name\" content=\"PHEONIXSOLUTIONS\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/PheonixSolutions-209942982759387\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-12-10T04:01:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-03-30T05:02:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.pheonixsolutions.com\/wp-content\/uploads\/2018\/12\/crud1-1024x291.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@pheonixsolution\" \/>\n<meta name=\"twitter:site\" content=\"@pheonixsolution\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/php-script-for-crud-application\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/php-script-for-crud-application\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#\\\/schema\\\/person\\\/0ffa33d73c869faec2d50e79c24e3503\"},\"headline\":\"PHP Script for CRUD Application\",\"datePublished\":\"2018-12-10T04:01:41+00:00\",\"dateModified\":\"2019-03-30T05:02:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/php-script-for-crud-application\\\/\"},\"wordCount\":295,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/php-script-for-crud-application\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/blog.pheonixsolutions.com\\\/wp-content\\\/uploads\\\/2018\\\/12\\\/crud1-1024x291.png\",\"keywords\":[\"Create\",\"CRUD\",\"Delete\",\"Edit\",\"php\",\"Phpmyadmin\",\"Update\"],\"articleSection\":[\"Database\",\"HTML CSS\",\"Mysql\",\"PHP\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/php-script-for-crud-application\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/php-script-for-crud-application\\\/\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/php-script-for-crud-application\\\/\",\"name\":\"Pheonix Solutions - We Empower Your Business Growth\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/php-script-for-crud-application\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/php-script-for-crud-application\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/blog.pheonixsolutions.com\\\/wp-content\\\/uploads\\\/2018\\\/12\\\/crud1-1024x291.png\",\"datePublished\":\"2018-12-10T04:01:41+00:00\",\"dateModified\":\"2019-03-30T05:02:46+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/php-script-for-crud-application\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/php-script-for-crud-application\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/php-script-for-crud-application\\\/#primaryimage\",\"url\":\"https:\\\/\\\/blog.pheonixsolutions.com\\\/wp-content\\\/uploads\\\/2018\\\/12\\\/crud1-1024x291.png\",\"contentUrl\":\"https:\\\/\\\/blog.pheonixsolutions.com\\\/wp-content\\\/uploads\\\/2018\\\/12\\\/crud1-1024x291.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/php-script-for-crud-application\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PHP Script for CRUD Application\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/\",\"name\":\"Pheonix Solutions\",\"description\":\"We Empower Your Business Growth\",\"publisher\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#organization\",\"name\":\"PheonixSolutions\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/logo.png\",\"contentUrl\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/logo.png\",\"width\":454,\"height\":300,\"caption\":\"PheonixSolutions\"},\"image\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/PheonixSolutions-209942982759387\\\/\",\"https:\\\/\\\/x.com\\\/pheonixsolution\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#\\\/schema\\\/person\\\/0ffa33d73c869faec2d50e79c24e3503\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/09bacc0294abee1322a23ab4bc6a0330dd4cb4df707dc9d0b0efeba6c109608b?s=96&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/09bacc0294abee1322a23ab4bc6a0330dd4cb4df707dc9d0b0efeba6c109608b?s=96&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/09bacc0294abee1322a23ab4bc6a0330dd4cb4df707dc9d0b0efeba6c109608b?s=96&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"http:\\\/\\\/blog.pheonixsolutions.com\"],\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Pheonix Solutions - We Empower Your Business Growth","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:\/\/pheonixsolutions.com\/blog\/php-script-for-crud-application\/","og_locale":"en_US","og_type":"article","og_title":"Pheonix Solutions - We Empower Your Business Growth","og_description":"PHP Script for CRUD Application Date :06\/12\/2018 What is CRUD? CRUD refers to the four basic types of Database operations: Create, Read, Update, Delete. Most applications and projects perform\u00a0 CRUD functionality. This is a important script for all PHP beginners.\u00a0Once you learn about these CRUD operations, you can use them&hellip; Continue Reading PHP Script for CRUD Application","og_url":"https:\/\/pheonixsolutions.com\/blog\/php-script-for-crud-application\/","og_site_name":"PHEONIXSOLUTIONS","article_publisher":"https:\/\/www.facebook.com\/PheonixSolutions-209942982759387\/","article_published_time":"2018-12-10T04:01:41+00:00","article_modified_time":"2019-03-30T05:02:46+00:00","og_image":[{"url":"https:\/\/blog.pheonixsolutions.com\/wp-content\/uploads\/2018\/12\/crud1-1024x291.png","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_creator":"@pheonixsolution","twitter_site":"@pheonixsolution","twitter_misc":{"Written by":"admin","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pheonixsolutions.com\/blog\/php-script-for-crud-application\/#article","isPartOf":{"@id":"https:\/\/pheonixsolutions.com\/blog\/php-script-for-crud-application\/"},"author":{"name":"admin","@id":"https:\/\/pheonixsolutions.com\/blog\/#\/schema\/person\/0ffa33d73c869faec2d50e79c24e3503"},"headline":"PHP Script for CRUD Application","datePublished":"2018-12-10T04:01:41+00:00","dateModified":"2019-03-30T05:02:46+00:00","mainEntityOfPage":{"@id":"https:\/\/pheonixsolutions.com\/blog\/php-script-for-crud-application\/"},"wordCount":295,"commentCount":0,"publisher":{"@id":"https:\/\/pheonixsolutions.com\/blog\/#organization"},"image":{"@id":"https:\/\/pheonixsolutions.com\/blog\/php-script-for-crud-application\/#primaryimage"},"thumbnailUrl":"https:\/\/blog.pheonixsolutions.com\/wp-content\/uploads\/2018\/12\/crud1-1024x291.png","keywords":["Create","CRUD","Delete","Edit","php","Phpmyadmin","Update"],"articleSection":["Database","HTML CSS","Mysql","PHP"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/pheonixsolutions.com\/blog\/php-script-for-crud-application\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/pheonixsolutions.com\/blog\/php-script-for-crud-application\/","url":"https:\/\/pheonixsolutions.com\/blog\/php-script-for-crud-application\/","name":"Pheonix Solutions - We Empower Your Business Growth","isPartOf":{"@id":"https:\/\/pheonixsolutions.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/pheonixsolutions.com\/blog\/php-script-for-crud-application\/#primaryimage"},"image":{"@id":"https:\/\/pheonixsolutions.com\/blog\/php-script-for-crud-application\/#primaryimage"},"thumbnailUrl":"https:\/\/blog.pheonixsolutions.com\/wp-content\/uploads\/2018\/12\/crud1-1024x291.png","datePublished":"2018-12-10T04:01:41+00:00","dateModified":"2019-03-30T05:02:46+00:00","breadcrumb":{"@id":"https:\/\/pheonixsolutions.com\/blog\/php-script-for-crud-application\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pheonixsolutions.com\/blog\/php-script-for-crud-application\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pheonixsolutions.com\/blog\/php-script-for-crud-application\/#primaryimage","url":"https:\/\/blog.pheonixsolutions.com\/wp-content\/uploads\/2018\/12\/crud1-1024x291.png","contentUrl":"https:\/\/blog.pheonixsolutions.com\/wp-content\/uploads\/2018\/12\/crud1-1024x291.png"},{"@type":"BreadcrumbList","@id":"https:\/\/pheonixsolutions.com\/blog\/php-script-for-crud-application\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pheonixsolutions.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PHP Script for CRUD Application"}]},{"@type":"WebSite","@id":"https:\/\/pheonixsolutions.com\/blog\/#website","url":"https:\/\/pheonixsolutions.com\/blog\/","name":"Pheonix Solutions","description":"We Empower Your Business Growth","publisher":{"@id":"https:\/\/pheonixsolutions.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pheonixsolutions.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/pheonixsolutions.com\/blog\/#organization","name":"PheonixSolutions","url":"https:\/\/pheonixsolutions.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pheonixsolutions.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/logo.png","contentUrl":"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/logo.png","width":454,"height":300,"caption":"PheonixSolutions"},"image":{"@id":"https:\/\/pheonixsolutions.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/PheonixSolutions-209942982759387\/","https:\/\/x.com\/pheonixsolution"]},{"@type":"Person","@id":"https:\/\/pheonixsolutions.com\/blog\/#\/schema\/person\/0ffa33d73c869faec2d50e79c24e3503","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/09bacc0294abee1322a23ab4bc6a0330dd4cb4df707dc9d0b0efeba6c109608b?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/09bacc0294abee1322a23ab4bc6a0330dd4cb4df707dc9d0b0efeba6c109608b?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/09bacc0294abee1322a23ab4bc6a0330dd4cb4df707dc9d0b0efeba6c109608b?s=96&r=g","caption":"admin"},"sameAs":["http:\/\/blog.pheonixsolutions.com"],"url":"https:\/\/pheonixsolutions.com\/blog\/author\/admin\/"}]}},"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p7F4uM-MJ","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/3021","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=3021"}],"version-history":[{"count":0,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/3021\/revisions"}],"wp:attachment":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=3021"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=3021"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=3021"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}