{"id":3979,"date":"2020-09-28T00:07:07","date_gmt":"2020-09-27T15:07:07","guid":{"rendered":"https:\/\/www.programming-se.com\/?p=3979"},"modified":"2020-09-28T00:09:07","modified_gmt":"2020-09-27T15:09:07","slug":"php-%e3%83%87%e3%83%bc%e3%82%bf%e3%83%99%e3%83%bc%e3%82%b9%e3%82%92%e5%88%a9%e7%94%a8%e3%81%97%e3%81%9fweb%e3%82%a2%e3%83%97%e3%83%aa%e3%82%b1%e3%83%bc%e3%82%b7%e3%83%a7%e3%83%b3%e3%81%ae%e9%96%8b-5","status":"publish","type":"post","link":"https:\/\/www.programming-se.com\/?p=3979","title":{"rendered":"PHP \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u5229\u7528\u3057\u305fWeb\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u958b\u767a\u3010\u7b2c\u4e94\u56de\u3011\u30c7\u30fc\u30bf\u306e\u524a\u9664 delete"},"content":{"rendered":"\n

\u3010\u7b2c\u4e09\u56de\u3011\u3067\u4f5c\u6210\u3057\u305f\u4e00\u89a7\u30da\u30fc\u30b8\u306b\u3001\u524a\u9664\u30dc\u30bf\u30f3\u3092\u8a2d\u7f6e\u3057\u307e\u3057\u305f\u304c\u3001\u4eca\u56de\u300c\u524a\u9664\u300d\u30dc\u30bf\u30f3\u306b\u30c7\u30fc\u30bf\u524a\u9664\u306e\u6a5f\u80fd\u3092\u5b9f\u88c5\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

<\/figure>
PHP \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u5229\u7528\u3057\u305fWeb\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u958b\u767a\u3010\u7b2c\u4e09\u56de\u3011\u30c7\u30fc\u30bf\u306e\u4e00\u89a7\u8868\u793a...<\/div>
\u3010\u7b2c\u4e8c\u56de\u3011\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u4f1a\u54e1\u60c5\u5831\u3092\u767b\u9332\u3057\u307e\u3057\u305f\u3002\u4eca\u56de\u306f\u3001\u767b\u9332\u3057\u305f\u30c7\u30fc\u30bf\u3092\u4e00\u89a7\u8868\u793a\u3057\u3001\u7de8\u96c6\u7528\u306e\u753b\u9762\u3078\u306e\u30ea\u30f3\u30af\u3068\u524a\u9664\u7528\u306e\u30dc\u30bf\u30f3\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002\u4eca\u56de\u958b\u767a\u3059\u308bWeb\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3-\u30c7\u30e2\u4f1a\u54e1\u60c5\u5831\u4e00\u89a7\u30da\u30fc\u30b8\u3092HTML\u3067\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u3059\u308b\u4e00\u89a7\u30da\u30fc\u30b8\u306b\u63b2\u8f09\u3059\u308b\u5185\u5bb9\u306f\u4e0b\u8a18\u306e\u5185\u5bb9\u3067\u4f5c\u6210\u3057\u307e\u3059\u3002\u8a73\u7d30\uff08\u7de8\u96c6\uff09\u30da\u30fc\u30b8\u3078\u306e\u30dc\u30bf\u30f3\u540d\u524d\u5e74\u9f62\u524a\u9664\u30dc\u30bf\u30f3\u4e0a\u8a18\u4ee5\u5916\u306e\u9805\u76ee\u306f\u300c\u8a73\u7d30\uff08\u7de8\u96c6\uff09\u30da\u30fc\u30b8\u3078\u306e\u30dc\u30bf\u30f3\u300d\u304b\u3089\u78ba\u8a8d\u3067\u304d\u308b\u4ed5\u69d8\u3092\u60f3\u5b9a\u3057\u3066\u3044\u307e\u3059\u3002\u4f1a\u54e1\u60c5\u5831\u4e00\u89a7\u7528list.php\u306e\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u307e\u305a\u3001list.php \u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002\u8868\u793a\u3059\u308b\u4f1a\u54e1\u60c5\u5831\u306ftable\u3067\u8868...<\/div><\/div>
<\/div><\/div><\/a><\/div><\/div>\n\n\n\n
\n\n<\/div><\/div><\/div><\/div>
<\/svg><\/div>
\n

\u3053\u306e\u8a18\u4e8b\u306e\u8457\u8005 ->S.E;<\/strong> \u3067\u3059\u3002<\/p>\n\n\n\n

\u666e\u6bb5\u306f\u3001\u30b7\u30b9\u30c6\u30e0\u958b\u767a\u306b\u5fc5\u8981\u306a\u30d2\u30a2\u30ea\u30f3\u30b0\u3001\u30b7\u30b9\u30c6\u30e0\u306e\u8981\u4ef6\u5b9a\u7fa9\u3001\u8a2d\u8a08\u304b\u3089\u30d7\u30ed\u30b0\u30e9\u30de\u3068\u3057\u3066Web\u30b5\u30a4\u30c8\u3084Web\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u958b\u767a\u3001WordPress\u3067\u306e\u30d6\u30ed\u30b0\u306e\u57f7\u7b46\u3084\u30b5\u30fc\u30d0\u30fc\u904b\u7528\u30fb\u7ba1\u7406\u3092\u884c\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n

\u3053\u306e\u30da\u30fc\u30b8\u306f\u300c\u672a\u7d4c\u9a13\u306e\u70ba\u306e\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u8b1b\u5ea7 \u30bc\u30ed\u304b\u3089\u59cb\u3081\u308bPHP\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u301c\u521d\u7d1a\u304b\u3089\u5b9f\u8df5\u7de8\u307e\u3067\u3092\u7db2\u7f85\u301c<\/strong>\u300d\u3068\u3057\u3066PHP\u306e\u57fa\u672c\u7684\u306a\u90e8\u5206\u3092\u3010\u521d\u7d1a\u7de8\u3011\u3010\u4e2d\u7d1a\u7de8\u3011\u3010\u4e0a\u7d1a\u7de8\u3011\u306b\u5206\u3051\u3066\u89e3\u8aac\u3057\u3066\u3044\u307e\u3059\u3002\u6700\u7d42\u7684\u306b\u306f\u7c21\u5358\u306a\u30d5\u30a9\u30fc\u30e0\u3084\u30b7\u30b9\u30c6\u30e0\u958b\u767a\u3092\u30d5\u30eb\u30b9\u30af\u30e9\u30c3\u30c1\u3067\u884c\u3046\u3053\u3068\u3092\u76ee\u7684\u3068\u3057\u3066\u3044\u307e\u3059\u3002\u307e\u305f\u3001\u53c2\u8003\u306b\u306a\u308b\u66f8\u7c4d\u306a\u3069\u3082\u7d39\u4ecb\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div>\n\n\n\n

\n
\u4eca\u56de\u958b\u767a\u3059\u308bWeb\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u30c7\u30e2<\/a><\/div>\n<\/div>\n\n\n\n

\u4f1a\u54e1\u60c5\u5831\u4e00\u89a7\u30da\u30fc\u30b8\u306b\u524a\u9664\u6a5f\u80fd\u3092\u5b9f\u88c5\u3059\u308b<\/h2>\n\n\n\n

\u7b2c\u4e09\u56de\u3067\u4f5c\u6210\u3057\u305flist.php\u306f\u4ee5\u4e0b\u306e\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n

<?php\ninclude 'class.Member.php';\n\n$Member = new Member();\n\n\/\/ \u4f1a\u54e1\u60c5\u5831\u3092\u53d6\u5f97\n$memberData = $Member->getData();\n\n?><!DOCTYPE html>\n<html lang=\"ja\">\n<head>\n <meta charset=\"utf-8\">\n <title>\u4f1a\u54e1\u60c5\u5831\u4e00\u89a7<\/title>\n<\/head>\n<body>\n<header>\n <h1>\u4f1a\u54e1\u60c5\u5831\u4e00\u89a7<\/h1>\n<\/header>\n\n<section>\n\n <table>\n <tr>\n <th>\u8a73\u7d30<\/th>\n <th>\u4f1a\u54e1\u540d<\/th>\n <th>\u5e74\u9f62<\/th>\n <th>\u767b\u9332\u65e5<\/th>\n <th>\u66f4\u65b0\u65e5<\/th>\n <th>\u524a\u9664<\/th>\n <\/tr>\n<?php\nfor( $i = 0; $i < $memberData['rows']; $i++ ){\n?>\n <tr>\n <td><a href=\"edit.php?id=<?php echo $memberData['test_id'][$i];?>\">\u8a73\u7d30\u30fb\u7de8\u96c6<\/a><\/td>\n <td><?php echo $memberData['test_name'][$i];?><\/td>\n <td><?php echo $memberData['test_age'][$i];?>\u6b73<\/td>\n <td><?php echo $memberData['test_create'][$i];?><\/td>\n <td><?php echo $memberData['test_update'][$i];?><\/td>\n <td><a href=\"list.php?delete_id=<?php echo $memberData['test_id'][$i];?>\">\u524a\u9664<\/a><\/td>\n <\/tr>\n<?php\n}\n?>\n <\/table>\n\n<\/section>\n\n<\/body>\n<\/html><\/pre><\/div>\n\n\n\n
\u524a\u9664\u30dc\u30bf\u30f3\u306f\u3059\u3067\u306b\u8a18\u8ff0\u3057\u3066\u3044\u308b\u306e\u3067\u3001\u30af\u30ea\u30c3\u30af\u5f8c\u306e\u51e6\u7406\u90e8\u5206\u3092\u958b\u767a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n
\u524a\u9664\u6a5f\u80fd\u3092class.Member.php\u306b\u8ffd\u8a18\u3059\u308b<\/h2>\n\n\n\n
\u3067\u306f\u524a\u9664\u306e\u51e6\u7406\u3092\u30af\u30e9\u30b9\u30d5\u30a1\u30a4\u30eb\u306b\u8ffd\u8a18\u3057\u307e\u3059\u3002<\/p>\n\n\n\n
\u30d5\u30e9\u30b0\u3092\u5229\u7528\u3057\u305f\u524a\u9664\u65b9\u6cd5<\/h3>\n\n\n\n
\u4f1a\u54e1\u60c5\u5831\u3092\u767b\u9332\u3059\u308b\u30c6\u30fc\u30d6\u30eb\u306b\u306f\u300ctest_delete_key<\/strong>\u300d\u30ab\u30e9\u30e0\u3092\u7528\u610f\u3057\u3066\u3044\u307e\u3059\u3002\u901a\u5e38\u6642\u306f\u300c0<\/strong>\u300d\u3001\u524a\u9664\u6642\u306f\u300c1<\/strong>\u300d\u3068\u3057\u3066\u3044\u308b\u306e\u3067UPDATE\u6587\u3067\u300ctest_delete_key<\/strong>\u300d\u3092\u300c1\u300d\u306b\u66f4\u65b0\u3059\u308b\u3053\u3068\u3067\u3001\u30b7\u30b9\u30c6\u30e0\u4e0a\u524a\u9664\u3057\u305f\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n
<?php\n\/\/ class.DB\u3092\u30a4\u30f3\u30af\u30eb\u30fc\u30c9\ninclude 'class.DB.php';\n\n\/\/ DB\u30af\u30e9\u30b9\u3092\u7d99\u627f\u3057Member\u30af\u30e9\u30b9\u3092\u4f5c\u6210\nclass Member extends DB{\n\n \u301c\u7701\u7565\u301c\n\n public function deleteDB(){\n \n try{\n $PDO = parent::ConnectDB();\n\n $query = \"UPDATE test_table SET \";\n $query .= \" test_delete_key = 1 \";\n $query .= \"WHERE \";\n $query .= \"test_id = :test_id \";\n\n $stmt = $PDO->prepare($query);\n $stmt->bindValue(':test_id', self::getTestID(), PDO::PARAM_INT);\n $stmt->execute();\n\n return true;\n\n }\n catch( Exception $e ){\n\n echo $e->getMessage();\n exit();\n\n }\n }\n\n \u301c\u7701\u7565\u301c\n}\n?><\/pre><\/div>\n\n\n\n
DELETE\u6587\u3092\u5229\u7528\u3057\u305f\u524a\u9664\u65b9\u6cd5<\/h3>\n\n\n\n
UPDATE\u6587\u306b\u3088\u308a\u300ctest_delete_key\u300d\u3092\u300c1\u300d\u306b\u66f4\u65b0\u3057\u3001\u30b7\u30b9\u30c6\u30e0\u4e0a\u524a\u9664\u3057\u305f\u72b6\u614b\u3067\u3042\u3063\u3066\u3082\u60c5\u5831\u306f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u6b8b\u3063\u3066\u3044\u307e\u3059\u3002\u9593\u9055\u3063\u3066\u524a\u9664\u3057\u305f\u5834\u5408\u306a\u3069\u30c7\u30fc\u30bf\u3068\u5fa9\u65e7\u3059\u308b\u306e\u306f\u5bb9\u6613\u3067\u3059\u304c\u3001\u30b7\u30b9\u30c6\u30e0\u306e\u8981\u4ef6\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3088\u308a\u5b8c\u5168\u306b\u524a\u9664\u304c\u5fc5\u8981\u306a\u5834\u5408\u306f\u3001DELETE\u6587<\/span><\/strong>\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3088\u308a\u5b8c\u5168\u306b\u524a\u9664\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n
DELETE\u6587<\/strong>\u3092\u5229\u7528\u3057\u305f\u8a18\u8ff0\u306f\u4e0b\u8a18\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n
<?php\n\/\/ class.DB\u3092\u30a4\u30f3\u30af\u30eb\u30fc\u30c9\ninclude 'class.DB.php';\n\n\/\/ DB\u30af\u30e9\u30b9\u3092\u7d99\u627f\u3057Member\u30af\u30e9\u30b9\u3092\u4f5c\u6210\nclass Member extends DB{\n\n \u301c\u7701\u7565\u301c\n\n public function deleteDB(){\n \n try{\n $PDO = parent::ConnectDB();\n\n $query = \"DELETE FROM \";\n $query .= \" test_table \";\n $query .= \"WHERE \";\n $query .= \"test_id = :test_id \";\n\n $stmt = $PDO->prepare($query);\n $stmt->bindValue(':test_id', self::getTestID(), PDO::PARAM_INT);\n $stmt->execute();\n\n return true;\n\n }\n catch( Exception $e ){\n\n echo $e->getMessage();\n exit();\n\n }\n }\n\n \u301c\u7701\u7565\u301c\n}\n?><\/pre><\/div>\n\n\n\n
HTML\uff08list.php\uff09\u306b\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u57cb\u3081\u8fbc\u3080<\/h2>\n\n\n\n
\u524a\u9664\u7528\u306e\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u30af\u30e9\u30b9\u306b\u8ffd\u52a0\u3057\u305f\u306e\u3067\u3001\u524a\u9664\u3092\u5b9f\u884c\u3059\u308b\u305f\u3081\u306e\u30b9\u30af\u30ea\u30d7\u30c8\u3092list.php\u306b\u57cb\u3081\u8fbc\u307f\u307e\u3059\u3002<\/p>\n\n\n\n
\u6ce8\u610f\u70b9\u306f\u524a\u9664\u7528\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u884c\u3046\u3053\u3068\u3067\u3059\u3002
\u4e00\u89a7\u53d6\u5f97\u7528\u306e\u3082\u306e\u3068\u540c\u3058\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u5229\u7528\u3059\u308b\u3068setTestID<\/strong>\u306bID\u3092\u30bb\u30c3\u30c8\u3057\u3066\u3057\u307e\u3046\u306e\u3067\u4e00\u89a7\u306e\u60c5\u5831\u304c\u53d6\u5f97\u3067\u304d\u307e\u305b\u3093\u3002\u53d6\u5f97\u3059\u308b\u305f\u3081\u306b\u3001\u524a\u9664\u90e8\u5206\u3088\u308a\u4e0a\u90e8\u306bgetData<\/strong>\u3092\u6301\u3063\u3066\u304f\u308b\u3068\u3001\u4eca\u5ea6\u306f\u3001\u524a\u9664\u524d\u306e\u72b6\u614b\u306e\u4e00\u89a7\u3092\u53d6\u5f97\u3059\u308b\u305f\u3081\u3001\u524a\u9664\u3057\u305f\u4f1a\u54e1\u60c5\u5831\u3082\u53d6\u5f97\u3057\u4e00\u89a7\u306b\u63b2\u8f09\u3057\u3066\u3057\u307e\u3044\u307e\u3059\u3002<\/p>\n\n\n\n
<?php\ninclude 'class.Member.php';\n\n\nif( isset($_GET['delete_id']) ){\n \n $MemberDelete = new Member();\n \n $mes = '';\n $MemberDelete->setTestID($_GET['delete_id']);\n if( $MemberDelete->deleteDB() ){\n $mes = '\u4f1a\u54e1\u3092\u524a\u9664\u3057\u307e\u3057\u305f\u3002';\n }\n else{\n $mes = '\u4f1a\u54e1\u306e\u524a\u9664\u306b\u5931\u6557\u3057\u307e\u3057\u305f\u3002';\n }\n}\n\n$Member = new Member();\n\n\/\/ \u4f1a\u54e1\u60c5\u5831\u3092\u53d6\u5f97\n$memberData = $Member->getData();\n\n?><!DOCTYPE html>\n<html lang=\"ja\">\n<head>\n <meta charset=\"utf-8\">\n <title>\u4f1a\u54e1\u60c5\u5831\u4e00\u89a7<\/title>\n<\/head>\n<body>\n<header>\n <h1>\u4f1a\u54e1\u60c5\u5831\u4e00\u89a7<\/h1>\n<\/header>\n\n<section>\n\n<?php\nif( $mes ){\n echo '<p>'.$mes.'<\/p>'; \n}\n?>\n <table>\n <tr>\n <th>\u8a73\u7d30<\/th>\n <th>\u4f1a\u54e1\u540d<\/th>\n <th>\u5e74\u9f62<\/th>\n <th>\u767b\u9332\u65e5<\/th>\n <th>\u66f4\u65b0\u65e5<\/th>\n <th>\u524a\u9664<\/th>\n <\/tr>\n<?php\nfor( $i = 0; $i < $memberData['rows']; $i++ ){\n?>\n <tr>\n <td><a href=\"edit.php?id=<?php echo $memberData['test_id'][$i];?>\">\u8a73\u7d30\u30fb\u7de8\u96c6<\/a><\/td>\n <td><?php echo $memberData['test_name'][$i];?><\/td>\n <td><?php echo $memberData['test_age'][$i];?>\u6b73<\/td>\n <td><?php echo $memberData['test_create'][$i];?><\/td>\n <td><?php echo $memberData['test_update'][$i];?><\/td>\n <td><a href=\"list.php?delete_id=<?php echo $memberData['test_id'][$i];?>\">\u524a\u9664<\/a><\/td>\n <\/tr>\n<?php\n}\n?>\n <\/table>\n\n<\/section>\n\n<\/body>\n<\/html><\/pre><\/div>\n\n\n\n
\u4eca\u56de\u306f\u3001\u51e6\u7406\u7d50\u679c\u3092 echo \u3057 exit \u3059\u308b\u306e\u3067\u306f\u306a\u304f\u3001$mes \u306b\u51e6\u7406\u7d50\u679c\u3092\u4ee3\u5165\u3057\u3001\u4e00\u89a7\u30da\u30fc\u30b8\u306e\u4e0a\u90e8\u306b\u8868\u793a\u3059\u308b\u4ed5\u69d8\u3067\u4f5c\u6210\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n\n
\n\t
\n\t\t
\n\t\t\t\t\t\t\t<\/a>\t\t\t\t\t<\/div>\n\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t\t\u4f53\u7cfb\u7684\u306b\u5b66\u3076 \u5b89\u5168\u306aWeb\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u4f5c\u308a\u65b9 \u7b2c2\u7248 \u8106\u5f31\u6027\u304c\u751f\u307e\u308c\u308b\u539f\u7406\u3068\u5bfe\u7b56\u306e\u5b9f\u8df5 [ \u5fb3\u4e38 \u6d69 ]<\/a>\t\t\t\t\t\t\t<\/div>\n\t\t\t
\n\t\t\t\t\t\t\t
created by Rinker<\/a><\/div>\n\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t
\n\t\t\t\t\tWeb\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306b\u306f\u306a\u305c\u8106\u5f31\u6027\u304c\u751f\u307e\u308c\u308b\u306e\u304b?\r\n\u8106\u5f31\u6027\u3092\u89e3\u6d88\u3059\u308b\u306b\u306f\u3069\u3046\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u3059\u308c\u3070\u3088\u3044\u304b?\r\nPHP\u30b5\u30f3\u30d7\u30eb\u3078\u306e\u653b\u6483\u3092\u901a\u3057\u3066\u8106\u5f31\u6027\u304c\u751f\u307e\u308c\u308b\u539f\u7406\u3068\u5177\u4f53\u7684\u306a\u5bfe\u51e6\u65b9\u6cd5\u304c\u5b66\u3079\u308b! \t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t