#Laravel Carbon

[learntechsolution]

When working with date and time formatting in Vue.js with Laravel's Carbon, you can use the moment library to format and manipulate dates in your Vue components. Here's a step-by-step guide

[learntech-solution]

When working with date and time formatting in Vue.js with Laravel's Carbon, you can use the moment library to format and manipulate dates in your Vue components. Here's a step-by-step guide

[learn-tech-solution]

When working with date and time formatting in Vue.js with Laravel's Carbon, you can use the moment library to format and manipulate dates in your Vue components. Here's a step-by-step guide

[learn-techsolution]

When working with date and time formatting in Vue.js with Laravel's Carbon, you can use the moment library to format and manipulate dates in your Vue components. Here's a step-by-step guide

[jeetutech]

Getting Current Date and Time in Laravel: A Complete Guide

In Laravel, working with dates and times is a common task. Whether you need to retrieve the current date or time, or format them in a specific way, Laravel provides a powerful utility called Carbon. Carbon is a simple PHP API extension for DateTime that helps with date and time manipulation. In this guide, we will explore how to use the Carbon library in Laravel to get the current date and time,…

[techanical-atom-blog]

Working With Date And Time In Laravel Carbon is very effective and efficient because of the use of the Carbon class which is instantiated from the date.

[codehunger]

Laravel-find days between two dates in laravel

Laravel-find days between two dates in laravel

In this blog, we will learn about how to find days between two dates in laravel, This tutorial will give you a simple example of getting days difference in laravel. if you want to see an example of how to get days difference in laravel then you are in the right place. Follow the below tutorial step of laravel 8 gets last week’s records from the database. If you want to see what all carbon does…

[laravelvuejs]

Global Vuejs Filters and Momentjs Instead of Carbon in Laravel and Vue Let's Build a Multi-Purpose Laravel + Vue Application is out now. In this series, you learn everything you need to know about Building a complete web ... source

[phpdeveloperfan]

PHP Date and Time with Carbon by Edwin Diaz ☞ http://bit.ly/2WToUTh #php #laravel

[decodewebin]

Json and Laravel Eloquent with example

JSON is short form of JavaScript Object Notation, which is used to store data and since it is very lightweight hence majorly used for transporting data to and from a web server. In earlier days, XML was used for this very purpose but writing and reading XML data was very tedious while JSON on the other hand, is self describing.

In today’s topic I am going to show you how to store JSON data into MySQL and access those data using laravel eloquent query builders.

Storing JSON data in MySQL using Laravel

First let’s create a dummy table using migration command.

Schema::create(json_examples, function (Blueprint $table) {             $table->bigIncrements('id');             $table->string('name');             $table->text('json_details'); //using text datatype to store json             $table->timestamps();         });

As you can see I used text datatype for storing json.

Next, let’s create a corresponding Model for the same

php artisan make:model JsonExample

JsonExample.php

public static function create($data) {     $new = new self();     $new->name = $data['name'];     $new->json_details = $data['json_details''];     $new->save(); }

So in controller we can do something like this:

public function storeEmpData(Request $request) {     ...     $name = $request->name';     $details = ['emp_code' => '001', 'date_of_joining' => Carbon::parse($request->doj), 'salary' => '50000'];         $dataToStore = [         'name' => $name,         'Json_details' => json_encode($details)       ];       //saving data       JsonExample::create($dataToStore); }

Processing Json data in Laravel eloquent.

Json data in where()

We can easily apply conditions on json data in laravel using -> (arrow notation), for example, fetch records where salary is more than 50000.

JsonExample.php

public static function getSalaryMoreThan($salary) {     return self::where('json_details->salary','>',$salary)->get(); }

Access json data using json_extract()

Another example, we need records of employees who joined the company before a date for instance 9th November 2018.

JsonExample.php

public static function getEmployeesBeforeDate($date) {     return self::whereDate("json_extract('json_details', '$.doj')", '<', $date)->get() }

As you can see above, I used json_extract() method which is MySQL’s function to extract a field from JSON column since I can not simply instruct eloquent using arrow operator like

return self::whereDate('json_details->doj', '<', $date)->get()

Rather I have to explicitly tell eloquent to extract json field and then proceed.

JSON data in DB::raw()

Many times we need to use MySQL’s aggregate functions like SUM() as per the requirement, in that case we use DB facade. For example,

select(DB::raw('sum(...)'))

How to access json field in MySQL’s aggregate function ?

It is very simple, let’s take an example, we need to sum total salary of employees.

public static function findTotalSalary() {     return self::select(DB:raw('sum("json_extract('json_details', '$.salary')") as total_salary'))->get(); }

Conclusion

That’s all about this topic friends, I hope you learned something new which you haven’t thought about. I thought I should share this knowledge as I encountered such problem while working on a project today where I do save additional data in json format. Do comment your reviews and experiences below.

Thank you :)

Ebooks available now

You can download this article’s PDF eBooks for offline reading from below:

Issuu

Slide Share

Edocr

AuthorStream

Scribd

[wordpresstemplateslove]

PHP Date and Time with Carbon by Edwin Diaz ☞ http://bit.ly/2ylQlLP #php #laravel

[phpprogrammingblr]

PHP Date and Time with Carbon by Edwin Diaz ☞ http://bit.ly/2ylQlLP #php #laravel

[carbon-c6]

Top Manchester Business Applications Development Companies in Uk

We are a  software development company specializing in the latest Laravel framework and manchester business applications technology and we create excellent software. If you are interested in Manchester Business Applications Development, do not hesitate to ask the officials of Carbon C6 once. In such a way, the future of your career can go ahead in such a world, contact us today for more information: 020 7183 7381.