navyism
\nhttp:\/\/navyism.com<\/p>\n
\uc608\uc804\uc5d0 n@search\ub77c\ub294 \ub85c\uceec\uac80\uc0c9\uc5d4\uc9c4\uc5d0 \ub123\uae30 \uc704\ud574
\n\ub9cc\ub4e4\uc5b4 \ub450\uc5c8\ub358 \uac80\uc0c9\uae30\uc758 \ucffc\ub9ac\uc0dd\uc131 \ud568\uc218 \uc785\ub2c8\ub2e4.<\/p>\n
\ud638\ucd9c\uc740 \uc544\ub798\uc640 \uac19\uc774 \ud574\uc8fc\uc2dc\uba74 \ub429\ub2c8\ub2e4.<\/p>\n
$array = make_where (A, B, C, D)<\/p>\n
A : \uac80\uc0c9\uc5b4\uc758 \uacf5\ubc31\uc744 \ub300\uccb4\ud560 \uc5f0\uc0b0\uc790 (and | or)
\nB : \uac80\uc0c9 \ud560 \uceec\ub7fc \uc774\ub984 (,\uc73c\ub85c \uc5f0\uacb0)
\nC : \uac80\uc0c9\uc5b4
\nD : \uac80\uc0c9\uc5b4\/\ubd80\uc815\uc5b4 \uc120\ud0dd (1 : \ubd80\uc815\uc5b4, 0 : \uac80\uc0c9\uc5b4)<\/p>\n
\ub9ac\ud134\ub418\ub294 $array\ub77c\ub294 \ubc30\uc5f4\uc5d0\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uac12\uc774 \uc800\uc7a5\ub429\ub2c8\ub2e4.<\/p>\n
$array[where] : Where\uc808\uc758 \ub0b4\uc6a9
\n$array[word] : \uac80\uc0c9\uc5d0 \uc0ac\uc6a9\ub41c \uac80\uc0c9\uc5b4 (\uacf5\ubc31\uc73c\ub85c \uc5f0\uacb0)<\/p>\n
\uc608)
\n$result = make_where (“and”, “name,title”, “\uc0ac\uacfc \ud3ec\ub3c4”, 0); \/\/ \ud638\ucd9c
\necho “$result[where]
$result[word]”; \/\/ \uacb0\uacfc\ucd9c\ub825<\/p>\n
\uacb0\uacfc)
\n( name like ‘%\uc0ac\uacfc%’ or title like ‘%\uc0ac\uacfc%’) and ( name like ‘%\ud3ec\ub3c4%’ or title like ‘%\ud3ec\ub3c4%’)
\n\uc0ac\uacfc \ud3ec\ub3c4<\/p>\n
\uac80\uc0c9\uc2dd\uc740 “(\uc0ac\uacfc and \ud3ec\ub3c4) or \ubc14\ub098\ub098” \uc640 \uac19\uc774 \uc0ac\uc6a9 \ud558\uc2e4 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.
\n\uadf8\ub9ac\uace0 \ubc14\ub85c where\uc808\uc5d0 \ud3ec\ud568\ud558\uae30 \ub54c\ubb38\uc5d0 Mysql\uc5d0\uc11c \uc9c0\uc6d0\ud558\ub294 _ \uc640 %\ub3c4 \uac00\ub2a5 \ud558\uaca0\uc8e0~<\/p>\n
\uadf8\uc800\uadf8\ub7f0 \uc18c\uc2a4\uc9c0\ub9cc…\uac80\uc0c9\ubd80\ubd84 \uc791\uc5c5\ud558\uc2e4\ub54c \uc720\uc6a9\ud55c \uc790\ub8cc\uac00 \ub418\uc2dc\uae30\ub97c…^^;;<\/p>\n
\n\n\/*<\/p>\n
*** \uac80\uc0c9\uc744 \uc704\ud55c SQL\uad6c\ubb38\uc758 Where\uc808 \uc0dd\uc131 \ud568\uc218<\/p>\n
*** by navyism
\n*** http:\/\/navyism.com
\n*** 2003.7.7<\/p>\n
$array = make_where (A, B, C, D)<\/p>\n
A : \uac80\uc0c9\uc5b4\uc758 \uacf5\ubc31\uc744 \ub300\uccb4\ud560 \uc5f0\uc0b0\uc790 (and | or)
\nB : \uac80\uc0c9 \ud560 \uceec\ub7fc \uc774\ub984 (,\uc73c\ub85c \uc5f0\uacb0)
\nC : \uac80\uc0c9\uc5b4
\nD : \uac80\uc0c9\uc5b4\/\ubd80\uc815\uc5b4 \uc120\ud0dd (1 : \ubd80\uc815\uc5b4, 0 : \uac80\uc0c9\uc5b4)<\/p>\n
-> return
\n$array[where] : Where\uc808\uc758 \ub0b4\uc6a9
\n$array[word] : \uac80\uc0c9\uc5d0 \uc0ac\uc6a9\ub41c \uac80\uc0c9\uc5b4 (\uacf5\ubc31\uc73c\ub85c \uc5f0\uacb0)<\/p>\n
*\/<\/p>\n
\nfunction make_where ($blank_is, $column_list, $word, $ban)
\n{
\nglobal $word_list;<\/p>\n
if($ban)
\n {
\n $like = “NOT LIKE”;
\n $join = “AND”;
\n }
\n else
\n {
\n $like = “LIKE”;
\n $join = “OR”;
\n }<\/p>\n
$word = stripslashes($word);
\n$temp = eregi_replace(“(“)(.*)( +)(.*)(“)”,”\\2[###blank###]\\4″,$word);
\n$temp = eregi_replace(“(|)| and | or “,” \\0 “,$temp);
\n$temp = trim(eregi_replace(” {2,}”,” “,$temp));
\n$result[word] = eregi_replace(“(|)| and | or “,” “,$temp);
\n$temp = explode(” “,$temp);<\/p>\n
for($i=0; $i
\n if($i)
\n {
\n if(eregi(“^)$”,$temp[$i-1]) && !eregi(“^or$|^and$”,$temp[$i]))
\n {
\n $temp2[] = $blank_is;
\n }<\/p>\n
if(!eregi(“^((|)|and|or)$”,$temp[$i-1]) && eregi(“^($”,$temp[$i]))
\n {
\n $temp2[] = $blank_is;
\n }<\/p>\n
if(!eregi(“^((|)|and|or)$”,$temp[$i-1]) && !eregi(“^((|)|and|or)$”,$temp[$i]))
\n {
\n $temp2[] = $blank_is;
\n }
\n }<\/p>\n
$temp2[] = $temp[$i];
\n }<\/p>\n
for($i=0; $i
\n if(eregi(“^((|)|and|or)$”,$temp2[$i]))
\n {
\n continue;
\n }<\/p>\n
unset($temp);
\n $temp .= “(“;
\n $temp2[$i] = addslashes($temp2[$i]);
\n $column_list_array =explode(“,”,$column_list);<\/p>\n
for($j=0; $j
\n if($j && $temp && $temp!=”(“)
\n {
\n $temp .= ” $join”;
\n }<\/p>\n
$temp .= ” $column_list_array[$j] $like ‘%$temp2[$i]%'”;<\/p>\n
\n }<\/p>\n
$temp .= “)”;
\n $temp2[$i] = $temp;
\n }<\/p>\n
$temp = implode(” “,$temp2);
\n$result[where] = str_replace(“[###blank###]”,” “,$temp);<\/p>\n
return $result;
\n}
\n?> <\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
navyism http:\/\/navyism.com \uc608\uc804\uc5d0 n@search\ub77c\ub294 \ub85c\uceec\uac80\uc0c9\uc5d4\uc9c4\uc5d0 \ub123\uae30 \uc704\ud574 \ub9cc\ub4e4\uc5b4 \ub450\uc5c8\ub358 \uac80\uc0c9\uae30\uc758 \ucffc\ub9ac\uc0dd\uc131 \ud568\uc218 \uc785\ub2c8\ub2e4. \ud638\ucd9c\uc740 \uc544\ub798\uc640 \uac19\uc774 \ud574\uc8fc\uc2dc\uba74 \ub429\ub2c8\ub2e4. $array = make_where (A, B, C, D) A : \uac80\uc0c9\uc5b4\uc758 \uacf5\ubc31\uc744 \ub300\uccb4\ud560 \uc5f0\uc0b0\uc790 (and | or) B : \uac80\uc0c9 \ud560 \uceec\ub7fc \uc774\ub984 (,\uc73c\ub85c \uc5f0\uacb0) C : \uac80\uc0c9\uc5b4 D : \uac80\uc0c9\uc5b4\/\ubd80\uc815\uc5b4 \uc120\ud0dd (1 : \ubd80\uc815\uc5b4, 0 : \uac80\uc0c9\uc5b4) […]<\/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-928","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\/928","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=928"}],"version-history":[{"count":0,"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts\/928\/revisions"}],"wp:attachment":[{"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=928"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=928"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=928"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}