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

57 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


<!doctype html>

<html>



<body>

<?php

$message = null;

  if (isset($_POST['firstname']) && isset($_POST['lastname']) && 

  !empty($_POST['firstname']) && !empty($_POST['lastname'])) {

    $firstname = $_POST['firstname'];

    $lastname = $_POST['lastname'];

    $user = $_POST['user'];

    $pass = $_POST['pass'];

    $typ = $_POST['typ'];

    

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

    try {    

        $sql = "INSERT INTO users (firstname, lastname, user, pass, typ) 

          VALUES (?, ?, ?, ?, ?)";

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

        $data = array($firstname, $lastname, $user, $pass, $typ);

        $stmt->execute($data);

            

        echo "New record created successfully";

        $lastId = $dbconn->lastInsertId();

        echo "id på sista posten: $lastId";

    }

    catch(PDOException $e)  {

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

    }

    

    $dbconn = null;

  } else {

    $message .= "<br />Du måste fylla i förnamn, efternamn och epost!<br /><br />";

  }

echo $message;

?>

<form method="post" action=""> 



  Förnamn: 

  <input type="text" name="firstname" size=40 maxlength=100><br>



  Efternamn: 

  <input type="text" name="lastname" size=40 maxlength=100><br>



  User: 

  <input type="text" name="user" size=40 maxlength=100><br>



  Pass: 

  <input type="text" name="pass" size=40 maxlength=100><br>



  Typ: 

  <input type="text" name="typ" size=40 maxlength=100><br>



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

</form>

</body>

</html>