Simple blog built on Codeigniter
No Data
ciBlog
This is a simple blog application built on CodeIgniter 3.x. It is from the YouTube series Build a CodeIgniter PHP App
Usage
Create the database with the posts table and upload to your host
SQL
CREATE TABLE
posts(
idint(11) NOT NULL AUTOINCREMENT, `categoryid
int(11) NOT NULL,userid
int(11) NOT NULL,title
varchar(255) NOT NULL,slug
varchar(255) NOT NULL,body
text NOT NULL,postimage
varchar(255) NOT NULL,createdat` timestamp NOT NULL DEFAULT CURRENTTIMESTAMP, PRIMARY KEY (
id) ) ENGINE=InnoDB;
CREATE TABLE
categories(
idint(11) NOT NULL AUTOINCREMENT, `userid
int(11) NOT NULL,name
varchar(255) NOT NULL,createdat` timestamp NOT NULL DEFAULT CURRENTTIMESTAMP, PRIMARY KEY (
id) ) ENGINE=InnoDB;
CREATE TABLE
comments(
idint(11) NOT NULL,
post_idint(11) NOT NULL,
namevarchar(255) NOT NULL,
bodytext NOT NULL,
created_attimestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (
id) ) ENGINE=InnoDB;
CREATE TABLE
users(
idint(11) NOT NULL,
namevarchar(255) NOT NULL,
zipcodevarchar(255) NOT NULL,
usernamevarchar(255) NOT NULL,
passwordvarchar(255) NOT NULL,
register_datetimestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (
id) ) ENGINE=InnoDB;