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/updatepost.php

   1 | <!-- updatepost.php -->
   2 | <!doctype html>
   3 | <html>
   4 | <head>
   5 | <meta charset="utf-8">
   6 | <title>Update</title>
   7 | </head>
   8 | 
   9 | <body>
  10 |     <form action="index.html" method="get"><button type="submit">Tillbaka till meny</button></form>
  11 | <?php
  12 | include ('../dbconnection.php');
  13 | if (!$dbconn) {
  14 |   die("Connection failed: Can't connect to database.");
  15 | }
  16 | 
  17 | $message = null;
  18 | $getid = null;
  19 | $getfirstname = null;
  20 | $getlastname = null;
  21 | $getmobilenumber = null;
  22 | $getemail = null;
  23 | 
  24 | if (isset($_POST['firstname']) && isset($_POST['lastname']) && 
  25 |   isset($_POST['id']) && !empty($_POST['firstname']) && 
  26 |   !empty($_POST['lastname']) && !empty($_POST['id'])) {
  27 |       
  28 |     $id = $_POST['id'];
  29 |     $firstname = $_POST['firstname'];
  30 |     $lastname = $_POST['lastname'];
  31 |     $mobilenumber = isset($_POST['mobilenumber']) ? $_POST['mobilenumber'] : 0;
  32 |     $email = $_POST['email'];
  33 |     
  34 |     try {    
  35 |         # prepare
  36 |         $sql = "UPDATE kompisar SET firstname=?, lastname=?, mobilenumber=?, email=?
  37 |           WHERE id=?";
  38 |         $stmt = $dbconn->prepare($sql);
  39 |         # the data we want to insert
  40 |         $data = array($firstname, $lastname, $mobilenumber, $email, $id);
  41 |         # execute width array-parameter
  42 |         $stmt->execute($data);
  43 |             
  44 |         $message .= "<br />Record updated successfully.<br />";
  45 |         // clear form from info
  46 |         $_GET['id'] = null;
  47 |     }
  48 |     catch(PDOException $e)
  49 |         {
  50 |         $message .= $sql . "<br>" . $e->getMessage();
  51 |     }
  52 | } else {
  53 |     $message .= "<br />Först väljer du en post. 
  54 |       Sen måste du fylla i minst förnamn och efternamn!<br /><br />";
  55 | }
  56 | 
  57 | if (isset($_GET['id']) && !empty($_GET['id']) ) {
  58 |     $id = $_GET['id'];
  59 |     
  60 |     try {    
  61 |         # prepare
  62 |         $sql = "SELECT * FROM kompisar WHERE id=?";
  63 |         $stmt = $dbconn->prepare($sql);
  64 |         # the data we want to insert
  65 |         $data = array($id);
  66 |         # execute width array-parameter
  67 |         $stmt->execute($data);
  68 |             
  69 |         $res = $stmt->fetch(PDO::FETCH_ASSOC);
  70 |         $getid = htmlentities($res['id']);
  71 |         $getfirstname = htmlentities($res['firstname']);
  72 |         $getlastname = htmlentities($res['lastname']);
  73 |         $getmobilenumber = htmlentities($res['mobilenumber']);
  74 |         $getemail = htmlentities($res['email']);
  75 |         
  76 |         $message .= "<br />Record was selected successfully.<br />";
  77 |     }
  78 |     catch(PDOException $e)
  79 |         {
  80 |         $message .= $sql . "<br>" . $e->getMessage();
  81 |     }
  82 | } else {
  83 | 
  84 |     $message .= "<br />Välj en ny post att uppdatera.<br /><br />";
  85 | 
  86 | }
  87 | 
  88 | echo $message;
  89 | 
  90 |     ?>
  91 |         <form method="post" action=""> 
  92 |         <table> 
  93 |             <tr>
  94 |             <td>Förnamn*:</td>
  95 |             <td>
  96 |                 <input type="text" name="firstname" size="40" maxlength="40" 
  97 |                   value="<?= $getfirstname; ?>">
  98 |             </td>
  99 |             </tr> 
 100 |             <tr>
 101 |             <td>Efternamn*:</td>
 102 |             <td>
 103 |                 <input type="text" name="lastname" size="40" maxlength="40" 
 104 |                   value="<?= $getlastname; ?>">
 105 |             </td>
 106 |             </tr> 
 107 |             <tr>
 108 |             <td>Mobilnummer:</td>
 109 |             <td>
 110 |                 <input type="text" name="mobilenumber" size="20" maxlength="20" 
 111 |                   value="<?= $getmobilenumber; ?>">
 112 |             </td>
 113 |             <td>E-post:</td>
 114 |             <td>
 115 |                 <input type="text" name="email" size= "20" maxlength="20"
 116 |                 value="<?= $getemail; ?>">
 117 |             </td>
 118 |             </tr>
 119 |             <tr>
 120 |             <td>* = obligatoriskt</td>
 121 |             <td>
 122 |                 <button type="submit">Lägg till</button>
 123 |                 <input type="hidden" name="id" value="<?= $getid; ?>">
 124 |             </td>
 125 |             </tr> 
 126 |         </table> 
 127 |     </form>
 128 | <?php    
 129 |     // Ouput table with all posts
 130 |     /*** The SQL SELECT statement ***/
 131 |     $sql = "SELECT * FROM kompisar";
 132 |     $stmt = $dbconn->prepare($sql);
 133 |     // fetch width column names, create a table
 134 |     $data = array();  
 135 |     $stmt->execute($data);
 136 |     $output = "<table><caption>Kompisar i table:</caption>";
 137 |     while ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {
 138 |         $idx = htmlentities($res['id']);
 139 |         $first = htmlentities($res['firstname']);
 140 |         $last = htmlentities($res['lastname']);
 141 |         $mobilex = htmlentities($res['mobilenumber']);
 142 |         $email = htmlentities($res['email']);
 143 |         
 144 |         $output .= "<tr>".
 145 |             "<td><a href='?id=$idx'>$idx</a></td>".
 146 |             "<td>$first</td>".
 147 |             "<td>$last</td>".
 148 |             "<td>$mobilex</td>".
 149 |             "<td>$email</td>".
 150 |         "</tr>";
 151 |         
 152 |     }
 153 |     $output .= "</table>";
 154 |     echo "$output";
 155 | 
 156 |     $dbconn = null;
 157 | ?>
 158 | 
 159 | </body>
 160 | </html>