function str_replace_deep($search, $replace, $subject) { if (is_array($subject)) { foreach ($subject as &$oneSubject) { $oneSubject = str_replace_deep($search, $replace, $oneSubject); } unset($oneSubject); return $subject; } else { return str_replace($search, $replace, $subject); } }
$POSTS = getGET_POST($POSTS_STRING, 'POST'); updateSQL('ppt', $POSTS, "`id`='{$GETS['id']}'"); echo json_encode($POSTS, true); exit; break; case 'before_search': $POSTS_STRING = "s"; $POSTS = getGET_POST($POSTS_STRING, 'POST'); $SQL = "SELECT REPLACE(CONCAT(\r\n `名詞`,'|',\r\n `同義詞`,'|',\r\n `技術相關`,'|',\r\n `事件相關`,'|',\r\n `物品相關`,'|',\r\n `空間相關`,'|',\r\n `人物相關`),'|',',') as `output`\r\n FROM `keywords`\r\n WHERE \r\n UPPER(CONCAT(\r\n `名詞`,'|',\r\n `同義詞`,'|',\r\n `技術相關`,'|',\r\n `事件相關`,'|',\r\n `物品相關`,'|',\r\n `空間相關`,'|',\r\n `人物相關`)\r\n ) LIKE ? \r\n LIMIT 1 "; $SCODE = "%{$POSTS['s']}%"; $ra = selectSQL_SAFE($SQL, array($SCODE)); if (count($ra) == 0) { echo $POSTS['s']; } else { $ra[0]['output'] = str_replace("\n", "", $ra[0]['output']); $ra[0]['output'] = str_replace_deep(",,", ",", $ra[0]['output']); $m = explode(",", $ra[0]['output']); for ($i = 0, $max_i = count($m); $i < $max_i; $i++) { if (trim($m[$i]) == "") { unset($m[$i]); } } $m = array_values($m); echo implode(",", $m); } exit; break; case 'doLike': $GETS_STRING = "id"; $GETS = getGET_POST($GETS_STRING, 'GET'); $ppt_items_info = pdo_get_assoc_from_id('ppt_items', $GETS['id']);