How to write json encoded data into a json file?

Question

I am trying to get json encoded data into a json file inorder to show them in an event calendar.I am using php codeigniter framework.I just want to know whether is there any other method other than the method i have used. Because it is not working. But when i echo the json_encode data it displays.But I want to write them into a separate file calls events.json.

Thanks in advance.

model

function get_all_reservations_for_calendar(){
        $this->db->select('reservations.date,reservations.time,reservations.hall');
        $this->db->from('reservations');
        $this->db->where('is_deleted', '0');
        $query = $this->db->get();
        return $query->result();
    }

Controller

function index() {
        $reservation_service = new Reservation_service();
        $output['calendar_results'] = $reservation_service->get_all_reservations_for_calendar();
        $partials = array('content' => 'dashboard/dashboard_view');
        $this->template->load('template/main_template', $partials, $output);
    }

calendar_view

<head>
        <title>TODO supply a title</title>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">

        <style type="text/css">
            #event_cal{
                width: 500px;
                height: 500px;
            }
        </style>

        <link rel="stylesheet" href="http://localhost/Calendar/backend_resources/css/eventCalendar.css">
        <link rel="stylesheet" href="http://localhost/Calendar/backend_resources/css/eventCalendar_theme_responsive.css">
        <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js" type="text/javascript"></script>
        <script src="http://localhost/Calendar/backend_resources/js/jquery.eventCalendar.min.js" type="text/javascript"></script>

        <?php //echo json_encode($calendar_results); ?>
        <?php
        //write to json file
        $fp = fopen('events.json', 'w');
        fwrite($fp, json_encode($calendar_results));
        fclose($fp);
        ?>

        <script type="text/javascript">
            $(function() {
                $("#event_cal").eventCalendar({
                    eventsjson: 'http://localhost/Calendar/backend_resources/json/events.json',
                    dateFormat: 'dddd MM-D-YYYY'
                });
            });
        </script>
    </head>
    <body>
        <div id="event_cal" ></div>
    </body>
</div>

maybe this stack overflow post might help you. write json encoded values into a file — Harigovind R
– Harigovind R, Commented Jun 11, 2015 at 11:31
You could also do this inside the controller itself the process of writing it to the file. Since you would not have to mix the php and html together. — Harigovind R
– Harigovind R, Commented Jun 11, 2015 at 11:39
So 701 bytes were successfully written to the file. You need to specify more precisely what exactly is not working. — jeroen
– jeroen, Commented Jun 12, 2015 at 8:44

Lal krishnan S L · Accepted Answer · 2015-06-11 11:40:09Z

1

You can put your file data using file_put_contents();

<?php
    //write to json file
     $jsonEvents=json_encode($calendar_results);
     file_put_contents('events.json',$jsonEvents);
    ?>

answered Jun 11, 2015 at 11:40

Lal krishnan S L

1,7451 gold badge16 silver badges33 bronze badges

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

3 Comments

Lal krishnan S L Over a year ago

is this url is correct ?? localhost/Calendar/backend_resources/json/events.json

Lal krishnan S L Over a year ago

k. are sure the file has permision to write?

Ishani Pathinayake Over a year ago

Yes. I am using jquery.eventCalendar.min.js plugin. will it effect to this??

Collectives™ on Stack Overflow

How to write json encoded data into a json file?

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related