PHP JSON data value all same

Question

I'm on PHP JSON query with database.

$qAdzanIqomah = mysqli_query($con, "SELECT * FROM tb_sholat WHERE active = 'Y'");
while($dAdzanIqomah = mysqli_fetch_array($qAdzanIqomah))
{
    $sholatName[] = $dAdzanIqomah['sholat_name'];

    $audio_before_adzan[] = $dAdzanIqomah['audio_before_adzan'];

    $iq = $dAdzanIqomah['iqamah'];

    echo $iqamahC[] = date("H:i:s", strtotime("+ '" . $iq . "' minutes"));
}

$data = array(
    'iqamah' => $iqamahC
);

echo json_encode($data);

The problem is, all the result is same even on table data is variations.

Result echo $iqamaC[]:

{"iqamah":["01:00:00","01:00:00","01:00:00","01:00:00","01:00:00"]}

-

01:00:00
01:00:00
01:00:00
01:00:00
01:00:00

Result echo $iq:

Is there something wrong with that code?

Death-is-the-real-truth · Accepted Answer · 2017-11-02 11:53:54Z

3

You have unnecessary quotes and spaces in the minute-adding code, and that is the actual cause of the issue (failing to add minutes)

Remove unnecessary quotes like below:-

$iqamahC[] = date("H:i:s", strtotime("+$iq minutes"));

And check.

A demo working example:-https://eval.in/891471

edited Nov 2, 2017 at 11:53

answered Nov 2, 2017 at 11:46

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Death-is-the-real-truth Over a year ago

@HiDayurieDave glad to help you :):)

Collectives™ on Stack Overflow

PHP JSON data value all same

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related