Write data to a json file from PHP file

Question

I have a test.php page which displayes three has 3 "Add Link" buttons, on clicking the buttons the user sees a popup window. In the window he adds the link. Once the link is added , the base page will change from "Add link" button to hyperlink with the new link. Now, I have to pass the new link I receive from the user from test.php to links.php using an ajax call. Links.php has to have a JSON code to write the link to another file called first.json. first.jason will have key value pair for variable and link. I would have to retrieve the value from .json file later and reconstruct into an array, update the corresponding variable and save it back.

I have by far, managed to get the new link from test.php and able to send the same via ajax call to links.php. I am also able to display the link I receive and have verified the same. Now, I would like to copy the link into .json file as a key vale pair. I am new to json and unable to figure out how to go about it. My variable $p, in links.php has the link.

Any pointers on the same will be helpful. Thanks.

Below is my code in test.php:

         <!DOCTYPE html>
        <html>
        <body>   
        <div id="demos1">
    <button id="demo1" onclick="Link1()">Add Link-1</button>  
             <br>
    </div>
    <div id="demos2">
    <button id="demo2" onclick="Link2()">Add Link-2</button>
            <br>
    </div>
    <div id="demos3">
    <button id="demo3" onclick="Link3()">Add Link-3</button>
            <br>
            </div>
    <div id="txtHint"></div>
    <script>
           function Link1()
           {
            var demo1 = document.getElementById('demo1');
            var demos1 = document.getElementById('demos1');
            var value1 = prompt("Please Enter the Link"); 
            var link1 = document.createElement('a'); 
            link1.setAttribute('href', value1); 
            link1.innerHTML = "New Link1";                              
            demo1.parentNode.removeChild(demo1);
            demos1.appendChild(link1);  
            sendlink(value1);
            }
        function Link2()
           {
            var demo2 = document.getElementById('demo2');
            var demos2 = document.getElementById('demos2');
            var value2 = prompt("Please Enter the Link"); 
            var link2 = document.createElement('a'); 
            link2.setAttribute('href', value2); 
            link2.innerHTML = "New Link2"; 
            demo2.parentNode.removeChild(demo2);
            demos2.appendChild(link2);
            sendlink(value2);
            }
        function Link3()
           {
            var demo3 = document.getElementById('demo3');
            var demos3 = document.getElementById('demos3');
            var value3 = prompt("Please Enter the Link"); 
            var link3 = document.createElement('a'); 
            link3.setAttribute('href', value3); 
            link3.innerHTML = "New Link3"; 
            demo3.parentNode.removeChild(demo3);
            demos3.appendChild(link3);  
            sendlink(value3);
             }
        function sendlink(str)
        {
            if (str.length==0)
              { 
              document.getElementById("txtHint").innerHTML="hello";
              return;
              }
            if (window.XMLHttpRequest)
              {// code for IE7+, Firefox, Chrome, Opera, Safari
              xmlhttp=new XMLHttpRequest();
              }
            else
              {// code for IE6, IE5
              xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
              }
            xmlhttp.onreadystatechange=function()
              {
              if (xmlhttp.readyState==4 && xmlhttp.status==200)
                {

               document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
                }
              }
            xmlhttp.open("GET","links.php?q="+str,true);
            xmlhttp.send();
        }
    </script>
         </body>

          </html>

Below is the code for links.php which receives the value(i.e, link) the test.php sends through ajax call:

<?php
include 'test.php';
$p=$_REQUEST['q'];
?>

I am able to write to json file using json_encode. Now I would have to read the link from .json file, associate it to the corresponding variable and save it back. How would I go about this?

are you looking to do PHP file i/o? it sounds like you have successfully completed all of your javascript and ajax. This link should get you going in that direction: tutorialspoint.com/php/php_files.htm — MaxPRafferty
– MaxPRafferty, Commented Jul 12, 2013 at 20:46

D-Rock · Accepted Answer · 2013-07-12 21:03:31Z

25

To write the json:

file_put_contents('filename.json', json_encode($p));

To read the json:

$p = json_decode(file_get_contents('filename.json'));

Obviously this does no error checking at all though.

answered Jul 12, 2013 at 21:03

D-Rock

2,6661 gold badge21 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

AbcAeffchen · Accepted Answer · 2015-01-09 05:03:57Z

2

if you want to insert the data in json file below one is usefull

function exportToJson() {

    mysql_connect("localhost", "root", "");
    mysql_select_db("krasimir_benchmark");      

    $res = mysql_query("SELECT * FROM users ORDER BY id");
    $records = array();
    while($obj = mysql_fetch_object($res)) {
        $records []= $obj;
    }
    file_put_contents("data.json", json_encode($records));

}

edited Jan 9, 2015 at 5:03

AbcAeffchen

15.1k15 gold badges52 silver badges67 bronze badges

answered Jan 9, 2015 at 4:44

Ravi Mane

1,5462 gold badges19 silver badges25 bronze badges

Comments

Panagiotis Panagi · Accepted Answer · 2013-07-12 21:16:46Z

1

If you have created your json already, then you can simply do this:

fwrite("yourjson.json",json_encode($yourvariablewithdata))

If you have NOT created your json file, then you could create it with fopen function. See details http://www.php.net/manual/es/function.fopen.php

edited Jul 12, 2013 at 21:16

Panagiotis Panagi

10.1k7 gold badges60 silver badges103 bronze badges

answered Jul 12, 2013 at 20:56

ZeroBryan

93 bronze badges

1 Comment

user2521326 Over a year ago

I am able to write to json file using json_encode. Now I would have to read the link from .json file, associate it to the corresponding variable and save it back. How would I go about this?

Asinus Rex · Accepted Answer · 2014-12-07 12:01:02Z

0

You can always JSON.stringify the JSON on the client side with jQuery, like so:

var dataForJson = JSON.stringify(your_aray);

Then on the server side write it as is (no need for json_encode):

$jsondata = $_POST['dataForJson'];
$writeJson = file_put_contents('data_en.json', $jsondata);

answered Dec 7, 2014 at 12:01

Asinus Rex

5549 silver badges29 bronze badges

Collectives™ on Stack Overflow

Write data to a json file from PHP file

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related