Guest User

Untitled

a guest
Nov 5th, 2017
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.83 KB | None | 0 0
  1. $xmlstr="../XML/questions.xml";
  2.  
  3. $local = 0;
  4. if($local == 0){
  5. $server ="localhost";
  6. $user = "root";
  7. $pass = "";
  8. $db = "quiz";
  9. }else{
  10. $server ="localhost";
  11. $user = "id3001514_t17";
  12. $pass = "12345";
  13. $db = "id3001514_quiz";
  14. }
  15. $konektatu = mysqli_connect($server, $user, $pass, $db);
  16.  
  17. $sql = "INSERT INTO questions VALUES('','$_POST[posta]', '$_POST[galdera]', '$_POST[zuzena]', '$_POST[okerra1]','$_POST[okerra2]','$_POST[okerra3]', '$_POST[zailtasuna]', '$_POST[arloa]')";
  18. if (file_exists($xmlstr)) {
  19. $questions = simplexml_load_file($xmlstr);
  20. $simpleXML = new SimpleXMLElement($questions->asXML());
  21. $question = $simpleXML->addChild('assessmentItem');
  22. $question->addChild('itemBody','Hau galdera izango zen');
  23. $correct=$question->addChild('correctResponse');
  24. $correct->addChild('value','Hemen erantzun zuzena');
  25. $incorrect=$question->addChild('incorrectResponse');
  26. $incorrect->addChild('value','Hemen erantzun okerra');
  27. $incorrect->addChild('value','Hemen Bigarrena');
  28. $simpleXML->asXML($xmlstr);
  29.  
  30. } else {
  31. echo "Error, no se pudo abrir el archivo XML, revise la ruta y si existe";
  32. }
  33. $execute=mysqli_query($konektatu,$sql);
  34. if(!$execute){
  35. echo"Ezin izan dira datuak txertatu. ".mysqli_error($konektatu);
  36. }else{
  37. echo"Datuak txertatu egin dira";
  38. echo"<a href=../HTML5/showQuestions.php> Ikusi Datuak </a><br>";
  39. echo'<a href=../PHP/showXMLQuestions.php>Ikusi Datuak (XML) </a>';
  40. }
  41. mysqli_close($konektatu);
  42.  
  43. <?xml version="1.0" encoding="UTF-8" ?>
  44. <assessmentItems>
  45.  
  46. <assessmentItem complexity="3" subject="mikologia">
  47.  
  48. <itemBody>
  49.  
  50. <p>Zein Amanita da jangarria?</p>
  51.  
  52. </itemBody>
  53.  
  54. <correctResponse>
  55.  
  56. <value>Caesarea</value>
  57.  
  58. </correctResponse>
  59.  
  60. <incorrectResponses>
  61.  
  62. <value>Phalloides</value>
  63.  
  64. <value>Muscaria</value>
  65.  
  66. <value>Virosa</value>
  67.  
  68. </incorrectResponses>
  69.  
  70. </assessmentItem>
  71.  
  72. <assessmentItem complexity="3" subject="mikologia">
  73.  
  74. <itemBody>
  75.  
  76. <p>Tripakiek zer dute kapela azpian?</p>
  77.  
  78. </itemBody>
  79.  
  80. <correctResponse>
  81.  
  82. <value>Eztenak</value>
  83.  
  84. </correctResponse>
  85.  
  86. <incorrectResponses>
  87.  
  88. <value>Filamenduak</value>
  89.  
  90. <value>Himenioa</value>
  91.  
  92. <value>Hodiak</value>
  93.  
  94. </incorrectResponses>
  95.  
  96. </assessmentItem>
  97.  
  98. <assessmentItem complexity="5" subject="mikologia">
  99.  
  100. <itemBody>
  101.  
  102. <p>Eranztuna du</p>
  103.  
  104. </itemBody>
  105.  
  106. <correctResponse>
  107.  
  108. <value>Galanpernak</value>
  109.  
  110. </correctResponse>
  111.  
  112. <incorrectResponses>
  113.  
  114. <value>Gibel urdinak</value>
  115.  
  116. <value>Esnegorriak</value>
  117.  
  118. <value>Errotariak</value>
  119.  
  120. </incorrectResponses>
  121.  
  122. </assessmentItem>
  123.  
  124. </assessmentItems>
  125.  
  126. <assessmentItems>
  127. ...
  128. <assessmentItem>
  129.  
  130. <itemBody>
  131. <p>Hau galdera izango zen</p>
  132. </itemBody>
  133.  
  134. <correctResponse>
  135. <value>Hemen erantzun zuzena</value>
  136. </correctResponse>
  137.  
  138. <incorrectResponses>
  139. <value>Hemen erantzun okerra</value>
  140. <value>Hemen Bigarrena</value>
  141. </incorrectResponses>
  142.  
  143. </assessmentItem>
  144. ...
  145. </assessmentItems>
  146.  
  147. $xmlstr='../XML/questions.xml';
  148.  
  149. if (file_exists($xmlstr)) {
  150.  
  151. $questions = simplexml_load_file($xmlstr);
  152. $simpleXML = new SimpleXMLElement($questions->asXML());
  153. $question = $simpleXML->addChild('assessmentItem');
  154. $question->addChild('itemBody','Hau galdera izango zen');
  155. $correct=$question->addChild('correctResponse');
  156. $correct->addChild('value','Hemen erantzun zuzena');
  157. $incorrect=$question->addChild('incorrectResponse');
  158. $incorrect->addChild('value','Hemen erantzun okerra');
  159. $incorrect->addChild('value','Hemen Bigarrena');
  160.  
  161. $simpleXML->asXML($xmlstr);
  162.  
  163. } else {
  164.  
  165. echo "Error, no se pudo abrir el archivo XML, revise la ruta y si existe";
  166.  
  167. }
  168.  
  169. $xmlstr='myxml.xml';
  170.  
  171. if (file_exists($xmlstr)) {
  172.  
  173. $questions = simplexml_load_file($xmlstr);
  174. $question = $questions->addChild('assessmentItem');
  175. $question->addChild('itemBody','Hau galdera izango zen');
  176. $correct=$question->addChild('correctResponse');
  177. $correct->addChild('value','Hemen erantzun zuzena');
  178. $incorrect=$question->addChild('incorrectResponse');
  179. $incorrect->addChild('value','Hemen erantzun okerra');
  180. $incorrect->addChild('value','Hemen Bigarrena');
  181. $questions->asXML($xmlstr);
  182.  
  183. } else {
  184.  
  185. echo "Error, no se pudo abrir el archivo XML, revise la ruta y si existe";
  186.  
  187. }
  188.  
  189. <assessmentItem>
  190.  
  191. <itemBody>Hau galdera izango zen</itemBody>
  192.  
  193. <correctResponse>
  194. <value>Hemen erantzun zuzena</value>
  195. </correctResponse>
  196.  
  197. <incorrectResponse>
  198. <value>Hemen erantzun okerra</value>
  199. <value>Hemen Bigarrena</value>
  200. </incorrectResponse>
  201.  
  202. </assessmentItem>
Add Comment
Please, Sign In to add comment