function getResultsOutputJsn() { // connect(); $output = "{"; $query = getJoinQuery(); $sql = mysql_query($query) or die(" Join query Failed!" . mysql_error()); $columns_total = mysql_num_fields($sql); // Get Records from the table while ($row = mysql_fetch_array($sql, MYSQLI_ASSOC)) { $output .= "item:" . json_encode($row) . ","; } $output = rtrim($output, ","); $output .= "}"; echo stripcslashes(json_encode($output)); //mysql_close(); }
function getResultsOutputJsn() { $output = "{"; $query = getJoinQuery(); $result = runQuery($query); // Get Records FROM the table while ($row = $result->fetch_assoc()) { //mysql_fetch_array($result, MYSQL_ASSOC)) { $output .= "item:" . json_encode($row) . ",\n"; } $output = rtrim($output, ","); $output .= "}"; echo stripcslashes(json_encode($output)); }