DEV Community

Benyamin Khalife
Benyamin Khalife

Posted on • Edited on

SQL And PHP: People whose birthday is today

#oop #database #mysql #mariadb

How do we find a list of people whose birthday is today from a database and perform an operation on them?

To start, we add the Foxdb library:

composer require webrium\foxdb
Enter fullscreen mode Exit fullscreen mode

In this way, write the default configuration for using the library and change it according to your project.

use Foxdb\DB;
use Foxdb\Config;
use Foxdb\DB;

DB::addConnection('main', [
    'host'=>'localhost',
    'port'=>'3306',

    'database'=>'test',
    'username'=>'root',
    'password'=>'1234',

    'charset'=>Config::UTF8,
    'collation'=>Config::UTF8_GENERAL_CI,
    'fetch'=>Config::FETCH_CLASS
]);
Enter fullscreen mode Exit fullscreen mode

Now, using a simple query, we can get the list of people whose birthday is today.

$list = DB::table('users')
        ->month('birth_date', date('m'))
        ->day('birth_date', date('d'))  
          ->get();
Enter fullscreen mode Exit fullscreen mode

See the GitHub repository and documentation at the link below.

FoxDB Documentation

Top comments (0)