{"id":3021,"date":"2018-12-10T09:31:41","date_gmt":"2018-12-10T04:01:41","guid":{"rendered":"https:\/\/pheonixsolutions.com\/blog\/?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":"

PHP Script for CRUD Application<\/h2>\n

Date :06\/12\/2018<\/strong><\/h4>\n

What is CRUD?<\/h3>\n

CRUD refers to the four basic types of Database operations: Create, Read, Update, Delete. Most applications and projects perform\u00a0 CRUD functionality.<\/p>\n

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

Executing a CRUD Script<\/strong><\/h3>\n

Step by step procedure are as follows;<\/p>\n

STEP 1:<\/strong><\/h5>\n
    \n
  • In this script, I have taken a example as testimonial section for CRUD usage.<\/li>\n
  • In a PHPMYADMIN\u00a0<\/strong> , create a database Name “testimonials<\/strong>“<\/li>\n
  • Create a table name as “users<\/strong>“<\/li>\n
  • Create a table structure of rows having\u00a0 id<\/strong> , rating<\/strong>, clientname<\/strong>, reviews.\u00a0<\/strong> I have attached a snapshot below,<\/li>\n<\/ul>\n

    \"This<\/p>\n

    STEP 2:<\/strong><\/h5>\n

    Create a connection.php<\/strong> file in your favorite text editor and execute the below script to make connection with your DB.<\/p>\n

    <?php\n\n$databaseHost = 'localhost';\n$databaseName = 'testimonials';\n$databaseUsername = 'root';\n$databasePassword = '';\n\n$mysqli = mysqli_connect($databaseHost, $databaseUsername, $databasePassword, $databaseName); \n \n?>\n<\/pre>\n
    Step 3:<\/strong><\/h5>\n
    Create add.php<\/strong> file and execute the below script for adding the Information and to insert a queries in to DB.<\/p>\n
    The programming script is with Enhanced CSS quality. Take a look on it and make use of it,<\/p>\n
    <html>\n<style>\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<\/style>\n<body>\n  <a href=\"list.php\"><input type=\"submit\" value=\"<< Added \" name=\"Go Back\" \/><\/a>\n  <br\/><br\/>\n\n  <form action=\"add.php\" method=\"post\" name=\"form1\">\n    <table width=\"25%\" border=\"0\">\n      <tr> \n        <td><span style=\"color:blue\">rating<\/span><\/td>\n        <td><input type=\"text\" name=\"rating\"><\/td>\n      <\/tr>\n      <tr> \n        <td><span style=\"color:blue\">clientname<\/span><\/td>\n        <td><input type=\"text\" name=\"clientname\"><\/td>\n      <\/tr>\n      <tr> \n          <td><span style=\"color:blue\">reviews<\/span><\/td>\n        <td><input type=\"text\" name=\"reviews\"><\/td>\n      <\/tr>\n      <tr> \n        \n        <td><input type=\"submit\" name=\"Submit\" value=\"Add >>\"><\/td>\n      <\/tr>\n      \n    <\/table>\n  <\/form>\n  \n  <?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     ?>\n  \n<\/body>\n<\/html>


    <\/pre>\n
    Once You execute this in XAMPP , the output will be like this.<\/p>\n\n\n
    • \"\"<\/figure><\/li><\/ul>\n\n\n\n
      STEP 4:<\/strong><\/p>\n\n\n\n
      Create 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
      \n&lt;?php\n\/\/ include database connection file\ninclude_once("connection.php");\n\n\/\/ Check if form is submitted for user update, then redirect to homepage after update\nif(isset($_POST['update']))\n{\t\n\t\n\t$id = $_POST['id'];\n\t\n\t$rating=$_POST['rating'];\n\t$clientname=$_POST['clientname'];\n\t$reviews=$_POST['reviews'];\n\t\t\n\t\/\/ update user data\n\t$result = mysqli_query($mysqli, "UPDATE users SET rating='$rating',clientname='$clientname',reviews='$reviews' WHERE id=$id");\n\t\n\t\/\/ Redirect to homepage to display updated user in list\n\theader("Location: list.php");\n}\n?&gt;\n&lt;?php\n\/\/ Display selected user data based on id\n\/\/ Getting id from url\n$id = $_GET['id'];\n\n\/\/ Fetech user data based on id\n$result = mysqli_query($mysqli, "SELECT * FROM users WHERE id=$id");\n\nwhile($user_data = mysqli_fetch_array($result))\n{\n\t$rating = $user_data['rating'];\n\t$clientname = $user_data['clientname'];\n\t$reviews = $user_data['reviews'];\n\t\n}\n?&gt;\n&lt;html&gt;\n&lt;head&gt;\t\n\t&lt;title&gt;Edit User Data&lt;\/title&gt;\n&lt;\/head&gt;\n &lt;style&gt;\n    input[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[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   &lt;\/style&gt;\n   &lt;body&gt;\n   \n\t&lt;a href="list.php"&gt;&lt;input type="submit" name="Submit" value="Home Listings"&gt;&lt;\/a&gt;\n\t&lt;br\/&gt;&lt;br\/&gt;\n\t\n\t&lt;form name="update_user" method="post" action="edit.php"&gt;\n\t\t&lt;table border="0"&gt;\n\t\t\t&lt;tr&gt; \n\t\t\t\t&lt;td&gt;&lt;span style="color:blue"&gt;rating&lt;\/span&gt;&lt;\/td&gt;\n\t\t\t\t&lt;td&gt;&lt;input type="text" name="rating" value=&lt;?php echo $rating;?&gt;&gt;&lt;\/td&gt;\n\t\t\t&lt;\/tr&gt;\n\t\t\t&lt;tr&gt; \n\t\t\t\t&lt;td&gt;&lt;span style="color:blue"&gt;clientname&lt;\/span&gt;&lt;\/td&gt;\n\t\t\t\t&lt;td&gt;&lt;input type="text" name="clientname" value=&lt;?php echo $clientname;?&gt;&gt;&lt;\/td&gt;\n\t\t\t&lt;\/tr&gt;\n\t\t\t&lt;tr&gt; \n\t\t\t\t&lt;td&gt;&lt;span style="color:blue"&gt;reviews&lt;\/span&gt;&lt;\/td&gt;\n\t\t\t\t&lt;td&gt;&lt;input type="text" name="reviews" value=&lt;?php echo $reviews;?&gt;&gt;&lt;\/td&gt;\n\t\t\t&lt;\/tr&gt;\n\t\t\t&lt;tr&gt;\n\t\t\t\t&lt;td&gt;&lt;input type="hidden" name="id" value=&lt;?php echo $_GET['id'];?&gt;&gt;&lt;\/td&gt;\n\t\t\t\t&lt;td&gt;&lt;input type="submit" name="update" value="Update"&gt;&lt;\/td&gt;\n\t\t\t&lt;\/tr&gt;\n\t\t&lt;\/table&gt;\n\t&lt;\/form&gt;\n&lt;\/body&gt;\n&lt;\/html&gt;\n\n\n<\/pre><\/div>\n\n\n
      STEP 5:<\/strong><\/p>\n\n\n\n
      Create a file called  delete.php<\/strong>  , This will delete the content and directly delete in DB.<\/p>\n\n\n
      \n&lt;?php\n\/\/ include database connection file\n\ninclude_once("connection.php");\n\n\/\/ Get id from URL to delete that user\n$id = $_GET['id'];\n\n\/\/ Delete user row from table based on given id\n$result = mysqli_query($mysqli, "DELETE FROM users WHERE id=$id");\n\n\/\/ After delete redirect to Home, so that latest user list will be displayed.\nheader("Location:list.php");\n?&gt;\n<\/pre><\/div>\n\n\n
      The output will look like this,<\/p>\n\n\n\n
      You can Edit \/ Delete a content  Both in UI and DB<\/strong><\/p>\n\n\n\n
      • \"\"<\/figure><\/li><\/ul>\n\n\n\n
        Step 6:<\/strong><\/p>\n\n\n\n
        I named a file as “list.php<\/strong>” , this is index\u00a0 page for a total crud.<\/p>\n\n\n
        \n&lt;?php\n\/\/ Create database connection using config file\ninclude_once("connection.php");\n\n\/\/ Fetch all users data from database\n$result = mysqli_query($mysqli, "SELECT * FROM users ORDER BY id DESC");\n?&gt;\n\n&lt;html&gt;\n&lt;head&gt;    \n    &lt;title&gt;Homepage&lt;\/title&gt;\n&lt;\/head&gt;\n&lt;style&gt;\n&lt;style&gt;\n#rating {\n    font-family: "Trebuchet MS", 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[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&lt;\/style&gt;\n&lt;\/style&gt;\n\n&lt;body&gt;\n&lt;a href="add.php"&gt;&lt;input type="submit" name="Submit" value="Add Ratings"&gt;&lt;\/a&gt;&lt;br\/&gt;&lt;br\/&gt;\n\n   \n\t&lt;table id = "rating"&gt;\n\n    &lt;tr&gt;\n        &lt;th&gt;rating&lt;\/th&gt; &lt;th&gt;clientname&lt;\/th&gt; &lt;th&gt;reviews&lt;\/th&gt; &lt;th&gt;Update&lt;\/th&gt;\n    &lt;\/tr&gt;\n    &lt;?php  \n    while($user_data = mysqli_fetch_array($result)) {         \n        echo "&lt;tr&gt;";\n        echo "&lt;td&gt;".$user_data['rating']."&lt;\/td&gt;";\n        echo "&lt;td&gt;".$user_data['clientname']."&lt;\/td&gt;";\n        echo "&lt;td&gt;".$user_data['reviews']."&lt;\/td&gt;";    \n        echo "&lt;td&gt;&lt;a href='edit.php?id=$user_data[id]'&gt;Edit&lt;\/a&gt; | &lt;a href='delete.php?id=$user_data[id]'&gt;Delete&lt;\/a&gt;&lt;\/td&gt;&lt;\/tr&gt;";        \n    }\n    ?&gt;\n    &lt;\/table&gt;\n&lt;\/body&gt;\n&lt;\/html&gt;\n<\/pre><\/div>\n\n\n
        \"\"<\/figure>\n\n\n\n
        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":"
        PHP Script for CRUD Application Date :06\/12\/2018 What is CRUD? CRUD refers to the four basic types of Database operations: […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[1022],"tags":[504,503,506,505,273,339,507],"class_list":["post-3021","post","type-post","status-publish","format-standard","hentry","category-web-architecture","tag-create","tag-crud","tag-delete","tag-edit","tag-php","tag-phpmyadmin","tag-update","psol-cat-web-architecture"],"jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/phn2x7-MJ","jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_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}]}}