{"id":1777,"date":"2019-02-22T16:12:13","date_gmt":"2019-02-22T07:12:13","guid":{"rendered":"http:\/\/akal.co.kr\/?p=1777"},"modified":"2021-06-22T14:21:19","modified_gmt":"2021-06-22T05:21:19","slug":"php-isset-empty-%ec%b0%a8%ec%9d%b4%ec%a0%90%ea%b3%bc-database-%ec%82%ac%ec%9a%a9%ec%8b%9c-%ec%a3%bc%ec%9d%98%ed%95%a0-%ec%a0%90","status":"publish","type":"post","link":"https:\/\/akal.co.kr\/?p=1777","title":{"rendered":"[PHP] isset, empty \ucc28\uc774\uc810\uacfc Database \uc0ac\uc6a9\uc2dc \uc8fc\uc758\ud560 \uc810"},"content":{"rendered":"

PHP\ub97c \uc0ac\uc6a9\ud558\ub294 \ub9ce\uc740 \ud504\ub85c\uadf8\ub798\uba38\ub4e4\uc774 isset, empty\ub97c \uc774\uc6a9\ud574\uc11c \ubcc0\uc218\ub97c \uccb4\ud06c\ud558\uace0 \uc788\uc744\ud150\ub370 \uc774 \ubcc0\uc218\ub4e4\uc758 \ubbf8\ubb18\ud55c \ucc28\uc774\ub97c \ubaa8\ub974\uace0 \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0\ub3c4 \ub9ce\uace0 \ud2b9\ud788 Database\uc640 \uc5f0\uacb0\ud574\uc11c \uc0ac\uc6a9\ud560\ub54c \uc65c \uc790\uae30\uac00 \uc6d0\ud558\ub294 \uacb0\uacfc\ub97c \ub3c4\ucd9c\ud560\uc218 \uc5c6\ub294\uc9c0 \ud798\ub4e4\uc5b4 \ud558\ub294 \ubd84\ub4e4\uc774 \uc788\uc74c\uc744 \uc54c\uac8c \ub410\ub2e4. \ub098\ub3c4 \ub098\ub984 \ub2e4\uc2dc \uc0dd\uac01\uc744 \uc815\ub9ac\ud560 \uacb8 \ud574\uc11c 2\uac1c\uc758 \ud568\uc218\uc640 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uc5f0\uacc4\uc2dc \uc0dd\uac01\ud574\uc57c \ud560\uc810\uc5d0 \ub300\ud574\uc11c \uc815\ub9ac\ud558\ub824\uace0 \ud55c\ub2e4.<\/p>\n

isset\uacfc empty\uc758 \ucc28\uc774<\/div>\n

\uac04\ub2e8\ud558\uac8c \ub2e4\uc74c\uacfc \uac19\uc740 \ucf54\ub4dc\ub97c \ud1b5\ud574 isset\uacfc empty\uc758 \ucc28\uc774\uc810\uc744 \uc54c\uc544\ubcf4\uc790.<\/p>\n

<?PHP\r\nclass aaa {\r\n    public $a;\r\n    public $b = \"\";\r\n    public $c = 0;\r\n    public $d = \"oragne\";\r\n    public $e = 123;\r\n}\r\n\r\n$dd = new aaa();\r\n\r\necho \"public \\$a <BR>--------------<br>\";\r\nvar_dump($dd->a);\r\necho \"<BR>\";\r\necho \"isset = \";\r\nvar_dump(isset($dd->a));\r\necho \"<BR>\";\r\necho \"empty = \";\r\nvar_dump(empty($dd->a));\r\necho \"<BR>\";\r\necho \"<BR>\";\r\n\r\necho \"public \\$b = \\\"\\\" <BR>--------------<br>\";\r\nvar_dump($dd->b);\r\necho \"<BR>\";\r\necho \"isset = \";\r\nvar_dump(isset($dd->b));\r\necho \"<BR>\";\r\necho \"empty = \";\r\nvar_dump(empty($dd->b));\r\necho \"<BR>\";\r\necho \"<BR>\";\r\n\r\necho \"public \\$c = 0 <BR>--------------<br>\";\r\nvar_dump($dd->c);\r\necho \"<BR>\";\r\necho \"isset = \";\r\nvar_dump(isset($dd->c));\r\necho \"<BR>\";\r\necho \"empty = \";\r\nvar_dump(empty($dd->c));\r\necho \"<BR>\";\r\necho \"<BR>\";\r\n\r\necho \"public \\$d = \\\"orange\\\" <BR>--------------<br>\";\r\nvar_dump($dd->d);\r\necho \"<BR>\";\r\necho \"isset = \";\r\nvar_dump(isset($dd->d));\r\necho \"<BR>\";\r\necho \"empty = \";\r\nvar_dump(empty($dd->d));\r\necho \"<BR>\";\r\necho \"<BR>\";\r\n\r\necho \"public \\$e = 123 <BR>--------------<br>\";\r\nvar_dump($dd->e);\r\necho \"<BR>\";\r\necho \"isset = \";\r\nvar_dump(isset($dd->e));\r\necho \"<BR>\";\r\necho \"empty = \";\r\nvar_dump(empty($dd->e));\r\necho \"<BR>\";\r\necho \"<BR>\";\r\n<\/pre>\n
\uc704\uc640 \uac19\uc740 \uc18c\uc2a4\ub97c \uc0ac\uc6a9\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \uacb0\uacfc\uac12\uc744 \uac00\uc9c0\uac8c \ub41c\ub2e4.<\/p>\n
public $a \r\n--------------\r\nNULL \r\nisset = bool(false) \r\nempty = bool(true) \r\n\r\npublic $b = \"\" \r\n--------------\r\nstring(0) \"\" \r\nisset = bool(true) \r\nempty = bool(true) \r\n\r\npublic $c = 0 \r\n--------------\r\nint(0) \r\nisset = bool(true) \r\nempty = bool(true) \r\n\r\npublic $d = \"orange\" \r\n--------------\r\nstring(6) \"oragne\" \r\nisset = bool(true) \r\nempty = bool(false) \r\n\r\npublic $e = 123 \r\n--------------\r\nint(123) \r\nisset = bool(true) \r\nempty = bool(false) <\/pre>\n
\ub208\uce58\uac00 \ube60\ub978 \ubd84\ub4e4\uc774 \uc774\ubbf8 isset\uacfc empty \ub450 \ud568\uc218\uc758 \ucc28\uc774\uc810\uc744 \ubaa8\ub450 \ud30c\uc545\ud558\uc168\uc73c\ub9ac\ub77c \ubcf8\ub2e4. \uadf8\ub798\ub3c4 \uc544\uc9c1 \ub208\uce58\ucc44\uc9c0 \ubabb\ud558\uace0 \uacc4\uc2e0\ubd84\ub4e4\uc774 \uc788\uc744\uc218\ub3c4 \uc788\uc73c\ub2c8 \uc124\uba85\uc740 \ud558\ub3c4\ub85d \ud558\uc790. isset\uc740 \uae30\ubcf8\uc801\uc73c\ub85c \ubcc0\uc218\uc5d0 \uac12\uc774 \uc788\ub290\ub0d0\ub97c \uccb4\ud06c\ud558\ub294 \ud568\uc218\ub85c NULL \uacfc \uadf8\uc678\ub85c \ubd84\ub958\ub41c\ub2e4. empty\ub294 \ubcc0\uc218\uc5d0 \uac12\uc774 \ube44\uc5b4\uc788\ub290\ub0d0\ub97c \uccb4\ud06c\ud558\ub294 \ud568\uc218\ub85c NULL, \uc22b\uc790 0, \ube48\ubb38\uc790\uc5f4 “” \uacfc \uadf8\uc678\ub85c \ubd84\ub958\ub41c\ub2e4.
\nempty\uc758 \uacbd\uc6b0 \uacf5\ubc31\ubb38\uc790\uc5f4(\ube48\ubb38\uc790\uc5f4)\uc774 \uc788\uac70\ub098 0\uc774 \uc788\uc73c\uba74 NULL \uc77c\ub54c\uc640 \ub9c8\ucc2c\uac00\uc9c0\ub85c \uac12\uc774 \ube44\uc5b4\uc788\ub294 \uac83\uc73c\ub85c \ud574\uc11d\ud55c\ub2e4. NULL\uc774\ub77c\ub294 \uac83\uc740 \uac12\uc774 \uc5c6\uc74c\uc744 \uc758\ubbf8\ud558\ub294 \uac83\uc774\uace0 \uadf8 \uac12\uc740 0\ub3c4 \ud3ec\ud568\ub418\uc9c0 \uc54a\ub294\uac83\uc744 \ub9d0\ud558\ub294\ub370 empty\ub294 \ud568\uc218\ub294 null = 0 = “” 3\uac00\uc9c0\uac00 \ub2e4 \uac19\uc740 \ub9ac\ud134\uac12 true\ub97c \ubc18\ud658\ud55c\ub2e4. <\/p>\n
\ub530\ub77c\uc11c \uc77c\ubc18\uc801\uc73c\ub85c \ubcc0\uc218\uc5d0 \uac12\uc774 \uc788\ub294\uc9c0\ub97c \uccb4\ud06c\ud560\ub54c\ub294 isset\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \uc77c\ubc18\uc801\uc774\uba70 NULL\uacfc NULL\uc774 \uc544\ub2cc \uac12\uc73c\ub85c \ubd84\uba85\ud558\uac8c \ub098\ub220 \uccb4\ud06c\ud560\uc218 \uc788\uac8c \ub41c\ub2e4.<\/p>\n
isset\uc744 Database\uc640 \ud568\uaed8 \uc0ac\uc6a9\uc2dc \uc8fc\uc758\ud560 \uc810<\/div>\n
\uc815\uc791 \ubb38\uc81c\ub294 Database\uc640 \ud568\uaed8 \uc0ac\uc6a9\ud560\ub54c \ub098\ud0c0\ub09c\ub2e4. Database\uc5d0\uc11c\ub294 \ubcf4\ud1b5 \uae30\ubcf8\uac12\uc744 Not Null\ub85c \uc8fc\uae30 \ub54c\ubb38\uc5d0 \uacf5\ubc31\ubb38\uc790\uc5f4(\ube48\ubb38\uc790\uc5f4)\uc744 \ubc1b\uc544\uc624\uac70\ub098 \uae30\ubcf8\uac12 0\uc73c\ub85c \uc124\uc815\ub41c \uac12\uc744 \ubc1b\uc544\uc624\ub294 \uacbd\uc6b0\uac00 \ud5c8\ub2e4\ud558\ub2e4. \ud504\ub85c\uadf8\ub798\ubc0d\uc744 \ud560\ub54c \uac12\uc774 \ub4e4\uc5b4\uac00\uc9c0 \uc54a\uc740 \ud544\ub4dc\uc5d0 \ub300\ud574 \ud504\ub85c\uadf8\ub798\uba38\ub294 \uac12\uc774 \uc5c6\ub2e4\ub294 \uc0dd\uac01\uc744\ud558\uc5ec isset\uc73c\ub85c \uccb4\ud06c\ud558\uac8c \ub418\uba74 \ubb38\uc81c\uac00 \uc0dd\uae34\ub2e4. isset\uc740 \uba85\ubc31\ud558\uac8c NULL\ub9cc\uc744 true\ub85c \ub9ac\ud134\ud558\uae30 \ub54c\ubb38\uc774\ub2e4. <\/p>\n
\ub9c8\ucc2c\uac00\uc9c0\ub85c \uc26c\uc6b4 \uc608\uc81c\ub97c \ud1b5\ud574 \uc704\uc758 \uc774\uc57c\uae30\ub97c \ud655\uc778\ud558\ub294 \uac83\uc774 \uac00\uc7a5 \uc88b\uc740 \uc774\ud574\ubc95\uc774\ub77c\uace0 \uc0dd\uac01\ud55c\ub2e4.<\/p>\n
<?PHP\r\n\r\n    \/\/ Database open\r\n    $db = new PDO(PDO_DSN, DB_USER, DB_PASS);\r\n  \r\n    $sql = \"SELECT * FROM table_name WHERE id = 1\";\r\n\r\n    $stmt = db->prepare($sql);\r\n    $stmt->execute();\r\n\r\n    $row = $stmt->fetch(PDO::FETCH_ASSOC);\r\n\r\n    var_dump($row);\r\n?>\r\n \r\n\uc2e4\ud589\ud654\uba74\r\n-------\r\narray(9) { \r\n    [\"id\"]=> string(1) \"1\" \r\n    [\"todo\"]=> string(59) \"\ud504\ub85c\uadf8\ub7a8 \uac1c\ubc1c \uc644\ub8cc\" \r\n    [\"tdate\"]=> string(10) \"2019-12-31\" \r\n    [\"mem_id\"]=> string(1) \"1\" \r\n    [\"person\"]=> string(9) \"\uc544\uce7c\" \r\n    [\"duty\"]=> string(0) \"\" \r\n    [\"complete\"]=> string(1) \"0\" \r\n    [\"startdate\"]=> string(10) \"2019-02-12\" \r\n    [\"enddate\"]=> NULL \r\n}\r\n<\/pre>\n
var_dump\ub85c \ucd9c\ub825\ub41c $row \uac12\ub4e4\uc744 \uc790\uc138\ud788 \uc0b4\ud3b4\ubcf4\uba74 \uc27d\uac8c \uc774\ud574\uac00 \ub420\uac83\uc774\ub2e4. \uc77c\ub2e8 \uc8fc\uc758\ud574\uc57c\ud560 \uc810\uc740 \ubcc0\uc218\ud615\uc774 \ubaa8\uc870\ub9ac String \ud0c0\uc785\uc73c\ub85c \ubd88\ub824\uc628\ub2e4\ub294 \uc810\uc774\ub2e4. \ub610\ud55c \uacc4\uc18d \ub9d0\ud55c\ubc14\uc640 \uac19\uc774 $row[‘duty’] \uac19\uc740 \uacbd\uc6b0\ub294 \ube48\ubb38\uc790\uc5f4\ub85c isset\uc740 \uac12\uc774 \uc788\ub2e4\uace0 \uccb4\ud06c\ud558\uc5ec true\ub97c \ubc18\ud658\ud560 \uac83\uc774\ub2e4. \ub530\ub77c\uc11c \uc774\ub7f0 \uc0c1\ud669\uc5d0 \uc54c\ub9de\uac8c \ubcc0\uc218\ub97c \uccb4\ud06c\ud574\uc904\uc218 \uc788\uc5b4\uc57c \ud558\uaca0\ub2e4.
\n\uc774\ub807\uac8c \uc124\uba85\ud588\ub294\ub370\ub3c4 \uc774\ud574\uac00 \uc548\ub41c\ub2e4 \ud558\uc2dc\uba74 \uc800\ub3c4 \ud560\ub9d0\uc740 \uc5c6;;;;;\uc2b5\ub2c8\ub2e4…<\/p>\n
isset\uacfc empty\ub294 \uc870\uac74\uccb4\ud06c\uc5d0 \ub9ce\uc774 \uc0ac\uc6a9\ud558\uac8c \ub418\ub294 \ud568\uc218\ub77c \uba85\ud655\ud788 \uc54c\uace0 \uc788\ub294\uac8c \uc88b\uc73c\uba70, DB\uc640 \uc5f0\uacb0\uc2dc\uc5d0 \uc8fc\uc758\ud574\uc57c\ud560 \ubd80\ubd84\uae4c\uc9c0 \uc219\uc9c0\ud558\uace0 \uc788\ub2e4\uba74 \uc2e4\uc81c \ud504\ub85c\uadf8\ub798\ubc0d\uc5d0\uc11c \ubc1c\uc0dd\ud560\uc218 \uc788\ub294 \uc624\ub958\ub97c \ub9c9\ub294\ub370 \ud070 \ub3c4\uc6c0\uc774 \ub420\uac83\uc785\ub2c8\ub2e4. <\/p>\n","protected":false},"excerpt":{"rendered":"
PHP\ub97c \uc0ac\uc6a9\ud558\ub294 \ub9ce\uc740 \ud504\ub85c\uadf8\ub798\uba38\ub4e4\uc774 isset, empty\ub97c \uc774\uc6a9\ud574\uc11c \ubcc0\uc218\ub97c \uccb4\ud06c\ud558\uace0 \uc788\uc744\ud150\ub370 \uc774 \ubcc0\uc218\ub4e4\uc758 \ubbf8\ubb18\ud55c \ucc28\uc774\ub97c \ubaa8\ub974\uace0 \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0\ub3c4 \ub9ce\uace0 \ud2b9\ud788 Database\uc640 \uc5f0\uacb0\ud574\uc11c \uc0ac\uc6a9\ud560\ub54c \uc65c \uc790\uae30\uac00 \uc6d0\ud558\ub294 \uacb0\uacfc\ub97c \ub3c4\ucd9c\ud560\uc218 \uc5c6\ub294\uc9c0 \ud798\ub4e4\uc5b4 \ud558\ub294 \ubd84\ub4e4\uc774 \uc788\uc74c\uc744 \uc54c\uac8c \ub410\ub2e4....<\/p>\n","protected":false},"author":1,"featured_media":1614,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[1426],"tags":[1429,1428,1427,1216],"_links":{"self":[{"href":"https:\/\/akal.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1777"}],"collection":[{"href":"https:\/\/akal.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/akal.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/akal.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/akal.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1777"}],"version-history":[{"count":0,"href":"https:\/\/akal.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1777\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/akal.co.kr\/index.php?rest_route=\/wp\/v2\/media\/1614"}],"wp:attachment":[{"href":"https:\/\/akal.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1777"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/akal.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1777"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/akal.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1777"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}