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');
keep up the good work. this is an Assam post. this to helpful, i have reading here all post. i am impressed. thank you. this is our digital marketing training center. This is an online certificate course
ReplyDeletedigital marketing training in bangalore | https://www.excelr.com/digital-marketing-training-in-bangalore
ReplyDeleteThanks for your extraordinary blog. Your idea for this was so brilliant. This would provide people with an excellent tally resource from someone who has experienced such issues. You would be coming at the subject from a different angle and people would appreciate your honesty and frankness. Good luck for your next blog!
Tally ERP 9 Training
tally classes
Tally Training institute in Chennai
Tally course in Chennai
seo training classes
seo training course
seo training institute in chennai
seo training institutes
seo courses in chennai
seo institutes in chennai
seo classes in chennai
seo training center in chennai
Good blog, its really very informative, do more blog under good concepts.
ReplyDeleteData Science Course in Chennai
Data Science Courses in Bangalore
Data Science Training in Bangalore
Best Data Science Courses in Bangalore
Data Science Institute in Bangalore
Data Science Training Institutes in Bangalore
Data Science Training in BTM
AWS Training in Bangalore
DevOps Training in Bangalore
PHP Training in Bangalore
Phenomenal Blog!!! thanks for your post and awaiting for your new updates...
ReplyDeleteDigital Marketing Course in Chennai
Digital Marketing Training in Chennai
Digital Marketing Training
Digital Marketing Course
Digital marketing course in Tambaram
Digital marketing course in Guindy
Python Training in Chennai
Big data training in chennai
SEO training in chennai
JAVA Training in Chennai
Nice Blog...Thanks for sharing the article waiting for next update...
ReplyDeleteArtificial Intelligence Course in Chennai
AI Training in chennai
ai classes in chennai
C C++ Training in Chennai
javascript training in chennai
Html5 Training in Chennai
QTP Training in Chennai
Spring Training in Chennai
DOT NET Training in Chennai
Great post. keep sharing such a worthy information
ReplyDeleteTally Course in chennai
Tally Course in Bangalore
Tally Training in Bangalore
Tally training in coimbatore
Tally course in madurai
Tally Course in Hyderabad
Tally Classes in Bangalore
Tally institute in Bangalore
Ethical hacking course in bangalore
Selenium Course in Bangalore
I am overwhelmed by your post with such a nice topic. Usually I visit your blogs and get updated through the information you include but today’s blog would be the most appreciable. Well done!
ReplyDeletePlease check this ExcelR Digital Marketing Course in Pune
You are providing a post is very useful for develop my knowledge and I learn more info from your blog.
ReplyDeleteDigital Marketing Course In Kolkata
Web Design Course In Kolkata
SEO Course In Kolkata
I have to agree with everything in this post. Thanks for useful sharing information.
ReplyDeleteArtificial Intelligence Course in Chennai
AI courses in Chennai
Python Training in Bangalore
Python Course in Bangalore
Angularjs Training in Bangalore
Web Development courses in bangalore
salesforce institute in bangalore
Python Training in Chennai
Python Training in Coimbatore
Python Training in Hyderabad
This was really one of my favorite website. Please keep on posting. ExcelR Digital Marketing Course Pune
ReplyDeleteIf I had to give a prime example of great quality content, this article would be one. It's well-written material that keeps your interest well.
ReplyDeleteBest Data Science training in Mumbai
Data Science training in Mumbai
This article contains some of the most informative content I've read in quite some time. The points of this content are clear-cut and engaging. I think much like this writer.
ReplyDeleteBest Data Science training in Mumbai
Data Science training in Mumbai
Impressive! I finally found great post here. Nice article on data science . It's really a nice experience to read your post. Thanks for sharing your innovative ideas to our vision.
ReplyDeleteDigital Marketing Training Course in Chennai | Digital Marketing Training Course in Anna Nagar | Digital Marketing Training Course in OMR | Digital Marketing Training Course in Porur | Digital Marketing Training Course in Tambaram | Digital Marketing Training Course in Velachery
Thanks Friend!
ReplyDeleteI have seek solution for the same what you have posted friend.., share some more.it may help us a lot
Ai & Artificial Intelligence Course in Chennai
PHP Training in Chennai
Ethical Hacking Course in Chennai Blue Prism Training in Chennai
UiPath Training in Chennai
Thanks for your nice post, i am interested to learn online freelancing, but firstly i have to learn computer , could you suggest me please which computer training center best.
ReplyDeleteDot Net Training in Chennai | Dot Net Training in anna nagar | Dot Net Training in omr | Dot Net Training in porur | Dot Net Training in tambaram | Dot Net Training in velachery
The development of artificial intelligence (AI) has propelled more programming architects, information scientists, and different experts to investigate the plausibility of a vocation in machine learning. Notwithstanding, a few newcomers will in general spotlight a lot on hypothesis and insufficient on commonsense application. machine learning projects for final year In case you will succeed, you have to begin building machine learning projects in the near future.
ReplyDeleteProjects assist you with improving your applied ML skills rapidly while allowing you to investigate an intriguing point. Furthermore, you can include projects into your portfolio, making it simpler to get a vocation, discover cool profession openings, and Final Year Project Centers in Chennai even arrange a more significant compensation.
Data analytics is the study of dissecting crude data so as to make decisions about that data. Data analytics advances and procedures are generally utilized in business ventures to empower associations to settle on progressively Python Training in Chennai educated business choices. In the present worldwide commercial center, it isn't sufficient to assemble data and do the math; you should realize how to apply that data to genuine situations such that will affect conduct. In the program you will initially gain proficiency with the specialized skills, including R and Python dialects most usually utilized in data analytics programming and usage; Python Training in Chennai at that point center around the commonsense application, in view of genuine business issues in a scope of industry segments, for example, wellbeing, promoting and account.
nice blog..valuable information....thanks for sharing...
ReplyDeleteStudy Abroad Consultants in Kerala
study abroad consultants in thrissur
Study Abroad Consultants in Calicut
abroad job consultancy in coimbatore
best overseas education consultants in thrissur
overseas education consultants in kozhikode
study abroad
study in poland
study in europe
free abroad study