Read JSON Data in Javascript and jQuery

  Convert JSON Data in JavaScript and jQuery

coding-zon-CONVERT-JSON-HTML-example


 

This tutorial explains how to read JSON data from various sources using JavaScript and jQuery.

 

1. How to read JSON data from local array.

2. How to read JSON data from external file.

3. How to read JSON data from URL.

 

1. How to read  local JSON Array in JavaScript?

 

 MenuTop

read-json-array-JS.html

<!DOCTYPE html>
<html>
<head> 
<title>Coding-zon Demo - Read JSON in Javascript</title>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script> 
</head> 
<body>  
<h2>How to read a json array in table format using jQuery</h2>
<table style="width: 80%" border="1" id="t1">
	<thead>
		<tr>
			<th>Id<</th>
			<th>Name</th>
			<th>Age</th>
			<th>City</th>
		</tr>
	<thead>
	<tbody>
	</tbody>
</table>
<script>
	var data =   [
	{
		id : "001",
		name : "Anna",
		age : 22,
		city : "London"
	},
	{
		id : "002",
		name : "John",
		age : 23,
		city : "Paris"
	},
	{
		id : "003",
		name : "Sofie",
		age : 21,
		city : "Texas"
	}
	];
	
	for(var i = 0, len = data.length; i < len; i++) {
		var temp = '<tr><td>' + data[i].id + '</td>';
		temp+= '<td>' + data[i].name+ '</td>';
		temp+= '<td>' + data[i].age + '</td>';
		temp+= '<td>' + data[i].city + '</td></tr>';
		$('#t1 tbody').append(temp); 
	}
	
</script>
 
</body>
</html> 
 

Result

 GoTop
coding-zon-read-local-json-array-JS-demo

The below given example takes a JSON ARRAY String that contains JSON object literals inside, So JavaScript first parses it first, and displays objects in a HTML table using jQuery.
 
read-json-array-string-JS.html
 Example-2
<!DOCTYPE html>
<html>
<head> 
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script> 
</head>
<body> 

<h2>How to Parse a JSON Array and Display in table format using Javascript</h2>
<table style="width: 80%" border="1" id="t1">
<thead>
	<tr>
	<th>Id</th>
	<th>Name</th>
	<th>Age</th>
	</tr>
</thead>
<tbody>
</tbody>
</table>
<script>

const txt = '[{"id": 1, "name": "Tom", "age": 23}, {"id": 2, "name": "Alice", "age": 22}, {"id": 3, "name": "John", "age": 24}, {"id": 3, "name": "Sony", "age": 21}]';

var students = JSON.parse(txt);
 
for(var i = 0, len = students.length; i < len; i++) {
	var temp = '<tr><td>' + students[i].id + '</td>';
	temp+= '<td>' + students[i].name + '</td>';
	temp+= '<td>' + students[i].age +  '</td></tr>';
	$('#t1 tbody').append(temp);
}


</script>

</body>
</html>
 Result:
 

coding-zon-read-ljson-array-syting-JS
 

 
2. How to read an external local JSON file in JavaScript?

 Top
data.JSON
var jsondata = '{"name":"John","email" :"john@example.com","phone" : "12341234"}' ;  
 
 
 
Linking External file
 
Example:
 
 <script type="text/javascript" src="data.json"></script>
 Code Example
 
read-external-json-js.html
 
<!DOCTYPE html>
<html>
<head>
 <script type="text/javascript" src="data.json"></script>

</head>

<body>

<h2>Reading data from External JSON file.</h2>

 

<script>
  
var jsobj = JSON.parse(jsondata);

document.write("<br>name: "+ jsobj.name);  
document.write("<br>email: "+ jsobj.email);  
document.write("<br>Phone: "+ jsobj.phone); 
 
</script>

</body>
</html>
 
 Result:
 
 Move toTop
coding-zon-read-externaljson-JS-example

 
 3. How to read  JSON data from url Using jQuery getJSON() method.
In the example, we read JSON data from https://jsonplaceholder.typicode.com/posts The returned object has three attributes: Id, Title, and Body. 
 
 
 GoTop
read-json-url-js.html
<!DOCTYPE html>
<html>
<head> 
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js">

</script>
</head>
<body> 

<h2>How to read JSON from URL using jQuery - getJSON</h2>
 <table style="width: 80%" border="1">
     <thead>
          <tr>
               <th>Id</th>
               <th>Title</th>
               <th>Body</th>
             
           </tr>
     </thead>
     <tbody id="tbody">
     </tbody>
</table> 

 
<script>

$.getJSON('https://jsonplaceholder.typicode.com/posts', function(posts) {
for(var i = 0, len = posts.length; i < len; i++) {
    var temp = '<tr><td>' + posts[i].id + '</td>';
    temp+= '<td>' + posts[i].title+ '</td>';
    temp+= '<td>' + posts[i].body + '</td></tr>';
    $('tbody').append(temp); 
  });

</script>

</body>
</html>

 
 Result:
 
 
 TopMenu
 
e-trainings-read-json-url-Demo

 
 
































Comments











Post a Comment



















Popular posts from this blog









Using javascript pass form variables to iframe src 














Image







      Open PDF in Bootstrap Modal Window   This tutorial shows How to pass a JavaScript/jQuery variable to bootstrap modal  view and sets it to iframe  src attribute. It passes value dynamically to src attribute of the iframe. When the user clicks a link, it opens the URL in a popup window. This  code shows the PDF in a Model without download option by hiding the toolbar.  To show PDF toolbar in modal, just add #toolbar=1   in the above script. index.php <!DOCTYPE html> <html lang= "en" >     <head>         <title>Bootstrap Model with PDF Example - coding-zon</title>         <meta charset= "utf-8" >         <meta name= "viewport"  content= "width=device-width, initial-scale=1" >         <link rel= "stylesheet"  href= "https://cdn.jsdelivr.net/npm/bootstrap@4.6.2/dist/css/bootstrap.min.css" >         <script src= "https://cdn.jsdelivr.net/npm/jquery@3.6.1/dist/jquery.slim.








Read more










 Creating a new PDF by Merging PDF documents using TCPDF














Image







Merging two PDFs in PHP What is PDF? The Portable Document Format. PDF  stands for "Portable Document Format". Essentially, the format is used when you need to save files that cannot be modified but still need to be easily shared and printed. PDF is one of the most commonly used file types around. PDFs generally contain shareable data, such as text or photo documents etc., and are accessible to anyone who has a computer or smartphone. Unlike a Word file, which requires Microsoft Word to view or edit, most browsers will open a PDF. How to merge PDFs?  You can merge several documents into one. In PHP, you  have a library called TCPDF which allows you to combine one or more PDF  documents to one single document. In this article, we will create a new PDF by Merging PDF documents using TCPDF. Download the  PDFMerger-tcpdf.zip here. Unzip it and copy it to the PHP server. Copy the  PDF files into the same folder that you want to combine. Open the file: merge-pdf-example.php Provide








Read more










Import excel file into mysql in PHP 














Image







  Upload Excel file and Import  it into MySQL in PHP  Create a table in some database with given code.   Download Library  - extract it, rename the folder to library . Create index.php  file with given code in a server. Create  excelUpload.php  with given code. Create db_config.php . Create one Excel file with some sample data as shown in the below image of Excel file. Create ' uploads ' folder in the same directory. Now start server, run the index.php. Upload a .xls  file. If Everything is fine, Excel data inserted in the above created MySQL table - tbl_products . PHP Version:    5.5.11 Folder Structure       Query: CREATE  TABLE  IF NOT  EXISTS  `tbl_products` (   `id` int ( 11 ) NOT  NULL  AUTO_INCREMENT,   `productname` varchar ( 100 ) DEFAULT  NULL ,   `description` varchar ( 100 ) DEFAULT  NULL ,   PRIMARY  KEY  (`id`) )     Top index.php <!DOCTYPE html>  <html>  <head>  <title> coding-zon Demo - Upload Excel to MySQL in PHP </title>  <lin








Read more