\u3053\u308c\u3067HTML\u306e\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u306f\u5b8c\u4e86\u3067\u3059\u3002<\/p>\n\n\n\n
\u524d\u56de\u3001\u4f1a\u54e1\u60c5\u5831\u3092\u767b\u9332\u3059\u308b\u305f\u3081\u306e\u30af\u30e9\u30b9\u300cclass.Member.php\u300d\u3092\u4f5c\u6210\u3057\u307e\u3057\u305f\u3002\u4eca\u56de\u306e\u4e00\u89a7\u60c5\u5831\u53d6\u5f97\u7528\u306e\u30b9\u30af\u30ea\u30d7\u30c8\u3082\u3053\u306e\u300cclass.Member.php\u300d\u306b\u307e\u3068\u3081\u3066\u8a18\u8ff0\u3057\u307e\u3059\u3002<\/p>\n\n\n\n
\u524d\u56de\u307e\u3067\u306e\u300cclass.Member.php\u300d\u306e\u30bd\u30fc\u30b9\u306f\u4e0b\u8a18\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 const ERROR_STR01 = '\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044';\n const ERROR_STR02 = '\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044';\n\n private $_test_name;\n private $_test_age;\n private $_test_gender;\n private $_test_tel;\n private $_test_tel01;\n private $_test_tel02;\n private $_test_tel03;\n \n public $_test_gender_arr = array( 1 => '\u7537\u6027', 2 => '\u5973\u6027' );\n \n \/\/ \u30bb\u30c3\u30bf\u30fc\u3068\u30b2\u30c3\u30bf\u30fc\n public function setTestName( $val ){\n $this->_test_name = $val;\n }\n public function getTestName(){\n return $this->_test_name;\n }\n \n public function setTestAge( $val ){\n $this->_test_age = $val;\n }\n public function getTestAge(){\n return $this->_test_age;\n }\n \n public function setTestGender( $val ){\n $this->_test_gender = $val;\n }\n public function getTestGender(){\n return $this->_test_gender;\n }\n \n public function setTestTel( $val01, $val02, $val03){\n if($val01 && $val02 && $val03)\n $this->_test_tel = $val01.'-'.$val02.'-'.$val03;\n else\n $this->_test_tel = '';\n $this->_test_tel01 = $val01;\n $this->_test_tel02 = $val02;\n $this->_test_tel03 = $val03;\n }\n public function getTestTel(){\n return $this->_test_tel;\n }\n public function getTestTel01(){\n return $this->_test_tel01;\n }\n public function getTestTel02(){\n return $this->_test_tel02;\n }\n public function getTestTel03(){\n return $this->_test_tel03;\n }\n\n \/\/ \u5165\u529b\u30a8\u30e9\u30fc\u30c1\u30a7\u30c3\u30af\n public function checkError(){\n $error = array();\n \n $error['error'] = false;\n \n $error['test_name'] = false;\n if( !self::getTestName() )\n $error['error'] = $error['test_name'] = true;\n \n $error['test_age'] = false;\n if( self::getTestAge() == '' )\n $error['error'] = $error['test_age'] = true;\n \n $error['test_gender'] = false;\n if( !self::getTestGender() )\n $error['error'] = $error['test_gender'] = true;\n \n $error['test_tel'] = false;\n if( !self::getTestTel() )\n $error['error'] = $error['test_tel'] = true;\n \n return $error;\n }\n\n\n public function insertDB(){\n \n try{\n $PDO = parent::ConnectDB();\n\n $query = \"INSERT INTO test_table ( \";\n $query .= \" test_name \"; $query2 = \" :test_name \";\n $query .= \",test_age \"; $query2 .= \",:test_age \";\n $query .= \",test_gender \"; $query2 .= \",:test_gender \";\n $query .= \",test_tel \"; $query2 .= \",:test_tel \";\n $query .= \",test_create \"; $query2 .= \",now() \";\n $query .= \")VALUES( \";\n $query .= $query2;\n $query .= \") \";\n\n $stmt = $PDO->prepare($query);\n $stmt->bindValue(':test_name', self::getTestName(), PDO::PARAM_STR);\n $stmt->bindValue(':test_age', self::getTestAge(), PDO::PARAM_INT);\n $stmt->bindValue(':test_gender', self::getTestGender(), PDO::PARAM_INT);\n $stmt->bindValue(':test_tel', self::getTestTel(), PDO::PARAM_STR);\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}\n\n?><\/pre><\/div>\n\n\n\n\u3067\u306f\u300cclass.Member.php\u300d\u306b\u30c7\u30fc\u30bf\u53d6\u5f97\u7528\u306e\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u8ffd\u8a18\u3057\u307e\u3059\u3002
\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u306bSELECT\u6587\u3092\u5229\u7528\u3057\u307e\u3059\u3002
SELECT\u6587\u306e\u6ce8\u610f\u70b9\u3068\u3057\u3066\u306f\u3001\u524a\u9664\u3055\u308c\u305f\u4f1a\u54e1\u60c5\u5831\u306f\u53d6\u5f97\u3057\u306a\u3044\u3088\u3046\u306b\u300cWHERE\u53e5\u300d\u3092\u5229\u7528\u3057\u300ctest_delete_key != 1\u300d\u3068\u8a18\u8ff0\u3059\u308b\u3053\u3068\u3067\u3059\u3002
\u307e\u305f\u3001\u30c7\u30fc\u30bf\u53d6\u5f97\u5f8c\u306b\u53d6\u5f97\u3057\u305f\u30c7\u30fc\u30bf\u306e\u7dcf\u6570\u3092\u300crowCount()\u300d\u3092\u5229\u7528\u3057\u3066\u53d6\u5f97\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n
\u30c7\u30fc\u30bf\u767b\u9332\u6642\u306b\u30a8\u30b9\u30b1\u30fc\u30d7\u3055\u308c\u305f\u6587\u5b57\u5217\u3092\u5143\u306b\u623b\u3059\u305f\u3081\u306e\u30e1\u30bd\u30c3\u30c9\u300cStripcslashesArray\u300d\u3082\u8a18\u8ff0\u3057\u307e\u3057\u305f\u3002
\u30a8\u30b9\u30b1\u30fc\u30d7\u3055\u308c\u305f\u6587\u5b57\u5217\u306e\u4f8b\u3068\u3057\u3066\u300cI’m<\/strong>\u300d\u304c\u300cI\\’m<\/strong>\u300d\u3068\u767b\u9332\u3055\u308c\u3066\u3044\u308b\u306e\u3067\u3001\u5143\u306e\u72b6\u614b\u306e\u300cI’m<\/strong>\u300d\u306b\u623b\u3059\u305f\u3081\u306e\u30e1\u30bd\u30c3\u30c9\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n\u307e\u305f\u3001\u300cHtmlspecialcharsArray\u300d\u306f\u53d6\u5f97\u3057\u305f\u60c5\u5831\u3092HTML\u30a8\u30f3\u30c6\u30a3\u30c6\u30a3\u306b\u30a8\u30f3\u30b3\u30fc\u30c9\u3059\u308b\u305f\u3081\u306e\u30e1\u30bd\u30c3\u30c9\u3067\u3059\u3002\u53d6\u5f97\u3057\u305f\u60c5\u5831\u3092\u4e00\u500b\u3065\u3064\u300chtmlspecialchars()\u300d\u3067\u30a8\u30f3\u30b3\u30fc\u30c9\u3057\u3066\u3082\u3044\u3044\u306e\u3067\u3059\u304c\u3001\u30b3\u30fc\u30c9\u3092\u7c21\u7565\u5316\u3059\u308b\u305f\u3081\u3001\u5f15\u6570\u306b\u914d\u5217\u3092\u6e21\u3059\u3068HTML\u30a8\u30f3\u30c6\u30a3\u30c6\u30a3\u3057\u8fd4\u3057\u3066\u304f\u308c\u308b\u30e1\u30bd\u30c3\u30c9\u300cHtmlspecialcharsArray\u300d\u3092\u4f5c\u6210\u3057\u307e\u3057\u305f\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 getData(){\n\n try{\n $PDO = parent::ConnectDB();\n\n $query = \"SELECT \";\n $query .= \" test_id \";\n $query .= \",test_name \";\n $query .= \",test_age \";\n $query .= \",test_gender \";\n $query .= \",test_tel \";\n $query .= \",test_create \";\n $query .= \",test_update \";\n $query .= \"FROM \";\n $query .= \"test_table \";\n $query .= \"WHERE \";\n $query .= \"test_delete_key != 1 \";\n\n $stmt = $PDO->prepare($query);\n $stmt->execute();\n while( $row = $stmt->fetch(PDO::FETCH_ASSOC) ) {\n $row = self::stripSlashesArray($row);\n $tmp = self::htmlSpecialCharsArray($row);\n \n $data['test_id'][] = $tmp['test_id'];\n $data['test_name'][] = $tmp['test_name'];\n $data['test_age'][] = $tmp['test_age'];\n $data['test_gender'][] = $tmp['test_gender'];\n $data['test_tel'][] = $tmp['test_tel'];\n $data['test_create'][] = $tmp['test_create'];\n $data['test_update'][] = $tmp['test_update'];\n }\n $data['rows'] = $stmt->rowCount();\n\n return $data;\n\n }\n catch( Exception $e ){\n\n echo $e->getMessage();\n exit();\n\n }\n }\n\n \/\/ addcslashes() \u3067\u30af\u30a9\u30fc\u30c8\u3055\u308c\u305f\u6587\u5b57\u5217\u3092\u30a2\u30f3\u30af\u30a9\u30fc\u30c8\u3059\u308b\n \/\/**************************************\n public function stripSlashesArray( $arr ){\n $ret = $arr;\n if( is_array( $arr ) ) {\n foreach( $arr as $key => $value )\n {\n if( $key != '' && $value != '' )\n $ret[$key] = stripcslashes( $value );\n }\n }\n return $ret;\n }\n\n \/\/ \u7279\u6b8a\u6587\u5b57\u3092HTML\u30a8\u30f3\u30c6\u30a3\u30c6\u30a3\u306b\u5909\u63db\u3059\u308b\n \/\/**************************************\n public function htmlSpecialCharsArray( $arr ){\n $ret = $arr;\n if( is_array( $arr ) ) {\n foreach( $arr as $key => $value )\n {\n if( $key != '' && $value != '' )\n $ret[$key] = htmlspecialchars( $value );\n }\n }\n return $ret;\n }\n}\n?><\/pre><\/div>\n\n\n\n\u3053\u308c\u3067\u4e00\u89a7\u53d6\u5f97\u7528\u306e\u30b9\u30af\u30ea\u30d7\u30c8\u304c\u5b8c\u6210\u3067\u3059\u3002
\u6b21\u306f\u3001list.php\u306b\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u57cb\u3081\u8fbc\u3093\u3067\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n
HTML\uff08list.php\uff09\u306b\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u57cb\u3081\u8fbc\u3080<\/h3>\n\n\n\n
list.php\u306b\u4eca\u56de\u8ffd\u8a18\u3057\u305fgetData()\u3092\u57cb\u3081\u8fbc\u307f\u3001\u4e00\u89a7\u60c5\u5831\u3092\u53d6\u5f97\u3057\u3066\u8868\u793a\u3059\u308b\u3088\u3046\u306b\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u3057\u307e\u3059\u3002<\/p>\n\n\n\n
\u6ce8\u610f\u70b9\u3068\u3057\u300c\u8a73\u7d30\u30fb\u7de8\u96c6\u300d\u3001\u300c\u524a\u9664\u300d\u3078\u306e\u30ea\u30f3\u30af\u306b $memberData[‘test_id’][$i] \u3092\u8a18\u8ff0\u3057\u524a\u9664\u3059\u308b\u60c5\u5831\u3092\u6307\u5b9a\u3057\u3066\u3044\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\u30c7\u30fc\u30bf\u306e\u4e00\u89a7\u8868\u793a\u3092\u958b\u767a\u3057\u3066\u307f\u3066<\/h2>\n\n\n\n
\u30c7\u30fc\u30bf\u306e\u4e00\u89a7\u8868\u793a\u306f\u3001CRUD\u306e\u4e2d\u3067\u306f\u6bd4\u8f03\u7684\u7c21\u5358\u306b\u4f5c\u6210\u3067\u304d\u307e\u3059\u304c\u3001\u4ef6\u6570\u304c\u591a\u3044\u3068\u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3\uff08\u30da\u30fc\u30b8\u9001\u308a\uff09\u3092\u3064\u3051\u305f\u308a\u3001\u691c\u7d22\u7528\u306e\u30d5\u30a9\u30fc\u30e0\u3092\u7528\u610f\u3057\u305f\u308a\u3068\u3001\u307e\u3060\u307e\u3060\u30d6\u30e9\u30c3\u30b7\u30e5\u30a2\u30c3\u30d7\u3067\u304d\u308b\u90e8\u5206\u306f\u591a\u6570\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n
\u4eca\u56de\u306f\u30b3\u30fc\u30c9\u3092\u7c21\u7d20\u5316\u3057\u308f\u304b\u308a\u3084\u3059\u3044\u3088\u3046\u306b\u5168\u4ef6\u53d6\u5f97\u306e\u4e00\u89a7\u8868\u793a\u3092\u4f5c\u6210\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n\n
![](\"\/\/www.programming-se.com\/wp-content\/uploads\/2020\/04\/image-1-150x150.jpeg\")
<\/figure>![\"\"](\"https:\/\/www.programming-se.com\/wp-content\/uploads\/2020\/04\/IMG_4842-2-scaled.jpg\")
\n<\/div><\/div><\/div><\/div>