PHP MySQL multiple rows to JSON

Simple to store PHP MySQL to JSON with multiple rows result

<?php include('config.php'); $mkt = mysqli_query($con,'select * from booking order by csdate DESC'); //while //$mkt = mysqli_query($con, $sql); $result = array("booknow" => array()); //create an associative array with a property called "dashboard_content", which is an array. (json_encode will convert an associative array to a JSON object) if (check) { $rows = mysqli_fetch_assoc($mkt); if (!$rows) { echo "No results!"; } else { while ($rows = mysqli_fetch_assoc($mkt)) { $pickup = $rows['pickup']; $drop = $rows['drop']; $csdate = date('m-d-Y @ h:i A', strtotime($rows['csdate'])); $cmsgs = $rows['cmsgs']; $tstamp = $rows['tstamp']; // $rstatus = //append the current data to a new entry in the "dashboard_content" array $result["booknow"][] = array('pickup' => $cadd, 'drop' => $drop, 'csdate' => $csdate, 'cmsgs' => $cmsgs, 'tstamp' => $tstamp); } } } //now, output the whole completed result to one single, coherent, valid JSON array. echo json_encode($result); ?>