{"id":1414,"date":"2017-06-07T02:47:59","date_gmt":"2017-06-06T17:47:59","guid":{"rendered":"http:\/\/okamurax.com\/?p=1414"},"modified":"2017-06-07T02:51:00","modified_gmt":"2017-06-06T17:51:00","slug":"codeigniter%e3%81%a7%e3%83%9b%e3%83%bc%e3%83%a0%e3%83%9a%e3%83%bc%e3%82%b8%e3%81%ae%e9%aa%a8%e6%a0%bc%e4%bd%9c%e6%88%90","status":"publish","type":"post","link":"https:\/\/appbay.org\/?p=1414","title":{"rendered":"CodeIgniter\u3067\u30db\u30fc\u30e0\u30da\u30fc\u30b8\u306e\u9aa8\u683c\u4f5c\u6210"},"content":{"rendered":"

\u5b9f\u9a13\u3068\u3057\u3066\u8a18\u4e8b\u3092SQLite\u3067\u53d6\u308a\u51fa\u3059\u30bf\u30a4\u30d7\u3002\u8a18\u4e8b\u3092\u4f5c\u6210\u3057\u3066SQLite\u306b\u767b\u9332\u3059\u308b\u306e\u306f\u9762\u5012\u3067\u3001
\n\u5b9f\u969b\u306b\u904b\u7528\u3059\u308b\u5834\u5408\u3001\u8a18\u4e8b\u306f\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u305f\u65b9\u304c\u697d\u305d\u3046\u3002<\/p>\n

#container{\r\nmargin: 0 auto;\r\nwidth: 970px;\r\n}\r\n\r\n#header{\r\nbackground-color:green;\r\nheight: 100px;   \r\n}\r\n\r\n#left{\r\nfloat: left;\r\nheight: 500px;\r\nwidth: 80%;\r\nbackground-color: grey;\r\n}\r\n\r\n#right{\r\nfloat: left;\r\nheight: 500px;\r\nwidth: 20%;\r\nbackground-color:blue;\r\n}\r\n\r\n#footer{\r\nbackground-color:pink;\r\nheight: 100px; \r\nclear: both;  \r\n}\r\n<\/pre>\n
RewriteEngine on\r\nRewriteCond $1 !^(index\\.php|style.css)\r\nRewriteRule ^(.*)$ \/c\/index.php\/$1 [L]\r\n<\/pre>\n
\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9<\/p>\n
<?php\r\n\r\n\/*\r\n\r\n\u5916\u90e8CSS\u3092\u8aad\u307f\u8fbc\u3080\u65b9\u6cd5\u3002\r\n\r\n$this->load->helper('URL')\r\n \u3092\u8a2d\u5b9a\u3002\r\n\r\n$config['base_url'] = 'http:\/\/localhost\/c';\r\n\u3000\u3092\u8a2d\u5b9a\u3002\r\n.htaccess\u3067style.css\u3092rewrite\u304b\u3089\u9664\u5916\u8a2d\u5b9a\u3002\r\n\r\nheader.php\u3067\r\n<link rel=\"stylesheet\" type=\"text\/css\" href=\"<?php echo base_url(); ?>style.css\">\r\n\u3068\u3059\u308b\u3002\r\n\r\nconfig.php\u3092\u5909\u66f4\u3057\u305f\u304f\u306a\u3044\u5834\u5408\r\n\r\ncontroller\u5074\u304b\u3089\u7d76\u5bfe\u30d1\u30b9\u3092\u5909\u6570\u7d4c\u7531\u3067\u6e21\u3057\u3066\u3057\u307e\u3046\u306e\u4e00\u3064\u65b9\u6cd5(\u5171\u901a\u5316\u3067\u304d\u308b)\u3002\r\n\u3000\u3042\u308b\u3044\u306f\u3001header.php\u306b\u76f4\u63a5\u66f8\u3044\u3066\u3057\u307e\u3046\u3002\r\n\u4f55\u308c\u306b\u305b\u3088.htaccess\u3067rewrite\u304b\u3089\u306e\u9664\u5916\u306f\u5fc5\u8981\u3002\r\n\r\n*\/\r\n\r\nclass Vba extends CI_Controller {\r\n\r\n    public function __construct(){\r\n        parent::__construct();\r\n        $this->load->model('Content');\r\n    }\r\n\r\n    public function page($page=\"1\"){\r\n\r\n        $val['url'] = \"http:\/\/localhost\/c\/\"; \r\n        $val['content'] = $this->Content->loadContent($page);\r\n\r\n        $this->load->view('templates\/header',$val);\r\n        $this->load->view('pages\/body',$val);\r\n        $this->load->view('templates\/footer');\r\n        \r\n    }\r\n}\r\n<\/pre>\n
\u30e2\u30c7\u30eb<\/p>\n
<?php\r\n\r\nclass Content extends CI_Model {\r\n\r\npublic function __construct()\r\n{\r\n        $this->load->database();\r\n}\r\n\r\npublic function loadContent($i)\r\n{\r\n        if (empty($i))\r\n        {\r\n                $query = $this->db->get('tbl');\r\n                return $query->result_array();\r\n        }\r\n        else\r\n        {\r\n                $query = $this->db->get_where('tbl', array('id'=>$i));\r\n                return $query->result_array();\r\n                \/\/return $query->row_array();\r\n        }\r\n\r\n}\r\n\r\n}\r\n<\/pre>\n
\u30d3\u30e5\u30fc<\/p>\n
<div id=\"container\">\r\n<div id=\"header\">\u30bf\u30a4\u30c8\u30eb<\/div>\r\n<div id=\"left\">\r\n\r\n<?php foreach($content as $c): ?>\r\n<?php echo $c['article']; ?>\r\n<?php endforeach; ?>\r\n\r\n<\/div>\r\n<div id=\"right\">\u30b5\u30a4\u30c9\u30d0\u30fc<\/div>\r\n<div id=\"footer\">\u30d5\u30c3\u30bf\u30fc<\/div>\r\n<\/div>\r\n<\/pre>\n
<!DOCTYPE html>\r\n<html lang=\"ja\">\r\n  <head>\r\n    <meta charset=\"utf-8\">\r\n    <link rel=\"stylesheet\" type=\"text\/css\" href=\"<?php echo $url; ?>style.css\">\r\n    <title>\u30bf\u30a4\u30c8\u30eb<\/title>\r\n  <\/head>\r\n  <body>\r\n<\/pre>\n
<script src=\"https:\/\/code.jquery.com\/jquery-2.2.4.min.js\" integrity=\"sha256-BbhdlvQf\/xTY9gja0Dq3HiwQF8LaCRTXxZKRutelT44=\" crossorigin=\"anonymous\"><\/script>\r\n  <\/body>\r\n<\/html>\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
\u5b9f\u9a13\u3068\u3057\u3066\u8a18\u4e8b\u3092SQLite\u3067\u53d6\u308a\u51fa\u3059\u30bf\u30a4\u30d7\u3002\u8a18\u4e8b\u3092\u4f5c\u6210\u3057\u3066SQLite\u306b\u767b\u9332\u3059\u308b\u306e\u306f\u9762\u5012\u3067\u3001 \u5b9f\u969b\u306b\u904b\u7528\u3059\u308b\u5834\u5408\u3001\u8a18\u4e8b\u306f\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u305f\u65b9\u304c\u697d\u305d\u3046\u3002 #container{ margin: 0 auto; width:  … <\/p>\n
“CodeIgniter\u3067\u30db\u30fc\u30e0\u30da\u30fc\u30b8\u306e\u9aa8\u683c\u4f5c\u6210” \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-1414","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\/1414","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=1414"}],"version-history":[{"count":4,"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/posts\/1414\/revisions"}],"predecessor-version":[{"id":1418,"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/posts\/1414\/revisions\/1418"}],"wp:attachment":[{"href":"https:\/\/appbay.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1414"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/appbay.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1414"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/appbay.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1414"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}