/
install.php
43 lines (30 loc) · 1 KB
/
install.php
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
<?php
ini_set('display_errors',1); error_reporting(E_ALL);
require_once ('vendor/autoload.php');
use Controller\Config;
use PDO;
try{
$DB = new PDO('mysql:host=' . Config::$mysqlHost . ';dbname=' . Config::$databaseName, Config::$databaseUser, Config::$databasePassword);
$DB->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
//ready query for execute
$sqlInstallQuery = $DB->prepare("
CREATE TABLE `links` (
`id` int(11) NOT NULL,
`long` varchar(700) NOT NULL,
`short` varchar(50) NOT NULL,
`expire` DATE NOT NULL DEFAULT '2050/01/01',
`click` INT NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `links`
ADD PRIMARY KEY (`id`);
ALTER TABLE `links`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;
");
$sqlInstallQuery->execute();
echo "database successfully imported!";
echo "please delete this file!";
}catch(PDOException $e){
//error text info
echo "import failed! <br>";
echo "Error: " . $e->getMessage();
}