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

29 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


<!doctype html>

<html>



<body>

<?php

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

    try {

  

      $sql = "CREATE TABLE kompisar (

      id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, 

      firstname VARCHAR(30) NOT NULL,

      lastname VARCHAR(30) NOT NULL,

      phonenum INT,

      epost VARCHAR(30) NOT NULL

      )";

  

      $dbconn->exec($sql);

      echo "Table created successfully";

    }

  

    catch(PDOException $e) {

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

    }

  

    $dbconn = null;



?>

</body>

</html>