未分類
- 2021年03月12日
- 未分類
初めまして
Hello Everyone,
I am ami, which is my Japanese name. My actual name is Khin Moh Moh Naing.
I am a web developer, loves to fix bugs and passionate in learning new technologies.
I graduated from Computer University from Mandalay in Myanmar with a degree in Computer Science.
Since I graduated from university, I am continuously working as a web developer.
I have been working in the industry of technology for over 2 years with the languages PHP and Laravel.
At the end of 2020 I started to join Gigas Japan and it’s such a great pleasure to meet you all.
One of my dreams is to work in Japan and want to study modern technologies and Japanese working culture.
In the future, I am also interested in Mobile Development. Currently I am working in web related system.
I am not very well communication in Japanese language but I will keep learning Japanese and try to improve my Japanese skills.
I will be writing tech related articles every Friday.
It’s nice to meet to you again everyone. よろしくお願いいたします。
By Ami
asahi at 2021年03月12日 11:00:29
Laravel Date Filtering
I would like to talk about the date filtering process I am using in laravel today.
If we want to select records that is created today. We can normally use raw queries or without raw queries like this.
//Raw Query
Model::where(DB::raw("DATE(created_at) = '".date('Y-m-d')."'"))->get();
//Not Raw Query
Model::where('created_at', '>=', date('Y-m-d').' 00:00:00'))->get();
In fact, we can do more neat and eloquent way in laravel like this.
Model::whereDate('created_at', '=', date('Y-m-d'))->get();
We can also use Carbon function instead of date(), result will still the same.
Model::whereDate('created_at', '=', Carbon::today()->toDateString())->get();
If you want to filter just not with full date, it’s totally fine. You can filter with day, month and year like this.
//Day
Model::whereDay('created_at', '=', date('d'))->get();
//Month
Model::whereMonth('created_at', '=', date('m'))->get();
//Year
Model::whereYear('created_at', '=', date('Y'))->get();
There is also another method called `whereBetween` if you want to filter by date range.
Model::whereBetween('created_at', [FROM_DATE, TO_DATE])->get();
By Yuuma
yuuma at 2021年02月22日 11:00:59
- 2019年10月25日
- 未分類
はじめまして
Hello Everyone, I am yuuma. I joined to Gigas Japan at the start of October 2019 and it’s such a great pleasure to meet you.
I came from Myanmar and want to study Japanese working culture and of course modern technologies. Currently I am working as a web engineer here and focusing mostly on PHP , may be later I will be working on AR, VR technologies.
As I am still not very well in writing Japanese, I will keep writing my articles in English. Please also support my articles.
Again, Nice to meet you everyone.
Yuuma
yuuma at 2019年10月25日 10:00:39
- 2019年01月07日
- 未分類
新年のご挨拶
謹んで新年のお慶びを申し上げます。旧年中は格別のお引立てを賜わり厚くお礼申し上げます。
本年もより一層尽力してまいりたいと存じておりますので、
何とぞ昨年同様のご愛顧を賜わりますよう、お願い申し上げます。
株式会社ギガスジャパン 社員一同
SH at 2019年01月07日 11:52:14
PHP5とPHP7の共存 on Windows 10
今回は、研修中に偶然私のPC(Windows 10)上で出来上がったPHP5とPHP7の共存方法をご紹介させていただきます。
以下のようにコマンドプロンプト上において、php とコマンドを打てばPHP7が、php5 とコマンドを打てばPHP5が起動するようにしました。
これによってPHP5では動作するけれど、PHP7では動作しないといったコードの検証を素早く行うことが出来ます。
続きを読む
yoshimoto at 2018年05月17日 10:10:09