{"id":376,"date":"2023-05-24T03:38:52","date_gmt":"2023-05-24T03:38:52","guid":{"rendered":"https:\/\/www.devopsconsulting.in\/blog\/?p=376"},"modified":"2023-05-24T03:38:53","modified_gmt":"2023-05-24T03:38:53","slug":"how-to-stored-data-in-procedure","status":"publish","type":"post","link":"https:\/\/www.devopsconsulting.in\/blog\/how-to-stored-data-in-procedure\/","title":{"rendered":"How to stored data in procedure"},"content":{"rendered":"\n<p><strong>To store data from a request using a stored procedure in Laravel 9, you can follow these steps:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"805\" height=\"440\" src=\"https:\/\/www.devopsconsulting.in\/blog\/wp-content\/uploads\/2023\/05\/image-18.png\" alt=\"\" class=\"wp-image-377\" srcset=\"https:\/\/www.devopsconsulting.in\/blog\/wp-content\/uploads\/2023\/05\/image-18.png 805w, https:\/\/www.devopsconsulting.in\/blog\/wp-content\/uploads\/2023\/05\/image-18-300x164.png 300w, https:\/\/www.devopsconsulting.in\/blog\/wp-content\/uploads\/2023\/05\/image-18-768x420.png 768w\" sizes=\"auto, (max-width: 805px) 100vw, 805px\" \/><\/figure>\n\n\n\n<p><strong>Create the Stored Procedure:<\/strong> In your database management system, create a stored procedure that handles the insertion of data. The stored procedure should accept parameters that match the fields in your table. For example, let&#8217;s assume you have a table named &#8220;users&#8221; with fields &#8220;name&#8221; and &#8220;email&#8221;. Here&#8217;s an example of a stored procedure in MySQL:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DELIMITER \/\/\r\nCREATE PROCEDURE sp_insert_user(IN p_name VARCHAR(255), IN p_email VARCHAR(255))\r\nBEGIN\r\n    INSERT INTO users (name, email) VALUES (p_name, p_email);\r\nEND \/\/\r\nDELIMITER ;<\/code><\/pre>\n\n\n\n<p><strong>Create a Controller:<\/strong> Generate a controller that will handle the request and call the stored procedure. You can use the Artisan command php artisan make:controller UserController to create a UserController.<\/p>\n\n\n\n<p><strong>Define the Store Method:<\/strong> In your UserController, define a store method that will handle the request and call the stored procedure. The method should receive a Request object and use the DB facade to execute the stored procedure. For example:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>use Illuminate\\Http\\Request;\r\nuse Illuminate\\Support\\Facades\\DB;\r\n\r\npublic function store(Request $request)\r\n{\r\n    $name = $request->input('name');\r\n    $email = $request->input('email');\r\n\r\n    DB::statement(\"CALL sp_insert_user(?, ?)\", &#91;$name, $email]);\r\n\r\n    \/\/ Optionally, you can return a response or redirect\r\n}<\/code><\/pre>\n\n\n\n<p><strong>Route Configuration:<\/strong> Configure a route to map the URL to your UserController&#8217;s store method. Open the routes\/web.php file and add a route definition. For example:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>use App\\Http\\Controllers\\UserController;\r\n\r\nRoute::post('\/users', &#91;UserController::class, 'store'])<\/code><\/pre>\n\n\n\n<p><strong>Blade Form Submission:<\/strong> In your Blade view, create a form that submits the data to the defined route. Ensure that the form method matches the route method (e.g., POST). For example:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;form method=\"POST\" action=\"\/users\">\r\n    @csrf\r\n    &lt;input type=\"text\" name=\"name\" placeholder=\"Name\">\r\n    &lt;input type=\"email\" name=\"email\" placeholder=\"Email\">\r\n    &lt;button type=\"submit\">Submit&lt;\/button>\r\n&lt;\/form>\r<\/code><\/pre>\n\n\n\n<p>That&#8217;s it! When the form is submitted, the data will be passed to the store method in your UserController, and Laravel will execute the stored procedure to store the data in the database. Adjust the stored procedure name, table name, and field names as per your database structure.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To store data from a request using a stored procedure in Laravel 9, you can follow these steps: Create the Stored Procedure: In your database management system,&#8230; <\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[77],"class_list":["post-376","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-stored-procedure"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to stored data in procedure - DevOps Consulting<\/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:\/\/www.devopsconsulting.in\/blog\/how-to-stored-data-in-procedure\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to stored data in procedure - DevOps Consulting\" \/>\n<meta property=\"og:description\" content=\"To store data from a request using a stored procedure in Laravel 9, you can follow these steps: Create the Stored Procedure: In your database management system,...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.devopsconsulting.in\/blog\/how-to-stored-data-in-procedure\/\" \/>\n<meta property=\"og:site_name\" content=\"DevOps Consulting\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-24T03:38:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-24T03:38:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.devopsconsulting.in\/blog\/wp-content\/uploads\/2023\/05\/image-18.png\" \/>\n<meta name=\"author\" content=\"Abhishek Singh\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Abhishek Singh\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-stored-data-in-procedure\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-stored-data-in-procedure\\\/\"},\"author\":{\"name\":\"Abhishek Singh\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#\\\/schema\\\/person\\\/fc397ba8be42f9fdd53450edfc73006f\"},\"headline\":\"How to stored data in procedure\",\"datePublished\":\"2023-05-24T03:38:52+00:00\",\"dateModified\":\"2023-05-24T03:38:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-stored-data-in-procedure\\\/\"},\"wordCount\":261,\"commentCount\":1,\"image\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-stored-data-in-procedure\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/05\\\/image-18.png\",\"keywords\":[\"stored Procedure\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-stored-data-in-procedure\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-stored-data-in-procedure\\\/\",\"url\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-stored-data-in-procedure\\\/\",\"name\":\"How to stored data in procedure - DevOps Consulting\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-stored-data-in-procedure\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-stored-data-in-procedure\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/05\\\/image-18.png\",\"datePublished\":\"2023-05-24T03:38:52+00:00\",\"dateModified\":\"2023-05-24T03:38:53+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#\\\/schema\\\/person\\\/fc397ba8be42f9fdd53450edfc73006f\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-stored-data-in-procedure\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-stored-data-in-procedure\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/05\\\/image-18.png\",\"contentUrl\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/05\\\/image-18.png\",\"width\":805,\"height\":440},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/\",\"name\":\"DevOps Consulting\",\"description\":\"DevOps Consulting | SRE Consulting | DevSecOps Consulting | MLOps Consulting\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#\\\/schema\\\/person\\\/fc397ba8be42f9fdd53450edfc73006f\",\"name\":\"Abhishek Singh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g\",\"caption\":\"Abhishek Singh\"},\"description\":\"I\u2019m Abhishek, a DevOps, SRE, DevSecOps, and Cloud expert with a passion for sharing knowledge and real-world experiences. I\u2019ve had the opportunity to work with Cotocus and continue to contribute to multiple platforms where I share insights across different domains: \u2022 DevOps School \u2013 Tech blogs and tutorials \u2022 Holiday Landmark \u2013 Travel stories and guides \u2022 Stocks Mantra \u2013 Stock market strategies and tips \u2022 My Medic Plus \u2013 Health and fitness guidance \u2022 TrueReviewNow \u2013 Honest product reviews \u2022 Wizbrand \u2013 SEO and digital tools for businesses I\u2019m also exploring the fascinating world of Quantum Computing.\",\"url\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/author\\\/abhishek\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to stored data in procedure - DevOps Consulting","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.devopsconsulting.in\/blog\/how-to-stored-data-in-procedure\/","og_locale":"en_US","og_type":"article","og_title":"How to stored data in procedure - DevOps Consulting","og_description":"To store data from a request using a stored procedure in Laravel 9, you can follow these steps: Create the Stored Procedure: In your database management system,...","og_url":"https:\/\/www.devopsconsulting.in\/blog\/how-to-stored-data-in-procedure\/","og_site_name":"DevOps Consulting","article_published_time":"2023-05-24T03:38:52+00:00","article_modified_time":"2023-05-24T03:38:53+00:00","og_image":[{"url":"https:\/\/www.devopsconsulting.in\/blog\/wp-content\/uploads\/2023\/05\/image-18.png","type":"","width":"","height":""}],"author":"Abhishek Singh","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Abhishek Singh","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.devopsconsulting.in\/blog\/how-to-stored-data-in-procedure\/#article","isPartOf":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/how-to-stored-data-in-procedure\/"},"author":{"name":"Abhishek Singh","@id":"https:\/\/www.devopsconsulting.in\/blog\/#\/schema\/person\/fc397ba8be42f9fdd53450edfc73006f"},"headline":"How to stored data in procedure","datePublished":"2023-05-24T03:38:52+00:00","dateModified":"2023-05-24T03:38:53+00:00","mainEntityOfPage":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/how-to-stored-data-in-procedure\/"},"wordCount":261,"commentCount":1,"image":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/how-to-stored-data-in-procedure\/#primaryimage"},"thumbnailUrl":"https:\/\/www.devopsconsulting.in\/blog\/wp-content\/uploads\/2023\/05\/image-18.png","keywords":["stored Procedure"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.devopsconsulting.in\/blog\/how-to-stored-data-in-procedure\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.devopsconsulting.in\/blog\/how-to-stored-data-in-procedure\/","url":"https:\/\/www.devopsconsulting.in\/blog\/how-to-stored-data-in-procedure\/","name":"How to stored data in procedure - DevOps Consulting","isPartOf":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/how-to-stored-data-in-procedure\/#primaryimage"},"image":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/how-to-stored-data-in-procedure\/#primaryimage"},"thumbnailUrl":"https:\/\/www.devopsconsulting.in\/blog\/wp-content\/uploads\/2023\/05\/image-18.png","datePublished":"2023-05-24T03:38:52+00:00","dateModified":"2023-05-24T03:38:53+00:00","author":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/#\/schema\/person\/fc397ba8be42f9fdd53450edfc73006f"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.devopsconsulting.in\/blog\/how-to-stored-data-in-procedure\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.devopsconsulting.in\/blog\/how-to-stored-data-in-procedure\/#primaryimage","url":"https:\/\/www.devopsconsulting.in\/blog\/wp-content\/uploads\/2023\/05\/image-18.png","contentUrl":"https:\/\/www.devopsconsulting.in\/blog\/wp-content\/uploads\/2023\/05\/image-18.png","width":805,"height":440},{"@type":"WebSite","@id":"https:\/\/www.devopsconsulting.in\/blog\/#website","url":"https:\/\/www.devopsconsulting.in\/blog\/","name":"DevOps Consulting","description":"DevOps Consulting | SRE Consulting | DevSecOps Consulting | MLOps Consulting","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.devopsconsulting.in\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.devopsconsulting.in\/blog\/#\/schema\/person\/fc397ba8be42f9fdd53450edfc73006f","name":"Abhishek Singh","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g","caption":"Abhishek Singh"},"description":"I\u2019m Abhishek, a DevOps, SRE, DevSecOps, and Cloud expert with a passion for sharing knowledge and real-world experiences. I\u2019ve had the opportunity to work with Cotocus and continue to contribute to multiple platforms where I share insights across different domains: \u2022 DevOps School \u2013 Tech blogs and tutorials \u2022 Holiday Landmark \u2013 Travel stories and guides \u2022 Stocks Mantra \u2013 Stock market strategies and tips \u2022 My Medic Plus \u2013 Health and fitness guidance \u2022 TrueReviewNow \u2013 Honest product reviews \u2022 Wizbrand \u2013 SEO and digital tools for businesses I\u2019m also exploring the fascinating world of Quantum Computing.","url":"https:\/\/www.devopsconsulting.in\/blog\/author\/abhishek\/"}]}},"_links":{"self":[{"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/posts\/376","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/comments?post=376"}],"version-history":[{"count":1,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/posts\/376\/revisions"}],"predecessor-version":[{"id":378,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/posts\/376\/revisions\/378"}],"wp:attachment":[{"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/media?parent=376"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/categories?post=376"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/tags?post=376"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}