<?php $con = mysqli_connect("localhost", "root", "", "mchannel_learningtool"); $sqlQury=mysqli_query($con,"SELECT Course_id,Course_name,course_type FROM course_master WHERE Is_active=1"); $xml = new DOMDocument('1.0', 'UTF-8'); $xml -> preserveWhiteSpace = FALSE; $courseList = $xml -> creatEelement("CourseList"); $xml -> appendChild($courseList); while($row=mysqli_fetch_array($sqlQury)) { $value=$row['Course_id']; $CoursesRoot=$xml->documentElement; $courses=$CoursesRoot->getElementsByTagName("Course"); echo "<br>".$courses->length."Fetching from array ....<br>"; if($courses->item(0)) { $DesireCoursefound=false; foreach($courses as $SingleCourse) { echo "<br>if item -1"; if($SingleCourse->getElementsByTagName("Course_id")->item(0)->nodeValue==$value) { $DesireCoursefound=true; } if(!$DesireCoursefound) { //echo "<br>if item -2"; $Course=$xml->createElement("Course"); $name=$xml->createElement("Course_name"); $id=$xml->createElement("Course_id"); $Type=$xml->createElement("Course_type"); $id->nodeValue=$row['Course_id']; $name->nodeValue=$row['Course_name']; $Type->nodeValue=$row['course_type']; $Course->appendChild($id); $Course->appendChild($name); $Course->appendChild($Type); $courseList->appendChild($Course); } } } if(!$courses->item(0)) { echo "<br>if no item"; $Course=$xml->createElement("Course"); $name=$xml->createElement("Course_name"); $id=$xml->createElement("Course_id"); $Type=$xml->createElement("Course_type"); $id->nodeValue=$row['Course_id']; $name->nodeValue=$row['Course_name']; $Type->nodeValue=$row['course_type']; $Course->appendChild($id); $Course->appendChild($name); $Course->appendChild($Type); $courseList->appendChild($Course); } } echo $xml->savexML(); $xml -> save("CourseList.xml"); ?>
<courselist> <course> <course_id>1</course_id> <course_name>physics</course_name> <course_type>1</course_type> </course> <course> <course_id>2</course_id> <course_name>chemistry</course_name> <course_type>2</course_type> </course> </courselist>
<course>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)