Guest User

Untitled

a guest
Nov 5th, 2017
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.37 KB | None | 0 0
  1. $questions = simplexml_load_file("../XML/questions.xml");
  2.  
  3. $local = 0;
  4. if($local == 0){
  5. $server ="localhost";
  6. $user = "root";
  7. $pass = "";
  8. $db = "quiz";
  9. }
  10. $konektatu = mysqli_connect($server, $user, $pass, $db);
  11.  
  12. $sql = "INSERT INTO questions VALUES('','$_POST[posta]', '$_POST[galdera]', '$_POST[zuzena]', '$_POST[okerra1]','$_POST[okerra2]','$_POST[okerra3]', '$_POST[zailtasuna]', '$_POST[arloa]')";
  13.  
  14. $question = $questions->assessmentItem[0]->addChild('assessmentItem');
  15. $question->addChild('itemBody','Hau galdera izango zen');
  16. $question->addChild('correctResponse','Hemen erantzun zuzena');
  17. $question->addChild('incorrectResponses','Hemen erantzun okerra' . 'Hemen Bigarrena');
  18.  
  19. $execute=mysqli_query($konektatu,$sql);
  20. if(!$execute){
  21. echo"Ezin izan dira datuak txertatu. ".mysqli_error($konektatu);
  22. }else{
  23. echo"Datuak txertatu egin dira";
  24. echo"<a href=../HTML5/showQuestions.php> Ikusi Datuak </a><br>";
  25. echo'<a href=../PHP/showXMLQuestions.php>Ikusi Datuak (XML) </a>';
  26. }
  27. mysqli_close($konektatu);
  28.  
  29. <?xml version="1.0" encoding="UTF-8" ?>
  30. <assessmentItems>
  31.  
  32. <assessmentItem complexity="3" subject="mikologia">
  33.  
  34. <itemBody>
  35.  
  36. <p>Zein Amanita da jangarria?</p>
  37.  
  38. </itemBody>
  39.  
  40. <correctResponse>
  41.  
  42. <value>Caesarea</value>
  43.  
  44. </correctResponse>
  45.  
  46. <incorrectResponses>
  47.  
  48. <value>Phalloides</value>
  49.  
  50. <value>Muscaria</value>
  51.  
  52. <value>Virosa</value>
  53.  
  54. </incorrectResponses>
  55.  
  56. </assessmentItem>
  57.  
  58. <assessmentItem complexity="3" subject="mikologia">
  59.  
  60. <itemBody>
  61.  
  62. <p>Tripakiek zer dute kapela azpian?</p>
  63.  
  64. </itemBody>
  65.  
  66. <correctResponse>
  67.  
  68. <value>Eztenak</value>
  69.  
  70. </correctResponse>
  71.  
  72. <incorrectResponses>
  73.  
  74. <value>Filamenduak</value>
  75.  
  76. <value>Himenioa</value>
  77.  
  78. <value>Hodiak</value>
  79.  
  80. </incorrectResponses>
  81.  
  82. </assessmentItem>
  83.  
  84. <assessmentItem complexity="5" subject="mikologia">
  85.  
  86. <itemBody>
  87.  
  88. <p>Eranztuna du</p>
  89.  
  90. </itemBody>
  91.  
  92. <correctResponse>
  93.  
  94. <value>Galanpernak</value>
  95.  
  96. </correctResponse>
  97.  
  98. <incorrectResponses>
  99.  
  100. <value>Gibel urdinak</value>
  101.  
  102. <value>Esnegorriak</value>
  103.  
  104. <value>Errotariak</value>
  105.  
  106. </incorrectResponses>
  107.  
  108. </assessmentItem>
  109.  
  110. </assessmentItems>
Add Comment
Please, Sign In to add comment