브랜드 검색값을 구해봅니다. 채택완료

가능합니다

영카트 5.3버전 기준으로..

/shop/search.php if (isset($_GET['qname']) || isset($_GET['qexplan']) || isset($_GET['qid']) || isset($_GET['qbasic']) || isset($_GET['qbrand']))     $search_all = false;

$q       = utf8_strcut(get_search_string(trim($_GET['q'])), 30, ""); $qname   = isset($_GET['qname']) ? trim($_GET['qname']) : ''; $qexplan = isset($_GET['qexplan']) ? trim($_GET['qexplan']) : ''; $qid     = isset($_GET['qid']) ? trim($_GET['qid']) : ''; $qbasic  = isset($_GET['qbasic']) ? trim($_GET['qbasic']) : ''; $qbrand  = isset($_GET['qbrand']) ? trim($_GET['qbrand']) : ''; $qcaid   = isset($_GET['qcaid']) ? preg_replace('#[^a-z0-9]#i', '', trim($_GET['qcaid'])) : ''; $qfrom   = isset($_GET['qfrom']) ? preg_replace('/[^0-9]/', '', trim($_GET['qfrom'])) : ''; $qto     = isset($_GET['qto']) ? preg_replace('/[^0-9]/', '', trim($_GET['qto'])) : ''; if (isset($_GET['qsort']))  {     $qsort = trim($_GET['qsort']);     $qsort = preg_replace("/[\<\>\'\"\\\'\\\"\%\=\(\)\s]/", "", $qsort); } else {     $qsort = ''; } if (isset($_GET['qorder']))  {     $qorder = preg_match("/^(asc|desc)$/i", $qorder) ? $qorder : ''; } else {     $qorder = ''; }

if(!($qname || $qexplan || $qid || $qbasic || $qbrand))     $search_all = true;

// 검색범위 checkbox 처리 $qname_check = false; $qexplan_check = false; $qid_check = false; $qbasic_check = false;

if($search_all) {     $qname_check = true;     $qexplan_check = true;     $qid_check = true;     $qbasic_check = true;     $qbrand_check = true; } else {     if($qname)         $qname_check = true;     if($qexplan)         $qexplan_check = true;     if($qid)         $qid_check = true;     if($qbasic)         $qbasic_check = true;     if($qbrand)         $qbrand_check = true; }

if ($q) {     $arr = explode(" ", $q);     $detail_where = array();     for ($i=0; $i

        $concat = array();         if ($search_all || $qname)             $concat[] = "a.it_name";         if ($search_all || $qexplan)             $concat[] = "a.it_explan2";         if ($search_all || $qid)             $concat[] = "a.it_id";         if ($search_all || $qbasic)             $concat[] = "a.it_basic";         if ($search_all || $qbrand)             $concat[] = "a.it_brand";         $concat_fields = "concat(".implode(",' ',",$concat).")";

        $detail_where[] = $concat_fields." like '%$word%' ";

        // 인기검색어         insert_popular($concat, $word);     }

    $where[] = "(".implode(" and ", $detail_where).")"; }

./skin/shop/search.skin.php