{"id":1401,"date":"2017-06-01T21:30:30","date_gmt":"2017-06-01T12:30:30","guid":{"rendered":"http:\/\/okamurax.com\/?p=1401"},"modified":"2020-05-05T01:20:08","modified_gmt":"2020-05-04T16:20:08","slug":"sqlite%e4%bd%bf%e3%81%84%e6%96%b9%e3%83%a1%e3%83%a2","status":"publish","type":"post","link":"https:\/\/appbay.org\/?p=1401","title":{"rendered":"CodeIgniter + SQLite + mod_rewrite\u306e\u4f7f\u3044\u65b9\u30e1\u30e2"},"content":{"rendered":"

SQLite\u30e1\u30e2<\/del><\/h2>\n

DB\u3078\u306e\u4f5c\u6210\u3001\u63a5\u7d9a<\/del>
\n sqlite3 xxx<\/span><\/del><\/p>\n

\u60c5\u5831\u78ba\u8a8d<\/del>
\n .schema<\/span><\/del><\/p>\n

\u7d42\u4e86<\/del>
\n .exit<\/span><\/del><\/p>\n

\u6307\u5b9a\u3067\u304d\u308b\u578b<\/del>
\n TEXT<\/span><\/del>
\n NUMERIC<\/span><\/del>
\n INTEGER<\/span><\/del>
\n REAL<\/span><\/del>
\n NONE<\/span><\/del><\/p>\n

\u30ad\u30fc\u30ef\u30fc\u30c9<\/del><\/p>\n

PRIMARY KEY\u3001<\/span>ROWID\u3001<\/span>AUTOINCREMENT<\/span><\/del><\/p>\n

INTEGER PRIMARY KEY\u3068\u8a2d\u5b9a\u3057\u3066\u3082\u81ea\u52d5\u3067\u5897\u52a0\u3059\u308b\u304c\u3001\u4ee5\u524d\u4f7f\u3063\u305f\u5024\u3092\u518d\u5ea6\u4f7f\u3046\u3002<\/del>
\n INTEGER PRIMARY KEY AUTOINCREMENT\u3068\u3059\u308b\u3068\u3001\u4ee5\u524d\u306e\u5024\u3092\u4f7f\u308f\u306a\u3044\u3002<\/del><\/p>\n

create table xxx (id integer primary key autoincrement)<\/span><\/del>
\n \u306e\u3088\u3046\u306a\u611f\u3058\u3002<\/del><\/p>\n

NOT NULL\u3001<\/span>UNIQUE\u3001<\/span>DEFAULT\u3001<\/span>CHECK<\/span><\/del><\/p>\n

\u30c6\u30fc\u30d6\u30eb\u306e\u4f5c\u6210\u3001\u524a\u9664\u306f\u6a19\u6e96<\/del>
\n create,drop\u7b49\u3002<\/del><\/p>\n

\u4f8b)<\/del>
\n create table news (<\/span><\/del>
\n id integer not null primary key autoincrement,<\/span><\/del>
\n title text not null,<\/span><\/del>
\n slug text not null,<\/span><\/del>
\n text text not null<\/span><\/del>
\n );<\/span><\/del><\/p>\n

xampp+SQLite\u3067\u306e\u8a2d\u5b9a<\/del><\/h2>\n

php.ini\u306e\u4ee5\u4e0b\u30b3\u30e1\u30f3\u30c8\u5916\u3059<\/del>
\n extension=php_sqlite3.dll<\/span><\/del><\/p>\n

application\\config\\database.php<\/span><\/del>
\n \u306e\u4ee5\u4e0b\u3092\u4fee\u6b63<\/del><\/p>\n

‘database’ => APPPATH.’sqlite\/db’,<\/span><\/del>
\n ‘dbdriver’ => ‘sqlite3’,<\/span><\/del><\/p>\n

SQLite\u306e\u307f\u5225\u8a18\u4e8b\u3078<\/p>\n

CodeIgniter\u306e\u4f7f\u3044\u65b9(\u30e6\u30fc\u30b6\u30ac\u30a4\u30c9\u53c2\u8003)<\/h2>\n

\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9<\/h2>\n

application\/controllers\/pages.php<\/span>
\n\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30af\u30e9\u30b9\u540d\u3068\u30d5\u30a1\u30a4\u30eb\u540d\u304c\u540c\u3058\u3002<\/p>\n

\u30eb\u30fc\u30c6\u30a3\u30f3\u30b0\u306f\u3053\u306e\u3088\u3046\u306a\u611f\u3058\u3002
\n\/\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30af\u30e9\u30b9\/\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30af\u30e9\u30b9\u30e1\u30bd\u30c3\u30c9\/\u5f15\u6570
\n\u4f8b)
\nhttp:\/\/localhost\/c\/index.php\/pages\/view\/news<\/span><\/p>\n

\u5b9a\u7fa9\u306f\u3053\u306e\u3088\u3046\u306a\u611f\u3058
\nclass Pages extends CI_Controller {<\/span>
\n public function view($page = ‘home’){}<\/span>
\n}<\/span><\/p>\n

CI_Controller\u3092\u7d99\u627f\u3057\u3066\u3044\u308b\u306e\u3067\u3001
\nsystem\/core\/Controller.php<\/span>
\n\u3092\u5229\u7528\u3067\u304d\u308b\u3002<\/p>\n

\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8<\/h2>\n

application\/views\/templates\/header.php<\/span><\/p>\n

\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u611f\u3058\u3002
\n<html><\/span>
\n<head><\/span>
\n<title>CodeIgniter Tutorial<\/title><\/span>
\n<\/head><\/span>
\n<body><\/span>
\n<h1><?php echo $title; ?><\/h1><\/span><\/p>\n

\u9759\u7684\u306a\u30da\u30fc\u30b8<\/h2>\n

application\/views\/pages\/<\/span>
\nhome.php\u3084about.php\u7b49\u4f5c\u6210\u3002<\/p>\n

\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u304b\u3089\u306e\u547c\u3073\u51fa\u3057<\/h2>\n

public function view($page = ‘home’)<\/span>
\n{<\/span>
\n if ( ! file_exists(APPPATH.’views\/pages\/’.$page.’.php’))<\/span>
\n {<\/span>
\n show_404();<\/span>
\n }<\/span>
\n $data[‘title’] = ucfirst($page); \/\/ \u982d\u6587\u5b57\u3092\u5927\u6587\u5b57\u306b<\/span>
\n $this->load->view(‘templates\/header’, $data);<\/span>
\n $this->load->view(‘pages\/’.$page, $data);<\/span>
\n $this->load->view(‘templates\/footer’, $data);<\/span>
\n}<\/span><\/p>\n

\u30e2\u30c7\u30eb\u306e\u4f5c\u6210<\/h2>\n

application\\models<\/span>
\nNews_model.php\u3092\u4f5c\u6210\u3057\u3001\u4ee5\u4e0b\u3092\u8a18\u8ff0<\/p>\n

<?php<\/span>
\nclass News_model extends CI_Model {<\/span>
\npublic function __construct()<\/span>
\n {<\/span>
\n \u3000\u3000$this->load->database();<\/span>
\n }
\npublic function get_news($slug = FALSE)<\/span>
\n{<\/span>
\nif ($slug === FALSE)<\/span>
\n{<\/span>
\n$query = $this->db->get(‘news’);<\/span>
\nreturn $query->result_array();<\/span>
\n}<\/span>
\n$query = $this->db->get_where(‘news’, array(‘slug’ => $slug));<\/span>
\nreturn $query->row_array();<\/span>
\n}<\/span>
\n}<\/span><\/p>\n

\u30e2\u30c7\u30eb\u3092\u547c\u3073\u51fa\u3059\u305f\u3081\u306e\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9<\/h2>\n

<?php<\/span>
\nclass News extends CI_Controller {<\/span>
\npublic function __construct()<\/span>
\n{<\/span>
\nparent::__construct();<\/span>
\n$this->load->model(‘news_model’); \/\/\u30e2\u30c7\u30eb\u306e\u30ed\u30fc\u30c9<\/span>
\n$this->load->helper(‘url_helper’);<\/span>
\n}<\/span>
\npublic function index()<\/span>
\n{<\/span>
\n$data[‘news’] = $this->news_model->get_news();
\n<\/span>\/\/\u30e2\u30c7\u30eb->\u30e2\u30c7\u30eb\u30e1\u30bd\u30c3\u30c9
\n}<\/span>
\npublic function view($slug = NULL)<\/span>
\n{<\/span>
\n$data[‘news_item’] = $this->news_model->get_news($slug);<\/span>
\n}<\/span>
\n}<\/span><\/p>\n

\u5909\u6570<\/h2>\n

\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u5185\u306e$data[‘title’]\u306e\u30d3\u30e5\u30fc\u5185\u306e$title<\/p>\n

\u30eb\u30fc\u30c6\u30a3\u30f3\u30b0<\/h2>\n

application\/config\/routes.php<\/span><\/p>\n

$route[‘default_controller’] = ‘pages\/view’;<\/span>
\ndefault_controller\u306fURI\u306b\u4f55\u3082\u306a\u3044\u5834\u5408\u3001
\n\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\/\u30e1\u30bd\u30c3\u30c9\u306b\u306a\u308b\u304c\u30e1\u30bd\u30c3\u30c9\u3092\u7701\u7565\u3059\u308b\u3068index\u3092\u547c\u3076\u3002<\/p>\n

$route[‘(:any)’] = ‘news\/$1’;<\/span>
\n\/\/\u3053\u306e\u30eb\u30fc\u30c6\u30a3\u30f3\u30b0\u3092\u4f7f\u3046\u3068\u3001
\n\/\/http:\/\/localhost\/c\/index.php\/create<\/span>
\n\/\/\u3068\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3068\u3001
\n\/\/http:\/\/localhost\/c\/index.php\/news\/create
\n<\/span>\/\/\u5b9f\u969b\u306f\u4e0a\u8a18\u306b\u30a2\u30af\u30bb\u30b9\u3057\u305f\u3053\u3068\u306b\u306a\u308b\u3002<\/p>\n

index.php\u3092\u6d88\u3059\u3002<\/h2>\n

httpd.conf\u306emod_rewrite\u304c\u6709\u52b9\u304b\u3069\u3046\u304b\u78ba\u8a8d\u3002(\u901a\u5e38\u6709\u52b9)<\/p>\n

\u30eb\u30fc\u30c8\u306b.htaccess\u3092\u4f5c\u6210\u3002(localhost\/c\/.htaccess)<\/p>\n

RewriteEngine on<\/span>
\nRewriteCond $1 !^(index\\.php|images|robots\\.txt)<\/span>
\nRewriteRule ^(.*)$ \/c\/index.php\/$1 [L]
\n<\/span>\u3068\u8a18\u8ff0\u3002<\/p>\n

.htaccess(mod_rewrite)\u306b\u3064\u3044\u3066<\/h2>\n

RewriteEngine On<\/span>
\nRewriteCond %{REQUEST_FILENAME} !-f<\/span>
\nRewriteCond %{REQUEST_FILENAME} !-d<\/span>
\nRewriteRule ^(.*)$ index.php\/$1 [L]<\/span><\/p>\n

RewriteCond\u306f
\nRewriteRule\u3092\u5b9f\u884c\u3059\u308b\u305f\u3081\u306e\u6761\u4ef6\u3002IF\u6587\u306e\u3088\u3046\u306a\u3082\u306e\u3002<\/p>\n

\u4ee5\u4e0b\u8a18\u8ff0\u4f8b\u3002<\/p>\n

RewriteCond %\u5909\u6570\u540d(\u30c6\u30b9\u30c8\u6587\u5b57\u5217) \u6761\u4ef6\u30d1\u30bf\u30fc\u30f3(\u6b63\u898f\u8868\u73fe) [\u30d5\u30e9\u30b0]<\/span>
\nRewriteRule \u3053\u3053\u306bRewriteRule\u306eURL\u66f8\u63db\uff06\u8ee2\u9001\u8a2d\u5b9a\u3092\u8a18\u8ff0<\/span><\/p>\n

\u30d5\u30e9\u30b0\u306f\u4f55\u3082\u8a18\u8ff0\u3057\u306a\u3044\u3068AND\u3067\u3001OR\u306e\u5834\u5408[OR]\u3068\u8a18\u8ff0\u3002
\n[OR]\u3092\u4f7f\u308f\u305a\u306b\u7a7a\u767d\u884c\u3092\u5165\u308c\u3066\u3082OR\u6271\u3044\u3002
\n[NC]\u3068\u8a18\u8ff0\u3059\u308b\u3068\u5927\u6587\u5b57\/\u5c0f\u6587\u5b57\u306e\u533a\u5225\u3092\u3057\u306a\u3044\u3002
\n\u3075\u305f\u3064\u540c\u6642\u306e\u5834\u5408\u3002[OR,NC]<\/p>\n

WordPress\u7b49\u306emod_rewrite<\/h2>\n

<IfModule mod_rewrite.c><\/span>
\nRewriteEngine On<\/span>
\nRewriteBase \/<\/span><\/p>\n

# Rewrite\u51e6\u7406\u5f8c\u306b\u30d9\u30fc\u30b9\u3068\u306a\u308bURL
\n# \u8a18\u8ff0\u304c\u306a\u3044\u3068htaccess\u306e\u8a2d\u7f6e\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u304c\u9078\u629e
\n# RewriteRule\u304c\u76f8\u5bfe\u30d1\u30b9\u306e\u307f\u9069\u7528\u3055\u308c\u308b\u3002<\/p>\n

RewriteCond %{REQUEST_FILENAME} !-f<\/span><\/p>\n

# %{REQUEST_FILENAME} \u304c !-f \u3060\u3063\u305f\u3068\u3044\u3046\u6761\u4ef6\u5f0f\u3002
\n# ! \u3068 -f \u3067\u3042\u308a\u3001
\n# -f \u306f\u30d5\u30a1\u30a4\u30eb\u304b\u3069\u3046\u304b\u3002! \u306f\u771f\u507d\u306e\u53cd\u8ee2\u3002<\/p>\n

RewriteCond %{REQUEST_FILENAME} !-d<\/span><\/p>\n

# -d \u306f\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u304b\u3069\u3046\u304b<\/p>\n

RewriteRule . \/index.php [L]<\/span><\/p>\n

# URL\u304c(.)\u3060\u3063\u305f\u3089\u3001\/index.php\u3092\u53c2\u7167\u3002
\n# \u5168\u3066\u306e\u30a2\u30af\u30bb\u30b9\u304c\/index.php\u3092\u53c2\u7167\u3068\u3044\u3046\u3053\u3068\u3002
\n# [L]\u306f\u6700\u5f8c\u3068\u3044\u3046\u610f\u5473\u3002<\/p>\n

<\/IfModule><\/span><\/p>\n

\u30d5\u30e9\u30b0\u306f
\n[NC] \u5927\u5c0f\u533a\u5225\u7121\u3057
\n[R] \u30ea\u30c0\u30a4\u30ec\u30af\u30c8
\n[R=301] \u30ea\u30c0\u30a4\u30ec\u30af\u30c8<\/p>\n","protected":false},"excerpt":{"rendered":"

SQLite\u30e1\u30e2 DB\u3078\u306e\u4f5c\u6210\u3001\u63a5\u7d9a sqlite3 xxx \u60c5\u5831\u78ba\u8a8d .schema \u7d42\u4e86 .exit \u6307\u5b9a\u3067\u304d\u308b\u578b TEXT NUMERIC INTEGER REAL NONE \u30ad\u30fc\u30ef\u30fc\u30c9 PRIMARY KEY\u3001R … <\/p>\n

“CodeIgniter + SQLite + mod_rewrite\u306e\u4f7f\u3044\u65b9\u30e1\u30e2” \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[3],"class_list":["post-1401","post","type-post","status-publish","format-standard","hentry","category-1","tag-php"],"_links":{"self":[{"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/posts\/1401","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/appbay.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1401"}],"version-history":[{"count":10,"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/posts\/1401\/revisions"}],"predecessor-version":[{"id":1858,"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/posts\/1401\/revisions\/1858"}],"wp:attachment":[{"href":"https:\/\/appbay.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1401"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/appbay.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1401"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/appbay.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}