PHPackages                             mikecai/fancyphoto - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [File & Storage](/categories/file-storage)
4. /
5. mikecai/fancyphoto

ActiveLibrary[File & Storage](/categories/file-storage)

mikecai/fancyphoto
==================

Is the tiny photo uploader for backend site.Using fancy-box to development it.

v1.1.x-dev(5y ago)026MITPHPPHP >=7.1

Since Feb 24Pushed 5y agoCompare

[ Source](https://github.com/mikethai/fancyphoto)[ Packagist](https://packagist.org/packages/mikecai/fancyphoto)[ RSS](/packages/mikecai-fancyphoto/feed)WikiDiscussions master Synced 3d ago

READMEChangelogDependencies (4)Versions (2)Used By (0)

FancyPhoto for Codeigniter
==========================

[](#fancyphoto-for-codeigniter)

透過Fancy Box實現-後台圖片上傳與刪除工具

### Step 1 - 新增SQL

[](#step-1---新增sql)

```
DROP TABLE IF EXISTS `n_fancy_photo`;

CREATE TABLE `n_fancy_photo` (
  `fp_id` int(11) UNSIGNED NOT NULL,
  `fp_controller` varchar(20) NOT NULL COMMENT 'controler名稱',
  `fp_controller_id` smallint(8) NOT NULL COMMENT '物件id',
  `fp_filename` varchar(128) NOT NULL COMMENT '圖片位置',
  `fp_data` longblob NOT NULL COMMENT '資料內容',
  `fp_mime` varchar(32) NOT NULL COMMENT 'MIME type',
  `fp_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增時間',
  `fp_del` enum('Y','N') NOT NULL DEFAULT 'N' COMMENT '是否刪除'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='資料圖庫';

ALTER TABLE `n_fancy_photo`
  ADD PRIMARY KEY (`fp_id`),
  ADD UNIQUE KEY `fp_id` (`fp_id`);

ALTER TABLE `n_fancy_photo` ADD KEY `idx_controller_id_del` (`fp_controller`,`fp_controller_id`,`fp_del`);

ALTER TABLE `n_fancy_photo` ADD KEY `idx_name_del` (`fp_filename`,`fp_del`);

ALTER TABLE `n_fancy_photo` CHANGE `fp_id` `fp_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT;
```

### Setp 2 - 修改config/router.php

[](#setp-2---修改configrouterphp)

新增下面程式碼

```
$route['fancy_photo/upload_image'] = 'fancy_photo/upload_image';
$route['fancy_photo/get_image'] = 'fancy_photo/get_image';
$route['fancy_photo/remove_image'] = 'fancy_photo/remove_image';
$route['fancyphoto/photos/(:any)'] = 'fancy_photo/read_photos/$1';
```

### Step 3 - 載入fancy\_photo套件

[](#step-3---載入fancy_photo套件)

```
composer requires mikecai\fancyphoto

```

### Step 4 - 新增Controller - Fancy\_photo.php

[](#step-4---新增controller---fancy_photophp)

```