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_table.php
9 lines ASCII Windows (CRLF)
<?php
require __DIR__ . '/../../../../dbconnect.php';
$sql = "CREATE TABLE users (id int NOT NULL AUTO_INCREMENT PRIMARY KEY, firstname varchar(255) NOT NULL, lastname varchar(255) NOT NULL, username varchar(255) NOT NULL, password varchar(255) NOT NULL, type varchar(255) NOT NULL, date_changed date NOT NULL)";
$stmt = $dbconn->prepare($sql);
$result = $stmt->execute();
echo $result;