Php dataset to json

PHP Json_encode: Serialize PHP Objects to JSON

PHP is a server-side scripting language for creating your website’s backend system that can serve webpages, communicate with databases, and exchange data over the internet. A decent backend framework like PHP needs to be capable of providing and processing data in any format (e.g., XML, JSON, etc.) to be socially accepted in a society of skilled web development frameworks.

Since JSON is a ubiquitous data format for sharing and storing data, it is vital that a PHP backend allows processing of JSON data. This is where json_encode (and json_decode) come into the picture and enable PHP processed data to be compatible with frameworks and systems that deal with JSON data and make way for easier and faster web development.

In this post, we’ll learn about the JSON format, about the json_encode() function — what it is, why it is required, and how it can be used to convert PHP data structures into JSON format, all with examples. In the end, we’ll also see how we can decode JSON data to be able to process it. Let’s get started!

Use these links to navigate the guide:

What is the JSON_Encode Function?

What is JSON?

JSON (JavaScript Object Notation) is one of the most popular open-standard file formats used for storing and sharing data. It uses human-readable text to represent data using attribute-value pairs and array data types.

This is what a common JSON object looks like —

We’ll be using this example in the sections below to understand how we can encode PHP data into JSON format.

JSON allows us to represent and encapsulate complex data in an organized fashion that can be shared easily across the internet. Even though JSON derives its name from JavaScript, JSON was created to be used by all programming languages.

Let’s see how we can convert our PHP variables into JSON format.

JSON_Encode — PHP variables to JSON

json_encode() is a native PHP function that allows you to convert PHP data into the JSON format.

json_encode ( mixed $value [, int $options = 0 [, int $depth = 512 ]] ) : string 

The function takes in a PHP object ($value) and returns a JSON string (or False if the operation fails). Don’t worry about the $options and $depth parameters; you’re seldom going to need them.

Let’s look at a simple example —

 1, 'b' => 2); echo json_encode($arr); ?>

Why encode to JSON?

As we saw above, JSON is one of the most common formats for exchanging data over the internet. Therefore, it can be imperative in some cases for PHP servers to provide JSON-encoded data and to be able to process it.

Let’s see how we can encode various PHP data structures into JSON using json_encode() .

Convert PHP Strings to JSON

JSON encoding for a string is the string itself. Therefore, encoding a PHP string into JSON is quite simple; it results in the same string being returned.

Let’s see this using an example —

PHP String to JSON Example

Convert PHP Objects to JSON

Since the information in JSON is stored in key/value pairs, json_encode() is more likely to be used to encode PHP objects and their instance variables.

PHP Object to JSON Example

Let’s understand how we can JSON-encode a PHP object by creating an instance of a Book class based on the Library example we saw above (Sec 1.1). We’ll create two instance variables for the book’s instance and encode the object using json_encode().

 $book = new Book(); $book->id = 101; $book->label = "Lorem ipsum"; $jsonData = json_encode($book); echo $jsonData."\n"; ?>

Convert PHP Array to JSON

There are three types of arrays in PHP, namely — Indexed arrays, Associative arrays, and Multidimensional arrays. Let us look at what these are and some examples of how we can encode each of these into JSON —

Indexed Array to JSON

Indexed arrays are conventional arrays that are represented by index numbers.

Example: $arr = array(1,2,3,4); // [1,2,3,4]

Converting them to JSON is quite easy —

Associative Array to JSON

Associative arrays are arrays that use named keys as indices for your values.

Example: $age = array(«John»=>»11», «Ken»=>»19», «Tim»=>»14»);

We can also arrive at the book JSON object that we saw above by encoding an Associative array as such —

101, "label"=>"Lorem Ipsum"); echo json_encode($book); ?>

Notice how an Indexed array is represented by an array in JSON, whereas Associative arrays take the form of a complete JSON object after being encoded.

Multidimensional Array to JSON

Multidimensional arrays can be created by nesting arrays into each other as such-

$multid_arr = array( array(1,2,3,4), array(1,2,3,4), ); 

We can create a Multidimensional array to store a list of books for our library example. Let’s create one and encode that into JSON.

101, "label"=>"Lorem Ipsum"), array("id"=>102, "label"=>"Dolor sir amet"), array("id"=>103, "label"=>"Lorem Ipsum dolor"), ); echo json_encode($books); ?>

Putting it all together

Now that we have seen how json_encode( ) is used in different contexts, for encoding different PHP data types, let’s put all of our learnings together to create JSON data for the Library example we saw above.

 class Library < >class Book < >$book1 = new Book(); $book1->id = 101; $book1->label = "Lorem ipsum"; $book2 = new Book(); $book2->id = 102; $book2->label = "Dolor sir amet"; $books = array($book1, $book2); $library = new Library(); $library->books = $books; $myClass = new MyClass(); $myClass->library = $library; $jsonData = json_encode($myClass); echo $jsonData."\n"; 

Well, that was fun! Now before we wrap up, I think it’s worthwhile to see how we can convert JSON data back to PHP variables.

JSON_Decode — JSON to PHP variables

In the very likely case of your JavaScript front-end sending JSON-based data back to your PHP server, you would need a way to decode the JSON data in a way that can be processed by PHP.

We can use PHP’s json_decode() function for the same, which takes in a JSON encoded string and returns the corresponding PHP variable.

json_decode ( string $json [, bool $assoc = FALSE [, int $depth = 512 [, int $options = 0 ]]] ) : mixed

$assoc parameter (False by default) is used to specify whether you need the function to return an Associative array or a standard class Object.

JSON_Decode example

Let’s try to retrieve the book object that we encoded into JSON above by decoding it using php_decode() .

'; $book = json_decode($book_json); var_dump($book); ?>

Note how by default a stdClass object is returned. For decoding it as an Associative array, set the $assoc parameter to True as such —

$book = json_decode($book_json, True);

This will result in an Associative array being returned.

Try the JSON_Encode Function for Yourself

In this post, we read about the JSON (JavaScript Object Notation) format, why it is essential, and how we can convert different PHP variables into JSON using json_encode() . We also saw how we could use json_decode() to decode JSON data into PHP variables. With this understanding of processing JSON data using PHP, go ahead and encode your PHP objects into JSON and share them across the internet. All of this while staying at home. Stay healthy, stay safe!

Get peace of mind knowing your PHP application is performing at its best with ScoutAPM

Most popular

Follow Us on Social Media!

Источник

How to Convert MySQL Data to JSON using PHP

One of the important responsibilities in web development for PHP is the conversion of data from MySQL to JSON format. JSON is favoured over XML as a data interchange format between web applications and has grown in popularity over time.

JSON has its own benefits, such as being lightweight, allowing for the storage of sophisticated data structures in plain text, and being extremely readable by humans. Here, we’ve already spoken about translating JSON data to MySQL. Let’s now examine how to use PHP to translate the MySQL result set to JSON.

PHP Script to convert MySQL to JSON

Step 1: Create Table and Add Demo Data in Database

If you do not have a database table ready, use the following SQL query to create a technologies table with id and tech_name table properties and add some data into the technologies table to check that data using the jQuery live search box in PHP.

CREATE TABLE technologies ( id INT NOT NULL AUTO_INCREMENT , tech_name VARCHAR(255) NOT NULL , PRIMARY KEY (id) ); INSERT INTO technologies VALUES(1,'HTML'); INSERT INTO technologies VALUES(2,'CSS'); INSERT INTO technologies VALUES(3,'JAVASCRIPT'); INSERT INTO technologies VALUES(4,'JQUERY'); INSERT INTO technologies VALUES(5,'PHP'); INSERT INTO technologies VALUES(6,'AJAX'); INSERT INTO technologies VALUES(7,'NODEJS'); INSERT INTO technologies VALUES(8,'EXPRESSJS'); INSERT INTO technologies VALUES(9,'ANGULARJS'); INSERT INTO technologies VALUES(10,'REACTJS'); 

Источник