Giter VIP home page Giter VIP logo

ciblog's Introduction

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;

ciblog's People

Contributors

bradtraversy avatar michaelh818 avatar mv92 avatar qncm avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

ciblog's Issues

Posts control / edit - no validation

First of all, thank you so much for posting your blog tutorial to youtube. It must have taken a long time but very much appreciated!!

Wonder if you can show how you would add validation to the Posts controller and the edit method?

Error for me with about.php page

At the 11:05 mark, I have replicated everything in my own domain as I watch, but for the about.php page, I'm getting this error. I used the header code from the page provided. Any ideas?

A PHP Error was encountered
Severity: Error
Message: Call to undefined function base_url()
Filename: templates/header.php
Line Number: 5
Backtrace:

Not so much an issue but more request

Understanding the get post by category but curious how would you go about implementing display posts (displayed in list like they are the post/index) related to a specific category as a featured post on your home page, about page, etc.

Edit Post does not work after JOIN table

Hi,
First of all, Thank you for the good lecture :),

Beacause Table posts and categories has same column name "id"
$this->db->order_by('posts.id', 'DESC');
$this->db->join('categories', 'categories.id = posts.category_id');

get_posts METHOD return id is categories.id

so when edit post it is not working properly.
I changed Model

    **$this->db->select('posts.*, posts.id as post_id, categories.*');**
    
    $this->db->order_by('posts.id', 'DESC');
    $this->db->join('categories', 'categories.id = posts.category_id');

and also edit view.php, edit.php to $post['post_id']

Thx

How can you still using MD5 for password encryptation

1st that nothing change that !
Is not recommended

and 2nd how can you create a user table without use the auto incremental and primary value? need to read and learn a liitle more to build safe and correct software, keep working!

created_at

Hey brad,
When we use join method on sql,
We are getting two "created_at" from category and post tables.
And posts/index methods always calling category's "created_at",
This is wrong,
What is the best solution ?
Change "created_at" name from categories or change SQL ?
Which one do you prefer ?
And i have no idea how can i change our SQL for working good.

Flush Errors

First off great work, keep it up and if need help just asks, cool stuff dude.

You're not flushing your errors after attempting to upload an image

 If ($errors){
  then what??
}

not_flushing_errors

Administration

your youtube tutorial was really fine, what of data administration? I am thtinking that there is need to manage the system by considering the fact that an admin should be included

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.