Webbserv1: Källkod
Webbserverprogrammering 1

Show sourcecode

The following files exists in this folder. Click to view.

webbsrvprg/exercises/databas/

admin.php
createtable.php
deletepost.php
deletetable.php
insertdefaultposts.php
insertpost.php
ovn_sqlintro1.php
ovn_sqlintro1_delete.php
ovn_sqlintro1_insert.php
ovn_sqlintro1_skapa.php
ovn_sqlintro1_skrivut.php
ovn_sqlintro1_update.php
ovn_sqlintro2.php
ovn_sqlintro2_delete.php
ovn_sqlintro2_insert.php
ovn_sqlintro2_login.php
ovn_sqlintro2_skapa.php
ovn_sqlintro2_skrivut.php
ovn_sqlintro2_update.php
ovn_sqlintro3.php
ovn_sqlintro3_default.php
ovn_sqlintro3_insert.php
ovn_sqlintro3_skapa.php
ovn_sqlintro3_skrivut.php
selectposts.php
updatepost.php
welcome.php

ovn_sqlintro3_insert.php

78 lines UTF-8 Windows (CRLF)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
<!doctype html>
<html>

<body>
<?php
include ('../../dbconnection.php');
$message = null;
  if (isset($_POST['regnr']) && isset($_POST['color']) && 
  !empty($_POST['regnr']) && !empty($_POST['color'])) {
    $regnr = $_POST['regnr'];
    $color = $_POST['color'];
    $garage = $_POST['garage'];
    $owner = $_POST['owner'];
    
    try {    
        $sql = "INSERT INTO car (regnr, color, garage, owner) 
          VALUES (?, ?, ?, ?)";
        $stmt = $dbconn->prepare($sql);
        $data = array($regnr, $color, $garage, $owner);
        $stmt->execute($data);
            
        echo "New record created successfully";
        $lastId = $dbconn->lastInsertId();
    }
    catch(PDOException $e)  {
        echo $sql . "<br>" . $e->getMessage();
    }
    
    $dbconn = null;
  } else {
    $message .= "<br />Du måste fylla i fälten!<br /><br />";
  }
echo $message;
?>
<form method="post" action=""> 

  Regnummer: 
  <input type="text" name="regnr" size=40 maxlength=100><br>

  Färg: 
  <input type="text" name="color" size=40 maxlength=100><br>

  Garage:
  <select name="garage">
    <?php
      $sql = "SELECT * FROM garage";
      $stmt = $dbconn->prepare($sql);

      $stmt->execute();

      while ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {
        ?>
        <option value="<?php echo htmlentities($res['garageid']);?>"><?php echo htmlentities($res['name']);?></option>
        <?php
      }
      ?>
  </select>

  Ägare:
  <select name="owner">
    <?php
      $sql = "SELECT * FROM owner";
      $stmt = $dbconn->prepare($sql);

      $stmt->execute();

      while ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {
        ?>
        <option value="<?php echo htmlentities($res['ownerid']);?>"><?php echo htmlentities($res['name']);?></option>
        <?php
      }
    ?>
  </select>

  <button type="submit">Lägg till</button>
</form>
</body>
</html>