Advertisement
Guest User

Untitled

a guest
Apr 19th, 2017
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.99 KB | None | 0 0
  1. <?php
  2. $host = '127.0.0.1';
  3. $db = 'pks';
  4. $user = 'root';
  5. $password = '';
  6. $charset = 'utf8';
  7. $dsn = "mysql:host=$host;dbname=$db;charset=$charset";
  8. $opt = [
  9. PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
  10. PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
  11. PDO::ATTR_EMULATE_PREPARES => false,
  12. ];
  13. $dbh = new PDO($dsn, $user, $password, $opt);
  14. $sql = $dbh->prepare("SELECT id_user, surname, name, id_user FROM user");
  15. $result = array();
  16. /*while($row = $sql->fetch(PDO::FETCH_ASSOC)){
  17. var_dump($row);
  18. $row['surname'];
  19. $row['name'];
  20. }*/
  21.  
  22. ?>
  23.  
  24. <html>
  25. <head>
  26. <link rel="stylesheet" href="style.css" type="text/css"/>
  27. </head>
  28. <body>
  29. <table style="border:2px solid black">
  30. <tr>
  31. <td> <p> Oceny </p> </td>
  32. </tr>
  33. <tr>
  34. <td> Nazwa laboratorium </td>
  35. <td> Maksymalne punkty</td>
  36. </tr>
  37. <tr>
  38. <td> Nazwisko </td>
  39. <td> Imię </td>
  40. <td> Punkty </td>
  41. </tr>
  42. <?php
  43. $id_laboratory = $_GET['id_laboratory'] ;
  44. $userId ='';
  45. $points = '';
  46. $user = $userId;
  47. if($sql->execute()){
  48. while($row = $sql->fetch(PDO::FETCH_ASSOC)){
  49. $userId = $row['id_user'];
  50. ?>
  51. <tr>
  52. <td><?=$row['surname']?></td>
  53. <td><?=$row['name']?></td>
  54. <form action ="marks5.php?id_laboratory=2" method="post" id="form1">
  55. <td>
  56. <input type="number" name="points" value = "<?=$points ? $points :'' ?>"/>
  57. </td>
  58. <td><input type="submit" name="submit" value="Send"></td>
  59. </form>
  60. </tr>
  61. <?php
  62. }?>
  63.  
  64. <?php
  65. }
  66. ?>
  67. <?php
  68.  
  69. $ins = $dbh->prepare("INSERT INTO points( `user`,laboratory, points) VALUES (:usr, :laboratory, :points)");
  70. $ins->bindParam(':usr', $user);
  71. $ins->bindParam(':laboratory',$id_laboratory);
  72. $ins->bindParam(':points', $points);
  73.  
  74. if( isset($_POST['submit'])){
  75. $ins->execute();
  76. }
  77. var_dump($user);
  78. var_dump($points);
  79.  
  80. ?>
  81. </table>
  82.  
  83. </body>
  84. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement