php (35) javascript (31) phpjavascript (30) jquery (23) html (20) mysql (14) database (9) codeigniter (4) json (4) bar chart (2) calendar (2) column chart (2) framework (2) google maps (2) query (2) tables (2) url (2) dropdown (1)

Thursday, March 22, 2018

How to populate JSON data in input fields using Javascript in a best way?

Here we are discussing about how to populate JSON data in HTML input fields dynamically.This might be the best way to work on any kind of edit data/form operation.


1. Creating database and table
2. Connecting to database
3. Fetching data
4. Parsing data
5. Populating in the form

Creating database and table

Create a database(demo) make sure that you are using the right database name in your config.php file.

Run the following queries to create a table with some sample data

To create a table(user) 

  `UserID` int(12) NOT NULL,
  `FirstName` varchar(48) NOT NULL,
  `LastName` varchar(48) NOT NULL,
  `Email` varchar(128) NOT NULL,
  `Password` varchar(20) NOT NULL,
  `City` varchar(48) NOT NULL

To insert data into the table

INSERT INTO `user` (`UserID`, `FirstName`, `LastName`, `Email`, `Password`, `City`) VALUES
(7, 'Rahul', 'Rajshekaran', '', 'Rahul@123', 'Pune'),
(8, 'Mahesh', 'Krishna', '', 'Mahesh@123', 'Delhi'),
(9, 'Mahidar', 'kumar', '', 'Mahidar@123', 'Pune'),
(10, 'Mahpal', 'yadhav', '', 'Mahipa@123', 'Delhi');

Connecting to database(config.php)

/* Database connection start */
$dbHost = 'localhost';
$dbUsername = 'root';
$dbPassword = 'root';
$dbName = 'demo';

//Create connection and select DB
$connection = new mysqli($dbHost, $dbUsername, $dbPassword, $dbName);
die("Unable to connect database: " . $connection->connect_error);

Fetching data(index.php)

//Check UserID set or not
if (isset($_GET['UserID'])) {
    $UserID = $_GET['UserID'];
    $sql = "SELECT * FROM user WHERE UserID='$UserID'";
    $result = mysqli_query($connection, $sql);
    if ((mysqli_num_rows($result)) > 0) {
        while ($row = mysqli_fetch_array($result)) {
            $rows[] = array("Message" => "Success", "UserID" => $UserID, "FirstName" => $FirstName, "LastName" => $LastName, "Email" => $Email, "City" => $City);
    } else {
        $rows[] = array("Message" => "No Data");
} else {
    $rows[] = array("Message" => "Error");
echo json_encode($rows);

Parsing data with JQuery

<script src=""></script>
function userEdit(UserID) {
    $(document).ready(function () {
        $.getJSON("http://localhost/demo/user.php?UserID=" + UserID,
            function (json) {
                for (var i = 0; i < json.length; i++) {
var Message = json[i].Message;
document.getElementById("Message").innerHTML = Message;
                    $.each(json[0] , function (key, value){
<style type="text/css">
        position: absolute;
        width: 600px;
        height: 200px;
        z-index: 15;
        top: 40%;
        left: 30%;
        margin: -100px 0 0 -150px;
        background: #43c181;
        padding-top: 10px;
        padding-left: 60px;
        padding-bottom: 30px;
        width: 500px;
        height: auto;
        padding: 5px;

*Place the above code in the head section of your HTML.

Populating in the form


<div class='box'>

<h4 id="Message"></h4>

<form action='#' method='post' id='Form' enctype='multipart/form-data'>

<div class="col-md-10">
            <label>First Name</label>
            <input type="text" id="FirstName" class="form-control" name="FirstName" placeholder='First Name'/>

 <div class="col-md-10">
            <label>Last Name</label>
            <input id="LastName" name="LastName" class="form-control" type="text" placeholder='Last Name'/>

 <div class="col-md-10">
            <input id="Email" name="Email" class="form-control" type="text"




//Call function
userEdit(UserID = 7);


*Please subscribe to PHP Javascript for more.

* Display JSON data in dropdown

Display JSON data in a table


  1. Hi,
    This is my first visit to your blog! I found your article very fantasy. Thanks for sharing this information. You have very good information about latest topic. You have given great information article that will be very useful for me. I want to know more information deeply about it.

  2. Pretty blog, so many ideas in a single site, thanks for the informative article, keep updating more article.
    Webdesining course in chennai

  3. great. I am confident there are many outstanding features coming soon.
    hotmail login account

  4. Nice post. Thanks for sharing! I want people to know just how good this information is in your article. It’s interesting content and Great work.
    Thanks & Regards,
    VRIT Professionals,
    No.1 Leading Web Designing Training Institute In Chennai.

    And also those who are looking for
    Web Designing Training Institute in Chennai
    Photoshop Training Institute in Chennai
    PHP & Mysql Training Institute in Chennai
    SEO Training Institute in Chennai
    Android Training Institute in Chennai

  5. Great work! This is the type of info that should be shared around the web. Shame on the search engines for not positioning this post higher! Come on over and visit my web site . Thanks =) web development firm singapore

  6. Youre so cool! I dont suppose Ive learn anything like this before. So good to search out any person with some authentic thoughts on this subject. realy thank you for beginning this up. this web site is one thing that's wanted on the net, somebody with a bit of originality. helpful job for bringing one thing new to the web! 个人陈述

  7. Thanks for such a continuous great postings. We are also provide Digital Signature Certificate in Delhi

  8. Nice Article, Thanks For Sharing This, Very Interesting And Helpful Support Provide By this blog, This was the first news blog. Class 2 Digital Signature Certificate

  9. Thanks for sharing the relevant information with us…It are good for us. Apply Class 3 Digital Signature Certificate

  10. I really enjoyed reading your blog, you have lots of great content. To make the documents secure digital signature and encryption is the best way. Please visit here:
    Digital Signature Certificate in Delhi

  11. You have given such a great information that will be very useful for me. I want to know more information deeply about it.
    Private Detective Agency in Mumbai

  12. This is a 2 good post. This post gives truly quality information. in fact very useful tips are provided here. thank you so much. Keep up the good works.
    Class 2 Digital Signature Certificates

  13. Very interesting topics, I hope the incoming comments and suggestion are equally positive. Thank you for sharing this information that is actually helpful.

  14. Reading this information So i’m happy to convey that I have a very good uncanny feeling I discovered exactly what I needed. I most certainly will make certain to do not forget this web site and give it a look on a constant basis. intelligent video analytics


More Posts