bradtraversy/ ciblog
Need help with ciblog?
Click the “chat” button below for chat support from the developer who created it, or find similar developers for support.
About the developer
138 Stars 
160 Forks 
MIT License 
16 Commits 
10 Opened issues 
Description
Simple blog built on Codeigniter
Services available
Contributors list
No Data
Readme
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;