Dropdown list by using data from an xml file

We can create one drop down list box by using data from our student table. This xml file is created by reading data from MySQL table. You can check the output as XML from our file-xml-demo.xml file.
Demo of dropdown list using XML data
Here is the PHP Script to generate the dropdown list

<?Php
$obj_xml = new SimpleXMLElement('file-xml-demo.xml', NULL, TRUE);
// Total number of elements present ///
//$total = $obj_xml->count(); // total number of elements for PHP 5.3 and above
$total =count($obj_xml->children());  // for < php 5.3 version

$str="<select name='student'>";
for($i=0; $i<$total; $i++) { 
$str= $str . "<option value=".$obj_xml->details[$i]->id.">".$obj_xml->details[$i]->name. "</option>";
}
$str = $str. "</select>";
echo $str;
?>

XML XML Output from database records

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

Schalk	09-11-2018
Ahhhhh, Yes. Thank you.This was exactly what I have been searching for. Thank you soooo much!

Dropdown list box using data from XML file

Subhendu Mohapatra