\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9<\/h2>\n<?\r\nif( !is_file('affiliate.sqlite') ){\r\n $flg = 1;\r\n}\r\n\r\n$db = new SQLite3('affiliate.sqlite');\r\n\r\nif( $flg ){\r\n $query = \"CREATE TABLE 'i-mobile' ( 'seq' INTEGER PRIMARY KEY, 'ymd' DATE , 'pv' INT, 'imp' INT, 'click' INT, 'ctr' FLOAT, 'cpm' FLOAT, 'income' INT );\";\r\n $result = $db->query($query);\r\n}\r\n\r\n\r\n\/* \u30ea\u30bb\u30c3\u30c8\u6642 *\/\r\nif( $_GET['mode'] == 'reset' ){\r\n $query = 'DELETE FROM `i-mobile`';\r\n\r\n $result = $db->query($query);\r\n\r\n if( !$result ){\r\n $msg = 'reset error!';\r\n } else {\r\n header('Location:' . $_SERVER['PHP_SELF'] . '?mode=reseted');\r\n }\r\n}\r\n\r\n\r\n\/* \u30d5\u30a1\u30a4\u30eb\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u6642 *\/\r\nif (is_uploaded_file($_FILES[\"upfile\"][\"tmp_name\"])) {\r\n\r\n $msg = '';\r\n\r\n do {\r\n\r\n \/* \u30a2\u30c3\u30d7\u30ed\u30fc\u30c9 *\/\r\n if( !move_uploaded_file($_FILES[\"upfile\"][\"tmp_name\"], $_FILES[\"upfile\"][\"name\"]) ){\r\n $msg = 'file upload error!';\r\n break;\r\n }\r\n\r\n chmod( $_FILES[\"upfile\"][\"name\"], 0644);\r\n setlocale(LC_ALL, 'ja_JP.UTF-8');\r\n $data = file_get_contents($_FILES[\"upfile\"][\"name\"]);\r\n $data = mb_convert_encoding($data, 'UTF-8', 'sjis-win');\r\n $temp = tmpfile();\r\n $meta = stream_get_meta_data($temp);\r\n fwrite($temp, $data);\r\n rewind($temp);\r\n $file = new SplFileObject($meta['uri']);\r\n $file->setFlags(SplFileObject::READ_CSV);\r\n $csv = array();\r\n foreach($file as $line) {\r\n $csv[] = $line;\r\n }\r\n fclose($temp);\r\n $file = null;\r\n unlink($_FILES[\"upfile\"][\"name\"]);\r\n\r\n\r\n \/* \u65e2\u306b\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u65e5\u4ed8\u306e\u547c\u3073\u51fa\u3057 *\/\r\n $query = '\r\n SELECT ymd \r\n FROM `i-mobile`\r\n ';\r\n $result = $db->query($query);\r\n\r\n if( !$result ){\r\n $msg = 'select error!';\r\n break;\r\n }\r\n\r\n while ($row = $result->fetchArray()) {\r\n $readData[$row['ymd']] = 1;\r\n }\r\n\r\n\r\n \/* \u66f8\u304d\u8fbc\u307f *\/\r\n $insertData = '';\r\n for( $i = 1; $i < count($csv); $i++ ){\r\n\r\n if( !$readData[$csv[$i][0]] ){ \/\/\u65e2\u306b\u767b\u9332\u3055\u308c\u3066\u3044\u308b\u5206\u306f\u4e0d\u8981\r\n\r\n $query = '\r\n INSERT INTO `i-mobile` \r\n (ymd, pv, imp, click, ctr, cpm, income) \r\n VALUES \r\n (\"' . $csv[$i][0] . '\",\"' . $csv[$i][1] . '\",\"' . $csv[$i][2] . '\", \"' . $csv[$i][3] . '\",\"' . str_replace('%','',$csv[$i][4]) . '\", \"' . str_replace('\uffe5','',$csv[$i][5]) . '\", \"' . $csv[$i][6] . '\")\r\n ';\r\n\r\n $result = $db->query($query);\r\n\r\n if( !$result ){\r\n $msg = 'insert error!';\r\n break;\r\n }\r\n }\r\n }\r\n\r\n\r\n if( $msg == '' ){\r\n header('Location:' . $_SERVER['PHP_SELF'] . '?mode=uploaded');\r\n }\r\n\r\n } while (0);\r\n}\r\n\r\n\r\n\/* \u8aad\u307f\u8fbc\u307f *\/\r\n$query = '\r\n SELECT * \r\n FROM `i-mobile` \r\n ORDER BY ymd ASC \r\n';\r\n$result = $db->query($query);\r\n\r\n$highchartsData['ymd'] = '';\r\n$highchartsData['pv'] = '';\r\n$highchartsData['imp'] = '';\r\n$highchartsData['click'] = '';\r\n$highchartsData['ctr'] = '';\r\n$highchartsData['cpm'] = '';\r\n$highchartsData['income'] = '';\r\n\r\nwhile ($row = $result->fetchArray()) {\r\n $affiliateData[$row['id']]['ymd'] = $row['ymd'];\r\n $affiliateData[$row['id']]['pv'] = $row['pv'];\r\n $affiliateData[$row['id']]['imp'] = $row['imp'];\r\n $affiliateData[$row['id']]['click'] = $row['click'];\r\n $affiliateData[$row['id']]['ctr'] = $row['ctr'];\r\n $affiliateData[$row['id']]['cpm'] = $row['cpm'];\r\n $affiliateData[$row['id']]['income'] = $row['income'];\r\n\r\n $highchartsData['ymd'] .= '\"'. $row['ymd'] . '\",';\r\n $highchartsData['pv'] .= $row['pv'] . ',';\r\n $highchartsData['imp'] .= $row['imp'] . ',';\r\n $highchartsData['click'] .= $row['click'] . ',';\r\n $highchartsData['ctr'] .= $row['ctr'] . ',';\r\n $highchartsData['cpm'] .= $row['cpm'] . ',';\r\n $highchartsData['income'] .= $row['income'] . ',';\r\n}\r\n?>\r\n\r\n<!DOCTYPE html>\r\n<html lang=\"ja\">\r\n<head>\r\n<meta charset=\"utf-8\">\r\n<title>i-mobile\u30b0\u30e9\u30d5\u5316<\/title>\r\n<script type=\"text\/javascript\" src=\"http:\/\/ajax.googleapis.com\/ajax\/libs\/jquery\/1.9.1\/jquery.min.js\"><\/script>\r\n<link href=\"\/\/netdna.bootstrapcdn.com\/twitter-bootstrap\/2.3.2\/css\/bootstrap-combined.min.css\" rel=\"stylesheet\">\r\n<script src=\"\/\/netdna.bootstrapcdn.com\/twitter-bootstrap\/2.3.2\/js\/bootstrap.min.js\"><\/script>\r\n<script src=\".\/highcharts\/js\/highcharts.js\"><\/script>\r\n<script>\r\n$(function(){\r\n $('#line').highcharts({\r\n chart: {\r\n type: 'line',\r\n marginRight: 130,\r\n marginBottom: 25\r\n },\r\n title: {\r\n text: 'i-mobile',\r\n x:-20 \/\/center\r\n },\r\n xAxis: {\r\n categories: [<? echo rtrim($highchartsData['ymd'], ',');?>]\r\n },\r\n yAxis: {\r\n title: {\r\n align: 'middle',\r\n rotation: -90\r\n\r\n },\r\n plotLines: [{\r\n value: 0,\r\n width: 1,\r\n color: '#808080'\r\n }]\r\n },\r\n legend: {\r\n layout: 'vertical',\r\n align: 'right',\r\n verticalAlign: 'top',\r\n x: -80,\r\n y: 0,\r\n borderWidth: 0\r\n },\r\n series: [{\r\n name: '\u30da\u30fc\u30b8\u8868\u793a\u56de\u6570',\r\n data: [<? echo rtrim($highchartsData['pv'], ',');?>]\r\n }, {\r\n name: '\u5e83\u544a\u8868\u793a\u56de\u6570',\r\n data: [<? echo rtrim($highchartsData['imp'], ',');?>]\r\n }, {\r\n name: '\u30da\u30fc\u30b8CTR',\r\n data: [<? echo rtrim($highchartsData['ctr'], ',');?>]\r\n }, {\r\n name: '\u30da\u30fc\u30b8CPM',\r\n data: [<? echo rtrim($highchartsData['cpm'], ',');?>]\r\n }, {\r\n name: '\u53ce\u76ca\u91d1\u984d',\r\n data: [<? echo rtrim($highchartsData['income'], ',');?>]\r\n }]\r\n });\r\n});\r\nfunction dataReset(){\r\n if( confirm('\u30c7\u30fc\u30bf\u3092\u30ea\u30bb\u30c3\u30c8\u3057\u307e\u3059\u304b\uff1f') ){\r\n location.href = '<?=$_SERVER[\"PHP_SELF\"]?>?mode=reset'\r\n } else {\r\n return false;\r\n }\r\n}\r\n<\/script>\r\n<\/head>\r\n<body>\r\n <? if( $msg ){ ?>\r\n <div class=\"alert alert-error\">\r\n <?=$msg?>\r\n <\/div>\r\n <? } ?>\r\n <? if( $_GET['mode'] == 'uploaded' || $_GET['mode'] == 'reseted' ){?>\r\n <div class=\"alert alert-success\">\r\n <?=( $_GET['mode'] == 'uploaded' ) ? 'CSV\u30d5\u30a1\u30a4\u30eb\u306e\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002': '\u30c7\u30fc\u30bf\u306e\u30ea\u30bb\u30c3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002';?>\r\n <\/div>\r\n <? } ?>\r\n <form enctype=\"multipart\/form-data\" method=\"post\" action=\"\">\r\n <input type=\"file\" name=\"upfile\"><br \/>\r\n <input type=\"submit\" value=\"Upload\" class=\"btn btn-info\">\r\n <input type=\"button\" value=\"Reset\" class=\"btn btn-danger\" onclick=\"return dataReset();\">\r\n <\/form>\r\n <div id=\"line\"><!--\u30b0\u30e9\u30d5\u9818\u57df--><\/div>\r\n<\/body>\r\n<\/html><\/pre>\n <\/p>\n
\u305d\u306e\u4ed6<\/h2>\n
\u30bd\u30fc\u30b9\u3092\u305d\u306e\u307e\u307e\u4fdd\u5b58\u3057\u3066\u3001highchats.js\u306e\u30d1\u30b9\u3092\u66f8\u304d\u63db\u3048\u3066\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b\u3060\u3051\u3067\u52d5\u304f\u306f\u305a\u3002<\/p>\n
\u6c17\u4ed8\u3044\u305f\u70b9\u3068\u3057\u3066SQLite\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u304c3.7.11\u4ee5\u524d\u306e\u3082\u306e\u3060\u3068\u3001MySQL\u3067\u3088\u304f\u4f7f\u3046\u4ee5\u4e0b\u306e\u5f62\u306e\u30d0\u30eb\u30af\u30a4\u30f3\u30b5\u30fc\u30c8\u304c\u3067\u304d\u306a\u3044\u6a21\u69d8\u3002<\/p>\n
INSERT INTO table \r\n (aaa, bbb) \r\nVALUES \r\n (aaa,bbb), (aaa,bbb)<\/pre>\n\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u5f62\u306a\u3089\u30d0\u30eb\u30af\u30a4\u30f3\u30b5\u30fc\u30c8\u53ef\u80fd\u307f\u305f\u3044\u3060\u3051\u3069\u30011\u56de\u306b\u633f\u5165\u3067\u304d\u308b\u306e\u306f500\u4ef6\u307e\u3067\u3002<\/p>\n
INSERT INTO member\r\nSELECT 0 AS id, 'foo' AS name\r\nUNION ALL SELECT 1, 'bar'\r\nUNION ALL SELECT 2, 'baz'\r\nUNION ALL SELECT 3, 'qux';<\/pre>\n500\u4ef6\u4ee5\u4e0a\u306a\u3089\u5206\u3051\u308b\u51e6\u7406\u3068\u304b\u5165\u308c\u308b\u306e\u304c\u9762\u5012\u304f\u3055\u304b\u3063\u305f\u306e\u30671\u56de\u305a\u3064\u633f\u5165\u306b\u3057\u305f\u3002<\/p>\n
\u307e\u305f\u3001\u30c7\u30fc\u30bf\u306e\u30ea\u30bb\u30c3\u30c8\u6642\u306bTRUNCATE\u3092\u4f7f\u304a\u3046\u3068\u3057\u305f\u3051\u3069SQLite\u306b\u306f\u7121\u3044\u3089\u3057\u3044\u3002DELETE FROM table\u3067\u5bfe\u5fdc\u3002<\/p>\n
BBS\u3068\u9055\u3063\u3066\u8907\u6570\u4eba\u6570\u304c\u4f7f\u3046\u3082\u306e\u3067\u3082\u306a\u3044\u3057\u3001\u65e5\u5225\u30c7\u30fc\u30bf\u306a\u3089\u30c7\u30fc\u30bf\u6570\u3082\u5c11\u306a\u3044\u3057\u3001\u3053\u3046\u3044\u3046\u30da\u30fc\u30b8\u306bSQLite\u304c\u5411\u3044\u3066\u3044\u305d\u3046\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
i-mobile\u3067\u30af\u30ea\u30c3\u30af\u4fdd\u8a3c\u306e\u30a2\u30d5\u30a3\u30ea\u30a8\u30a4\u30c8\u3060\u3051\u3069\u6570\u5024\u304c\u4e26\u3093\u3067\u3044\u308b\u3060\u3051\u3067\u30b0\u30e9\u30d5 ... <\/p>\n","protected":false},"author":1,"featured_media":2297,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2,3,43],"tags":[],"class_list":["post-1936","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php","category-jquery","category-sqlite"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts\/1936","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/comments?post=1936"}],"version-history":[{"count":2,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts\/1936\/revisions"}],"predecessor-version":[{"id":5854,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts\/1936\/revisions\/5854"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/media\/2297"}],"wp:attachment":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/media?parent=1936"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/categories?post=1936"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/tags?post=1936"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}