Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- session_start();
- $host = "localhost";
- $userName = "root";
- $password = "password";
- $db = "userdata";
- $connect = mysqli_connect($host,$userName,$password, $db);
- $sql = "SELECT title, body FROM news";
- $result = mysqli_query($connect,"$sql");
- $xml = new DomDocument("1.0", "UTF-8");
- $xml->load('xml.xml');
- $resRows = mysqli_num_rows($result);
- while($obj = $result->fetch_object())
- {
- $rootTag = $xml->getElementsByTagName("root")->item(0);
- $infoTag = $xml->createElement("News");
- if($xmlRows=count($infoTag)<$resRows)
- {
- $titleTag = $xml->createElement("Title", $obj->title);
- $bodyTag = $xml->createElement("Body", $obj->body);
- $infoTag->appendChild($titleTag);
- $infoTag->appendChild($bodyTag);
- $rootTag->appendChild($infoTag);
- $xml->save("xml.xml");
- }
- }
- $connect->close();
- ?>
- <?xml version="1.0"?>
- <root>
- <News>
- <Title/>
- <Body/>
- </News>
- <News>
- <Title>test1</Title>
- <Body>test2</Body>
- </News>
- <News>
- <Title>testing1</Title>
- <Body>testing2</Body>
- </News>
- <News>
- <Title>title3</Title>
- <Body>body3</Body>
- </News>
- <News>
- <Title>title4</Title>
- <Body>body4</Body>
- </News>
- <News>
- <Title/>
- <Body/>
- </News>
- <News>
- <Title>test1</Title>
- <Body>test2</Body>
- </News>
- <News>
- <Title>testing1</Title>
- <Body>testing2</Body>
- </News>
- <News>
- <Title>title3</Title>
- <Body>body3</Body>
- </News>
- <News>
- <Title>title4</Title>
- <Body>body4</Body>
- </News>
- </root>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement