Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html>
- <head>
- <title>MovieXplain</title>
- <meta charset="UTF-8">
- <link rel="stylesheet" href="stil.css">
- </head>
- <body>
- <ul>
- <li><a href="login.php">Logg inn</a></li>
- <li><a href="register.php">Registrer deg</a></li>
- </ul>
- <?php
- $server = 'localhost';
- $username = 'root';
- $password = '';
- $database = 'filmdatabase';
- $link = new mysqli($server, $username, $password, $database);
- $link->set_charset("utf8");
- $sql = "SELECT * FROM `filmer`";
- $result = $link->query($sql);
- ?>
- <table>
- <tr>
- <th>Tittel</th>
- <th>Sjanger</th>
- <th>Regissør</th>
- <th>Link</th>
- <th>Plakat</th>
- <th>Oscar</th>
- <th>Sum av stemmer</th>
- <th>Antall stemmer</th>
- <th>Stem</th>
- </tr>
- <?php
- while ($rad = $result->fetch_assoc())
- {
- $filmID = $rad['filmID'];
- $filmNavn = $rad['tittel'];
- $sjanger = $rad['Sjanger'];
- $regissør = $rad['Regissør'];
- $filmLink = $rad['link'];
- $plakat = $rad['plakat'];
- $oscar = $rad['oscar'];
- $sum_stemmer = $rad['sum av stemmer'];
- $antall_stemmer = $rad['antall stemmer']
- ?>
- <tr>
- <td><?=$filmNavn?></td>
- <td><?=$sjanger?></td>
- <td><?=$regissør?></td>
- <td><a href="<?=$filmLink?>" target="_blank">Link</a></td>
- <td><img src="Bilder/<?=$plakat?>" alt="<?=$filmNavn?> plakat" style="width:150px; height:250px;"></td>
- <td><?=$sum_stemmer?></td>
- <td><?=$antall_stemmer?></td>
- <td>
- <form action="xylune2.php" method="POST">
- <input type="radio" name="points" value="1"> 1 <br>
- <input type="radio" name="points" value="2"> 2 <br>
- <input type="radio" name="points" value="3"> 3 <br>
- <input type="radio" name="points" value="4"> 4 <br>
- <input type="radio" name="points" value="5"> 5 <br>
- <input type="radio" name="points" value="6"> 6 <br>
- <input type="radio" name="points" value="7"> 7 <br>
- <input type="radio" name="points" value="8"> 8 <br>
- <input type="radio" name="points" value="9"> 9 <br>
- <input type="radio" name="points" value="10"> 10 <br>
- <input type="hidden" name="id" value="<?=$filmID?>">
- <input type="submit" name="submit" value="Submit">
- </form>
- </td>
- </tr>
- <?php
- if (isset($_POST['submit'])){
- $rating = $_POST['points'];
- $id = $_POST['id'];
- $sum_stemmer = $sum_stemmer + $rating;
- if ($id == $filmID)
- {
- $sql = "UPDATE `filmer` SET `sum av stemmer` = '$sum_stemmer' WHERE `filmID` = '$id'";
- $link->query($sql);
- header("Refresh:0");
- }
- }
- }
- ?>
- </table>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement