Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host = '127.0.0.1';
- $db = 'pks';
- $user = 'root';
- $password = '';
- $charset = 'utf8';
- $dsn = "mysql:host=$host;dbname=$db;charset=$charset";
- $opt = [
- PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
- PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
- PDO::ATTR_EMULATE_PREPARES => false,
- ];
- $dbh = new PDO($dsn, $user, $password, $opt);
- $sql = $dbh->prepare("SELECT surname, name, id_user FROM user");
- $result = array();
- /*while($row = $sql->fetch(PDO::FETCH_ASSOC)){
- var_dump($row);
- $row['surname'];
- $row['name'];
- }*/
- ?>
- <html>
- <head>
- <link rel="stylesheet" href="style.css" type="text/css"/>
- </head>
- <body>
- <table style="border:2px solid black">
- <tr>
- <td> <p> Oceny </p> </td>
- </tr>
- <tr>
- <td> Nazwa laboratorium </td>
- <td> Maksymalne punkty</td>
- </tr>
- <tr>
- <td> Nazwisko </td>
- <td> Imię </td>
- <td> Punkty </td>
- </tr>
- <?php
- $userId ='';
- if($sql->execute()){
- while($row = $sql->fetch(PDO::FETCH_ASSOC)){
- $userId = $row['id_user'];
- ?>
- <tr>
- <td><?=$row['surname']?></td>
- <td><?=$row['name']?></td>
- <td>
- <form action = "marks4.php" method = "get" id = "form1">
- <input type="float" name="points">
- </form>
- </td>
- </tr>
- <?php
- }?>
- <?php
- }
- ?>
- <?php
- $points = $_GET['points'];
- $id_laboratory = $_GET['id_laboratory'];
- if($points){
- $ins = $dbh->prepare("INSERT INTO points(points, user,laboratory) VALUES (points='$points', user='$user', laboratory='$laboratory')");
- }?>
- <tr>
- <td></td>
- <td></td>
- <td> <button type = "submit" form = "form1" value = "Submit"> Zatwierdź </button></td>
- </tr>
- </table>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement