PHP PDO DATA FETCH ARRAY To JSON CONVERT

        $sql = " SELECT * FROM user_accounts ";

        $stmt = $dbcon->pdo->prepare($sql);

         $stmt->execute();
        $data = array();

        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
            $data['alldata'][]= $row;
        }

echo json_encode($data);


Published by

Unknown's avatar

Nusrat Faria

I Am A Web Developer And A Android Developer. This Is My Personal Blog So Noted My Work For Helping People .

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.