{"id":652,"date":"2002-11-05T01:45:30","date_gmt":"2002-11-05T01:45:30","guid":{"rendered":"http:\/\/dev.jblove.net\/?p=652"},"modified":"2002-11-05T01:45:30","modified_gmt":"2002-11-05T01:45:30","slug":"db-%ec%9c%a0%ec%a0%80%eb%9e%91-%ed%95%9c%eb%b2%88%ec%97%90-%ec%83%9d%ec%84%b1%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/jblove.net\/?p=652","title":{"rendered":"db \uc720\uc800\ub791 \ud55c\ubc88\uc5d0 \uc0dd\uc131\ud558\uae30"},"content":{"rendered":"<p>\uc544\ub098\uc2dc\uc2a4<\/p>\n<p>\uc0c8\ub85c\uc6b4 db\ub97c \uc0dd\uc131\ud558\uace0 \ud574\ub2f9 \uc720\uc800\uc5d0 \uad8c\ud55c\uc744 \uc904\ub54c\ub9c8\ub2e4 \ud544\uc694\ud55c \uc2a4\ud06c\ub9bd\ud2b8 \ud30c\uc77c \uc785\ub2c8\ub2e4..<br \/>\n\ud55c\ubc88\ub9cc \ub9cc\ub4e4\uc5b4 \ub193\uc73c\uba74 \uac04\ub2e8\ud55c \uc124\uc815\uc73c\ub85c \uc27d\uac8c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4..<\/p>\n<p><?<br \/>\n$DB_CONNECT = mysql_connect(&#8220;localhost&#8221;,&#8221;rootid&#8221;,&#8221;rootpass&#8221;);  \/\/rootid=\ub8e8\ud2b8\uc544\uc774\ub514 rootpass=\ub8e8\ud22c\ud328\uc2a4<br \/>\nmysql_select_db(&#8220;mysql&#8221;, $DB_CONNECT);<\/p>\n<p>$make_db=&#8221;db_name&#8221;;  \/\/\ub514\ube44 \uc774\ub984\uc124\uc815<br \/>\n$user_id=&#8221;user_id&#8221;;  \/\/\ub514\ube44 \uc720\uc800\uc544\uc774\ub514<br \/>\n$userpass=&#8221;user_password&#8221;; \/\/\ub514\ube44 \ud328\uc2a4\uc6cc\ub4dc<\/p>\n<p>   $query=mysql_query(&#8220;create database $make_db&#8221;) or die(mysql_error());<\/p>\n<p>   if($query)<br \/>\n   {<br \/>\n     echo &#8220;$make_db \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\ub97c \uc0dd\uc131\ud588\uc2b5\ub2c8\ub2e4<br \/>&#8220;;<br \/>\n   }else{<br \/>\n     echo &#8220;$make_db \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\ub97c \uc0dd\uc131 \uc2e4\ud328<br \/>&#8220;;<br \/>\n   }<\/p>\n<p>   $query1=mysql_query(&#8220;insert into db values(&#8216;%&#8217;,&#8217;$make_db&#8217;,&#8217;$user_id&#8217;,&#8217;y&#8217;,&#8217;y&#8217;,&#8217;y&#8217;,&#8217;y&#8217;,&#8217;y&#8217;,&#8217;y&#8217;,&#8217;y&#8217;,&#8217;y&#8217;,&#8217;y&#8217;,&#8217;y&#8217;)&#8221;);<br \/>\n   if($query1)<br \/>\n   {<br \/>\n     echo &#8220;$make_db \uad8c\ud55c \ucd94\uac00 \uc131\uacf5<br \/>&#8220;;<br \/>\n   }else{<br \/>\n     echo &#8220;$make_db \uad8c\ud55c \ucd94\uac00 \uc2e4\ud328<br \/>&#8220;;<br \/>\n   }<\/p>\n<p>   $query2=&#8221;insert into user values(&#8216;%&#8217;,&#8217;$user_id&#8217;,password(&#8216;$userpass&#8217;),&#8217;N&#8217;,&#8217;N&#8217;,&#8217;N&#8217;,&#8217;N&#8217;,&#8217;N&#8217;,&#8217;N&#8217;,&#8217;N&#8217;,&#8217;N&#8217;,&#8217;N&#8217;,&#8217;N&#8217;,&#8217;N&#8217;,&#8217;N&#8217;,&#8217;N&#8217;,&#8217;N&#8217;)&#8221;;   <br \/>\n   $query2=mysql_query($query2) or die(mysql_error());<\/p>\n<p>   if($query2)<br \/>\n   {<br \/>\n     echo &#8220;$make_db \uc720\uc800 \ucd94\uac00 \uc131\uacf5<br \/>&#8220;;<br \/>\n   }else{<br \/>\n     echo &#8220;$make_db \uc720\uc800 \ucd94\uac00 \uc2e4\ud328<br \/>&#8220;;<br \/>\n   }<\/p>\n<p>   $query3=mysql_query(&#8220;flush privileges&#8221;);<br \/>\n   if($query3)<br \/>\n   {<br \/>\n     echo &#8220;$make_db refresh \ucd94\uac00 \uc131\uacf5<br \/>&#8220;;<br \/>\n   }else{<br \/>\n     echo &#8220;$make_db refresh \ucd94\uac00 \uc2e4\ud328<br \/>&#8220;;<br \/>\n   }   <\/p>\n<p>mysql_close($DB_CONNECT);<\/p>\n<p>?> <\/p>\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc544\ub098\uc2dc\uc2a4 \uc0c8\ub85c\uc6b4 db\ub97c \uc0dd\uc131\ud558\uace0 \ud574\ub2f9 \uc720\uc800\uc5d0 \uad8c\ud55c\uc744 \uc904\ub54c\ub9c8\ub2e4 \ud544\uc694\ud55c \uc2a4\ud06c\ub9bd\ud2b8 \ud30c\uc77c \uc785\ub2c8\ub2e4.. \ud55c\ubc88\ub9cc \ub9cc\ub4e4\uc5b4 \ub193\uc73c\uba74 \uac04\ub2e8\ud55c \uc124\uc815\uc73c\ub85c \uc27d\uac8c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4..<\/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-652","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\/652","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=652"}],"version-history":[{"count":0,"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts\/652\/revisions"}],"wp:attachment":[{"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=652"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=652"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=652"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}