How to display multiple events per day in my php calendar code

Question

My calendar works fine as written, but if I add another event on the same day, it only displays the first event recorded in the database. I need to be able to display multiple events on the same day. I'm trying to use for/next loops and while loops in my code to extract information from the database. None of it works the way the code is written. This link will show you the work calendar as written: GrimsWorld Blog This is my code: <?php$cMonth=isset($_REQUEST["mon

P粉561438407 · Answer

If the SQL query is correct and $events returns valid results, use:

while($row = mysqli_fetch_assoc($events))
{
    # output events
    echo '';
    print_r($row);
    echo '';
}

According to the php documentation , the mysqli_fetch_assoc function fetches a row of data from the result set and returns it as an associative array. Each subsequent call to this function will return the next row in the result set (or null if there are no more rows), so we need to use a while() loop to loop over the result set. (Although there are consequences...doing this).

To improve the code further, you can first check if there are any results using the mysqli_num_rows built-in function. We don't need to loop over the results if there are no events for a given calendar date, so we can skip it.

Your code might look like:

$sql = "SELECT *
        FROM posts
        WHERE SUBSTR(date,7,4)='$cYear' AND month='$cMonth' AND day='$d'
        ";
$results = mysqli_query($connect, $sql);
if(mysqli_num_rows($results)) // only if there are results
{
    while($row = mysqli_fetch_assoc($results))
    {           
        $post_id = $row['id'];
        $post_title = $row['title'];
        // ...
        
        # output
        echo ''.$post_title.'';
    }
}

NOTE - I have changed your $events variable to $results just for general best practice purposes and consistency, but from a technical perspective There is no need to say this is the case.

Also - Consider using the ORDER BY clause in SQL (Documentation) to order events chronologically in the result set.
Also - Consider using Prepared Statements for your SQL queries, which is safer.