千原 耕司

Laravel

How to Check Executed SQL in Laravel

IntroductionWhen executing SQL using Eloquent ORM or Query Builder in Laravel, it is often necessary to verify what SQL ...
Database

How to Use WHERE Clause with mysqldump

When backing up MySQL data using mysqldump, you may need to export only specific data instead of the entire database, es...
Laravel

How to Implement OR Conditions with Laravel Collection

When working with Laravel's Collection, you may need to filter data using OR conditions. While Laravel provides an easy-...
PHP

How to Retrieve Consecutive Alphabets from A to Z in PHP

In PHP, you can easily retrieve consecutive alphabets from A to Z using the built-in range() function. This is a helpful...
AWS

How to Fix AWS CLI Help Errors: Step-by-Step Guide

When using AWS CLI and running the help command to look up parameters, you might encounter this error:$ aws cloudfront h...
Example

DB design for “Gotcha” – Grade Probability

This article describes a suggested DB design.This design is just an example.Please use this as a template and adapt it t...
Database

DB design of “reservation system” – basic form

This article describes a proposed DB design for a "Reservation System".SummaryThere are no complicated functions.All you...
Laravel

[Laravel] Using Resources in API Responses

This article is an article of explanation about Resources in Laravel.What is Resources?When using the API to convert an ...
PHP

How to find the distance of coordinates between two points

This article shows how to find the straight line distance between two points from their latitude and longitude.What is l...
PHP

[PHP] How to convert from strings to numbers

This article describes how to convert from strings to numbers in PHP.PHP is a dynamically typed language, meaning that t...