如何从多个php数组中获取特定索引值并存储在数组中

Question

I've multiple arrays received from db table. now i'm trying to check "is their birth date == current date" if yes then their contact numbers saved in a array called birthdays

Here is my try

$curr_date = date('m/d');

$birthday = array(); // array initialization
$anniversary = array(); // array initialization

$con=mysqli_connect("localhost","root","","birthdays");


$sql="SELECT * FROM users";

$result=mysqli_query($con,$sql);

$row=mysqli_fetch_assoc($result);

echo "<pre>";

if ($result=mysqli_query($con,$sql))
{
    while ($row=mysqli_fetch_assoc($result))
    {
        print_r ($row);
    }
}

Here is a image of current code with expected description

I'm trying lot of time but unable to achieve exact result. kindly guide me. Thanks

Answer 1

I think you need something like this?

$date1 = date('m-d', strtotime($row['birth_date']));
$date2 = date('m-d');

if ($date1 == $date2)   {
    echo 'Happy birthday!';
}

See PHP date function for more info.