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_db1/deletepost.php

   1 | <!-- deletepost.php -->
   2 | <!doctype html>
   3 | <html>
   4 | 
   5 | <head>
   6 |     <meta charset="utf-8">
   7 |     <title>Delete</title>
   8 | </head>
   9 | 
  10 | <body>
  11 |     <form action="index.html" method="get"><button type="submit">Tillbaka till meny</button></form>
  12 |     <?php
  13 |     include('../dbconnection.php');
  14 |     if (!$dbconn) {
  15 |         die("Connection failed: Can't connect to database.");
  16 |     }
  17 |     $message = null;
  18 |     $id = null;
  19 | 
  20 |     if (isset($_POST['id']) && !empty($_POST['id'])) {
  21 |         $id = $_POST['id'];
  22 | 
  23 |         try {
  24 |             # prepare
  25 |             $sql = "DELETE FROM kompisar WHERE id=?";
  26 |             $stmt = $dbconn->prepare($sql);
  27 |             # the data we want to insert
  28 |             $data = array($id);
  29 |             # execute width array-parameter
  30 |             $stmt->execute($data);
  31 | 
  32 |             $message .= "<br />Record deleted successfully.<br />";
  33 |         } catch (PDOException $e) {
  34 |             $message .= $sql . "<br>" . $e->getMessage();
  35 |         }
  36 |     } else {
  37 |         $message .= "<br />";
  38 |     }
  39 | 
  40 |     echo $message;
  41 | 
  42 |     
  43 | // Ouput table with all posts
  44 |     /*** The SQL SELECT statement ***/
  45 |     $sql = "SELECT * FROM kompisar";
  46 |     $stmt = $dbconn->prepare($sql);
  47 |     // fetch width column names, create a table
  48 |     $data = array();
  49 |     $stmt->execute($data);
  50 |     $output = "<table><caption>Kompisar i table:</caption>";
  51 |     while ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {
  52 |         $idx = htmlentities($res['id']);
  53 |         $first = htmlentities($res['firstname']);
  54 |         $last = htmlentities($res['lastname']);
  55 |         $mobilex = htmlentities($res['mobilenumber']);
  56 |         $email = htmlentities($res['email']);
  57 | 
  58 |         $output .= "<tr>" .
  59 |             "<td>$idx</td>" .
  60 |             "<td>$first</td>" .
  61 |             "<td>$last</td>" .
  62 |             "<td>$mobilex</td>" .
  63 |             "<td>$email</td>" .
  64 |             "<td><form method='post' action=''>" .
  65 |             "<input type='hidden' name='id' value='$idx'>" .
  66 |             "<button type='submit'>Ta bort</button></form></td>" .
  67 |             "</tr>";
  68 |     }
  69 |     $output .= "</table>";
  70 |     echo "$output";
  71 | 
  72 |     $dbconn = null;
  73 |     ?>
  74 | 
  75 | </body>
  76 | 
  77 | </html>