{"id":5570,"date":"2026-03-30T16:15:01","date_gmt":"2026-03-30T10:45:01","guid":{"rendered":"https:\/\/codematrix.co.in\/blog\/?page_id=5570"},"modified":"2026-04-01T13:11:10","modified_gmt":"2026-04-01T07:41:10","slug":"crud-apps","status":"publish","type":"page","link":"https:\/\/codematrix.co.in\/blog\/crud-apps\/","title":{"rendered":"CRUD Apps"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"5570\" class=\"elementor elementor-5570\">\n\t\t\t\t<div class=\"elementor-element elementor-element-cf50994 e-flex e-con-boxed e-con e-parent\" data-id=\"cf50994\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-36b8984 elementor-widget elementor-widget-html\" data-id=\"36b8984\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t\t<style>\r\n    \/* --- Brand Styling --- *\/\r\n    :root {\r\n        --brand-purple: #9C00E4;\r\n        --brand-light: #f3e8ff;\r\n    }\r\n\r\n    \/* Reset & Base *\/\r\n    .python-full-layout * { box-sizing: border-box; }\r\n\r\n    \/* Layout Adjustments *\/\r\n    .python-full-layout { \r\n        display: flex; \r\n        gap: 30px; \r\n        padding: 20px; \r\n        max-width: 1200px; \r\n        margin: 0 auto;\r\n        background: #fdfbff; \r\n    }\r\n\r\n    .sidebar { \r\n        width: 280px; \r\n        position: sticky; \r\n        top: 20px; \r\n        height: fit-content; \r\n        flex-shrink: 0;\r\n    }\r\n\r\n    .sidebar .topic { \r\n        display: block; \r\n        padding: 12px; \r\n        text-decoration: none; \r\n        color: #444; \r\n        border-radius: 8px; \r\n        margin-bottom: 8px; \r\n        background: #fff;\r\n        border: 1px solid #eee;\r\n        transition: 0.3s;\r\n    }\r\n\r\n    .sidebar .topic.active { \r\n        background: var(--brand-purple); \r\n        color: white; \r\n        border-color: var(--brand-purple);\r\n    }\r\n\r\n    \/* Main Content *\/\r\n    .main-content { \r\n        flex: 1; \r\n        font-family: 'Segoe UI', sans-serif; \r\n        min-width: 0; \r\n    }\r\n\r\n    .article-card { \r\n        background: white; \r\n        padding: 30px; \r\n        border-radius: 15px; \r\n        box-shadow: 0 4px 15px rgba(0,0,0,0.05); \r\n    }\r\n\r\n    h1 { color: var(--brand-purple); font-size: 2.2rem; margin-bottom: 20px; }\r\n    h2 { color: #333; margin-top: 30px; border-left: 4px solid var(--brand-purple); padding-left: 15px; }\r\n    \r\n    .custom-img { \r\n        display: block; \r\n        margin: 30px auto; \r\n        width: 100%; \r\n        max-width: 600px; \r\n        border: 2px solid #e9d5ff; \r\n        border-radius: 10px;\r\n    }\r\n\r\n    table { \r\n        width: 100%; \r\n        border-collapse: collapse; \r\n        margin: 20px 0; \r\n    }\r\n\r\n    table th, table td { \r\n        border: 1px solid #eee; \r\n        padding: 12px; \r\n        text-align: left; \r\n    }\r\n\r\n    table th { background: #f8f9fa; color: var(--brand-purple); }\r\n\r\n    \/* Responsive *\/\r\n    @media (max-width: 991px) {\r\n        .python-full-layout { flex-direction: column; }\r\n        .sidebar { width: 100%; position: relative; top: 0; }\r\n    }\r\n<\/style>\r\n\r\n<div class=\"python-full-layout\">\r\n    <aside class=\"sidebar\">\r\n        <h2 style=\"font-size: 1.2rem; color: var(--brand-purple); margin-bottom: 15px;\">App Development<\/h2>\r\n        <a href=\"#definition\" class=\"topic active\">What is CRUD?<\/a>\r\n        <a href=\"#breakdown\" class=\"topic\">1. CRUD Operations<\/a>\r\n        <a href=\"#http\" class=\"topic\">2. Mapping to HTTP<\/a>\r\n        <a href=\"#sql\" class=\"topic\">3. Mapping to SQL<\/a>\r\n        <a href=\"#mcq\" class=\"topic\">Practice MCQs<\/a>\r\n    <\/aside>\r\n\r\n    <main class=\"main-content\">\r\n        <article class=\"article-card\">\r\n            \r\n            <header id=\"definition\">\r\n                <h1>Understanding CRUD Apps<\/h1>\r\n                <p><strong>CRUD<\/strong> is an acronym that stands for the four basic functions of persistent storage. Most applications you use daily (like Instagram, Amazon, or a To-Do list) are essentially <strong>CRUD Apps<\/strong> because they allow users to manipulate data in a database.<\/p>\r\n            <\/header>\r\n\r\n            <img decoding=\"async\" src=\"http:\/\/codematrix.co.in\/blog\/wp-content\/uploads\/2026\/04\/CRUD-first-header.jpg\" alt=\"CRUD Apps\" class=\"custom-img\">\r\n            \r\n\r\n            <section id=\"breakdown\">\r\n                <h2>1. The Four Operations<\/h2>\r\n                <ul>\r\n                    <li><strong>Create:<\/strong> Adding new entries to the database (e.g., signing up for a new account).<\/li>\r\n                    <li><strong>Read:<\/strong> Viewing or searching for existing data (e.g., browsing your news feed).<\/li>\r\n                    <li><strong>Update:<\/strong> Editing existing information (e.g., changing your profile picture).<\/li>\r\n                    <li><strong>Delete:<\/strong> Removing data from the system (e.g., deleting a post).<\/li>\r\n                <\/ul>\r\n            <\/section>\r\n\r\n            <section id=\"http\">\r\n                <h2>2. CRUD vs. HTTP Methods<\/h2>\r\n                <p>In web development (REST APIs), CRUD operations are mapped to specific HTTP verbs:<\/p>\r\n                <table>\r\n                    <thead>\r\n                        <tr>\r\n                            <th>Operation<\/th>\r\n                            <th>HTTP Verb<\/th>\r\n                            <th>Description<\/th>\r\n                        <\/tr>\r\n                    <\/thead>\r\n                    <tbody>\r\n                        <tr><td><strong>Create<\/strong><\/td><td>POST<\/td><td>Submits data to the server.<\/td><\/tr>\r\n                        <tr><td><strong>Read<\/strong><\/td><td>GET<\/td><td>Retrieves data from the server.<\/td><\/tr>\r\n                        <tr><td><strong>Update<\/strong><\/td><td>PUT \/ PATCH<\/td><td>Modifies existing data.<\/td><\/tr>\r\n                        <tr><td><strong>Delete<\/strong><\/td><td>DELETE<\/td><td>Removes data.<\/td><\/tr>\r\n                    <\/tbody>\r\n                <\/table>\r\n            <\/section>\r\n\r\n            \r\n            \r\n\r\n            <section id=\"sql\">\r\n                <h2>3. CRUD in Databases (SQL)<\/h2>\r\n                <p>If you are working with databases like MySQL or PostgreSQL, you use these commands:<\/p>\r\n                <ul>\r\n                    <li><strong>Create<\/strong> &rarr; INSERT<\/li>\r\n                    <li><strong>Read<\/strong> &rarr; SELECT<\/li>\r\n                    <li><strong>Update<\/strong> &rarr; UPDATE<\/li>\r\n                    <li><strong>Delete<\/strong> &rarr; DELETE<\/li>\r\n                <\/ul>\r\n            <\/section>\r\n\r\n            <section id=\"mcq\" class=\"practice-mcqs\">\r\n                <h2>Knowledge Check<\/h2>\r\n                <div class=\"mcq-box\" style=\"background: #f9f4ff; padding: 20px; border-radius: 10px; border: 1px solid #e9d5ff;\">\r\n                    <p><strong>1. Which HTTP method is used for the \"Create\" operation?<\/strong><br>\r\n                    A) GET | B) <strong>POST<\/strong> | C) PUT<\/p>\r\n                    \r\n                    <p><strong>2. In a social media app, \"liking\" a post (which changes the like count) is which operation?<\/strong><br>\r\n                    A) Create | B) Read | C) <strong>Update<\/strong><\/p>\r\n\r\n                    <p><strong>3. Which SQL command corresponds to the \"Read\" operation?<\/strong><br>\r\n                    A) <strong>SELECT<\/strong> | B) INSERT | C) DROP<\/p>\r\n                <\/div>\r\n            <\/section>\r\n\r\n            <div style=\"text-align: center; margin-top: 40px;\">\r\n                <a href=\"https:\/\/codematrix.co.in\/courses\" target=\"_blank\" style=\"background: var(--brand-purple); color: white; padding: 12px 25px; text-decoration: none; border-radius: 8px; display: inline-block; font-weight: bold;\">\r\n                    \ud83d\ude80 Build Your First CRUD App!\r\n                <\/a>\r\n            <\/div>\r\n\r\n        <\/article>\r\n    <\/main>\r\n<\/div>\r\n\r\n<script>\r\nwindow.addEventListener('DOMContentLoaded', () => {\r\n    const sections = document.querySelectorAll('header[id], section[id]');\r\n    const navLinks = document.querySelectorAll('.sidebar .topic');\r\n\r\n    const observer = new IntersectionObserver((entries) => {\r\n        entries.forEach(entry => {\r\n            if (entry.isIntersecting) {\r\n                navLinks.forEach(link => {\r\n                    link.classList.remove('active');\r\n                    if (link.getAttribute('href') === `#${entry.target.id}`) {\r\n                        link.classList.add('active');\r\n                    }\r\n                });\r\n            }\r\n        });\r\n    }, { threshold: 0.5 });\r\n    sections.forEach(section => observer.observe(section));\r\n});\r\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>App Development What is CRUD? 1. CRUD Operations 2. Mapping to HTTP 3. Mapping to SQL Practice MCQs Understanding CRUD [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"no-sidebar","site-content-layout":"","ast-site-content-layout":"full-width-container","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":"disabled","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":""}},"footnotes":""},"class_list":["post-5570","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/codematrix.co.in\/blog\/wp-json\/wp\/v2\/pages\/5570","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/codematrix.co.in\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/codematrix.co.in\/blog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/codematrix.co.in\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/codematrix.co.in\/blog\/wp-json\/wp\/v2\/comments?post=5570"}],"version-history":[{"count":7,"href":"https:\/\/codematrix.co.in\/blog\/wp-json\/wp\/v2\/pages\/5570\/revisions"}],"predecessor-version":[{"id":6561,"href":"https:\/\/codematrix.co.in\/blog\/wp-json\/wp\/v2\/pages\/5570\/revisions\/6561"}],"wp:attachment":[{"href":"https:\/\/codematrix.co.in\/blog\/wp-json\/wp\/v2\/media?parent=5570"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}