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

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.

主站蜘蛛池模板: 鄂温| 孟村| 崇阳县| 双辽市| 长垣县| 长沙市| 聂荣县| 石泉县| 六盘水市| 都昌县| 万年县| 阿城市| 阿巴嘎旗| 广宗县| 青海省| 盐津县| 尼木县| 桓台县| 广河县| 博兴县| 西城区| 汨罗市| 阳曲县| 广水市| 晋江市| 墨脱县| 庄河市| 绩溪县| 澄江县| 任丘市| 凌云县| 屏东市| 衢州市| 通许县| 绥阳县| 思南县| 黎平县| 措美县| 酉阳| 竹山县| 昭平县|