· 5 years ago · Feb 05, 2020, 11:48 PM
1 <?php
2
3 /*
4
5
6 CREATE TABLE IF NOT EXISTS `users` (
7 `id` int(11) NOT NULL AUTO_INCREMENT,
8 `username` varchar(50) NOT NULL,
9 `email` varchar(50) NOT NULL,
10 `password` varchar(50) NOT NULL,
11 `trn_date` datetime NOT NULL,
12 `admin` int(11) NOT NULL,
13 `mod` int(11) NOT NULL,
14
15 PRIMARY KEY (`id`)
16 );
17
18
19
20 */
21
22$con = mysqli_connect("localhost","root","","mercury");
23
24// Check connection
25if (mysqli_connect_errno()) {
26 echo "Failed to connect to MySQL: " . mysqli_connect_error();
27 exit();
28}
29
30session_start();
31?>