{"id":12131,"date":"2023-12-03T07:00:06","date_gmt":"2023-12-02T22:00:06","guid":{"rendered":"https:\/\/blog.capilano-fw.com\/?p=12131"},"modified":"2023-12-03T21:16:04","modified_gmt":"2023-12-03T12:16:04","slug":"adminer-%e3%81%ae%e3%83%97%e3%83%a9%e3%82%b0%e3%82%a4%e3%83%b3%e3%82%92%e3%81%a4%e3%81%8f%e3%82%8b%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/blog.capilano-fw.com\/?p=12131","title":{"rendered":"adminer \u306e\u72ec\u81ea\u30d7\u30e9\u30b0\u30a4\u30f3\u3092\u3064\u304f\u308b\u65b9\u6cd5"},"content":{"rendered":"<p>\u3055\u3066\u3055\u3066\u3001\u3053\u308c\u306f\u500b\u4eba\u3067\u9055\u3063\u3066\u304f\u308b\u3068\u601d\u3044\u307e\u3059\u304c\u3001\u958b\u767a\u8005\u306e\u7686\u3055\u3093\u306f\u305d\u308c\u305e\u308c\u300c<strong>\u304a\u6c17\u306b\u5165\u308a\u306e\u958b\u767a\u30c4\u30fc\u30eb<\/strong>\u300d\u307f\u305f\u3044\u306a\u3082\u306e\u304c\u6c7a\u307e\u3063\u3066\u3044\u308b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<p>\u4f8b\u3048\u3070\u3001\u79c1\u306e\u5834\u5408\u3067\u3057\u305f\u3089<code>IDE<\/code>\u306f\u307b\u307c<code>phpstorm<\/code>\u306e\u307f\u3092\u4f7f\u3063\u3066\u3044\u305f\u308a\u3057\u307e\u3059\u304c\u3001<code>VSCode<\/code>\u3082\u4eba\u6c17\u3067\u3059\u3057\u3001\u3053\u306e\u8fba\u306f\u597d\u307f\u304c\u5206\u304b\u308c\u308b\u3068\u3053\u308d\u3058\u3083\u306a\u3044\u3067\u3057\u3087\u3046\u304b\u3002<\/p>\n<p>\u305d\u3057\u3066\u3001\u4eca\u56de\u3054\u7d39\u4ecb\u3059\u308b\u306e\u304c\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u64cd\u4f5c\u304c\u30a6\u30a7\u30d6\u4e0a\u3067\u3067\u304d\u308b<\/p>\n<p><strong style=\"font-size: 35px;\">adminer\uff08\u3042\u3069\u307e\u3044\u306a\u30fc\uff09<\/strong><\/p>\n<p>\u306e\u304a\u8a71\u3067\u3059\u3002<\/p>\n<p><strong><a href=\"https:\/\/www.adminer.org\/\" target=\"_blank\" rel=\"noopener\">adminer<\/a><\/strong> \u3068\u306f\u30a6\u30a7\u30d6\u4e0a\u304b\u3089<code>MySQL<\/code>\u306a\u3069\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u7ba1\u7406\u304c\u3067\u304d\u308b\u30c4\u30fc\u30eb\u3067\u3001\u3068\u3066\u3082\u30b7\u30f3\u30d7\u30eb\uff06\u8efd\u91cf\u306a\u306e\u304c\u6c17\u306b\u5165\u3063\u3066\u305a\u3063\u3068\u4f7f\u3063\u3066\u3044\u307e\u3059\u3002\uff08<code>PhpMyAdmin<\/code>\u306e\u30b7\u30f3\u30d7\u30eb\u7248\u3068\u3044\u3063\u305f\u4f4d\u7f6e\u3065\u3051\u3067\u3059\u304b\u306d \ud83e\udd14\uff09<\/p>\n<p>\u3057\u304b\u3057\u3001\u305d\u3093\u306a\u5927\u597d\u304d\u306a<code>adminer<\/code>\u3067\u3082\u300c<strong>\u3042\u30fc\u3001\u3053\u308c\u3067\u304d\u305f\u3089\u3044\u3044\u306e\u306b\u306a<\/strong>\u300d\u3068\u3044\u3046\u90e8\u5206\u304c\u51fa\u3066\u304d\u305f\u308a\u3082\u3057\u307e\u3059\u3002<\/p>\n<p>\u305d\u3053\u3067\u2757<\/p>\n<p>\u4eca\u56de\u306f<code>adminer<\/code>\u306e\u30d7\u30e9\u30b0\u30a4\u30f3\u3092\u72ec\u81ea\u306b\u3064\u304f\u308b\u65b9\u6cd5\u3092\u3054\u7d39\u4ecb\u3057\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<p>\u305c\u3072\u4f55\u304b\u306e\u53c2\u8003\u306b\u306a\u308a\u307e\u3057\u305f\u3089\u5b09\u3057\u3044\u3067\u3059\u3002\ud83d\ude04\u2728<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4328 aligncenter\" src=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2019\/08\/no_3.png\" alt=\"\" width=\"364\" height=\"320\" srcset=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2019\/08\/no_3.png 364w, https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2019\/08\/no_3-300x264.png 300w\" sizes=\"auto, (max-width: 364px) 100vw, 364px\" \/>\u300c\u82f1\u8a9e\u306e\u767a\u97f3\u30a2\u30d7\u30ea\u3067<br \/>\n\u300e\u3042\u3001\u9593\u9055\u3048\u305f\u300f\u3063\u3066\u8a00\u3063\u305f\u3089\u3001<br \/>\n\u6b63\u89e3\u306b\u306a\u3063\u305f\u3093\u3067\u3059\u304c\u2026\ud83d\ude05\u300d<\/p>\n<p><strong>\u958b\u767a\u74b0\u5883\uff1a<\/strong> adminer 4.8.1<\/p>\n<h1>\u4eca\u56de\u3084\u308a\u305f\u3044\u3053\u3068<\/h1>\n<p>\u3044\u3064\u3082\u79c1\u304c\u958b\u767a\u3092\u3057\u3066\u3044\u308b\u3068\u906d\u9047\u3059\u308b\u300c<strong>\u3042\u30fc\u3001\u3053\u308c\u3067\u304d\u305f\u3089\u3044\u3044\u306e\u306b\u306a<\/strong>\u300d\u306f\u8907\u6570\u30ab\u30e9\u30e0\u3092\u4e00\u6c17\u306b\u30b3\u30d4\u30fc\u3057\u305f\u3044\u3068\u304d\u3067\u3059\u3002<\/p>\n<p>\u4f8b\u3048\u3070\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u6d41\u308c\u3067\u3059\u3002<\/p>\n<ol>\n<li>\u958b\u767a\u4e2d\u306b\u300c\u3042\u308c\u3001\u3042\u306e\u30ab\u30e9\u30e0\u540d\u306a\u3093\u3060\u3063\u3051\ud83e\udd14\u300d\u3068\u306a\u308b<\/li>\n<li>adminer \u3067\u30c1\u30a7\u30c3\u30af\u3059\u308b<\/li>\n<li>\u5fc5\u8981\u306a\u8907\u6570\u30ab\u30e9\u30e0\u3092\u9078\u629e\u53cd\u8ee2\u3055\u305b\u3066\u300cCtrl + C\u300d\u3067\u30af\u30ea\u30c3\u30d7\u30dc\u30fc\u30c9\u3078\u30b3\u30d4\u30fc\u3057\u3088\u3046\u3068\u3059\u308b<\/li>\n<li>\u30fb\u30fb\u30fb\u3059\u308b\u3068\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u578b\u306a\u3069\u306e\u4f59\u8a08\u306a\u60c5\u5831\u304c\u5165\u3063\u3066\u304f\u308b<\/li>\n<li>\u30ab\u30e9\u30e0\u540d\u3060\u3051\u30b3\u30d4\u30da\u3055\u305b\u3066\u307b\u3057\u3044\u30fb\u30fb\u30fb<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12132\" style=\"border: 3px solid #000;\" src=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2023\/11\/adminer_plugin_1.png\" alt=\"\" width=\"425\" height=\"329\" srcset=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2023\/11\/adminer_plugin_1.png 425w, https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2023\/11\/adminer_plugin_1-300x232.png 300w\" sizes=\"auto, (max-width: 425px) 100vw, 425px\" \/><\/p>\n<p>\u306a\u306e\u3067\u3001\u4eca\u56de\u306f\u30d7\u30e9\u30b0\u30a4\u30f3\u306e\u4f5c\u6210\u624b\u9806\u3068\u3057\u3066\u300c<strong>\u30ab\u30e9\u30e0\u540d\u3092\u7c21\u5358\u306b\u30af\u30ea\u30c3\u30d7\u30dc\u30fc\u30c9\u306b\u30b3\u30d4\u30fc\u3067\u304d\u308b\u6a5f\u80fd<\/strong>\u300d\u3092\u30c6\u30fc\u30de\u306b\u8a71\u3092\u9032\u3081\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n<p>\u5177\u4f53\u7684\u306a\u6a5f\u80fd\u3068\u3057\u3066\u306f\u300c<strong>\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u304c ON \u306b\u306a\u3063\u305f\u30ab\u30e9\u30e0\u3060\u3051\u300d<\/strong>\u81ea\u52d5\u30b3\u30d4\u30fc\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002<\/p>\n<p>\u3067\u306f\u3001\u4eca\u56de\u3082\u697d\u3057\u3093\u3067\u3084\u3063\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u2757<\/p>\n<h1>\u958b\u767a\u74b0\u5883\u3092\u6574\u3048\u308b<\/h1>\n<p>\u307e\u305a\u306f\u958b\u767a\u74b0\u5883\u3067\u3059\u3002<\/p>\n<p>\u3068\u3044\u3046\u306e\u3082\u3001<code>adminer<\/code>\u306f\u306a\u3093\u3068\u300c<strong>\u305f\u3063\u305f\uff11\u30d5\u30a1\u30a4\u30eb\u3060\u3051<\/strong>\u300d\u3067\u52d5\u304f\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u3066\u3001\u4e2d\u8eab\u306f\u304c\u3063\u3061\u308a\u30d3\u30eb\u30c9\u3055\u308c\u3066\u3057\u307e\u3063\u3066\u304a\u308a\u3001\u5230\u5e95\u5909\u66f4\u3067\u304d\u308b\u3082\u306e\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n<p>\u305d\u306e\u305f\u3081\u3001<a href=\"https:\/\/www.adminer.org\/\" target=\"_blank\" rel=\"noopener\">adminer<\/a> \u306e\u30a6\u30a7\u30d6\u30b5\u30a4\u30c8\u3078\u884c\u304d\u3001\u958b\u767a\u7528\u30d5\u30a1\u30a4\u30eb\uff08<code>Current development version<\/code>\uff09\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u307e\u3059\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12133\" style=\"border: 3px solid #000;\" src=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2023\/11\/adminer_plugin_2.png\" alt=\"\" width=\"767\" height=\"252\" srcset=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2023\/11\/adminer_plugin_2.png 767w, https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2023\/11\/adminer_plugin_2-300x99.png 300w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/p>\n<p>\u3059\u308b\u3068\u3001<code>zip<\/code>\u30d5\u30a1\u30a4\u30eb\u304c\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3055\u308c\u308b\u306e\u3067\u3001\u3053\u308c\u3092<code>PHP<\/code>\u3067\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u30d5\u30a9\u30eb\u30c0\u3078\u79fb\u52d5\u3059\u308c\u3070\u6e96\u5099\u306f\u5b8c\u4e86\u3067\u3059\u3002<\/p>\n<p>\u203b \u79c1\u306e\u5834\u5408\u306f\u3001<code>nginx<\/code>\u306e\u8a2d\u5b9a\u3092\u5909\u66f4\u3057\u3001<code>adminer-dev.test<\/code>\u3067\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u307e\u3057\u305f\u3002<\/p>\n<h1>\u30d7\u30e9\u30b0\u30a4\u30f3\u3092\u3064\u304f\u308b<\/h1>\n<p>\u4eca\u56de\u306f\u3082\u3068\u3082\u3068\u5b58\u5728\u3057\u3066\u3044\u308b\u300c<strong>\u30c6\u30fc\u30d6\u30eb\u69cb\u9020<\/strong>\u300d\u306e\u30da\u30fc\u30b8\u306b\u65b0\u3057\u3044\u6a5f\u80fd\u3092\u8ffd\u52a0\u3057\u305f\u3044\u306e\u3067\u3001<code>plugins\/table-structure.php<\/code>\u3068\u3044\u3046\u30d5\u30a1\u30a4\u30eb\u3092\u30b3\u30d4\u30fc\u3057\u3066<code>plugins\/table-structure-with-copy.php<\/code>\u3068\u3057\u3066\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n<p>\u4e2d\u8eab\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p><strong>plugins\/table-structure-with-copy.php<\/strong><\/p>\n<div>\n<pre><strong>&lt;?php\r\n\r\n\/** Expanded table structure output\r\n * @link https:\/\/www.adminer.org\/plugins\/#use\r\n * @author Matthew Gamble, https:\/\/www.matthewgamble.net\/\r\n * @license https:\/\/www.apache.org\/licenses\/LICENSE-2.0 Apache License, Version 2.0\r\n * @license https:\/\/www.gnu.org\/licenses\/gpl-2.0.html GNU General Public License, version 2 (one or other)\r\n *\r\n * Modified by Sukohi Kuhoh, https:\/\/blog.capilano-fw.com\/\r\n *\/\r\nclass AdminerTableStructureWithCopy {\r\n\r\n    \/** Print table structure in tabular format\r\n     * @param array data about individual fields\r\n     * @return bool\r\n     *\/\r\n    function tableStructurePrint($fields) {\r\n        $table_names = [];\r\n        $i = 0;\r\n        echo \"&lt;div class='scrollable'&gt;\\n\";\r\n        echo \"&lt;table cellspacing='0' class='nowrap'&gt;\\n\";\r\n        echo \"&lt;thead&gt;&lt;tr&gt;&lt;th&gt;&lt;input class=\\\"table-structure-clipboard-checkboxes\\\" type=\\\"checkbox\\\" value=\\\"-1\\\"&gt;&lt;th&gt;\" . lang('Column') .\"&lt;th&gt;\" . lang('Type') . \"&lt;th&gt;\" . lang('Nullable') . \"&lt;th&gt;\" . lang('Default') . (support(\"comment\") ? \"&lt;th&gt;\" . lang('Comment') : \"\") . \"&lt;\/thead&gt;\\n\";\r\n        foreach ($fields as $field) {\r\n            echo \"&lt;tr\" . odd() . \"&gt;\";\r\n            echo \"&lt;th style=\\\"text-align:center;\\\"&gt;&lt;input class=\\\"table-structure-clipboard-checkboxes\\\" type=\\\"checkbox\\\" value=\\\"\". $i .\"\\\"&gt;\";\r\n            echo \"&lt;th&gt;\". h($field[\"field\"]) . ($field[\"primary\"] ? \" (PRIMARY)\" : \"\");\r\n            echo \"&lt;td&gt;&lt;span&gt;\" . h($field[\"full_type\"]) . \"&lt;\/span&gt;\";\r\n            echo ($field[\"auto_increment\"] ? \" &lt;i&gt;\" . lang('Auto Increment') . \"&lt;\/i&gt;\" : \"\");\r\n            echo ($field[\"collation\"] ? \" &lt;i&gt;\" . h($field[\"collation\"]) . \"&lt;\/i&gt;\" : \"\");\r\n            echo \"&lt;td&gt;\" . ($field[\"null\"] ? lang('Yes') : lang('No'));\r\n            echo \"&lt;td&gt;\" . h($field[\"default\"]);\r\n            echo (support(\"comment\") ? \"&lt;td&gt;\" . h($field[\"comment\"]) : \"\");\r\n            echo \"\\n\";\r\n            $table_names[] = $field[\"field\"];\r\n            $i++;\r\n        }\r\n        echo \"&lt;\/table&gt;\\n\";\r\n        echo \"&lt;\/div&gt;\\n\";\r\n        echo \"&lt;div id=\\\"table-structure-copying-text-container\\\" style=\\\"padding:.5rem 30px 0 0;display:none;\\\"&gt;\";\r\n        echo \"&lt;textarea id=\\\"table-structure-copying-text\\\" style=\\\"width:100%;form-sizing:content;min-height:120px;padding:5px;border:1px solid #999;\\\"&gt;&lt;\/textarea&gt;\";\r\n        echo \"&lt;div style=\\\"margin-top:5px;\\\"&gt;&lt;button id=\\\"table-structure-copying-button\\\" style=\\\"padding:5px 10px;\\\"&gt;Copy to clipboard&lt;\/button&gt;&lt;\/div&gt;\";\r\n        echo \"&lt;div id=\\\"table-name-copy-result\\\" style=\\\"color:#0e9300;padding:10px 0 0 0;display:none;font-weight:bold;\\\"&gt;&lt;\/div&gt;\\n\";\r\n        echo \"&lt;\/div&gt;\";\r\n        echo $this-&gt;getScriptCode($table_names);\r\n        return true;\r\n    }\r\n\r\n    function getScriptCode($table_names) {\r\n\r\n        $nonce = nonce();\r\n        $column_names_json = json_encode($table_names);\r\n\r\n        return &lt;&lt;&lt;EOT\r\n            &lt;script{$nonce}&gt;\r\n                \r\n                const columnNames = {$column_names_json};\r\n                let checkedIndexes = [];\r\n                let timer = null;\r\n                \r\n                \/\/ Methods\r\n                const initTableStructure = () =&gt; {\r\n                \r\n                    const checkboxes = getAllCheckboxElements();\r\n                    \r\n                    [].forEach.call(checkboxes, checkbox =&gt; {\r\n                    \r\n                        checkbox.addEventListener('change', onTableStructureCheckboxClick);\r\n                        \r\n                    });\r\n                    \r\n                    const button = document.getElementById('table-structure-copying-button');\r\n                    button.addEventListener('click', onTableStructureButtonClick);\r\n                \r\n                };\r\n                \r\n                \/\/ Events\r\n                const onTableStructureCheckboxClick = e =&gt; {\r\n                \r\n                    const checkboxIndex = Number(e.target.value);\r\n                    \r\n                    if(checkboxIndex === -1) { \/\/ Check all\r\n                    \r\n                        const checkboxes = getAllCheckboxElements();\r\n                        let allIndexes = [];\r\n                        \r\n                        [].forEach.call(checkboxes, checkbox =&gt; {\r\n                        \r\n                            checkbox.checked = e.target.checked;\r\n                            const index = Number(checkbox.value);\r\n                            \r\n                            if(index !== -1) {\r\n                            \r\n                                allIndexes.push(index);\r\n                            \r\n                            }\r\n                        \r\n                        });\r\n                        \r\n                        if(e.target.checked) {\r\n                        \r\n                            checkedIndexes = allIndexes;\r\n                        \r\n                        } else {\r\n                        \r\n                            checkedIndexes = [];\r\n                        \r\n                        }\r\n                    \r\n                    } else if(checkedIndexes.includes(checkboxIndex)) {\r\n                    \r\n                        const currentIndex = checkedIndexes.indexOf(checkboxIndex);\r\n                        checkedIndexes.splice(currentIndex, 1);\r\n                    \r\n                    } else {\r\n                    \r\n                        checkedIndexes.push(checkboxIndex);\r\n                    \r\n                    }\r\n                    \r\n                    checkedIndexes.sort((a, b) =&gt; {\r\n                    \r\n                        return a - b;\r\n                    \r\n                    });\r\n                    \r\n                    const text = getTableNameText();\r\n                    const container = document.querySelector('#table-structure-copying-text-container');\r\n                    \r\n                    if(text) {\r\n                    \r\n                        container.style.display = 'block';\r\n                    \r\n                    } else {\r\n                    \r\n                        container.style.display = 'none';\r\n                    \r\n                    }\r\n                    \r\n                    const textarea = document.getElementById('table-structure-copying-text');\r\n                    textarea.value = text;\r\n                \r\n                };\r\n                onTableStructureButtonClick = e =&gt; {\r\n                \r\n                    const textarea = document.getElementById('table-structure-copying-text');\r\n                    const copyingText = textarea.value;\r\n                    setTextToClipboard(copyingText);\r\n                    setCopyResult();\r\n                \r\n                };\r\n                \r\n                \/\/ Getter\r\n                const getAllCheckboxElements = () =&gt; {\r\n                \r\n                    return document.querySelectorAll('.table-structure-clipboard-checkboxes');\r\n                \r\n                };\r\n                const getTableNameText = () =&gt; {\r\n                \r\n                    const texts = [];\r\n                    \r\n                    checkedIndexes.forEach(checkedIndex =&gt; {\r\n                    \r\n                        texts.push(columnNames[checkedIndex]);\r\n                    \r\n                    });\r\n                    \r\n                    return texts.map(text =&gt; {\r\n                    \r\n                        return text + ',';\r\n                    \r\n                    }).join('\\\\n');\r\n                \r\n                };\r\n                \r\n                \/\/ Setter\r\n                const setTextToClipboard = (text) =&gt; {\r\n                \r\n                    const el = document.createElement('textarea');\r\n                    el.value = text;\r\n                    document.body.appendChild(el);\r\n                    el.select();\r\n                    document.execCommand('copy');\r\n                    document.body.removeChild(el);\r\n                \r\n                };\r\n                const setCopyResult = () =&gt; {\r\n                \r\n                    const el = document.getElementById('table-name-copy-result');\r\n                    el.innerHTML = 'Column name(s) copied to clipboard.';\r\n                    el.style.display = 'block';\r\n                    \r\n                    if(timer) {\r\n                    \r\n                        clearTimeout(timer);\r\n                    \r\n                    }\r\n                    \r\n                    timer = setTimeout(() =&gt; {\r\n                    \r\n                        el.innerHTML = '';\r\n                        el.style.display = 'none';\r\n                    \r\n                    }, 3000);\r\n                \r\n                };\r\n                \r\n                \/\/ Main\r\n                document.addEventListener('DOMContentLoaded', initTableStructure);\r\n            \r\n            &lt;\/script&gt;\r\n        EOT;\r\n\r\n    }\r\n}<\/strong><\/pre>\n<\/div>\n<p>\u203b \u306a\u304a\u3001<code>adminer<\/code>\u306e\u30e9\u30a4\u30bb\u30f3\u30b9\u306f\u306f<code>Apache License<\/code> \u3082\u3057\u304f\u306f <code>GPL 2<\/code>\uff082023.11.2 \u73fe\u5728\uff09\u306a\u306e\u3067\u6ce8\u610f\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>\u3061\u306a\u307f\u306b\u3001\u30d7\u30e9\u30b0\u30a4\u30f3\u7528\u306b\u30af\u30e9\u30b9\u3092\u3064\u304f\u308a\u3001\u305d\u308c\u3092\u8aad\u307f\u8fbc\u3080\u3068\u5143\u3005\u5b58\u5728\u3057\u3066\u3044\u305f\u30e1\u30bd\u30c3\u30c9\u3092\u4e0a\u66f8\u304d\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002\uff08\u6761\u4ef6\u306f\u3001\u8fd4\u308a\u5024\u304c<code>null<\/code>\u4ee5\u5916\u3067\u3001\u3055\u3089\u306b\u7279\u5b9a\u306e\u30e1\u30bd\u30c3\u30c9\u306f\u4e0a\u66f8\u304d\u3067\u304d\u306a\u304f\u306a\u3063\u3066\u3044\u307e\u3059\uff09<\/p>\n<p>\u3064\u307e\u308a\u3001\u4eca\u56de\u306e\u4f8b\u3067\u8a00\u3046\u3068\u300c<strong>tableStructurePrint()<\/strong>\u300d\u3068\u3044\u3046\u30e1\u30bd\u30c3\u30c9\u3092\u65b0\u3057\u304f\u4e0a\u66f8\u304d\u3057\u3066\u3044\u308b\u3068\u3044\u3046\u308f\u3051\u3067\u3059\u3002<\/p>\n<p>\u3082\u3057<code>adminer<\/code>\u306e\u30e1\u30bd\u30c3\u30c9\u4e00\u89a7\u3092\u30c1\u30a7\u30c3\u30af\u3057\u305f\u3044\u5834\u5408\u306f\u4ee5\u4e0b\u306e\u30da\u30fc\u30b8\u304b\u3089\u3067\u304d\u307e\u3059\u3088\ud83d\udc4d<\/p>\n<p><strong>\ud83d\udcdd \u53c2\u8003\u30da\u30fc\u30b8\uff1a<\/strong>\u00a0<a href=\"https:\/\/www.adminer.org\/en\/extension\/#api\" target=\"_blank\" rel=\"noopener\">Adminer &#8211; Extensions<\/a><\/p>\n<h1>\u30d7\u30e9\u30b0\u30a4\u30f3\u3092\u6709\u52b9\u306b\u3059\u308b<\/h1>\n<p>\u3067\u306f\u3001\u5148\u307b\u3069\u3064\u304f\u3063\u305f\u30d7\u30e9\u30b0\u30a4\u30f3\u3092\u6709\u52b9\u306b\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n<p>\u3042\u308a\u304c\u305f\u3044\u8a71\u3067\u3001<code>zip<\/code>\u304b\u3089\u5c55\u958b\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u306e\u4e2d\u306b<code>adminer\/plugin.php<\/code>\u3068\u3044\u3046\u30d5\u30a1\u30a4\u30eb\u304c\u3042\u308a\u3001\u3053\u308c\u3092\u4f7f\u3046\u3068\u7c21\u5358\u306b\u30d7\u30e9\u30b0\u30a4\u30f3\u3092\u6709\u52b9\u306b\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<div>\n<pre>&lt;?php\r\nfunction adminer_object() {\r\n    \/\/ required to run any plugin\r\n    include_once \"..\/plugins\/plugin.php\";\r\n    \r\n    \/\/ autoloader\r\n    foreach (glob(\"..\/plugins\/*.php\") as $filename) {\r\n       include_once $filename;\r\n    }\r\n    \/\/ enable extra drivers just by including them\r\n    \/\/~ include \"..\/plugins\/drivers\/simpledb.php\";\r\n    \r\n    $plugins = array(\r\n\r\n       \/\/ \u7701\u7565\r\n\r\n       <strong>new AdminerTableStructureWithCopy,<\/strong> \/\/ \ud83d\udc48 \u3053\u3053\u3092\u8ffd\u52a0\u3057\u307e\u3057\u305f\r\n    );\r\n    \r\n\/\/ \u4ee5\u4e0b\u7701\u7565<\/pre>\n<\/div>\n<p>\u3053\u308c\u3060\u3051\u3067\u3001\u30d7\u30e9\u30b0\u30a4\u30f3\u306f\u6709\u52b9\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p>\u3067\u306f\u3001\u4e00\u65e6\u3053\u306e\u72b6\u614b\u3067\u30d6\u30e9\u30a6\u30b6\u304b\u3089\u78ba\u8a8d\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002\u300c<strong>https:\/\/******\/adminer\/plugin.php<\/strong>\u300d\u3078\u30a2\u30af\u30bb\u30b9\u3057\u307e\u3059\u3002<\/p>\n<p>\u3059\u308b\u3068\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u30ed\u30b0\u30a4\u30f3\u30d5\u30a9\u30fc\u30e0\u304c\u8868\u793a\u3055\u308c\u308b\u306e\u3067\u30ed\u30b0\u30a4\u30f3\u3057\u3066\u9069\u5f53\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5185\u306e\u30c6\u30fc\u30d6\u30eb\u69cb\u9020\u3092\u8868\u793a\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12134\" style=\"border: 3px solid #000;\" src=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2023\/11\/adminer_plugin_3.png\" alt=\"\" width=\"301\" height=\"264\" \/><\/p>\n<p>\u3059\u308b\u3068\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3053\u308c\u307e\u3067\u306a\u304b\u3063\u305f\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u304c\u8868\u793a\u3055\u308c\u3066\u3044\u308b\u306e\u304c\u308f\u304b\u308a\u307e\u3059\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12135\" style=\"border: 3px solid #000;\" src=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2023\/11\/adminer_plugin_4.png\" alt=\"\" width=\"438\" height=\"355\" srcset=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2023\/11\/adminer_plugin_4.png 438w, https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2023\/11\/adminer_plugin_4-300x243.png 300w\" sizes=\"auto, (max-width: 438px) 100vw, 438px\" \/><\/p>\n<p>\u3067\u306f\u3001\u958b\u767a\u7528\u306e\u30d7\u30e9\u30b0\u30a4\u30f3\u304c\u6709\u52b9\u306b\u306a\u3063\u3066\u3044\u308b\u3088\u3046\u3067\u3059\u306e\u3067\u3001\u3053\u308c\u4ee5\u964d\u306e\u30c6\u30b9\u30c8\u306f\u5f8c\u306b\u3057\u3066\u672c\u756a\u74b0\u5883\u306b\u3053\u306e\u30d7\u30e9\u30b0\u30a4\u30f3\u3092\u30bb\u30c3\u30c8\u3057\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n<h1>\u72ec\u81ea\u30d7\u30e9\u30b0\u30a4\u30f3\u3092\uff08\u672c\u756a\u306e\uff09adminer \u3078\u9069\u7528\u3059\u308b<\/h1>\n<p>\u307e\u305a<code>adminer<\/code>\u304c\u3069\u3053\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u3066\u3044\u308b\u306e\u304b\u3092\u78ba\u8a8d\u3057\u3066\u304a\u3044\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>\u4f8b\u3048\u3070<code>\/usr\/share\/adminer<\/code>\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u3066\u3044\u308b\u5834\u5408\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u30d5\u30a1\u30a4\u30eb\u69cb\u6210\u306b\u3057\u307e\u3059\u3002<\/p>\n<p><strong>\/usr\/share\/adminer<\/strong><br \/>\n<strong>\u3000\u2514 plugins\/<\/strong><br \/>\n<strong>\u3000\u3000\u2514 plugin.php<br \/>\n\u2514 table-structure-with-copy.php<\/strong><br \/>\n<strong>\u3000\u2514 adminer.php\uff08\ud83d\udc48 \u5143\u304b\u3089\u3042\u308b adminer \u672c\u4f53\uff09<br \/>\n\u2514 index-with-plugins.php<\/strong><\/p>\n<p>\u203b \u65b0\u3057\u304f\u4f5c\u308b\u306e\u306f<code>plugins<\/code>\u30d5\u30a9\u30eb\u30c0\u3068\u305d\u306e\u4e2d\u306e\u30d5\u30a1\u30a4\u30eb\u3001\u305d\u3057\u3066<code>index-with-plugins.php<\/code>\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p>\u305d\u3057\u3066\u3001\u305d\u308c\u305e\u308c\u306e\u30d5\u30a1\u30a4\u30eb\u306e\u4e2d\u8eab\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p><strong>\/usr\/share\/adminer\/index-with-plugins.php<\/strong><\/p>\n<div>\n<pre><strong>function adminer_object() <\/strong><strong>{\r\n<\/strong>\r\n<strong>    include_once \".\/plugins\/plugin.php\";<\/strong>\r\n\r\n<strong>    foreach (glob(\".\/plugins\/*.php\") as $filename) {<\/strong>\r\n<strong>        include_once $filename;<\/strong>\r\n<strong>    }<\/strong>\r\n\r\n<strong>    $plugins = array(<\/strong>\r\n<strong>        new AdminerTableStructureWithCopy,<\/strong>\r\n<strong>    );<\/strong>\r\n\r\n<strong>    return new AdminerPlugin($plugins);\r\n<\/strong>\r\n<strong>}<\/strong>\r\n\r\n<strong>include \".\/adminer.php\"; \/\/ \u3082\u3057 latest.php \u3092\u4f7f\u3063\u3066\u3044\u308b\u5834\u5408\u306f\u305d\u3061\u3089\u306b\u5909\u66f4\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/strong><\/pre>\n<p><strong>\/usr\/share\/adminer\/plugins\/table-structure-with-copy.php<\/strong><\/p>\n<p>\u5148\u307b\u3069\u4f5c\u3063\u305f\u30d7\u30e9\u30b0\u30a4\u30f3\u300c<strong>AdminerTableStructureWithCopy<\/strong>\u300d\u306e\u4e2d\u8eab\u3092\u305d\u306e\u307e\u307e\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p><strong>\/usr\/share\/adminer\/plugins\/table-structure-with-copy.php<\/strong><\/p>\n<\/div>\n<p><code>zip<\/code>\u30d5\u30a1\u30a4\u30eb\u306e\u4e2d\u306b\u3042\u308b<code>plugins\/plugin.php<\/code>\u306e\u4e2d\u8eab\u3068\u540c\u3058\u3067<code>OK<\/code>\u3067\u3059\u3002<\/p>\n<p>\u306f\u3044\u2757\u3053\u308c\u3067\u3001\u4f5c\u696d\u306f\u3059\u3079\u3066\u7d42\u4e86\u3057\u307e\u3057\u305f\u3002<br \/>\n\u304a\u75b2\u308c\u69d8\u3067\u3057\u305f\ud83d\ude04\u2728<\/p>\n<h1>\u30c6\u30b9\u30c8\u3057\u3066\u307f\u308b<\/h1>\n<p>\u3067\u306f\u3001\u5b9f\u969b\u306b\u30c6\u30b9\u30c8\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u2757<\/p>\n<p>\u307e\u305a\u30d6\u30e9\u30a6\u30b6\u3067\u300c<strong>https:\/\/******\/index-with-plugins.php<\/strong>\u300d\u3078\u30a2\u30af\u30bb\u30b9\u3057\u3066\u30ed\u30b0\u30a4\u30f3\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>\u305d\u3057\u3066\u3001\u9069\u5f53\u306a\u30c6\u30fc\u30d6\u30eb\u69cb\u9020\u3092\u8868\u793a\u3059\u308b\u3068\u30fb\u30fb\u30fb\u30fb\u30fb\u30fb<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12138\" style=\"border: 3px solid #000;\" src=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2023\/11\/adminer_plugin_7.png\" alt=\"\" width=\"375\" height=\"279\" srcset=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2023\/11\/adminer_plugin_7.png 375w, https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2023\/11\/adminer_plugin_7-300x223.png 300w\" sizes=\"auto, (max-width: 375px) 100vw, 375px\" \/><\/p>\n<p>\u306f\u3044\uff01<br \/>\n\u958b\u767a\u4e2d\u3067\u3082\u78ba\u8a8d\u3057\u305f\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u304c\u8868\u793a\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>\u3067\u306f\u3001\u307e\u305a\u306f\u300c<code>user_id<\/code>\u300d\u306e\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u3092<code>ON<\/code>\u306b\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n<p>\u3069\u3046\u306a\u308b\u3067\u3057\u3087\u3046\u304b\u30fb\u30fb\u30fb\u30fb\u30fb\u30fb<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12139\" style=\"border: 3px solid #000;\" src=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2023\/11\/adminer_plugin_8.png\" alt=\"\" width=\"546\" height=\"456\" srcset=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2023\/11\/adminer_plugin_8.png 546w, https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2023\/11\/adminer_plugin_8-300x251.png 300w\" sizes=\"auto, (max-width: 546px) 100vw, 546px\" \/><\/p>\n<p>\u306f\u3044\uff01<br \/>\n\u30c6\u30ad\u30b9\u30c8\u30a8\u30ea\u30a2\u306e\u4e2d\u306b<code>user_id<\/code>\u304c\u5165\u3063\u3066\u3044\u3066\u3001\u3055\u3089\u306b\u30b3\u30d4\u30fc\u30dc\u30bf\u30f3\u3082\u8868\u793a\u306b\u306a\u308a\u307e\u3057\u305f\u3002<\/p>\n<p>\u3067\u306f\u3001\u8907\u6570\u306e\u30ab\u30e9\u30e0\u9078\u629e\u3068\u3001\u5168\u4f53\u9078\u629e\u3082\u8a66\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n<p><strong>\uff08\u8907\u6570\u9078\u629e\u306e\u5834\u5408\uff09<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12140\" style=\"border: 3px solid #000;\" src=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2023\/11\/adminer_plugin_9.png\" alt=\"\" width=\"374\" height=\"456\" srcset=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2023\/11\/adminer_plugin_9.png 374w, https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2023\/11\/adminer_plugin_9-246x300.png 246w\" sizes=\"auto, (max-width: 374px) 100vw, 374px\" \/><\/p>\n<p><strong>\uff08\u5168\u4f53\u9078\u629e\u306e\u5834\u5408\uff09<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12141\" style=\"border: 3px solid #000;\" src=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2023\/11\/adminer_plugin_10.png\" alt=\"\" width=\"371\" height=\"454\" srcset=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2023\/11\/adminer_plugin_10.png 371w, https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2023\/11\/adminer_plugin_10-245x300.png 245w\" sizes=\"auto, (max-width: 371px) 100vw, 371px\" \/><\/p>\n<p>\u306f\u3044\uff01<br \/>\n\u3046\u307e\u304f\u3044\u304d\u307e\u3057\u305f\u3002<\/p>\n<p>\u3067\u306f\u3001\u6700\u5f8c\u306b\u300c<strong>Copy to clipboard<\/strong>\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u30b3\u30d4\u30da\u3067\u304d\u308b\u304b\u30c1\u30a7\u30c3\u30af\u3057\u3066\u304a\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n<p>\u3046\u307e\u304f\u3044\u304f\u3067\u3057\u3087\u3046\u304b\u30fb\u30fb\u30fb\u30fb\u30fb\u30fb<\/p>\n<p><strong>\uff08\u5b9f\u969b\u306e\u30b3\u30d4\u30da\uff09<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12142\" style=\"border: 3px solid #000;\" src=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2023\/11\/adminer_plugin_11.png\" alt=\"\" width=\"310\" height=\"101\" srcset=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2023\/11\/adminer_plugin_11.png 310w, https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2023\/11\/adminer_plugin_11-300x98.png 300w\" sizes=\"auto, (max-width: 310px) 100vw, 310px\" \/><\/p>\n<p>\u306f\u3044\u2757<br \/>\n\u300c<strong>\u30b3\u30d4\u30fc\u3067\u304d\u305f\u3088<\/strong>\u300d\u30e1\u30c3\u30bb\u30fc\u30b8\u304c\u8868\u793a\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n<p>\u305d\u3057\u3066\u3001\u5b9f\u969b\u306e\u30b3\u30d4\u30da\u306f\u4ee5\u4e0b\u306b\u306a\u308a\u307e\u3059\u3002<br \/>\n\u2193\u2193\u2193<\/p>\n<p><strong>id,<\/strong><br \/>\n<strong>user_id,<\/strong><br \/>\n<strong>message,<\/strong><br \/>\n<strong>created_at,<\/strong><br \/>\n<strong>updated_at,<\/strong><\/p>\n<p>\u3059\u3079\u3066\u6210\u529f\u3067\u3059\ud83d\ude04\u2728<\/p>\n<h1>\u304a\u307e\u3051\uff1a \u4fbf\u5229\u306a\u300cAdminerTablesFilter\u300d\u3082\u304a\u3059\u3059\u3081\u3067\u3059<\/h1>\n<p><code>adminer<\/code>\u306b\u306f\u3059\u3067\u306b\u305f\u304f\u3055\u3093\u306e\u30d7\u30e9\u30b0\u30a4\u30f3\u304c\u5b58\u5728\u3057\u3066\u3044\u3066\u3001\u300c<strong>\u3053\u308c\u521d\u671f\u72b6\u614b\u3067\u6709\u52b9\u306b\u3057\u3066\u3082\u3044\u3044\u3093\u3058\u3083\u306a\u3044\uff1f\uff1f\ud83e\udd14<\/strong>\u300d\u3068\u3044\u3046\u4fbf\u5229\u306a\u3082\u306e\u3082\u3042\u3063\u305f\u308a\u3057\u307e\u3059\u3002<\/p>\n<p>\u305d\u3057\u3066\u3001\u305d\u306e\u4e2d\u3067\u3082\u304a\u3059\u3059\u3081\u306a\u306e\u304c\u300c<strong>AdminerTablesFilter<\/strong>\u300d\u3067\u3059\u3002<\/p>\n<p>\u305d\u306e\u540d\u306e\u3054\u3068\u304f\u30c6\u30fc\u30d6\u30eb\u540d\u3067\u30d5\u30a3\u30eb\u30bf\u30fc\u3092\u304b\u3051\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3082\u306e\u3067\u3059\u304c\u5b9f\u969b\u306e\u4f8b\u3067\u8a00\u3046\u3068\u3001\u901a\u5e38\u306a\u3089<code>adminer<\/code>\u306e\u30da\u30fc\u30b8\u5de6\u30e1\u30cb\u30e5\u30fc\u306b\u306f\u30c6\u30fc\u30d6\u30eb\u4e00\u89a7\u304c\u8868\u793a\u3055\u308c\u308b\u3060\u3051\u3067\u7279\u5225\u306a\u6a5f\u80fd\u304c\u3042\u308b\u308f\u3051\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12136\" style=\"border: 3px solid #000;\" src=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2023\/11\/adminer_plugin_5.png\" alt=\"\" width=\"286\" height=\"240\" \/><\/p>\n<p>\u3057\u304b\u3057\u3001\u958b\u767a\u304c\u9032\u3093\u3067\u30c6\u30fc\u30d6\u30eb\u306e\u6570\u304c\u591a\u304f\u306a\u3063\u3066\u3057\u307e\u3063\u305f\u5834\u5408\u306f\u3069\u3046\u3067\u3057\u3087\u3046\u304b\u3002<\/p>\n<p>\u305d\u3046\u3067\u3059\u3002\u3081\u3061\u3083\u304f\u3061\u3083\u76ee\u7684\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u63a2\u3059\u306e\u304c\u3081\u3093\u3069\u3046\u306b\u306a\u308a\u307e\u3059\u3088\u306d\u3002\uff08\u79c1\u306f\u3088\u304f<code>Ctrl + F<\/code>\u3067\u691c\u7d22\u3057\u3066\u3044\u307e\u3059\uff09<\/p>\n<p><code>AdminerTablesFilter<\/code>\u306f\u3001\u3053\u3053\u306b\u691c\u7d22\u30dc\u30c3\u30af\u30b9\u3092\u8868\u793a\u3057\u30ad\u30fc\u30ef\u30fc\u30c9\u306b\u95a2\u9023\u3059\u308b\u30c6\u30fc\u30d6\u30eb\u3060\u3051\u8868\u793a\u3057\u3066\u304f\u308c\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12137\" style=\"border: 3px solid #000;\" src=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2023\/11\/adminer_plugin_6.png\" alt=\"\" width=\"290\" height=\"100\" \/><\/p>\n<p>\u305d\u3053\u3067\u2757<br \/>\n\u305b\u3063\u304b\u304f\u3067\u3059\u306e\u3067\u3001\u3053\u306e\u30d5\u30a3\u30eb\u30bf\u30fc\u3082\u4f7f\u3048\u308b\u3088\u3046\u306b\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n<p>\u624b\u9806\u3068\u3057\u3066\u306f\u5148\u307b\u3069\u3068\u540c\u3058\u3067<code>\/usr\/share\/adminer\/plugins<\/code>\u30d5\u30a9\u30eb\u30c0\u306e\u4e2d\u306b<code>zip<\/code>\u30d5\u30a1\u30a4\u30eb\u306e\u4e2d\u306b\u3042\u3063\u305f<code>plugins\/tables-filter.php<\/code>\u3092\u30b3\u30d4\u30fc\u3057\u3066\u30d7\u30e9\u30b0\u30a4\u30f3\u3092\u6709\u52b9\u306b\u3059\u308b\u3060\u3051\u3067\u3059\u3002<\/p>\n<div>\n<pre>function adminer_object()\r\n{\r\n\r\n    include_once \".\/plugins\/plugin.php\";\r\n\r\n    foreach (glob(\".\/plugins\/*.php\") as $filename) {\r\n        include_once $filename;\r\n    }\r\n\r\n    $plugins = array(\r\n        <strong>new AdminerTablesFilter, \/\/ \ud83d\udc48 \u3053\u3053\u3092\u8ffd\u52a0<\/strong>\r\n        new AdminerTableStructureWithCopy,\r\n    );\r\n\r\n    return new AdminerPlugin($plugins);\r\n\r\n}\r\n\r\ninclude \".\/adminer.php\";<\/pre>\n<\/div>\n<p>\u3053\u308c\u3067\u307e\u305f\u300c\u3088\u308a\u52b9\u7387\u7684\u306a\u300d\u958b\u767a\u304c\u3067\u304d\u308b\u3093\u3058\u3083\u306a\u3044\u3067\u3057\u3087\u3046\u304b\u3002<\/p>\n<h1>\u4f01\u696d\u69d8\u3078\u306e\u3054\u63d0\u6848<\/h1>\n<p>\u3082\u3061\u308d\u3093\u5165\u529b\u30c1\u30a7\u30c3\u30af\uff08\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\uff09\u304c\u304d\u3061\u3093\u3068\u3057\u3066\u3044\u306a\u3044\u3068\u3044\u3051\u306a\u3044\u5834\u5408\u304c\u307b\u3068\u3093\u3069\u3067\u3057\u3087\u3046\u304c\u3001\u4e2d\u306b\u306f\u300c\u305d\u308c\u307b\u3069\u6c17\u69cb\u3048\u305b\u305a\u306b\u4f7f\u3063\u3066\u3082\u3044\u3044\u30b7\u30b9\u30c6\u30e0\u300d\u3082\u3042\u3063\u305f\u308a\u3059\u308b\u3068\u601d\u3044\u307e\u3059\u3002\uff08\u4f8b\u3048\u3070\u30ed\u30fc\u30ab\u30eb\u74b0\u5883\u306e\u307f\u306e\u30b7\u30b9\u30c6\u30e0\u306a\u3069\uff09<\/p>\n<p>\u305d\u3093\u306a\u5834\u5408\u306f\u3001\u30a6\u30a7\u30d6\u30b7\u30b9\u30c6\u30e0\u3092\u4f5c\u6210\u305b\u305a<code>adminer<\/code>\u3092\u4f7f\u3063\u3066\u30c7\u30fc\u30bf\u7ba1\u7406\u3059\u308b\u3053\u3068\u3082\u9078\u629e\u80a2\u306e\u3072\u3068\u3064\u306b\u3057\u3066\u3082\u3044\u3044\u304b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<p>\u3082\u3057\u305d\u3093\u306a\u5834\u5408\u306f<code>adminer<\/code>\u306e\u30ab\u30b9\u30bf\u30de\u30a4\u30ba\u3082\u53ef\u80fd\u3067\u3059\u306e\u3067\u3001\u305d\u3093\u306a\u5834\u5408\u306f\u305c\u3072\u304a\u554f\u3044\u5408\u308f\u305b\u304b\u3089\u3054\u76f8\u8ac7\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>\u304a\u5f85\u3061\u3057\u3066\u304a\u308a\u307e\u3059\u3002\ud83d\ude04\u2728<\/p>\n<h1>\u304a\u308f\u308a\u306b<\/h1>\n<p>\u3068\u3044\u3046\u3053\u3068\u3067\u3001\u4eca\u56de\u306f\u3044\u3064\u3082\u3068\u306f\u3061\u3087\u3063\u3068\u9055\u3046<code>adminer<\/code>\u306e\u30d7\u30e9\u30b0\u30a4\u30f3\u3092\u30c6\u30fc\u30de\u306b\u3057\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n<p>\u6b63\u76f4\u306a\u3068\u3053\u308d<code>PHP<\/code>\u306e\u30b3\u30fc\u30c9\u3092\u898b\u308b\u3068\u3001<code>echo<\/code>\u3067<code>HTML<\/code>\u30bf\u30b0\u3092\u8868\u793a\u3059\u308b\u306a\u3069\u6614\u3084\u3063\u3066\u3044\u305f\u3088\u3046\u306a\u30b3\u30fc\u30c9\u3060\u3063\u305f\u306e\u3067\u3059\u3054\u3044\u61d0\u304b\u3057\u304b\u3063\u305f\u3067\u3059\u3002<\/p>\n<p>\u307e\u305f\u3001<code>JavaScript<\/code>\u306e\u30b3\u30fc\u30c9\u3082\u4eca\u56de\u306f\u4e00\u5207\u30d5\u30ec\u30fc\u30e0\u30ef\u30fc\u30af\u3092\u4f7f\u3063\u3066\u3044\u307e\u305b\u3093\u304c\u3001\u611f\u60f3\u3068\u3057\u3066\u306f\u300c<code>JavaScript\u672c\u4f53\u304c\u9032\u5316\u3057\u3066\u3044\u3066\u3001\u30d0\u30cb\u30e9\u3067\u3082\u76f8\u5f53\u4f7f\u3048\u308b\u2757<\/code>\u300d\u3068\u3044\u3046\u3082\u306e\u3067\u3057\u305f\u3002<\/p>\n<p>\u307e\u305f\u3001<code>CSS<\/code>\u306f\u8d85\u6700\u65b0\u306e<code>form-sizing:content<\/code>\uff08\u30c6\u30ad\u30b9\u30c8\u30a8\u30ea\u30a2\u306e\u884c\u6570\u304c\u5897\u3048\u305f\u3089\u81ea\u52d5\u7684\u306b\u9ad8\u3055\u3092\u5408\u308f\u305b\u3066\u304f\u308c\u308b\u6a5f\u80fd\uff09\u3092\u4f7f\u3063\u3066\u307f\u307e\u3057\u305f\u304c\u3001\u307e\u3060<code>Chrome<\/code>\u304c\u5bfe\u5fdc\u3057\u3066\u306a\u3044\u3088\u3046\u3067\u3057\u305f\u3002\ud83d\ude2d<\/p>\n<p>\u3061\u306a\u307f\u306b\u3001<code>adminer<\/code>\u306f\u672c\u756a\u74b0\u5883\uff08\u30a6\u30a7\u30d6\u4e0a\u306b\u516c\u958b\u3055\u308c\u308b\u30b7\u30b9\u30c6\u30e0\uff09\u3068\u3057\u3066\u306f\u5c11\u3057\u7269\u8db3\u308a\u306a\u3044\u30a4\u30e1\u30fc\u30b8\u3082\u3042\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u304c\u3001\u958b\u767a\u306b\u4f7f\u3046\u306a\u3089\u3068\u3066\u3082\u4fbf\u5229\u3067\u3001\u306a\u306b\u3088\u308a\uff11\u30d5\u30a1\u30a4\u30eb\u3060\u3051\u306a\u306e\u3067\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u304c\u7c21\u5358\u3068\u3044\u3046\u5927\u304d\u306a\u30e1\u30ea\u30c3\u30c8\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>\u79c1\u3082\u9577\u304f<code>PhpMyAdmin<\/code>\u3084\u305d\u306e\u4ed6\u30c4\u30fc\u30eb\u3092\u4f7f\u3063\u3066\u3044\u307e\u3057\u305f\u304c\uff08\u6700\u8fd1\u306f<code>IDE<\/code>\u306b\u3082\u540c\u68b1\u3055\u308c\u3066\u305f\u308a\u3057\u307e\u3059\u3088\u306d \ud83e\udd14\uff09\u3001\u500b\u4eba\u7684\u306a\u597d\u307f\u3067\u306f<code>adminer<\/code>\u304c\uff11\u756a\u3067\u3057\u305f\u3002<\/p>\n<p>\u307f\u306a\u3055\u3093\u3082\u3054\u81ea\u8eab\u306e\uff11\u756a\u3092\u898b\u3064\u3051\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u306d\u3002<\/p>\n<p>\u3067\u306f\u3067\u306f\u301c\u2757<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6068 aligncenter\" src=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2020\/03\/no_12.png\" alt=\"\" width=\"226\" height=\"320\" srcset=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2020\/03\/no_12.png 226w, https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2020\/03\/no_12-212x300.png 212w\" sizes=\"auto, (max-width: 226px) 100vw, 226px\" \/>\u300c<strong>\u30d5\u30ec\u30fc\u30e0\u30ef\u30fc\u30af\u306e<\/strong><br \/>\n<strong>\u79c1\u306e\uff11\u756a\u306f\u3001\u3084\u3063\u3071\u308a<\/strong><br \/>\n<strong>Laravel\u3067\u3059\u306d<\/strong>\ud83d\udc4d\u300d<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3055\u3066\u3055\u3066\u3001\u3053\u308c\u306f\u500b\u4eba\u3067\u9055\u3063\u3066\u304f\u308b\u3068\u601d\u3044\u307e\u3059\u304c\u3001\u958b\u767a\u8005\u306e\u7686\u3055\u3093\u306f\u305d\u308c\u305e\u308c\u300c\u304a\u6c17\u306b\u5165\u308a\u306e\u958b\u767a\u30c4\u30fc\u30eb\u300d\u307f\u305f\u3044\u306a\u3082\u306e\u304c\u6c7a\u307e\u3063\u3066\u3044\u308b\u3068\u601d\u3044\u307e\u3059\u3002 \u4f8b\u3048\u3070\u3001\u79c1\u306e\u5834\u5408\u3067\u3057\u305f\u3089 &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/blog.capilano-fw.com\/?p=12131\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;adminer \u306e\u72ec\u81ea\u30d7\u30e9\u30b0\u30a4\u30f3\u3092\u3064\u304f\u308b\u65b9\u6cd5&#8221; \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":12146,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[256],"class_list":["post-12131","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-2","tag-adminer"],"_links":{"self":[{"href":"https:\/\/blog.capilano-fw.com\/index.php?rest_route=\/wp\/v2\/posts\/12131","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.capilano-fw.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.capilano-fw.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.capilano-fw.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.capilano-fw.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12131"}],"version-history":[{"count":5,"href":"https:\/\/blog.capilano-fw.com\/index.php?rest_route=\/wp\/v2\/posts\/12131\/revisions"}],"predecessor-version":[{"id":12148,"href":"https:\/\/blog.capilano-fw.com\/index.php?rest_route=\/wp\/v2\/posts\/12131\/revisions\/12148"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.capilano-fw.com\/index.php?rest_route=\/wp\/v2\/media\/12146"}],"wp:attachment":[{"href":"https:\/\/blog.capilano-fw.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.capilano-fw.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12131"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.capilano-fw.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}