{"id":695,"date":"2023-11-23T23:59:26","date_gmt":"2023-11-23T14:59:26","guid":{"rendered":"https:\/\/web.cloudfree.jp\/journal\/?p=695"},"modified":"2023-11-28T12:34:04","modified_gmt":"2023-11-28T03:34:04","slug":"695-2","status":"publish","type":"post","link":"https:\/\/web.cloudfree.jp\/journal\/695-2\/","title":{"rendered":"\u30d7\u30e9\u30b0\u30a4\u30f3XYZ PHP Code\u3068\u30ab\u30b9\u30bf\u30e0\u30d5\u30a3\u30fc\u30eb\u30c9\u3092\u7528\u3044\u3066DB-table\u30d6\u30ed\u30c3\u30af"},"content":{"rendered":"

\u30d7\u30e9\u30b0\u30a4\u30f3XYZ PHP Code\u3068\u30ab\u30b9\u30bf\u30e0\u30d5\u30a3\u30fc\u30eb\u30c9\u3092\u7528\u3044\u3066DB-table\u30d6\u30ed\u30c3\u30af<\/h3>\n\n\n

2023-11-23 \u8a18\u8f09
\u6982\u8981 : \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u5024\u3092\u697d\u306b\u304d\u308c\u3044\u306btable\u8868\u8a18\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u307e\u3057\u305f
Keyword : XYZ PHP Code, SQL, table\u30bf\u30b0, \u30ab\u30b9\u30bf\u30e0\u30d5\u30a3\u30fc\u30eb\u30c9, PDO, <\/p>\n\n\n\n

\u30d6\u30ed\u30c3\u30af\u30a8\u30c7\u30a3\u30bf\u306e\u30c6\u30fc\u30d6\u30eb\u304c\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u30d5\u30ec\u30f3\u30c9\u30ea\u30fc\u3067\u306f\u306a\u3044\u306e\u3067\u3001\u81ea\u4f5cPHP\u3067\u5bfe\u51e6\u3057\u307e\u3057\u305f\u3002\u30d7\u30e9\u30b0\u30a4\u30f3XYZ PHP Code\u3092\u4f7f\u3044\u307e\u3059\u3002

\u7ba1\u7406\u753b\u9762 XYZ PHP Code \u30e1\u30cb\u30e5\u30fc\u3088\u308a PHP Code Snippets
[Add New PHP Code Snippet]
\u3067
DBRTagTable
\u3092\u4f5c\u6210\u3002
\u30b3\u30fc\u30c9\u306f\u4ee5\u4e0b\u306e\u307f\u3002
\u203b\u3053\u306e\u30c6\u30ad\u30b9\u30c8\u30a8\u30ea\u30a2\u5185\u3067\u306f\u30b3\u30fc\u30c9\u7de8\u96c6\u304c\u4e0d\u4fbf\u306a\u306e\u3067\u5225\u30d5\u30a1\u30a4\u30eb\u306b\u8a18\u8ff0\u3002
VSCode\u3067\u7de8\u96c6\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

<?php\nrequire $_SERVER['DOCUMENT_ROOT'].'\/yourfolder\/dbrtagtable.php';<\/code><\/pre><\/div>\n\n\n\n
dbrtagtable.php \u306e\u5185\u5bb9\u306f\u4ee5\u4e0b\u3002<\/p>\n\n\n\n
<?php\nmb_language('Japanese');\nmb_internal_encoding('UTF-8');\ndate_default_timezone_set('Asia\/Tokyo');\nsetlocale(LC_ALL, 'ja_JP.UTF-8');\n\n$mode = '';\n$output = '';\n\n\/\/\u56fa\u5b9a\u30da\u30fc\u30b8\u306e\u30ab\u30b9\u30bf\u30e0\n$custom_key = 'xyz_param'.get_the_ID();\nif (!isset(get_post_custom()[$custom_key])) {\n    echo <<<EOT\n<pre>    \n\u30ab\u30b9\u30bf\u30e0\u30d5\u30a3\u30fc\u30eb\u30c9 xyz_param+\u6295\u7a3fID \u3092\u8a2d\u5b9a\u3057\u3066\u304f\u3060\u3055\u3044\n\u5024\uff1a(SQL)\nselect * from t_test where \u4fa1\u683c > 200;\n\u5024\uff1a(CSV)\n1,\u4e3b\u98df,\u767d\u3054\u306f\u3093,200\n2,\u6c41\u7269,\u5b63\u7bc0\u306e\u5473\u564c\u6c41,80\n3,\u4e3b\u98df,\u304b\u3084\u304f\u3054\u98ef,250\n\u5024\uff1a(TSV)\n1\t\u4e3b\u98df\t\u767d\u3054\u306f\u3093\t200\n2\t\u6c41\u7269\t\u5b63\u7bc0\u306e\u5473\u564c\u6c41\t80\n3\t\u4e3b\u98df\t\u304b\u3084\u304f\u3054\u98ef\t250\n\u5024\uff1a(HTML)\n<table>\u2026\u2026<\/table>\n<\/pre>\nEOT;\n    return;\n}\n$xyz_param1 = get_post_custom()[$custom_key][0];\n\nif (strpos($xyz_param1, 'select') === 0 || strpos($xyz_param1, 'with') === 0) {\n    $mode = 'SQL';\n    $sth = $wpdb->prepare($xyz_param1);\n    $sth->execute();\n    $output .= '<table><tr>';\n    for($col = 0; $col < $sth->columnCount(); $col++) {\n        $output .= '<th>'.$sth->getColumnMeta($col)['name'].'<\/th>';\n    }\n    $output .= '<\/tr>';\n    $result = $sth->fetchAll(PDO::FETCH_ASSOC);\n    foreach($result as $rec) {\n        $output .= '<tr>';\n        foreach($rec as $col) {\n            $output .= "<td>$col<\/td>";\n        }\n        $output .= '<\/tr>';\n    }\n    $output .= '<\/table>';\n} else if (strpos($xyz_param1, ',') !== false) {\n    $mode = 'CSV';\n    $output = str_replace(',', '<\/td><td>', $xyz_param1); \n} else if (strpos($xyz_param1, "\\t") !== false) {\n    $mode = 'TSV';\n    $output = str_replace("\\t", '<\/td><td>', $xyz_param1);\n} else {\n    $mode = 'HTML';\n    $output = '<style>.xyz-table001 td, .xyz-table001 th ';\n    $output .= '{ border: 1px solid #ccc; padding: 2px 16px;} ';\n    $output .= ' .xyz-table001 th { background-color: #ccc}<\/style>';\n    $output .= str_replace('<table>', '<table class="xyz-table001">', $xyz_param1);\n}\n\nif ($mode == 'CSV' || $mode == 'TSV') {\n    $output = str_replace("\\r\\n", '<\/td><\/tr><tr><td>', $output);\n    $output = '<table><tr><td>'.$output.'<\/tr><\/table>';\n    $output = str_replace('<tr><td><\/tr>', '', $output);\n}\nif ($mode != 'HTML') {\n    $output = htmlspecialchars($output);\n}\n\necho $output;<\/code><\/pre><\/div>\n\n\n\n
\u30ab\u30b9\u30bf\u30e0\u30d5\u30a3\u30fc\u30eb\u30c9\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\u540d\u524d\u306f xyz_param+\u6295\u7a3fID (post.php?post=695 \u306a\u3089 xyz_param695)
\u5024\u306f (\u6700\u521d\u306fSQL\u6587)
select * , RANK() over (PARTITION by \u533a\u5206 ORDER by \u4fa1\u683c) as \u5b89\u3044\u9806 from t_test;

\u6295\u7a3f\u6587\u306b\u30b9\u30cb\u30da\u30c3\u30c8 (\u2193\u5909\u63db\u3055\u308c\u306a\u3044\u3088\u3046\u306b\u3053\u308c\u306f\u5168\u89d2\u6587\u5b57\u30d6\u30e9\u30b1\u30c3\u30c8\u3067\u3059)
\uff3bxyz-ips snippet=”DBRTagTable”\uff3d
\u3092\u8a18\u8ff0\u3002<\/p>\n\n\n\n
\u30d7\u30ec\u30d3\u30e5\u30fc\u3092\u3068\u308a\u307e\u3059\u3068table\u306eHTML\u6587\u304c\u51fa\u529b\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
HTML\u6587\u3092\u307e\u308b\u3054\u3068\u30b3\u30d4\u30fc\u3057\u3066\u3001\u30ab\u30b9\u30bf\u30e0\u30d5\u30a3\u30fc\u30eb\u30c9 xyz_param1 \u306e\u5024\u3001SQL\u6587\u3092\u4e0a\u66f8\u304d\u3059\u308b\u3088\u3046\u306b\u30da\u30fc\u30b9\u30c8\u3057\u307e\u3059\u3002<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\u3075\u305f\u305f\u3073\u30d7\u30ec\u30d3\u30e5\u30fc\u3092\u3068\u308a\u307e\u3059\u3068<\/p>\n\n\n