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/admin/adduser.php

   1 | <!doctype html>
   2 | <html>
   3 | 
   4 | <head>
   5 |   <meta charset="utf-8">
   6 |   <title>Create User</title>
   7 | </head>
   8 | 
   9 | <body>
  10 |   <form action="../home.php" method="get"><button type="submit">Back to home</button></form>
  11 |   <?php
  12 |   session_start();
  13 |   if (!isset($_SESSION['is_admin']) || $_SESSION['is_admin'] != 1) {
  14 |     die("Access denied.");
  15 |   }
  16 |   $message = null;
  17 |   if (
  18 |     isset($_POST['username']) && isset($_POST['password']) &&
  19 |     isset($_POST['firstname']) && isset($_POST['lastname']) &&
  20 |     !empty($_POST['username']) && !empty($_POST['password']) &&
  21 |     !empty($_POST['firstname']) && !empty($_POST['lastname'])
  22 |   ) {
  23 |     $username = $_POST['username'];
  24 |     $password = $_POST['password'];
  25 |     $firstname = $_POST['firstname'];
  26 |     $lastname = $_POST['lastname'];
  27 |     $is_admin = isset($_POST['is_admin']) ? 1 : 0;
  28 | 
  29 |     include('../../dbconnection.php');
  30 |     if (!$dbconn) {
  31 |       die("Connection failed: Can't connect to database.");
  32 |     }
  33 |     try {
  34 |       # prepare
  35 |       $sql = "INSERT INTO users (username, password, is_admin, firstname, lastname) 
  36 |           VALUES (?, ?, ?, ?, ?)";
  37 |       $stmt = $dbconn->prepare($sql);
  38 |       # the data we want to insert
  39 |       $data = array($username, $password, $is_admin, $firstname, $lastname);
  40 |       # execute width array-parameter
  41 |       $stmt->execute($data);
  42 | 
  43 |       echo "New record created successfully";
  44 |       $lastId = $dbconn->lastInsertId();
  45 |       echo "Last post ID: $lastId";
  46 |     } catch (PDOException $e) {
  47 |       echo $sql . "<br>" . $e->getMessage();
  48 |     }
  49 | 
  50 |     $dbconn = null;
  51 |   } else {
  52 |     $message .= "<p>Please fill in all required fields to add a user.</p>";
  53 |   }
  54 |   echo $message;
  55 |   ?>
  56 |   <form method="post" action="">
  57 |     <table>
  58 |       <tr>
  59 |         <td>Username*:</td>
  60 |         <td><input type="text" name="username" size=20 maxlength=10>
  61 |         </td>
  62 |       </tr>
  63 |       <tr>
  64 |         <td>Password*:</td>
  65 |         <td><input type="password" name="password" size=20 maxlength=100></td>
  66 |       </tr>
  67 |       <tr>
  68 |         <td>Firstname*:</td>
  69 |         <td><input type="text" name="firstname" size=20 maxlength=30></td>
  70 |       </tr>
  71 |       <tr>
  72 |         <td>Lastname*:</td>
  73 |         <td><input type="text" name="lastname" size=20 maxlength=30></td>
  74 |       </tr>
  75 |       <tr>
  76 |         <td>Admin</td>
  77 |         <td><input type="checkbox" name="is_admin"></td>
  78 |       </tr>
  79 | 
  80 |       <tr>
  81 |         <td>* = Required</td>
  82 |         <td><button type="submit">Add user</button></td>
  83 |       </tr>
  84 |     </table>
  85 |   </form>
  86 | </body>
  87 | 
  88 | </html>