xml在php中无法正常创建 [英] xml is not creating properly in php

问题描述

我有一个PHP脚本....

i have a php script ....

<?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");
	
	
?>

我想创建一个xml结构，如...

and i want to create a xml structure like ...

<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>

但是在这个xml中有些< course> 节点正在重复..



i无法找出问题是什么...？

but in this xml some <course> node is repeating ..

i am unable to find out whats the problem ... ?

推荐答案

con = mysqli_connect（ localhost， root， ， mchannel_learningtool）;

con = mysqli_connect("localhost", "root", "", "mchannel_learningtool");

sqlQury = mysqli_query（

sqlQury=mysqli_query(

con， SELECT Course_id，Course_name，course_type FROM course_master WHERE Is_active = 1）;

con,"SELECT Course_id,Course_name,course_type FROM course_master WHERE Is_active=1");

这篇关于xml在php中无法正常创建的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！