Love Blomberg

Ovningar

Ovningar sorterade per kurs och kategori

Listan uppdateras automatiskt genom att PHP laser mapparna i excersises. Klicka pa "Visa kallkod" for att oppna en saker kodvisare for larare.

Ovningslista

Webbserverprogrammering

databas

  • createtable.php

    Webbserverprogrammering/databas/createtable.php

    689 B 2026-03-27 08:33 Visa kallkod
  • dbconnection.php

    Webbserverprogrammering/databas/dbconnection.php

    885 B 2026-03-27 08:33 Visa kallkod
  • deletepost.php

    Webbserverprogrammering/databas/deletepost.php

    1,68 KB 2026-03-27 08:33 Visa kallkod
  • deletetable.php

    Webbserverprogrammering/databas/deletetable.php

    522 B 2026-03-27 08:33 Visa kallkod
  • insertdefaultposts.php

    Webbserverprogrammering/databas/insertdefaultposts.php

    1,26 KB 2026-03-27 08:33 Visa kallkod
  • insertpost.php

    Webbserverprogrammering/databas/insertpost.php

    1,64 KB 2026-03-27 08:33 Visa kallkod
  • createtable.php

    Webbserverprogrammering/databas/ovn_db1/createtable.php

    877 B 2026-03-27 08:33 Visa kallkod
  • deletepost.php

    Webbserverprogrammering/databas/ovn_db1/deletepost.php

    2,12 KB 2026-03-27 08:33 Visa kallkod
  • index.html

    Webbserverprogrammering/databas/ovn_db1/index.html

    787 B 2026-03-27 08:33 Visa kallkod
  • insertpost.php

    Webbserverprogrammering/databas/ovn_db1/insertpost.php

    1,99 KB 2026-03-27 08:33 Visa kallkod
  • selectposts.php

    Webbserverprogrammering/databas/ovn_db1/selectposts.php

    1,81 KB 2026-03-27 08:33 Visa kallkod
  • showtable.php

    Webbserverprogrammering/databas/ovn_db1/showtable.php

    1,32 KB 2026-03-27 08:33 Visa kallkod
  • updatepost.php

    Webbserverprogrammering/databas/ovn_db1/updatepost.php

    4,72 KB 2026-03-27 08:33 Visa kallkod
  • admin.php

    Webbserverprogrammering/databas/ovn_db2/admin.php

    206 B 2026-03-27 08:33 Visa kallkod
  • adduser.php

    Webbserverprogrammering/databas/ovn_db2/admin/adduser.php

    2,47 KB 2026-03-27 08:33 Visa kallkod
  • createtable.php

    Webbserverprogrammering/databas/ovn_db2/admin/createtable.php

    1,08 KB 2026-03-27 08:33 Visa kallkod
  • deleteuser.php

    Webbserverprogrammering/databas/ovn_db2/admin/deleteuser.php

    2,05 KB 2026-03-27 08:33 Visa kallkod
  • edituser.php

    Webbserverprogrammering/databas/ovn_db2/admin/edituser.php

    5,25 KB 2026-03-27 08:33 Visa kallkod
  • home.php

    Webbserverprogrammering/databas/ovn_db2/home.php

    939 B 2026-03-27 08:33 Visa kallkod
  • login.php

    Webbserverprogrammering/databas/ovn_db2/login.php

    2,11 KB 2026-03-27 08:33 Visa kallkod
  • logout.php

    Webbserverprogrammering/databas/ovn_db2/logout.php

    106 B 2026-03-27 08:33 Visa kallkod
  • selectposts.php

    Webbserverprogrammering/databas/selectposts.php

    1,63 KB 2026-03-27 08:33 Visa kallkod
  • updatepost.php

    Webbserverprogrammering/databas/updatepost.php

    4,08 KB 2026-03-27 08:33 Visa kallkod

funktioner

  • ovn_funk1.php

    Webbserverprogrammering/funktioner/ovn_funk1.php

    268 B 2026-03-27 08:33 Visa kallkod
  • ovn_funk2.php

    Webbserverprogrammering/funktioner/ovn_funk2.php

    351 B 2026-03-27 08:33 Visa kallkod
  • ovn_funk3.php

    Webbserverprogrammering/funktioner/ovn_funk3.php

    402 B 2026-03-27 08:33 Visa kallkod
  • ovn_funk4.php

    Webbserverprogrammering/funktioner/ovn_funk4.php

    661 B 2026-03-27 08:33 Visa kallkod
  • ovn_funk5.php

    Webbserverprogrammering/funktioner/ovn_funk5.php

    661 B 2026-03-27 08:33 Visa kallkod

grunder

  • ovn_gr1.php

    Webbserverprogrammering/grunder/ovn_gr1.php

    296 B 2026-03-27 08:33 Visa kallkod
  • ovn_gr2.php

    Webbserverprogrammering/grunder/ovn_gr2.php

    461 B 2026-03-27 08:33 Visa kallkod
  • ovn_gr3.php

    Webbserverprogrammering/grunder/ovn_gr3.php

    409 B 2026-03-27 08:33 Visa kallkod
  • ovn_gr4.php

    Webbserverprogrammering/grunder/ovn_gr4.php

    339 B 2026-03-27 08:33 Visa kallkod
  • ovn_gr5.php

    Webbserverprogrammering/grunder/ovn_gr5.php

    406 B 2026-03-27 08:33 Visa kallkod
  • ovn_gr6.php

    Webbserverprogrammering/grunder/ovn_gr6.php

    599 B 2026-03-27 08:33 Visa kallkod
  • ovn_gr7.php

    Webbserverprogrammering/grunder/ovn_gr7.php

    607 B 2026-03-27 08:33 Visa kallkod

inlamningar

  • formular.php

    Webbserverprogrammering/inlamningar/formular.php

    7,08 KB 2026-03-27 08:33 Visa kallkod

klasser

  • ovn_klass1.php

    Webbserverprogrammering/klasser/ovn_klass1.php

    831 B 2026-03-27 08:33 Visa kallkod
  • ovn_klass2.php

    Webbserverprogrammering/klasser/ovn_klass2.php

    737 B 2026-03-27 08:33 Visa kallkod
  • ovn_klass3.php

    Webbserverprogrammering/klasser/ovn_klass3.php

    1,12 KB 2026-03-27 08:33 Visa kallkod

Kodvisare

Visar fil: Webbserverprogrammering/databas/ovn_db2/login.php

   1 | <?php
   2 | session_start();
   3 | $login_error = null;
   4 | 
   5 | if (isset($_SESSION['login_error'])) {
   6 |   $login_error = $_SESSION['login_error'];
   7 |   unset($_SESSION['login_error']);
   8 | }
   9 | 
  10 | function login($username, $password)
  11 | {
  12 |   include('../dbconnection.php');
  13 |   if (!$dbconn) {
  14 |     die("Connection failed: Can't connect to database.");
  15 |   }
  16 |   $sql = "SELECT * FROM users WHERE username = :username AND password = :password";
  17 |   $stmt = $dbconn->prepare($sql);
  18 |   $stmt->bindParam(':username', $username);
  19 |   $stmt->bindParam(':password', $password);
  20 |   $stmt->execute();
  21 | 
  22 |   $res = $stmt->fetch(PDO::FETCH_ASSOC);
  23 |   if (!$res) {
  24 |     return false;
  25 |   } else {
  26 |     $_SESSION['is_admin'] = ($res['is_admin'] == 1) ? 1 : 0;
  27 |     $_SESSION['logged_in'] = 1;
  28 |     header("Location: home.php");
  29 |     exit();
  30 |   }
  31 | }
  32 | 
  33 | if (
  34 |   isset($_POST['username']) && isset($_POST['password']) &&
  35 |   !empty($_POST['username']) && !empty($_POST['password'])
  36 | ) {
  37 |   $username = $_POST['username'];
  38 |   $password = $_POST['password'];
  39 | 
  40 |   try {
  41 |     if (!login($username, $password)) {
  42 |       $_SESSION['login_error'] = "<p>INCORRECT DETAILS</p>";
  43 |       header("Location: login.php");
  44 |       exit();
  45 |     }
  46 |   } catch (PDOException $e) {
  47 |     $_SESSION['login_error'] = "<p>An error occurred. Please try again later.</p>";
  48 |     header("Location: login.php");
  49 |     exit();
  50 |   }
  51 | }
  52 | ?>
  53 | 
  54 | <!DOCTYPE html>
  55 | <html lang="en">
  56 | 
  57 | <head>
  58 |   <meta charset="UTF-8">
  59 |   <meta name="viewport" content="width=device-width, initial-scale=1.0">
  60 |   <title>Login</title>
  61 | </head>
  62 | 
  63 | <body>
  64 |   <h1>Welcome! Please enter your credentials.</h1>
  65 |   <form method="post" action="">
  66 |     <table>
  67 |       <tr>
  68 |         <td>Username:</td>
  69 |         <td><input type="text" name="username" size=20 maxlength=10>
  70 |         </td>
  71 |       </tr>
  72 |       <tr>
  73 |         <td>Password:</td>
  74 |         <td><input type="password" name="password" size=20 maxlength=100></td>
  75 |       </tr>
  76 |       <tr>
  77 |         <td><button type="submit">Login</button></td>
  78 |       </tr>
  79 |     </table>
  80 |   </form>
  81 | 
  82 |   <?php
  83 |   // Display the error message here if it exists
  84 |   if ($login_error) {
  85 |     echo $login_error;
  86 |   }
  87 |   ?>
  88 | 
  89 | </body>
  90 | 
  91 | </html>