Getting array from database

Question

I'm using this class to display a calendar: https://www.phpclasses.org/package/8426-PHP-Generate-HTML-to-display-month-event-calendars.html

I need to populate dates from a database like this one:

$calendar->events=array("2014-01-16"=>1,"2014-01-19"=>4,);

I got the following but is not working.

Any help will be appreciated. Thanks

$number = 1;    
while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $response[] = array("$row['date']" => $number);
    $number++;
}
$dates = json_encode($response);
$calendar->events=array($dates);

The events are no showing on the calendar, but if I manually type the dates, like below, the events will show on the calendar.

$calendar->events=array("2014-01-16"=>1,"2014-01-19"=>4,);

Thank you for responding. Actually, there are no error messages. The problem is that the dates are no passing to "$calendar->events=array" thus not showing on the calendar. — William Orellana
– William Orellana, Commented Sep 4, 2020 at 16:06
Add error reporting to the top of your file(s) while testing right after your opening PHP tag for example. Even if you are developing on a server configured as LIVE you will now see any errors. <?php error_reporting(E_ALL); ini_set('display_errors', 1); — RiggsFolly
– RiggsFolly, Commented Sep 4, 2020 at 16:08

Nigel Ren · Accepted Answer · 2020-09-04 16:13:45Z

1

If you are adding the values keyed by the dates, then you need something like...

$number = 1; 
$response = [];   
while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $response[$row['date']] = $number++;
}

Then if you want the result encoded, you may need to use...

$calendar=json_encode([ 'events' => $dates]);

answered Sep 4, 2020 at 16:13

Nigel Ren

57.3k11 gold badges49 silver badges59 bronze badges

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

2 Comments

William Orellana Over a year ago

Unfortunately, that didn't work. Nothing shows on the calendar. Thank you for your time

Nigel Ren Over a year ago

Have you compared the output with what you are expecting. Just saying it doesn't work isn't a way forward.

Collectives™ on Stack Overflow

Getting array from database

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related