Advertisement
Guest User

Untitled

a guest
Apr 6th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.78 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 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. $userId ='';
  44. if($sql->execute()){
  45. while($row = $sql->fetch(PDO::FETCH_ASSOC)){
  46. $userId = $row['id_user'];
  47. ?>
  48. <tr>
  49. <td><?=$row['surname']?></td>
  50. <td><?=$row['name']?></td>
  51. <td>
  52. <form action = "marks4.php" method = "get" id = "form1">
  53. <input type="float" name="points">
  54. </form>
  55. </td>
  56. </tr>
  57. <?php
  58. }?>
  59.  
  60. <?php
  61. }
  62. ?>
  63. <?php
  64. $points = $_GET['points'];
  65. $id_laboratory = $_GET['id_laboratory'];
  66. if($points){
  67. $ins = $dbh->prepare("INSERT INTO points(points, user,laboratory) VALUES (points='$points', user='$user', laboratory='$laboratory')");
  68. }?>
  69. <tr>
  70. <td></td>
  71. <td></td>
  72. <td> <button type = "submit" form = "form1" value = "Submit"> Zatwierdź </button></td>
  73. </tr>
  74. </table>
  75.  
  76. </body>
  77. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement