Show sourcecode

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

webbserverprogrammering/exercises/ovn_db/ovn_db2/db/

create_table.php
create_user.php

`create_user.php`

12 lines UTF-8 Windows (CRLF)

1
2
3
4
5
6
7
8
9
10
11
12


<?php



require __DIR__ . '/../../../../dbconnect.php';



$username = "Anton";

$password = "12345678";



$stmt = $dbconn -> prepare("INSERT INTO users (firstname, lastname, username, password, type, date_changed) VALUES (?, ?, ?, ?, ?, ?)");

$data = ["Anton", "Lidström", $username, $password, "admin", date('Y-m-d')];

$result = $stmt -> execute($data);



echo $result;