Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- database.php
- <?php
- $username = 'root';
- $password = 'PdUaK7UTTnpd2wrM';
- $host = 'localhost';
- try {
- $pdo = new PDO("mysql:host=" . $host . ";charset=utf8", $username, $password);
- } catch (Exception $e) {
- die($e -> getMessage());
- }
- $statement = $pdo -> prepare("CREATE DATABASE IF NOT EXISTS `pistie-lab9websys`");
- $statement -> execute();
- try {
- $pdo = new PDO("mysql:host=" . $host . ";dbname=pistie-lab9websys;charset=utf8", $username, $password);
- } catch (Exception $e) {
- die($e -> getMessage());
- }
- $statement = $pdo -> prepare("CREATE TABLE IF NOT EXISTS `users` (email varchar(225) NOT NULL, password varchar(128) NOT NULL, salt varchar(16) NOT NULL, PRIMARY KEY(email))");
- $statement -> execute();
- $statement = $pdo -> prepare("CREATE TABLE IF NOT EXISTS `Websys_Course` (title varchar(225) NOT NULL, description varchar(1000) NOT NULL, link varchar(1000) NOT NULL, type varchar(20) NOT NULL, id int AUTO_INCREMENT NOT NULL, PRIMARY KEY(id))");
- $statement -> execute();
- session_start();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement