{"id":11813,"date":"2020-03-06T10:31:20","date_gmt":"2020-03-06T10:31:20","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=11813"},"modified":"2020-03-07T05:53:18","modified_gmt":"2020-03-07T05:53:18","slug":"how-to-read-data-from-database-in-tinker","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/how-to-read-data-from-database-in-tinker\/","title":{"rendered":"How to Read Data from Database in Tinker."},"content":{"rendered":"\n

To read data from the database, we use the below commands:- <\/p>\n\n\n\n

1. DB::table(“Table_name<\/em>“)->get()<\/strong> :- It returns all the data present in the given table of database. See below:- <\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

2. DB::table(“table_name”)->where(“key1″,”key1_value”)->first()<\/strong> :- It returns all data of the row in which key value found. See below:- <\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

3. DB::table(“table_name”)->pluck(“column_name”);<\/strong> :- It returns all the data stored in the given column from database.<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

Pluck :-<\/strong> pluck is a method in laravel which is used when we have to fetch a particular column from database.<\/p>\n\n\n\n

4. DB::table(“Table_name”)->select(“column1”, “column2”, “column3”)->get()<\/strong> :- It is used to return the given data of the row. Means, if we call name<\/strong> and E-mail<\/strong> column then it returns the both with row-wise. See below how it works:- <\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

5. DB::table(“Table_name”)->count()<\/strong> :- It returns the no. of rows. See below:- <\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

There are 5 rows in my database so it returns 5.<\/p>\n\n\n\n

6. DB::table(“Table_name”)->max(“<\/strong> Column_name<\/strong> “)<\/strong> :- It returns the maximum id no. of your data from database. See below:- <\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

See the Database Below:- <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

7. DB::table(“Table_name”)->min(“<\/strong> Column_name<\/strong> “)<\/strong> :- It returns the minimum id no. of your data from database. See below:- <\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

See the Database Below:- <\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

8. DB::table(“Table_name”)->min(“Column_name”)<\/strong> :- It returns the average value of the given column. <\/p>\n\n\n\n

Suppose I want the average value of the id<\/strong> column. See below:- <\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

To read data from the database, we use the below commands:- 1. DB::table(“Table_name“)->get() :- It returns all the data present in the given table of database. See below:- 2. DB::table(“table_name”)->where(“key1″,”key1_value”)->first()… <\/p>\n","protected":false},"author":19,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_joinchat":[],"footnotes":""},"categories":[5201],"tags":[5203],"class_list":["post-11813","post","type-post","status-publish","format-standard","hentry","category-laravel","tag-laravel"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/11813","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=11813"}],"version-history":[{"count":36,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/11813\/revisions"}],"predecessor-version":[{"id":11878,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/11813\/revisions\/11878"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=11813"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=11813"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=11813"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}