\uae00\uc4f4\uc774:\uc6b0\uc218\ud55c <\/p>\n
mysql_fetch_object\ub85c \ucffc\ub9ac\ub97c \ub358\uc9c0\uba74, \uadf8 \uacb0\uacfc \uc624\ube0c\uc81d\ud2b8(\uac1d\uccb4)\ub97c \ubc1b\uc544\uc624\uac8c \ub429\ub2c8\ub2e4.
\n\uc774\uac83\uc774 \uc5b4\ub5bb\uac8c \ud504\ub85c\uadf8\ub798\ubc0d\uc744 \uac04\ud3b8\ud558\uac8c \ub9cc\ub4e4\uc5b4\uc8fc\ub294\uc9c0 \uc0b4\ud3b4\ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n
\n—– [1\ub2e8\uacc4: \uae30\ucd08] —–<\/p>\n
\uc790, \ub2e4\uc74c\uacfc \uac19\uc740 \ud14c\uc774\ube14\uc774 \uc788\ub2e4\uace0 \ud569\uc2dc\ub2e4.
\nCREATE TABLE users (
\n id varchar(10) not null,
\n name varchar(10) not null,
\n addr varchar(30) not null,
\n phone varchar(14) not null,
\n PRIMARY KEY (id)
\n);
\nINSERT INTO users VALUES (“test”, “\uc544\ubb34\uac1c”, “\uc11c\uc6b8”, “02-123-4567”);<\/p>\n
\uc5ec\uae30\uc11c\ub294 \ud3b8\uc758\uc0c1 DB \ud074\ub798\uc2a4\ub97c \uc0ac\uc6a9\ud558\uaca0\uc2b5\ub2c8\ub2e4. (\ud558\uc9c0\ub9cc DB\ud074\ub798\uc2a4\uac00 \uc911\uc694\ud55c \uac83\uc740 \uc544\ub2d9\ub2c8\ub2e4.)
\nDB->fetch()\ub77c\ub294 \ud568\uc218\ub294 mysql_fetch_object()\ub97c \ub73b\ud55c\ub2e4\ub294 \uac83\ub9cc \uc544\uc2dc\uba74 \ub429\ub2c8\ub2e4.<\/p>\n
$DB->query(“SELECT id, name, addr, phone FROM users WHERE id=’test’ “);
\n$user = $DB->fetch();
\n\uc704\uc640 \uac19\uc740 \ucf54\ub4dc\ub97c \uc2e4\ud589\ud558\uba74, \uadf8 \uacb0\uacfc $user->id \uc5d0\ub294 “test”, $user->name \uc5d0\ub294 “\uc544\ubb34\uac1c” \ub4f1\uc758 \uac12\uc774 \ub4e4\uc5b4\uc788\ub294 \uac83\uc744 \ud655\uc778\ud558\uc2e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\uc790, \uadf8\ub7fc \uc704\uc758 \uae30\ub2a5\uc744 \ud568\uc218\ub85c \ub9cc\ub4e4\uc5b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.
\nfunction load_user($id) {
\n $SQL = ” SELECT * FROM users WHERE id=’$id’ “;
\n $DB =& DB::getInstance();
\n $DB->query($SQL);
\n return $DB->fetch();
\n}
\n\uc774\uc81c \ud68c\uc6d0\uc815\ubcf4\ub97c \uc77d\uc5b4\uc62c\ub54c $user = load_user(“test”); \ub77c\uace0 \ud558\uba74 \ub05d\uc785\ub2c8\ub2e4.
\n\ud68c\uc6d0\uc815\ubcf4\ub97c \ubcc0\uacbd\ud560 \uc218 \uc788\ub294 \ud3fc\uc744 \ucd9c\ub825\ud560\ub54c
\naddr?>”>
\n\uacfc \uac19\uc740 \uc2dd\uc73c\ub85c \uc4f0\uba74 \ub429\ub2c8\ub2e4.
\n\uc27d\uc8e0? \uc774\ub85c\uc368 SELECT \ucffc\ub9ac\ubb38\uc744 \uc791\uc131\ud558\ub294 \ubc88\uac70\ub85c\uc6c0\uc774 \uc904\uac8c \ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n
\n—– [2\ub2e8\uacc4: \ud65c\uc6a9] ——<\/p>\n
\uc0ac\uc6a9\uc790\uac00 \ud68c\uc6d0\uc815\ubcf4\ub97c \ubcc0\uacbd\ud558\ub294 \ud3fc\uc744 \uc785\ub825\ud588\ub2e4\uba74, \uc774\uc81c \ud68c\uc6d0\uc815\ubcf4\ub97c \uc218\uc815\ud574\uc57c\uaca0\uc8e0?
\n$user->name = $_POST[“name”] \uacfc \uac19\uc740 \uc2dd\uc73c\ub85c \uac12\uc744 \ubc1b\uc2b5\ub2c8\ub2e4.
\n\uc774\uac83\ub3c4 PHP\uc758 \uc720\uc5f0\uc131\uc774\ub77c\uace0 \ud574\uc57c \ud560\uae4c\ub098? \ud074\ub798\uc2a4\ub97c \uc0dd\uc131\ud560\ub54c \uba64\ubc84\ubcc0\uc218(var)\ub97c \uc9c0\uc815\ud574\uc8fc\uc9c0 \uc54a\ub354\ub77c\ub3c4 \ucd94\ud6c4\uc5d0 \uba64\ubc84\ubcc0\uc218\ub97c \ucd94\uac00\ud560 \uc218 \uc788\uace0, \ub610 $user = new user; \uc640 \uac19\uc774 \ud074\ub798\uc2a4\ub85c \ub9cc\ub4e4\uc9c0 \uc54a\ub354\ub77c\ub3c4 \uadf8\ub0e5 $user->name=”\uc544\ubb34\uac1c”; \ud558\uba74 \ubc14\ub85c \uc624\ube0c\uc81d\ud2b8\uac00 \ub429\ub2c8\ub2e4. –;;<\/p>\n
\ud68c\uc6d0\uc815\ubcf4\ub97c \uc800\uc7a5\ud560\ub54c\ub294 save_user() \ub77c\ub294 \ud568\uc218\ub97c \ub9cc\ub4e4\uc5b4 \uc4f0\uaca0\uc2b5\ub2c8\ub2e4.
\nfunction save_user($id, $user) {
\n if (!is_object($user)) return false;
\n $row = array();
\n foreach ($user as $key=>$val) $row[] = ” $key=’$val’ “;
\n $DB =& DB::getInstance();
\n $SQL = “UPDATE user SET “.join(“,”, $row).” WHERE id='”.$id.”‘ “;
\n return $DB->query($SQL);
\n}
\n\uc774\uc81c \uac10 \uc7a1\uc73c\uc168\uc8e0?
\n[\uc0ac\uc6a9 \uc608]
\n$user->name = “\uc544\ubb34\uac1c”;
\n$user->addr = “\ubd80\uc0b0”;
\nsave_user(“test”, $user);
\n\uc774\ub807\uac8c \ud558\uba74 \ud68c\uc6d0\uc815\ubcf4 \uc800\uc7a5\uc774 \ub05d\ub098\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p>\n
\uc5ec\uae30\uc11c $user->name=”\uc544\ubb34\uac1c” \ub294 \ubcc0\ud558\uc9c0 \uc54a\uace0 \uadf8\ub300\ub85c\uc774\uad70\uc694.
\n\ub530\ub77c\uc11c \ubd88\ud544\uc694\ud55c \ucffc\ub9ac\ub97c \ud558\uac8c \ub418\ub294\uad70\uc694.
\n\uc774\ub7f4\ub54c\ub294 \ubbf8\ub9ac unset($user->name); \ud55c \ub2e4\uc74c\uc5d0 save_user(“test”, $user); \ub97c \ud574\uc8fc\uba74
\nUPDATE … SET name=”\uc544\ubb34\uac1c” , addr=”\ubd80\uc0b0” …. \uc774\ub77c\ub294 \ucffc\ub9ac\ubb38\uc774
\nUPDATE … SET addr=”\ubd80\uc0b0” …. \uc73c\ub85c \ubc14\ub00c\uac8c\ub418\uaca0\uc8e0.<\/p>\n
\uc774\ub85c\uc368 \ucf54\ub4dc \uc791\uc131\uc2dc UPDATE \ucffc\ub9ac\ub97c \uc0dd\ub7b5\ud560 \uc218 \uc788\uac8c \ub418\uc5c8\uc2b5\ub2c8\ub2e4.
\n(\uc0ac\uc2e4\uc0c1 SQL \ucffc\ub9ac\ubb38\uc744 \uc801\ub2f9\ud788 \uc791\uc131\ud574\uc11c \uc2e4\ud589\ud558\ub294 \ub2e8\uc21c\ud55c \ud568\uc218\uc5d0 \ubd88\uacfc\ud569\ub2c8\ub2e4.)
\n\ud14c\uc774\ube14 \uc790\uccb4\ub97c \ud558\ub098\uc758 \uc624\ube0c\uc81d\ud2b8\ub85c \uac04\uc8fc\ud558\uace0 \ucf54\ub4dc\ub97c \uc791\uc131\ud558\uac8c \ub418\uae30 \ub54c\ubb38\uc5d0
\n\ubcc0\uc218 \uc774\ub984 \ub54c\ubb38\uc5d0 \ud5f7\uac08\ub9ac\uac70\ub098 \ud558\uc9c0 \uc54a\uace0, \ube44\uad50\uc801 \uc218\uc6d4\ud558\uac8c \uc791\uc5c5\uc744 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
—– [3\ub2e8\uacc4: \uc751\uc6a9] ——<\/p>\n
\uc9c0\uae08\uae4c\uc9c0 user \ub77c\uace0 \ud558\ub294 \ud2b9\uc815 \ud14c\uc774\ube14\uc744 \uac00\uc9c0\uace0 \uc791\uc5c5\uc744 \ud588\uc2b5\ub2c8\ub2e4.
\n\uc774\uc655 \ub9cc\ub4e0\uac70, \uc774\uc81c\ub294 \uc774\uac78 \uc880\ub354 \ubcf4\ud3b8\uc801\uc778 \ud568\uc218\ub85c \ub9cc\ub4e4\uc5b4\uc11c
\n\uc544\ubb34 \ud14c\uc774\ube14\uc5d0\uc11c\ub098 SELECT \ubc0f UPDATE \ub97c \ud558\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4.
\nload_xxxx($obj)\ud568\uc218\ub97c \uc2e4\ud589\ud558\uba74 \ud558\ub098\uc758 \ub808\ucf54\ub4dc\ub97c \uc77d\uc5b4\uc624\uace0
\nsave_xxxx($obj)\ud568\uc218\ub97c \uc2e4\ud589\ud558\uba74 \ub370\uc774\ud0c0\ub97c \uc5c5\ub370\uc774\ud2b8\ud558\ub294 \uac81\ub2c8\ub2e4.<\/p>\n
\ub2e8, \uc5ec\uae30\uc11c \uc8fc\uc758\ud560 \uc810\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uac00\ub839
\n$user->score = 100; \uc774\ub77c\uace0 \uc9c0\uc815\ud558\uace0
\nsave_xxxx($user); \ub97c \uc2e4\ud589\ud588\ub294\ub370
\n\ud574\ub2f9 \ud14c\uc774\ube14\uc5d0 score\ub77c\ub294 \ud544\ub4dc\uac00 \uc5c6\uc73c\uba74 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud558\uaca0\uc9c0\uc694.
\n\uadf8\ub7ec\ub2c8 \ud574\ub2f9\uac1d\uccb4($obj)\uc758 \uba64\ubc84\uac12\uc73c\ub85c \uc9c0\uc815\ub41c \ub0b4\uc6a9\uc774 \ud14c\uc774\ube14\uc5d0 \uc874\uc7ac\ud558\ub294\uc9c0\ub97c \ud310\ub2e8\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n
\uadf8\ub798\uc11c \uc6b0\uc120 \ud574\ub2f9 \ud14c\uc774\ube14\uc758 \ud544\ub4dc\ub97c \uc77d\uc5b4\uc624\ub294 \ud568\uc218\ub97c \ub9cc\ub4ed\ub2c8\ub2e4.
\nfunction get_fields($table) {
\n $key_ar = array();
\n $field_ar = array();
\n $DB =& DB::getInstance();
\n $SQL = “SHOW COLUMNS FROM “.$table;
\n $DB->query($SQL);
\n while ($row=$DB->fetch()) {
\n $field_ar[] = $row->Field;
\n if ($row->Key==”PRI”) $key_ar[] = $row->Field;
\n }
\n return array($key_ar, $field_ar);
\n}
\nget_fields(“\ud14c\uc774\ube14\uba85”)\uc744 \uc2e4\ud589\ud558\uba74 \uae30\ubcf8\ud0a4\uc758 \ubaa9\ub85d, \ubaa8\ub4e0 \ud544\ub4dc\uc758 \ubaa9\ub85d\uc744 \uac00\uc838\uc624\uac8c \ub429\ub2c8\ub2e4.
\n(\ucc38\uace0: \ubcf4\ud3b8\uc801\uc778 \uac78\ub85c \ub9cc\ub4e4\ub824\uace0 \ud558\ub2e4 \ubcf4\ub2c8 SHOW COLUMNS\/FIELDS \ub77c\ub294 \ucffc\ub9ac\ub97c \ud55c\ubc88 \ub354 \ud558\uac8c \ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc2e4\uc804\uc5d0\uc11c\ub294 \uc704\uc758 2\ub2e8\uacc4 \uc815\ub3c4\uae4c\uc9c0 \uc0ac\uc6a9\ud558\uc2dc\uac70\ub098 \uc774\ub7f0 \uc5d0\ub7ec \uac80\ucd9c\uc774 \ud544\uc694\uc5c6\ub294 \ucf54\ub4dc\ub97c \uc791\uc131\ud558\uc154\uc57c\uaca0\uc8e0.)<\/p>\n
\uc790, \uadf8\ub7fc \ub370\uc774\ud0c0\ub97c \uc77d\uc5b4\uc624\ub294 \ud568\uc218\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.
\n\uae30\ubcf8\ud0a4\uac12\uc73c\ub85c \uac80\uc0c9\ud574\uc11c 1\uac1c\uc758 \ub808\ucf54\ub4dc\ub97c \uac00\uc838\uc635\ub2c8\ub2e4.
\nfunction load_simple_db($table, $obj) {
\n if (!is_object($obj) && !is_array($obj)) return false;
\n $where = array();
\n list($key_ar,) = get_fields($table);
\n if (!$key_ar) return false;
\n foreach ($obj as $key=>$val) {
\n if (in_array($key, $key_ar)) $where[] = ” $key=’$val’ “;
\n }
\n $SQL = “SELECT * FROM “.$table.” WHERE “.join(” and “, $where);
\n $DB =& DB::getInstance();
\n $DB->query($SQL);
\n return $DB->fetch();
\n}
\n\uc774 \ud568\uc218\ub97c \uc0ac\uc6a9\ud560\ub54c\ub294, \ubbf8\ub9ac \uac1d\uccb4\ub97c \uc0dd\uc131\ud558\uace0 \uac80\uc0c9\ud560 \uc870\uac74 \uac12\uc744 \ubd80\uc5ec\ud574\uc57c \ud569\ub2c8\ub2e4. \uc989
\n[\uc0ac\uc6a9 \uc608]
\nunset($user);
\n$user->id = “test”;
\n$user = load_simple_db(“user”, $user);
\necho $user->name;
\necho $user->addr;
\necho $user->phone;
\n\uc774\ub7f0 \uc2dd\uc73c\ub85c \ud558\uba74 \ub429\ub2c8\ub2e4.<\/p>\n
\ub370\uc774\ud0c0\ub97c \uc5c5\ub370\uc774\ud2b8\ud558\ub294 \ud568\uc218\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.
\n\uc5ed\uc2dc \uae30\ubcf8\ud0a4\ub9cc\uc744 \uac80\uc0c9\uc870\uac74\uc5d0 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\nfunction save_simple_db ($table, $obj) {
\n if (!is_object($obj) && !is_array($obj)) return false;
\n $data = array();
\n $where = array();
\n list($key_ar,$field_ar) = get_fields($table);
\n if (!$key_ar) return false;
\n foreach ($obj as $key=>$val) {
\n if (in_array($key, $key_ar)) {
\n $where[] = ” $key=’$val’ “;
\n } elseif (in_array($key, $field_ar)) {
\n $data[] = ” $key=’$val’ “;
\n }
\n }
\n if (!$where || !$data) return false;
\n $SQL = “UPDATE “.$table.” SET “.join(“,”, $data).” WHERE “.join(” and “, $where);
\n $DB =& DB::getInstance();
\n return $DB->query($SQL);
\n}
\n\uc774 \ud568\uc218\ub97c \uc0ac\uc6a9\ud560\ub54c\ub294, \ubbf8\ub9ac \uc0dd\uc131\ub41c \uac1d\uccb4\uc5d0 \uc5c5\ub370\uc774\ud2b8\ud560 \uac12\uc744 \uc9c0\uc815\ud574\ub450\uc5b4\uc57c \ud569\ub2c8\ub2e4.
\n\ub610 \uae30\ubcf8\ud0a4\uac00 \uc801\uc5b4\ub3c4 \ud558\ub098\ub294 \ub4e4\uc5b4\uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4.
\n[\uc0ac\uc6a9 \uc608]
\n$user->id = “test”;
\n$user->name = “\uc544\ubb34\uac1c”;
\n$user->addr = “\ubd80\uc0b0”;
\n$user->phone = “02-123-4567”;
\nsave_simple_db(“user”, $user);
\n\uc774\ub7f0 \uc2dd\uc73c\ub85c \ud558\uba74 \ub429\ub2c8\ub2e4.<\/p>\n
\ubb3c\ub860 \uc81c\ud55c\uc810\uc774 \ub9ce\uc740 \ud568\uc218\uc785\ub2c8\ub2e4\ub9cc, \uacbd\uc6b0\uc5d0 \ub530\ub77c \uc720\uc6a9\ud558\uac8c \uc4f8 \uc218 \uc788\uaca0\uc8e0.<\/p>\n
\n—– [\ub05d] —–<\/p>\n
\uc5bc\ud54f \ubcf4\uae30\uc5d0 \ubcf5\uc7a1\ud574\ubcf4\uc77c\uc9c0 \ubab0\ub77c\ub3c4, \uc798 \uc0b4\ud3b4\ubcf4\uba74 \uc544\uc8fc \uac04\ub2e8\ud55c \ub0b4\uc6a9\uc785\ub2c8\ub2e4.
\n\uac1d\uccb4\uc9c0\ud5a5 \ud504\ub85c\uadf8\ub798\ubc0d\uc744 \ub2e4\ub8e8\ub294 \uac83\uc774 \uc544\ub2c8\ub77c,
\n\uc0ac\uc2e4\uc0c1 \ubc30\uc5f4 \ub300\uc2e0 \uac1d\uccb4 \ud0c0\uc785\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\uc77c \ubfd0\uc785\ub2c8\ub2e4.
\nSELECT, UPDATE \ucffc\ub9ac\ubb38\uc744 \uc0dd\ub7b5\ud560 \uc218 \uc788\uc73c\ubbc0\ub85c \ucf54\ub4dc\uac00 \uac04\uacb0\ud574\uc9c8 \uc218 \uc788\ub2e4\ub294 \uc694\uc9c0\uc785\ub2c8\ub2e4.
\n(\uc4f0\uace0 \ubcf4\ub2c8 \ubcc4 \uac70 \uc544\ub2c8\uad70\uc694.) –;;<\/p>\n","protected":false},"excerpt":{"rendered":"
\uae00\uc4f4\uc774:\uc6b0\uc218\ud55c mysql_fetch_object\ub85c \ucffc\ub9ac\ub97c \ub358\uc9c0\uba74, \uadf8 \uacb0\uacfc \uc624\ube0c\uc81d\ud2b8(\uac1d\uccb4)\ub97c \ubc1b\uc544\uc624\uac8c \ub429\ub2c8\ub2e4. \uc774\uac83\uc774 \uc5b4\ub5bb\uac8c \ud504\ub85c\uadf8\ub798\ubc0d\uc744 \uac04\ud3b8\ud558\uac8c \ub9cc\ub4e4\uc5b4\uc8fc\ub294\uc9c0 \uc0b4\ud3b4\ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. —– [1\ub2e8\uacc4: \uae30\ucd08] —– \uc790, \ub2e4\uc74c\uacfc \uac19\uc740 \ud14c\uc774\ube14\uc774 \uc788\ub2e4\uace0 \ud569\uc2dc\ub2e4. CREATE TABLE users ( id varchar(10) not null, name varchar(10) not null, addr varchar(30) not null, phone varchar(14) not null, PRIMARY KEY (id) ); INSERT INTO users VALUES (“test”, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[51],"tags":[],"class_list":["post-892","post","type-post","status-publish","format-standard","hentry","category-papa-php"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts\/892","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=892"}],"version-history":[{"count":0,"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts\/892\/revisions"}],"wp:attachment":[{"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=892"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=892"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=892"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}