Posts

Multi Item Slider in Codeigniter using JQuery

Image
Multi Item Slider in Codeigniter using JQuery  Database Queries : CREATE DATABASE IF NOT EXISTS `slider` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; USE `slider`; CREATE TABLE `slider` (   `s_id` int(11) NOT NULL,   `s_title` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSERT INTO `slider` (`s_id`, `s_title`) VALUES (1, 'Rose'), (2, 'Tulips'), (3, 'Lotus'); ALTER TABLE `slider`   ADD PRIMARY KEY (`s_id`); ALTER TABLE `slider`   MODIFY `s_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; COMMIT; Database.php <?php defined('BASEPATH') OR exit('No direct script access allowed'); $active_group = 'default'; $query_builder = TRUE; $db['default'] = array( 'dsn'   => '', 'hostname' => 'localhost', 'username' => 'root', 'password' => '', 'database' => 'slider&

Profile Form in Codeigniter with Image upload and Validation

Image
In this tutorial , we learn how to create user Profile Form in Codeigniter with Image upload , Validation  and insert user data in MySQL database. We will then retrieve the information from the database and display it on the user profile details  page. Follow following steps: 1.  Database Database: `forms` -- -------------------------------------------------------- CREATE TABLE `profile` (   `id` int(11) NOT NULL,   `name` varchar(255) NOT NULL,   `email` varchar(255) NOT NULL,   `mobnum` varchar(255) NOT NULL,   `gender` varchar(255) NOT NULL,   `educ` varchar(255) NOT NULL,   `hobbies` varchar(500) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- - INSERT INTO `profile` (`id`, `name`, `email`, `mobnum`, `gender`, `educ`, `hobbies`) VALUES (1, 'John', 'john@gmail.com', '1111111111', 'Male', 'MBA/MCA', 'Photography, Mountain climbing'), (2, 'Mary', 'mary@gmail.com', '11111122