Skip to content
Simple blog built on Codeigniter
PHP Other
  1. PHP 99.7%
  2. Other 0.3%
Branch: master
Clone or download
bradtraversy Merge pull request #7 from qncm/qncm-fixes
fix: categories.user_id is missing
Latest commit 5847210 Dec 6, 2017
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
application pagination and user categories May 5, 2017
assets pagination and user categories May 5, 2017
system Initial commit Nov 3, 2016
.gitignore Initial commit Nov 3, 2016
.htaccess Initial commit Nov 3, 2016
ciblog.sql fix: categories.user_id is missing Oct 26, 2017
composer.json Initial commit Nov 3, 2016
contributing.md Initial commit Nov 3, 2016
index.php Initial commit Nov 3, 2016
license.txt
readme.rst pagination and user categories May 5, 2017

readme.rst

ciBlog

This is a simple blog application built on CodeIgniter 3.x. It is from the YouTube series [Build a CodeIgniter PHP App](https://www.youtube.com/watch?v=I752ofYu7ag)

Usage

Create the database with the posts table and upload to your host

SQL

CREATE TABLE posts (
id int(11) NOT NULL AUTO_INCREMENT, category_id int(11) NOT NULL, user_id int(11) NOT NULL, title varchar(255) NOT NULL, slug varchar(255) NOT NULL, body text NOT NULL, post_image varchar(255) NOT NULL, created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id)

) ENGINE=InnoDB;

CREATE TABLE categories (
id int(11) NOT NULL AUTO_INCREMENT, user_id int(11) NOT NULL, name varchar(255) NOT NULL, created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 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;

You can’t perform that action at this time.