How to generate .json file with PHP?

Posted by Editorial Staff | Updated on January 26, 2020

Want to generate .json file with PHP? Use the below PHP program to generate .json file using PHP.

<?php

$sql="select * from Posts limit 20";

$response = array();

$posts = array();

$result=mysql_query($sql);

while($row=mysql_fetch_array($result)) {

$title=$row['title'];

$url=$row['url'];

$posts[] = array('title'=> $title, 'url'=> $url);

}

$response['posts'] = $posts;

$fp = fopen('results.json', 'w');

fwrite($fp, json_encode($response));

fclose($fp);

If you like this question & answer and want to contribute, then write your question & answer and email to freewebmentor[@]gmail.com. Your question and answer will appear on FreeWebMentor.com and help other developers.

How to generate .json file with PHP?

Related Questions & Answers

Solved Programs