{"id":951,"date":"2003-09-15T01:53:55","date_gmt":"2003-09-15T01:53:55","guid":{"rendered":"http:\/\/dev.jblove.net\/?p=951"},"modified":"2003-09-15T01:53:55","modified_gmt":"2003-09-15T01:53:55","slug":"mysql-%eb%8b%a4%ec%a4%91%ea%b2%80%ec%83%89","status":"publish","type":"post","link":"https:\/\/jblove.net\/?p=951","title":{"rendered":"mysql \ub2e4\uc911\uac80\uc0c9"},"content":{"rendered":"

\/\/ TEMPORARY TABLE MAKE<\/p>\n

$tmp_make=mysql_query(“create temporary table tmp (<\/p>\n

sid int NOT NULL DEFAULT ‘0’ auto_increment,<\/p>\n

board varchar(20) NOT NULL,<\/p>\n

bid int(11) NOT NULL,<\/p>\n

subject varchar(255) NOT NULL,<\/p>\n

content text,<\/p>\n

signdate int(10) NOT NULL,<\/p>\n

PRIMARY KEY(sid)<\/p>\n

)”);<\/p>\n

\/\/ \uac8c\uc2dc\ud310 \ud658\uacbd \uc124\uc815 \ud14c\uc774\ube14\uc5d0\uc11c \uac01 \uac8c\uc2dc\ud310 BOARD \uac00\uc838\uc624\uae30<\/p>\n

$total_result =mysql_query(“select board from board_config where limit_user_level < $admin_level\");\n\n\n$board_total = mysql_num_rows($total_result);\n\n\n \n\n\n \n\n\n\/\/ BOARD \ubcc4\ub85c \uac8c\uc2dc\ud310 \ub3cc\uba74\uc11c \uac80\uc0c9\ud55c\ub2e4\n\n\nfor($i=0;$i<$board_total;$i++) {\n\n\nmysql_data_seek($total_result,$i);\n\n\n$board = mysql_fetch_array($total_result);\n\n\n$search=mysql_query(“select bid,subject,content,signdate from $board[board] where name like ‘%$key%’ or subject like ‘%$key%’ or content like ‘%$key%'”);\n\n\n$search_total=mysql_num_rows($search);\n\n\n \n\n\n\/\/ \uac80\uc0c9 \uacb0\uacfc\ub97c TEMPORARY \ud14c\uc774\ube14\uc5d0 \uc9d1\uc5b4 \ub123\ub294\ub2e4\n\n\nfor($j=0;$j<$search_total;$j++) {\n\n\nmysql_data_seek($search,$j);\n\n\n$row = mysql_fetch_array($search);\n\n\n$insert=mysql_query(“insert into tmp\n\n\n(board,bid,subject,content,signdate)\n\n\nvalues\n\n\n(‘$board[board]’,’$row[bid]’,’$row[subject]’,’$row[content]’,’$row[subject]’)\n\n\n“); \n\n\n}\n\n\n}\n\n\n \n\n\n\/\/ TEMPORARY \ud14c\uc774\ube14 \uc815\ubcf4 \uac00\uc838\uc624\uae30\n\n\n$result=mysql_query(“select * from tmp order by signdate”);\n\n\n$total=mysql_num_rows($result);\n\n\n \n\n\necho “\n\n\n

<\/p>\n\n\n\n\n
\n

\uac80 \uc0c9 \uc5b4 $key<\/b><\/font> \ub85c $total<\/b><\/font> \uac1c\uc758 \uac8c\uc2dc\ubb3c\uc774 \uac80\uc0c9 \ub418\uc5c8\uc2b5\ub2c8\ub2e4<\/p>\n<\/td>\n<\/tr>\n

“;<\/p>\n

\/\/ \ubcf4\uc5ec\uc8fc\uae30<\/p>\n

for($k=0;$k<$total;$k++) {\n\n\nmysql_data_seek($result,$k);\n\n\n$board=mysql_fetch_array($result);\n\n\n$board[subject]=stripslashes($board[subject]);\n\n\n$board[content]=stripslashes($board[content]);\n\n\n$board[content]= htmlspecialchars($board[content]);\n\n\n$board[signdate]=date(“Y\/m\/d”,$board[signdate]);\n\n\n$board[content] = shortenStr($board[content],200,”
more…..”);<\/p>\n

$board[subject] = shortenStr($board[subject],60,”…..”); <\/p>\n

$board[subject] = eregi_replace(“($key)”,”1<\/font>“,$board[subject]);<\/p>\n

$board[content] = eregi_replace(“($key)”,”1<\/font>“,$board[content]);<\/p>\n

echo “<\/p>\n

\n

$board[subject]<\/b> ——- $board[signdate]<\/font><\/p>\n<\/td>\n<\/tr>\n

\n

$board[content]<\/a><\/p>\n<\/td>\n<\/tr>\n

“;<\/p>\n

}<\/p>\n

$drop=mysql_query(“drop table tmp”);<\/p>\n","protected":false},"excerpt":{"rendered":"

\/\/ TEMPORARY TABLE MAKE $tmp_make=mysql_query(“create temporary table tmp ( sid int NOT NULL DEFAULT ‘0’ auto_increment, board varchar(20) NOT NULL, bid int(11) NOT NULL, subject varchar(255) NOT NULL, content text, signdate int(10) NOT NULL, PRIMARY KEY(sid) )”); \/\/ \uac8c\uc2dc\ud310 \ud658\uacbd \uc124\uc815 \ud14c\uc774\ube14\uc5d0\uc11c \uac01 \uac8c\uc2dc\ud310 BOARD \uac00\uc838\uc624\uae30 $total_result =mysql_query(“select board from board_config where limit_user_level < $admin_level\"); […]\n<\/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-951","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\/951","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=951"}],"version-history":[{"count":0,"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts\/951\/revisions"}],"wp:attachment":[{"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=951"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=951"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=951"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}