You may learn about MySQL views in this blog post and how to successfully incorporate them into Laravel apps.<\/p>\n\n\n\n
SQL Create View Query<\/strong><\/p>\n\n\n\n SQL Drop View Query<\/strong><\/p>\n\n\n\n \u00a0Let\u2019s create migration with views.<\/p>\n\n\n\n Update Migration File:<\/strong><\/p>\n\n\n\n now we will create model as below:<\/strong><\/p>\n\n\n\n app\/ViewData.php<\/strong><\/p>\n\n\n\n Now we can use it as below on the controller file:<\/strong><\/p>\n\n\n\n you can see output:-<\/strong><\/p>\n\n\n\n You may learn about MySQL views in this blog post and how to successfully incorporate them into Laravel apps. SQL […]<\/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":[],"class_list":["post-772","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nCREATE VIEW view_data AS\r\r\nSELECT \r\r\n users.id, \r\r\n users.name, \r\r\n users.email,\r\n\r\n (SELECT count(*) FROM posts\r\r\n WHERE posts.user_id = users.id\r\r\n ) AS total_posts,\r\r\n (SELECT count(*) FROM comments\r\r\n WHERE comments.user_id = users.id\r\r\n ) AS total_comments\r\n\r\nFROM users<\/code><\/pre>\n\n\n\nDROP VIEW IF EXISTS `view_data`;<\/code><\/pre>\n\n\n\nphp artisan make:migration create_view<\/code><\/pre>\n\n\n\n<?php\r\n\r \r\nuse Illuminate\\Database\\Migrations\\Migration;\r\r\nuse Illuminate\\Database\\Schema\\Blueprint;\r\r\nuse Illuminate\\Support\\Facades\\Schema;\r\n\r\n \r\r\nclass CreateView extends Migration\r\r\n{\r\r\n \/**\r\r\n * Run the migrations.\r\r\r\r\n * @return void\r\r\n *\/\r\r\n public function up()\r\r\n {\r\r\n \\DB::statement($this->createView());\r\r\n }\r\n\r\r\n \/**\r\r\n * Reverse the migrations.\r\r\n *\r\r\n * @return void\r\r\n *\/\r\n\r\n public function down()\r\n\r\n {\r\r\n \\DB::statement($this->dropView());\r\r\n }\r\n\r\n \r\n\r\n \/**\r\r\n * Reverse the migrations.\r\r\n *\r\r\n * @return void\r\r\n *\/\r\r\n private function createView(): string\r\r\n {\r\r\n return <<\r\r\n CREATE VIEW view_data AS\r\r\n SELECT \r\r\n users.id, \r\r\n users.name, \r\r\n users.email,\r\r\n (SELECT count(*) FROM posts\r\r\n WHERE posts.user_id = users.id\r\r\n ) AS total_posts,\r\r\n (SELECT count(*) FROM comments\r\r\n WHERE comments.user_id = users.id\r\r\n ) AS total_comments\r\r\n FROM users\r\r\n SQL;\r\r\n }\r\r\n \/**\r\r\n * Reverse the migrations.\r\r\n *\r\r\n * @return void\r\r\n *\/\r\r\n private function dropView(): string\r\r\n {\r\r\n return <<\r\r\n DROP VIEW IF EXISTS `view_data`;\r\r\n SQL;\r\r\n }\r\r\n}<\/code><\/pre>\n\n\n\n<?php\r\n\r \r\nnamespace App;\r\r\nuse Illuminate\\Database\\Eloquent\\Model;\r\n\r\n \r\nclass ViewUserData extends Model\r\r\n{\r\r\n public $table = \"view_data\";\r\r\n}<\/code><\/pre>\n\n\n\n<?php\n\nnamespace App\\Http\\Controllers;\nuse Illuminate\\Http\\Request;\nuse App\\ViewData;\n\n \n\nclass UserController extends Controller\n\n{\n \/**\n * Display a listing of the resource.\n *\n * @return \\Illuminate\\Http\\Response\n *\/\n\n public function index()\n {\n $users = ViewData::select(\"*\")\n ->get()\n ->toArray(); \n dd($users);\n\n }\n\n}<\/code><\/pre>\n\n\n\narray:20 [\r\r\n 0 => array:5 [\r\r\n \"id\" => 1\r\r\n \"name\" => \"abhishek singh\"\r\r\n \"email\" => \"abhisheksingh.cotocus@gmail.com\"\r\r\n ]<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"