{"id":388,"date":"2017-09-21T13:13:21","date_gmt":"2017-09-21T04:13:21","guid":{"rendered":"http:\/\/marius.main.jp\/software\/blog\/?p=388"},"modified":"2020-03-25T18:13:00","modified_gmt":"2020-03-25T09:13:00","slug":"post-388","status":"publish","type":"post","link":"https:\/\/todosoft.net\/blog\/?p=388","title":{"rendered":"BLOB\u306b\u683c\u7d0d\u3057\u305f\u753b\u50cf\u30c7\u30fc\u30bf\u3092\u8907\u6570\u5c55\u958b\u3059\u308b"},"content":{"rendered":"\n<p> \u753b\u50cf1\u3064\u3092\u8fd4\u3059PHP\u3092\u4f5c\u6210\u3057\u3001Ajax\u3067PHP\u3092\u9023\u7d9a\u8aad\u307f\u8fbc\u307f\u3059\u308b\u3053\u3068\u3067<br>\u8907\u6570\u306e\u753b\u50cf\u30921\u30da\u30fc\u30b8\u306b\u5c55\u958b\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u306f\u3042\u308b\u304c\u3001<br>Base64\u3092\u4f7f\u3044PHP1\u3064\u306e\u307f\u3067\u8907\u6570\u5c55\u958b\u3059\u308b\u65b9\u6cd5\u3092\u8a18\u8f09\u3059\u308b\u3002 <\/p>\n\n\n\n<!--more-->\n\n\n\n<pre class=\"wp-block-luxe-blocks-syntaxhighlighter line-numbers language-php\"><code class=\"language-php\">$results = $db->query('SELECT image FROM item');\n\nwhile ($row = $results->fetchArray()) {\n\t$img = $row['image'];\n\t$img = base64_encode($img);\n\n\techo \"&lt;img src=\"data:image\/png;base64,\" . $img . \"\">\";\n}<\/code><\/pre>\n\n\n\n<p> SQL\u306b\u3066image\u5217(BLOB)\u306e\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u5f8c\u3001<br>\u53d6\u5f97\u3057\u305f\u753b\u50cf\u30c7\u30fc\u30bf\u3092\u3001<a rel=\"noreferrer noopener\" href=\"http:\/\/php.net\/manual\/ja\/function.base64-encode.php\" target=\"_blank\">base64_encode<\/a> \u3067Base64\u30a8\u30f3\u30b3\u30fc\u30c9\u3092\u884c\u3046\u3002<br>img\u30bf\u30b0\u306esrc\u306b\u3001\u300c&#8221;data:image\/png;base64,&#8221;\u300d\uff0bBase64\u30a8\u30f3\u30b3\u30fc\u30c9\u3057\u305f\u6587\u5b57\u5217\u3092\u683c\u7d0d\u3002<br>Jpeg\u306e\u5834\u5408\u306f\u300c&#8221;data:image\/jpg;base64,&#8221;\u300d\u7b49\u3001\u753b\u50cf\u5f62\u5f0f\u306b\u3088\u3063\u3066\u6587\u5b57\u5217\u304c\u5909\u308f\u308b\u306e\u3067\u6ce8\u610f\u3002<br>\u8907\u6570\u306e\u753b\u50cf\u7a2e\u5225\u304c\u6df7\u5728\u3059\u308b\u5834\u5408\u306f\u3001<a rel=\"noreferrer noopener\" href=\"http:\/\/php.net\/manual\/ja\/function.exif-imagetype.php\" target=\"_blank\">exif_imagetype<\/a> \u3092\u7528\u3044\u3066ImageType\u3092\u5224\u5b9a\u3059\u308b\u3068\u3088\u3044\u3002 <\/p>\n\n\n\n<p> \u306a\u304a\u3001\u4e0a\u8a18\u65b9\u6cd5\u306fPHP\u3060\u3051\u3067\u306a\u304f\u3001\u9759\u7684\u306aHTML\u306b\u304a\u3044\u3066\u3082\u540c\u69d8\u306a\u8a18\u8f09\u304c\u53ef\u80fd\u3002<br>\u305f\u3060\u3057\u3001\u30d0\u30a4\u30ca\u30ea\u30c7\u30fc\u30bf\u304cHTML\u5185\u306b\u76f4\u63a5\u8a18\u8f09\u3055\u308c\u308b\u70ba\u3001<br>\u5927\u91cf\u306e\u753b\u50cf\u53ca\u3073\u30b5\u30a4\u30ba\u306e\u5927\u304d\u3044\u753b\u50cf\u306b\u306f\u3042\u307e\u308a\u9069\u3055\u306a\u3044\u3002 <\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u753b\u50cf1\u3064\u3092\u8fd4\u3059PHP\u3092\u4f5c\u6210\u3057\u3001Ajax\u3067PHP\u3092\u9023\u7d9a\u8aad\u307f\u8fbc\u307f\u3059\u308b\u3053\u3068\u3067\u8907\u6570\u306e\u753b\u50cf\u30921\u30da\u30fc\u30b8\u306b\u5c55\u958b\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u306f\u3042\u308b\u304c\u3001Base64\u3092\u4f7f\u3044PHP1\u3064\u306e\u307f\u3067\u8907\u6570\u5c55\u958b\u3059\u308b\u65b9\u6cd5\u3092\u8a18\u8f09\u3059\u308b\u3002<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22,15],"tags":[33,34],"class_list":["post-388","post","type-post","status-publish","format-standard","hentry","category-php","category-15","tag-blob","tag-php"],"_links":{"self":[{"href":"https:\/\/todosoft.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/388","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/todosoft.net\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/todosoft.net\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/todosoft.net\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/todosoft.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=388"}],"version-history":[{"count":3,"href":"https:\/\/todosoft.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/388\/revisions"}],"predecessor-version":[{"id":728,"href":"https:\/\/todosoft.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/388\/revisions\/728"}],"wp:attachment":[{"href":"https:\/\/todosoft.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=388"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/todosoft.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=388"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/todosoft.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=388"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}