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

bradtraversy
178 Stars 166 Forks MIT License 16 Commits 11 Opened issues

Description

Simple blog built on Codeigniter

Services available

!
?

Need anything else?

Contributors list

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
(
id
int(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,
post
image
varchar(255) NOT NULL,
createdat` timestamp NOT NULL DEFAULT CURRENTTIMESTAMP, PRIMARY KEY (
id
) ) ENGINE=InnoDB;

CREATE TABLE

categories
(
id
int(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
(
id
int(11) NOT NULL,
post_id
int(11) NOT NULL,
name
varchar(255) NOT NULL,
email
varchar(255) NOT NULL,
body
text NOT NULL,
created_at
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (
id
) ) ENGINE=InnoDB;

CREATE TABLE

users
(
id
int(11) NOT NULL,
name
varchar(255) NOT NULL,
zipcode
varchar(255) NOT NULL,
email
varchar(255) NOT NULL,
username
varchar(255) NOT NULL,
password
varchar(255) NOT NULL,
register_date
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (
id
) ) ENGINE=InnoDB;

We use cookies. If you continue to browse the site, you agree to the use of cookies. For more information on our use of cookies please see our Privacy Policy.