{"id":16267,"date":"2020-07-15T12:32:05","date_gmt":"2020-07-15T12:32:05","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=16267"},"modified":"2021-10-30T06:21:48","modified_gmt":"2021-10-30T06:21:48","slug":"how-to-insert-and-retrieve-data-in-database-laravel-framework","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/how-to-insert-and-retrieve-data-in-database-laravel-framework\/","title":{"rendered":"How to Insert and Retrieve Data in Database – Laravel Framework"},"content":{"rendered":"\n

In this example, I am going to show you how to insert data in the database using laravel framework PHP<\/strong>.<\/p>\n\n\n\n

First, creating table the SQL query:<\/p>\n\n\n

CREATE TABLE student_details\n(\nid int NOT NULL<\/span> AUTO_INCREMENT,\nfirst_name varchar(50<\/span>),\nlast_name varchar(50<\/span>),\ncity_name varchar(50<\/span>),\nemail varchar(50<\/span>),\nPRIMARY KEY (id)\n);<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
Now, create three file for insert data in Laravel<\/strong>.<\/p>\n\n\n\n
Step 1<\/strong>. Create a controller name as StudInsertController.php<\/strong>.
The file location is : (app\/Http\/Controllers\/StudInsertController.php)<\/strong><\/p>\n\n\n\n
Step 2<\/strong>. Create view page name as stud_create.php<\/strong>
The file location is: (resources\/views\/stud_create.php)<\/strong><\/p>\n\n\n\n
Then put this code in your StudInsertController.php.<\/strong><\/p>\n\n\n\n