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