Labels

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, January 18, 2018

How To Populate JSON Data In Select Dropdown Using jQuery?

ViewUserData.php


<?php

$DatabaseServer = "localhost";

$DatabaseUsername = "root";

$DatabasePassword = "root";

$DatabaseName = "demo";


$Connection = mysqli_connect($DatabaseServer , $DatabaseUsername ,  $DatabasePassword , $DatabaseName);

 

if($Connection=== false){

    die("ERROR: Could not connect. " . mysqli_connect_error());

}


$SQL = mysqli_query($Connection, "SELECT * FROM User");

$Result = array();


while($Row = mysqli_fetch_assoc($SQL))    {

       $Result[] = array(

          'FirstName' => $Row['FirstName']            

       );

    }


    echo  json_encode($Result);

?>

Output:

JSON Array:



[{"UserID":"1","FirstName":"Ram","LastName":"Sri"}]

ViewUserData.html


<Html>

<head>

<script language="JavaScript" src="https://code.jquery.com/jquery-3.2.1.min.js"></script>

<script>

$(document).ready (function () {

            $.getJSON ("ViewUserData.php",

                function (json) {

                    for (var i = 0; i < json.length; i++) {

                        $("#UserID").append("<option>" + json[i].FirstName+ "</option>");

                    }

                });

});

</script>

</head>


<body>


<select id='UserID'>

//Your Json Array comes here
</select>


</body>


</html>


Output:










MySQL: Run these two queries


CREATE TABLE `user` (
  `UserID` int(12) NOT NULL,
  `FirstName` varchar(48) NOT NULL,
  `LastName` varchar(48) NOT NULL,
  `Email` varchar(128) NOT NULL,
  `City` varchar(48) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `user` (`UserID`, `FirstName`, `LastName`, `Email`, `City`) VALUES
(1, 'Ram', 'Sri', 'zzz@zzz.com', 'Delhi'),
(2, 'Krishna', 'Vasudev', 'yyy@yyy.com', 'Delhi');

-
Labels: , , , , , , , , , ,

49 comments:

  1. durga padhanJanuary 18, 2018 at 6:48 PM

    Thank's
    Good post

    ReplyDelete
  2. Sairam VarnakaviJanuary 18, 2018 at 7:12 PM

    Thanks For Your Post.

    ReplyDelete
  3. annaApril 10, 2018 at 4:11 PM

    This comment has been removed by the author.

    ReplyDelete
  4. Garry SinghApril 18, 2018 at 7:41 PM

    Buy perfect money in India @Rs.70/- per pm Sell @Rs.58/- per pm,CALL 08054019105, Chandigarh, 160017

    --------------------------------------------------------------------------------------------------------------

    Buy/Sell Perfect Money At Reasonable Rates. We Provide Perfect Money At best Rates.
    We also sell buy Perfect Money, neteller and Bitcoin.

    Call us : +91 9517544444

    Gtalk : garrysingh1598

    Web.: www.sellperfectmoney64.com

    ReplyDelete
  5. Jonna RichardApril 23, 2018 at 4:02 PM

    Most of the students who look for an academic writing solution simply search for such on a site on the most widely used search engine and select anyone firm from the top websites there.But little do they know that going through a review of such websites will give you much insight about it which you can’t know by simply visiting it.
    All Assignment Help review

    ReplyDelete
  6. Sunled EnergyMay 3, 2018 at 11:43 AM

    Thanks for the great writeup. This the fact is once were some sort of pleasure bank account this.Commercial Led Lighting

    ReplyDelete
  7. June Florist Pte LtdMay 15, 2018 at 11:09 AM

    June Florist - Same day flower delivery singapore. Call June Florist for floral arrangements for wedding, decorations for conferences, hand banquet decorations, Flower Box, table flower arrangement & more. Tel: +65 6282 7555
    online flower shop singapore
    online flower delivery

    ReplyDelete
  8. Sunled EnergyMay 30, 2018 at 10:12 AM

    Lighting Warehouse Sydney Eye-catching element of written content. I merely came across your own web site and accession capital to say that we receive essentially liked account your current blog page discussions

    ReplyDelete
  9. Pogo SupportJune 8, 2018 at 4:18 PM

    Thanks for the great writeup.
    free games

    ReplyDelete
  10. NortonsupportJune 9, 2018 at 1:05 PM

    excellent post!!!

    norton antivirus
    anti virus
    norton security
    best antivirus
    norton 360
    free virus protection
    antivirus for mac
    tech support
    symantec
    norton
    norton login
    norton security
    antivirus software
    norton login
    norton account
    norton internet security
    computer repair
    virus protection
    virus cleaner
    virus scan
    virus removal
    threat protection
    norton removal tool
    my norton account

    ReplyDelete
  11. condolence wreathJune 19, 2018 at 8:58 AM

    florist
    flower delivery to singapore
    buy flower bouquet
    flower shop delivery singapore
    condolence wreath

    ReplyDelete
  12. Olivia WatsonJune 26, 2018 at 3:53 PM

    You have helped to increase our kowedge in this field.
    Thanks for sharing .

    online meat delivery in kolkata
    online meat kolkata
    Online Meat Shopping in kolkata
    household items in kolkata
    online grocery Shop kolkata
    Online Fish Store in kolkata
    online vegetables shop in kolkata
    Online Meat Shopping in kolkata
    fresh bazar in kolkata

    ReplyDelete
  13. ajay akJune 27, 2018 at 12:20 PM

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

    ReplyDelete
  14. exp_nayonJuly 3, 2018 at 11:52 PM


    Hi guys, It’s always the first and important step for electric-guitar-beginners to get their first “right” BEST electric guitar. Because that guitar will follow us through our first stage in the guitar world. You know that since you’re reading this topic and haven’t yet picked a guitar randomly in a store, on the internet or recommended by some friends.

    if you want more just look here Studio Microphone

    ReplyDelete
  15. hotmailJuly 4, 2018 at 2:32 PM

    Blog của bạn all posts messages is very exclusive and good for the user because when you have read your blog look the symbol is not allowed for me. I want to thank thank you. Most priority is you have a bookmark your web to update the future.
    hotmail login

    ReplyDelete
  16. Anthony JuniorJuly 5, 2018 at 1:03 AM

    This is really great work. Thank you for sharing such a good and useful information here in the blog.

    Are you using roadrunner mail service or facing Roadrunner Email Problems and want help. just dial our customer service number +1-888-338-6033

    ReplyDelete
  17. ajayjayadsdAugust 4, 2018 at 3:33 AM

    I want to say thanks to you. I have bookmark your site for future updates.
    Kindle won't connect to wifi

    ReplyDelete
  18. andrewmathewAugust 4, 2018 at 6:42 PM

    Thanks for a marvelous posting! I actually enjoyed reading it, you can be a great author.I will be sure to bookmark your blog and definitely will come back later on. I want to encourage you to definitely continue your great job, have a nice afternoon! digital marketing trends

    ReplyDelete
  19. dollOctober 26, 2018 at 10:52 AM

    Hey would you mind letting me know which web host you're working with? I've loaded your blog in 3 different browsers and I must say this blog loads a lot quicker then most. Can you suggest a good hosting provider at a reasonable price? Thanks, I appreciate it!Amaron Inverter in Chennai

    ReplyDelete
  20. LiamJanuary 8, 2019 at 4:39 PM

    Java Assignment Help
    Many times students are tensed for their projects and assignments, so at that time they can take online assignment help to complete it on time. There are experts available online who prepare the perfect assignment for you.

    ReplyDelete
  21. LiamJanuary 8, 2019 at 4:53 PM

    you can go through AllAssignmentHelp reviews. It will help you to know about the services, and it will help you to know whether that site is reliable or not. This is a way of understanding the opinion of users, and it helps the website to maintain its functionality and reliability.

    ReplyDelete
  22. sathyarameshJanuary 14, 2019 at 12:23 PM

    Qtp training in Chennai
    Big Data Training in Chennai
    Hadoop Training in Chennai
    Android Training in Chennai
    Selenium Training in Chennai
    Digital Marketing Training in Chennai
    JAVA Training in Chennai
    web designing training in omr
    web designing training in anna nagar
    web designing training in Tnagar

    ReplyDelete
  23. Aruna RamJanuary 18, 2019 at 12:05 PM

    It's so nice. I suggest to my friends on this blog. This is a very great powerful post. Thank you and keep it up...
    IELTS coaching in Chennai
    IELTS coaching centre in Chennai
    Jmeter Training in Chennai
    TOEFL Coaching in Chennai
    Spoken English Classes in Chennai
    IELTS coaching in Adyar
    IELTS coaching in Porur
    IELTS coaching in Anna Nagar

    ReplyDelete
  24. Tech LineFebruary 22, 2019 at 11:42 AM


    SEO Company in Almora Uttarakhand
    SEO Service Almora Uttarakhand
    Digital Marketing Agency Almora
    PPC Services in Almora Uttarakhand
    Best Website Promotion Company Almora
    SEO Freelancer in Almora Uttarakhand
    Internet Marketing in Almora Uttarakhand

    ReplyDelete
  25. Rory DavisMarch 4, 2019 at 3:32 PM

    Thanks for sharing about "How To Populate JSON Data In Select Dropdown Using jQuery?" Your post is really helpful for PHP users. I hope you will share another post for your readers.
    Kindle Fire Wifi Connection Failure

    ReplyDelete
  26. Adam ThomasMarch 9, 2019 at 4:09 PM

    Thank you for sharing this resource with me and the world. Wish you always luck.AllAssignmenthelp.com reviews

    ReplyDelete
  27. Anbarasan14April 3, 2019 at 3:16 PM

    I believe that your blog will surely help the readers who are really in need of this vital piece of information. Waiting for your updates.

    IELTS Classes in Mumbai
    IELTS Coaching in Mumbai
    IELTS Mumbai
    Best IELTS Coaching in Mumbai
    IELTS Center in Mumbai
    IELTS Coaching in Chennai
    IELTS Coaching Centre in Chennai
    IELTS Training in Chennai
    IELTS Chennai
    Best IELTS Coaching in Chennai

    ReplyDelete
  28. sultanaApril 3, 2019 at 5:21 PM


    Great info. The content you wrote is very interesting to read. This will loved by all age groups.
    Angularjs Training in Chennai
    Angularjs Course in Chennai
    CCNA Training in Chennai
    Salesforce Training in Chennai
    Angular5 Training in Chennai
    Angular6 Training in Chennai
    Angular7 Training in Chennai
    Angularjs Training in Chennai
    Angularjs Course in Chennai

    ReplyDelete
  29. TuckerjackkApril 3, 2019 at 8:26 PM

    Office.com/Setup is a set of desktop applications, which is widely used products for the home as well as an office. Microsoft office gives the freedom of writing documents, blogs, letters and with the use of Microsoft office PowerPoint one can prepare a presentation also.

    howtominernewswatt
    Norton.com/Setup
    Office.com/Setup
    Office.com/Setup
    office Setup
    Daily Helps
    office.com/Setup

    ReplyDelete
  30. TuckerjackkApril 3, 2019 at 8:27 PM

    Office Setup is a software which is used by almost all company and business and even by individuals For all their office activities or for personal use. It has excels, word, and ppt as their constituent are most widely used apps. For any concern and help just visit website for office help and key activation. You can do it by yourself if you know how to install office setup on your PC or Mac or you can call third party companies as well who can do it on your behalf.
    office.com/Setup
    office.com/Setup
    Norton.com/Setup
    office.com/Setup
    office.com/Setup
    office.com/Setup
    Norton.com/Setup

    ReplyDelete
  31. Domenic TylorApril 12, 2019 at 12:39 PM

    Assignment writing services are providing our experts. Fully guide and help writer your assignment. Our experts are available anytime helping you. Direct hire at our website australiaasignmenthelp.com

    ReplyDelete
  32. ireland assignment helpMay 9, 2019 at 11:05 AM

    Ireland assignment help provides the best assignment help to all students of Ireland. We offer the outstanding assignment writing help services by assignment helper at an affordable price. So, students can get good marks and also impress their college and universities mentors, so, email us at info@irelandassignmenthelp.com

    ReplyDelete
  33. UnknownMay 17, 2019 at 6:02 PM

    Amazing Post. If you are dealing with any kindle issues then contact Kindle Help Guide expert team. You can call on our toll – free kindle helpline number USA\Canada: (+1) 8889494666, UK: (+44) 8000418324 or visit our website kindle help guides.

    ReplyDelete
  34. dollMay 20, 2019 at 1:36 PM

    Hey there! This is my first comment here so I just wanted to give a quick shout out and tell you I truly enjoy reading your posts. Can you recommend any other blogs/websites/forums that cover the same topics? Thank you!e-commerce website

    ReplyDelete
  35. Helen HensonMay 30, 2019 at 2:15 AM

    Awesome post

    Thanks
    resellerclub | thesmespace | fstoppers | hubpages | mollysonic

    ReplyDelete
  36. Kelly CainJune 3, 2019 at 4:34 PM

    Interpages

    Guest Blogger

    Best Guest Blogging Site

    Guest Posting Site

    Guest Blogging Website

    ReplyDelete
  37. AnonymousJune 3, 2019 at 5:21 PM

    Nice Post

    Best Learning Management System

    joomla moodle single login

    Prestashop Plugin development and customization

    Magento Web Development Services

    Moodle Service Provider

    ReplyDelete
  38. UnknownJune 4, 2019 at 1:01 PM

    Thanks for the post I actually learned something from it. Very good content on this site Always looking forward to new post. Digital Signature Certificate

    ReplyDelete
  39. kristinahojholtJune 4, 2019 at 8:08 PM

    Good day! I know this is kinda off topic but I was wondering if you knew where I could find a captcha plugin for my comment form? I'm using the same blog platform as yours and I'm having problems finding one? Thanks a lot!
    Build the Content

    ReplyDelete
  40. esigndscJune 5, 2019 at 3:33 PM

    Thanks for such a continuous great postings. Digital Signature Certificate

    ReplyDelete
  41. kristinahojholtJune 8, 2019 at 12:46 PM

    I think this is among the most vital information for me. And i'm glad reading your article. But should remark on some general things, The website style is perfect, the articles is really excellent : D. Good job, cheers
    advertising on social media platforms

    ReplyDelete
  42. kristinahojholtJune 8, 2019 at 12:57 PM

    It's best to take part in a contest for top-of-the-line blogs on the web. I'll recommend this site!
    digital marketing promotions

    ReplyDelete
  43. esigndscJune 24, 2019 at 4:35 PM

    Thank you so much for providing such useful content. Class 2 Digital Signature Certificate

    ReplyDelete
  44. esigndscJune 26, 2019 at 4:17 PM

    Thanks For Sharing This, Very Interesting And Helpful Support Provide By this blog. Apply Class 3 Digital Signature Certificate

    ReplyDelete
  45. ACE NETWORKS LLCJuly 11, 2019 at 3:32 PM

    Is it accurate to say that you are confronting
    Norton Error 8504 102 and unfit to begin the item? You should simply fix this blunder b interfacing the knowledgeable techniques. You can utilize group watcher to give the specialists a chance to fix basic framework issues and few of the incorporate framework organizing, reinforcement, cleaning, and recuperation.

    ReplyDelete
  46. FreddyKotAugust 1, 2019 at 10:00 AM

    I'm really enjoying the design and layout of your blog. It's a very easy on the eyes which makes it much more enjoyable for me to come here and visit more often. Did you hire out a designer to create your theme? Fantastic work!
    digital marketing landscape

    ReplyDelete
  47. Riya GuptaAugust 8, 2019 at 7:37 PM

    There are so many collections of jumpsuit at Indianochre.com. You can buy here different types of dresses for women’s.
    Dress and Jumpsuit Collection
    Online Women Clothing Delhi

    ReplyDelete
  48. adhiAugust 14, 2019 at 11:49 AM


    thanks for your information really good and very nice web design company in velachery

    ReplyDelete
  49. sangeetha sathyanAugust 16, 2019 at 3:27 PM

    Very nice post with lots of information. Thanks for this updates.
    ui ux design course in Chennai
    ui ux designer course in Chennai
    ui ux course in chennai
    ReactJS Training in Chennai
    Web Designing Course in chennai
    web designing training in chennai
    Tally course in Chennai
    ui ux design course in Porur
    ui ux design course in Tambaram
    ui ux design course in Adyar

    ReplyDelete

Subscribe to: Post Comments (Atom)

More Posts

FOLLOW