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

   1 | <!doctype html>
   2 | <html>
   3 | 
   4 | <head>
   5 |     <meta charset="utf-8">
   6 |     <title>Edit 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 |     include('../../dbconnection.php');
  17 |     if (!$dbconn) {
  18 |         die("Connection failed: Can't connect to database.");
  19 |     }
  20 | 
  21 |     $message = null;
  22 |     $getid = null;
  23 |     $getusername = null;
  24 |     $getpassword = null;
  25 |     $getfirstname = null;
  26 |     $getlastname = null;
  27 | 
  28 |     if (
  29 |         isset($_POST['username']) && isset($_POST['password']) &&
  30 |         isset($_POST['firstname']) && isset($_POST['lastname']) &&
  31 |         isset($_POST['id']) && !empty($_POST['username']) &&
  32 |         !empty($_POST['password']) && !empty($_POST['firstname']) &&
  33 |         !empty($_POST['lastname']) && !empty($_POST['id'])
  34 |     ) {
  35 | 
  36 |         $id = $_POST['id'];
  37 |         $username = $_POST['username'];
  38 |         $password = $_POST['password'];
  39 |         $firstname = $_POST['firstname'];
  40 |         $lastname = $_POST['lastname'];
  41 | 
  42 |         try {
  43 |             # prepare
  44 |             $sql = "UPDATE users SET username=?, password=?, firstname=?, lastname=? WHERE id=?";
  45 |             $stmt = $dbconn->prepare($sql);
  46 |             # the data we want to insert
  47 |             $data = array($username, $password, $firstname, $lastname, $id);
  48 |             # execute width array-parameter
  49 |             $stmt->execute($data);
  50 | 
  51 |             $message .= "<p>User updated successfully.</p>";
  52 |             // clear form from info
  53 |             $_GET['id'] = null;
  54 |         } catch (PDOException $e) {
  55 |             $message .= $sql . "<br>" . $e->getMessage();
  56 |         }
  57 |     }
  58 | 
  59 |     if (isset($_GET['id']) && !empty($_GET['id'])) {
  60 |         $id = $_GET['id'];
  61 | 
  62 |         try {
  63 |             # prepare
  64 |             $sql = "SELECT * FROM users WHERE id=?";
  65 |             $stmt = $dbconn->prepare($sql);
  66 |             # the data we want to insert
  67 |             $data = array($id);
  68 |             # execute width array-parameter
  69 |             $stmt->execute($data);
  70 | 
  71 |             $res = $stmt->fetch(PDO::FETCH_ASSOC);
  72 |             $getid = htmlentities($res['id']);
  73 |             $getusername = htmlentities($res['username']);
  74 |             $getpassword = htmlentities($res['password']);
  75 |             $getfirstname = htmlentities($res['firstname']);
  76 |             $getlastname = htmlentities($res['lastname']);
  77 | 
  78 |             $message .= "<p>User was selected successfully.</p>";
  79 |         } catch (PDOException $e) {
  80 |             $message .= $sql . "<br>" . $e->getMessage();
  81 |         }
  82 |     }
  83 | 
  84 |     echo $message;
  85 | 
  86 |     ?>
  87 |     <form method="post" action="">
  88 |         <h2>Edit User Details</h2>
  89 |         <table>
  90 |             <tr>
  91 |                 <td>Username*:</td>
  92 |                 <td>
  93 |                     <input type="text" name="username" size="40" maxlength="40"
  94 |                         value="<?= $getusername; ?>">
  95 |                 </td>
  96 |             </tr>
  97 |             <tr>
  98 |                 <td>Password*:</td>
  99 |                 <td>
 100 |                     <input type="text" name="password" size="40" maxlength="40"
 101 |                         value="<?= $getpassword; ?>">
 102 |                 </td>
 103 |             </tr>
 104 |             <tr>
 105 |                 <td>Firstname*:</td>
 106 |                 <td>
 107 |                     <input type="text" name="firstname" size="40" maxlength="30"
 108 |                         value="<?= $getfirstname; ?>">
 109 |                 </td>
 110 |             </tr>
 111 |             <tr>
 112 |                 <td>Lastname*:</td>
 113 |                 <td>
 114 |                     <input type="text" name="lastname" size="40" maxlength="30"
 115 |                         value="<?= $getlastname; ?>">
 116 |                 </td>
 117 |             </tr>
 118 |             <tr>
 119 |                 <td>
 120 |                     <p>* = Required</p>
 121 |                 </td>
 122 |                 <td>
 123 |                     <button type="submit">Submit</button>
 124 |                     <input type="hidden" name="id" value="<?= $getid; ?>">
 125 |                 </td>
 126 |             </tr>
 127 |         </table>
 128 |     </form>
 129 |     <?php    
 130 |     // Ouput table with all posts
 131 |     /*** The SQL SELECT statement ***/
 132 |     $sql = "SELECT * FROM users";
 133 |     $stmt = $dbconn->prepare($sql);
 134 |     // fetch width column names, create a table
 135 |     $data = array();
 136 |     $stmt->execute($data);
 137 |     $output = '<table><caption>Choose a user to edit</caption>';
 138 |     $output .= '<tr><th>ID</th><th>Username</th><th>Password</th><th>Firstname</th><th>Lastname</th><th>Last Modified</th></tr>';
 139 |     while ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {
 140 |         $idx = htmlentities($res['id']);
 141 |         $user = htmlentities($res['username']);
 142 |         $pass = htmlentities($res['password']);
 143 |         $first = htmlentities($res['firstname']);
 144 |         $last = htmlentities($res['lastname']);
 145 |         $date = htmlentities($res['last_modified']);
 146 | 
 147 |         $output .= "<tr>" .
 148 |             "<td><a href='?id=$idx'>$idx</a></td>" .
 149 |             "<td>$user</td>" .
 150 |             "<td>$pass</td>" .
 151 |             "<td>$first</td>" .
 152 |             "<td>$last</td>" .
 153 |             "<td>$date</td>" .
 154 |             "</tr>";
 155 |     }
 156 |     $output .= "</table>";
 157 |     echo "$output";
 158 | 
 159 |     $dbconn = null;
 160 |     ?>
 161 | 
 162 | </body>
 163 | 
 164 | </html>