why isnt json file separating the records (PHP)

Question

i can't find a way to make the JSON page separate the records into multiple lines and not stack into the same one.

<html>
    <head>
        <meta charset="UTF-8">
        <title>Task1</title>
    </head>
    <body>
        <?php
        $dsn = "mysql:host=localhost;dbname=egamesdb";
        $username = "root";
        $password = "";

        $pdo = new PDO($dsn, $username, $password);
        $sql = "select * from games";
        $statement = $pdo->query($sql);
        
        $statement->setFetchMode(PDO::FETCH_ASSOC);

        $records = $statement->fetchAll();
        
        

        foreach ($records as $row) {
            echo $row['name'] . ", " . $row['category'] . ", " .$row['creator'] . ", "
            .$row['monthly_subscription']. ", " .$row['platform'].", " .$row['filename'] . "<br>";
        }
         $json_data = json_encode($records);
        $f = fopen("dbconfig.json", "w");
        $rows = array($records);
        
        fwrite($f, $json_data);
        fclose($f);
        ?>
    </body>
</html>

why does it matter? either is valid json, seems a bit superficial — Wesley Smith, Oct 11 '20 at 07:21
IDK i just find it frustrating the i can't figure a way to separate it to just make it look neater. apologies if its a dumb question — Brock Bajjada, Oct 11 '20 at 07:26
See the above link, thats not quite what you want, but its as close as you can get — Wesley Smith, Oct 11 '20 at 07:28

why isnt json file separating the records (PHP)

0 Answers0