Advertisement
Guest User

Untitled

a guest
Feb 3rd, 2016
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.60 KB | None | 0 0
  1. <?php
  2. session_start();
  3. $host = "localhost";
  4. $userName = "root";
  5. $password = "password";
  6. $db = "userdata";
  7.  
  8. $connect = mysqli_connect($host,$userName,$password, $db);
  9. $sql = "SELECT title, body FROM news";
  10. $result = mysqli_query($connect,"$sql");
  11.  
  12. $xml = new DomDocument("1.0", "UTF-8");
  13. $xml->load('xml.xml');
  14.  
  15. $resRows = mysqli_num_rows($result);
  16.  
  17. while($obj = $result->fetch_object())
  18. {
  19. $rootTag = $xml->getElementsByTagName("root")->item(0);
  20. $infoTag = $xml->createElement("News");
  21. if($xmlRows=count($infoTag)<$resRows)
  22. {
  23. $titleTag = $xml->createElement("Title", $obj->title);
  24. $bodyTag = $xml->createElement("Body", $obj->body);
  25. $infoTag->appendChild($titleTag);
  26. $infoTag->appendChild($bodyTag);
  27. $rootTag->appendChild($infoTag);
  28. $xml->save("xml.xml");
  29. }
  30. }
  31. $connect->close();
  32. ?>
  33.  
  34. <?xml version="1.0"?>
  35. <root>
  36. <News>
  37. <Title/>
  38. <Body/>
  39. </News>
  40. <News>
  41. <Title>test1</Title>
  42. <Body>test2</Body>
  43. </News>
  44. <News>
  45. <Title>testing1</Title>
  46. <Body>testing2</Body>
  47. </News>
  48. <News>
  49. <Title>title3</Title>
  50. <Body>body3</Body>
  51. </News>
  52. <News>
  53. <Title>title4</Title>
  54. <Body>body4</Body>
  55. </News>
  56. <News>
  57. <Title/>
  58. <Body/>
  59. </News>
  60. <News>
  61. <Title>test1</Title>
  62. <Body>test2</Body>
  63. </News>
  64. <News>
  65. <Title>testing1</Title>
  66. <Body>testing2</Body>
  67. </News>
  68. <News>
  69. <Title>title3</Title>
  70. <Body>body3</Body>
  71. </News>
  72. <News>
  73. <Title>title4</Title>
  74. <Body>body4</Body>
  75. </News>
  76. </root>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement