Showing posts with label PHP. Show all posts
Showing posts with label PHP. Show all posts

Sunday, July 9, 2017

Simple CRUD application with User Authentication and Registration using PHP Codeigniter Framework

Hi there!
This is a News application which can perform User Authentication and Registration for users and also performs CRUD operations of News item using MVC architecture. News item contains title and text content. I have used WAMP software bundle.

First of all, create a database named "testdb" and a table named "news".

CREATE DATABASE `testdb`;
use `testdb`;

--
-- Table structure for table `news`
--

CREATE TABLE IF NOT EXISTS `news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(128) NOT NULL,
`slug` varchar(128) NOT NULL,
`text` text NOT NULL,
PRIMARY KEY (`id`),
KEY `slug` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`id`, `title`, `slug`, `text`) VALUES
(1, 'Test', 'test', 'Hello World !!'),
(2, 'What is Lorem Ipsum?', 'what-is-lorem-ipsum', 'Lorem Ipsum is simply dummy text.');


Click here to download the full code from GitHub.