Codeigniter 3 – Upload file and insert data into database!

Basic Setup:

MYSQL PART:

Go to MySQL or open phpMyadmin and create a database name called 'codeigniter3' and then create a table called 'pictures'. I am attaching the table structure here:

CREATE TABLE `pictures` (
 `pic_id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
 `pic_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `pic_desc` text COLLATE utf8_unicode_ci NOT NULL,
 `pic_file` varchar(255) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

MySQL part is over. No need to go to the database again.

CODEIGNITER CONFIGURATIONS:

1. First, open the database.php file inside /codigniter3/application/config/database.php and change the mysql hostname, username and password as per your database server configuration:

$db['default'] = array(
	'dsn'	=> '',
	'hostname' => 'localhost',//change this as per your server
	'username' => 'root',//change this as per your server
	'password' => '', //change this as per your server
	'database' => 'codeigniter3',
	'dbdriver' => 'mysqli',
	'dbprefix' => '',
	'pconnect' => FALSE,
	'db_debug' => (ENVIRONMENT !== 'production'),
	'cache_on' => FALSE,
	'cachedir' => '',
	'char_set' => 'utf8',
	'dbcollat' => 'utf8_general_ci',
	'swap_pre' => '',
	'encrypt' => FALSE,
	'compress' => FALSE,
	'stricton' => FALSE,
	'failover' => array(),
	'save_queries' => TRUE
);

2. Then, open config.php file inside /codigniter3/application/config/config.php and set the $config['base_url'] to $config['base_url'] = 'http://localhost/codeigniter3/';