Date as Header Row in PHP MySQL [solved]

After long bang bang and stackflow here is what i found to :
Date as Row Header
Daily Report Table in Using MySQL & PHP

How You will love it

<?php include('config.php'); $result = mysqli_query($con, 'select * from sform where date_format(csdate,"%Y") != "1969" order by csdate ASC'); $dateSection = ""; echo '<table width="100%">'; while($row = mysqli_fetch_assoc($result)) { $dateHeader = date("d-M, Y", strtotime($row['csdate'])); if ( $dateHeader != $dateSection ) { $dateSection = $dateHeader; echo '<tr><td colspan="5" style="background:#000;color:#fff; text-align:center; padding:8px; font-weight:bold;">' . $dateHeader .'</td></tr>'; } echo '<tr>'; echo '<td>#' . $row["rno"] . '</td>'; echo '<td>' . $row["cname"] . '</td>'; echo '<td>' . date('d-M, Y @ h:i A', strtotime($row["csdate"])) . '</td>'; echo '<td>' . $row["cphone"] . '</td>'; echo '<td>' . $row["caddr"] . '</td>'; echo '<td>' . $row["csnop"] . '</td>'; echo '</tr>'; } ?>

How to Install Laravel on Mac OSX

If you're facing this issue with macOS Catalina, I recommend these steps:

[PS: do not waste your time installing apt-get or yum ]

-- Just Install Homebrew (if you haven't already done so): head over to brew.sh or simply run this command: /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"

-- Run brew install php@7.3


Update your $PATH variable to include the newly installed version of php:
>>> echo 'export PATH="/usr/local/opt/php@7.3/bin:$PATH"' >> ~/.zshrc
-- Also --
>>>>>> echo 'export PATH="/usr/local/opt/php@7.3/sbin:$PATH"' >> ~/.zshrc

-- Reload your shell preferences script $ source ~/.zshrc or source ~/.bashrc

Finally, install laravel: composer global require laravel/installer