How to generate json file with PHP

Question

CREATE TABLE Posts   id INT PRIMARY KEY AUTO INCREMENT  title VARCHAR 200   url VARCHAR 200      json php code   lt  php  sql mysql query  select   from Posts limit 20    echo    posts       while  row mysql fetch array  sql      title  row  title     url  row  url    echo        title      title       url      url             echo          gt    I have to generate results json file

User · Answer

Insert your fetched values into an array instead of echoing    Use file put contents   and insert json encode  rows  into that file  if  rows is your data

User · Answer

Use this    json data   json encode  posts   file put contents  myfile json    json data     You have to create the myfile json before you run the script

User · Answer

First  you need to decode it     jsonString   file get contents  jsonFile json     data   json decode  jsonString  true     Then change the data     data 0   activity name      TENNIS      or if you want to change all entries with activity code  1  foreach   data as  key   gt   entry        if   entry  activity code       1              data  key   activity name      TENNIS             Then re-encode it and save it back in the file    newJsonString   json encode  data   file put contents  jsonFile json    newJsonString     copy

User · Answer

Here is a sample code    lt  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   gt   title   url   gt   url        response  posts      posts    fp   fopen  results json    w    fwrite  fp  json encode  response    fclose  fp       gt

User · Answer

Use PHP s json methods to create the json then write it to a file with fwrite

User · Answer

If you re pulling dynamic records it s better to have 1 php file that creates a json representation and not create a file each time    my json php   array   array       title    gt   title       url    gt   url     echo stripslashes json encode  array       Then in your script set the path to the file my json php

User · Answer

You can simply use json encode function of php and save file with file handling functions such as fopen and fwrite

User · Answer

Here i have mentioned the simple syntex for create json file and print the array value inside the json file in pretty manner    array   array  name    gt   name  id    gt   id  url    gt   url    fp   fopen  results json    w    fwrite  fp  json encode  array  JSON PRETTY PRINT         here it will print the array pretty fclose  fp     Hope it will works for you

[php] How to generate .json file with PHP?

Examples related to php

Examples related to json