官术网_书友最值得收藏!

Creating the database

Okay, you should have already set up CodeIgniter and Bootstrap as described in Chapter 1, Introduction and Shared Project Resources. If not, then you should know that the code in this chapter is specifically built with the setup from Chapter 1, Introduction and Shared Project Resources, in mind. However, it's not the end of the world—the code can easily be applied to other situations.

Firstly, we'll build the database. Copy out the following MySQL code into your database:

CREATE DATABASE `urls`;
USE `urls`;

CREATE TABLE `urls` (
  `url_id` int(11) NOT NULL AUTO_INCREMENT,
  `url_code` varchar(10) NOT NULL,
  `url_address` text NOT NULL,
  `url_created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`url_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

Tip

You don't have to call the database urls if you don't want to. Feel free to rename to something else if you wish; just be sure to update the config/database.php file accordingly.

Let's take a look at what each item in the database means:

We'll also need to make amends to the config/database.php file—namely setting the database access details, username password, and so on.

Open the config/database.php file and find the following lines:

$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'your username';
$db['default']['password'] = 'your password';
$db['default']['database'] = 'urls';

Edit the values in the preceding lines. Ensure you substitute those values with the ones that are more specific to your setup and situation—so enter your username, password, and so on.

主站蜘蛛池模板: 星子县| 沾益县| 南京市| 蕉岭县| 汝州市| 获嘉县| 景东| 万全县| 水富县| 利津县| 桦南县| 亚东县| 浦城县| 喀喇| 渝北区| 溧水县| 营山县| 姚安县| 竹山县| 项城市| 达尔| 双鸭山市| 通州区| 陆河县| 文昌市| 仁怀市| 军事| 商都县| 湖口县| 济南市| 左权县| 克什克腾旗| 双城市| 章丘市| 鲁山县| 兰考县| 乐陵市| 信宜市| 栖霞市| 辛集市| 尉氏县|