Advertisement
M0n5t3r

nogeens

Sep 9th, 2016
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.24 KB | None | 0 0
  1. if (isset($_POST['submit'])) {
  2. $studentnummer = $_SESSION['studentnummer'];
  3.  
  4. $cat11 = $_POST['katogorie1'];
  5. $cat22 = $_POST['katogorie2'];
  6. $cat33 = $_POST['katogorie3'];
  7. $cat44 = $_POST['katogorie4'];
  8. if($cat11 == '' & $cat22 == '' && $cat33 == '' && $cat44 == ''){
  9. echo "Vul voor elke catogorie een klas in!";
  10.  
  11. }else{
  12.  
  13. $db = new PDO('mysql:host=localhost;dbname=onething', 'root', '');
  14. $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  15.  
  16.  
  17. $katogorie1=$_POST['katogorie1'];
  18. $katogorie2=$_POST['katogorie2'];
  19. $katogorie3=$_POST['katogorie3'];
  20. $katogorie4=$_POST['katogorie4'];
  21.  
  22. $addvalue1 = "groepje" . $katogorie1;
  23. $addvalue2 = "groepje" . $katogorie2;
  24. $addvalue3 = "groepje" . $katogorie3;
  25. $addvalue4 = "groepje" . $katogorie4;
  26. echo "<br><br>";
  27.  
  28.  
  29. if($db === false){
  30. echo "Connection Error";
  31. }else{
  32.  
  33. }
  34. try {
  35. $update = "UPDATE cat1 SET stemmen = stemmen + 1 WHERE groepjes = '$addvalue1'";
  36. $update1 = "UPDATE cat2 SET stemmen = stemmen + 1 WHERE groepjes = '$addvalue2'";
  37. $update2 = "UPDATE cat3 SET stemmen = stemmen + 1 WHERE groepjes = '$addvalue3'";
  38. $update3 = "UPDATE cat4 SET stemmen = stemmen + 1 WHERE groepjes = '$addvalue4'";
  39. $update4 = "UPDATE studenten SET ingelogd = 1 WHERE studentennummer = '$studentnummer'";
  40.  
  41.  
  42.  
  43.  
  44.  
  45. }
  46. catch(PDOException $e)
  47. {
  48. echo $update . "<br>" . $e->getMessage();
  49. echo $update1 . "<br>" . $e->getMessage();
  50. echo $update2 . "<br>" . $e->getMessage();
  51. echo $update3 . "<br>" . $e->getMessage();
  52. echo $update4 . "<br>" . $e->getMessage();
  53. }
  54.  
  55. $db->exec($update);
  56. $db->exec($update1);
  57. $db->exec($update2);
  58. $db->exec($update3);
  59. $db->exec($update4);
  60.  
  61. echo "New record created successfully"; //-weghalen!
  62.  
  63. $select = "SELECT SUM(ingelogd) AS sum FROM studenten";
  64. $query = $db->query($select);
  65. $sum_row = $query->fetch(PDO::FETCH_ASSOC);
  66. $sum = $sum_row['sum'];
  67. echo "<br>";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement