Install Xampp
Run Xampp as an administrator or else it won't work!
Start the Apache and MySQL services.
Go to localhost/phpmyadmin/
Go to the SQL tab
Copy and Paste this into SQL and click Go. It will create the database.
CREATE DATABASE todoincdb;
USE todoincdb;
CREATE TABLE users
(
usersId
INT(11) AUTO_INCREMENT NOT NULL,
userName
VARCHAR(30) NOT NULL,
userEmail
VARCHAR(256) NOT NULL,
userPassword
VARCHAR(256) NOT NULL,
questionOne
DATE NOT NULL,
questionTwo
VARCHAR(256) NOT NULL,
PRIMARY KEY (usersId
)
);
CREATE TABLE tasks
(
tasksId
INT(11) AUTO_INCREMENT NOT NULL,
taskName
VARCHAR(30) NOT NULL,
taskDescription
VARCHAR(256) NOT NULL,
checkbox
BOOLEAN NULL,
currentDate
DATE NOT NULL,
usersId
INT(11) NOT NULL,
PRIMARY KEY (tasksId
),
FOREIGN KEY (usersId
) REFERENCES users
(usersId
)
);
CREATE TABLE userinfo (
usersId INT,
bio TEXT,
fname VARCHAR(50),
lname VARCHAR(50),
profilepicture LONGBLOB,
FOREIGN KEY (usersId) REFERENCES users(usersId)
);
ALTER TABLE userinfo
ADD UNIQUE(usersId);
ALTER TABLE tasks ADD COLUMN completeDate date;
Download the public_html file from https://github.com/thegreatwall123/public_html.git
Move the public_html file to the htdocs folder that was automatically created by the Xampp installation. Found at C://xampp/htdocs. (public_html should not have any files between it and htdocs)
Go to localhost/public_html/