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_sqlintro1_skrivut.php`

56 lines ASCII 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


<!doctype html>

<html>



<body>

<?php

  include ('../../dbconnection.php');

  try {



    $sql = "SELECT * FROM kompisar";

    $stmt = $dbconn->prepare($sql);

 

    $data = array();  

    $stmt->execute($data);

 

    $res = $stmt->fetchAll();

    $output = htmlentities(print_r($res, 1));

    echo "<pre>$output</pre>";



    $data = array();  

    $stmt->execute($data);

    $res = $stmt->fetch(PDO::FETCH_ASSOC);

    $output = htmlentities(print_r($res, 1));

    echo "<pre>$output</pre>";



    $data = array();  

    $stmt->execute($data);

    $res = $stmt->fetch(PDO::FETCH_NUM);

    $output = htmlentities(print_r($res, 1));

    echo "<pre>$output</pre>";



    $data = array();  

    $stmt->execute($data);

    $output = "<table><caption>Kompisar</caption>";

    while ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {

        $output .= "<tr>".

            "<td>".htmlentities($res['id'])."</td>".

            "<td>".htmlentities($res['firstname'])."</td>".

            "<td>".htmlentities($res['lastname'])."</td>".

            "<td>".htmlentities($res['phonenum'])."</td>".

            "<td>".htmlentities($res['epost'])."</td>".

        "</tr>";

    }



    $output .= "</table>";

    echo "$output";

  }



  catch(PDOException $e) {

    echo $sql . "<br />" . $e->getMessage();

  }



$dbconn = null;



?>

</body>

</html>