isTablet()){ $img_path='//artephant.com/images/art/195/'; $device='tablet'; }elseif($detect->isMobile()&&!$detect->isTablet()){ $img_path='//artephant.com/images/art/165/'; $device='phone'; }else{ $img_path='//artephant.com/images/art/300/'; $device='desktop'; } include_once('/home/artephant/config.php'); $conn=mysqli_connect($hostname,$user,$pass,$dbase)or die(mysqli_connect_error()); $followed_galleries=array(); $result=mysqli_query($conn,"SELECT * FROM alerts WHERE user_id='$user_id'")or die(mysqli_error($conn)); while($row=mysqli_fetch_array($result)){ if($row['artist_or_gallery']=='1'){ $followed_galleries[]=$row['artist_id']; } } isset($_GET['style'])?$style=mysqli_real_escape_string($conn,$_GET['style']):$style=''; isset($_GET['type'])?$type=mysqli_real_escape_string($conn,$_GET['type']):$type=''; isset($_GET['image'])?$image=mysqli_real_escape_string($conn,$_GET['image']):$image=''; isset($_GET['gallery'])?$gallery=mysqli_real_escape_string($conn,$_GET['gallery']):$gallery=''; isset($_GET['artist'])?$artist=mysqli_real_escape_string($conn,$_GET['artist']):$artist=''; isset($_GET['city'])?$city=mysqli_real_escape_string($conn,$_GET['city']):$city=''; isset($_GET['type'])?$type=mysqli_real_escape_string($conn,$_GET['type']):$type=''; if($image=='0'){ $default_view=' hidden'; $search_galleries=' hidden'; $text_view=''; $image_view=' hidden'; $alpha_view=''; } elseif($image=='1'){ if(!isset($_GET['style'])){ $default_view=''; $search_galleries=' hidden'; }else{ $default_view=' hidden'; $search_galleries=''; // Search results } $text_view=' hidden'; // Alpha results $image_view=''; $alpha_view=' hidden'; }else{ $default_view=''; $search_galleries=' hidden'; // Search results $text_view=' hidden'; // Alpha results $image_view=''; $alpha_view=' hidden'; } if($artist!=''){ $search_results=''; $default_view=' hidden'; $search_galleries=''; $alpha_view=' hidden'; if($artist>1000000){ $sql="Select artist_first_name,artist_last_name FROM artists_c WHERE artist_id=$artist"; }else{ $sql="Select artist_first_name,artist_last_name FROM artists WHERE artist_id=$artist"; } $result=mysqli_query($conn,$sql)or die(mysqli_error($conn)); while($row=mysqli_fetch_array($result)){ $artist_name=$row['artist_first_name'].' '.$row['artist_last_name']; } $sql="SELECT a.establishment_name,a.id,a.logo,a.gallery_image,a.corporate1_city,a.corporate2_city,a.corporate3_city,a.corporate4_city,a.corporate5_city,a.corporate6_city,a.corporate7_city,a.corporate8_city,a.corporate9_city,a.corporate10_city,a.styles,a.additional_styles FROM users a JOIN gallery_ads b on a.id=b.user_id WHERE b.artist_id='$artist' AND a.frozen!='1' AND a.gallery_type='$type'"; $result=mysqli_query($conn,$sql)or die(mysqli_error($conn)); while($row=mysqli_fetch_array($result)){ $gallery_id=$row['id']; $gallery_name=$row['establishment_name']; $row['gallery_image']!=''?$img=$row['gallery_image']:$img=$row['logo']; $cities=$row['corporate1_city']; $row['corporate2_city']!=''?$cities.=', '.$row['corporate2_city']:$cities; $row['corporate3_city']!=''?$cities.=', '.$row['corporate3_city']:$cities; $row['corporate4_city']!=''?$cities.=', '.$row['corporate4_city']:$cities; $row['corporate5_city']!=''?$cities.=', '.$row['corporate5_city']:$cities; $row['corporate6_city']!=''?$cities.=', '.$row['corporate6_city']:$cities; $row['corporate7_city']!=''?$cities.=', '.$row['corporate7_city']:$cities; $row['corporate8_city']!=''?$cities.=', '.$row['corporate8_city']:$cities; $row['corporate9_city']!=''?$cities.=', '.$row['corporate9_city']:$cities; $row['corporate10_city']!=''?$cities.=', '.$row['corporate10_city']:$cities; $styles=rtrim(str_replace('||',', ',$row['styles']),', '); if($row['additional_styles']!=''){ $styles.=', '.rtrim(str_replace('||',', ',$row['additional_styles']),', '); } $search_results.='

'.$gallery_name.'

'.$cities.'

'.$styles.'

'; $search_results.=build_follow_button_gallery2($gallery_id,$followed_galleries,$user_id); $search_results.='
'; } } elseif($city!=''){ $search_results=''; $default_view=' hidden'; $search_galleries=''; $alpha_view=' hidden'; $city_chunks=explode(',',urldecode($city)); $corporate1_city=trim($city_chunks[0]); $corporate1_country=trim($city_chunks[2]); $corporate1_state=trim($city_chunks[1]); $sql="SELECT establishment_name,id,logo,gallery_image,corporate1_city,corporate2_city,corporate3_city,corporate4_city,corporate5_city,corporate6_city,corporate7_city,corporate8_city,corporate9_city,corporate10_city,styles,additional_styles FROM users WHERE corporate1_city='$corporate1_city' AND corporate1_country='$corporate1_country' AND (corporate1_state='$corporate1_state' OR corporate1_province='$corporate1_state') AND frozen!='1' AND gallery_type='$type'"; $result=mysqli_query($conn,$sql)or die(mysqli_error($conn)); while($row=mysqli_fetch_array($result)){ $gallery_id=$row['id']; $gallery_name=$row['establishment_name']; $row['gallery_image']!=''?$img=$row['gallery_image']:$img=$row['logo']; $cities=$row['corporate1_city']; $row['corporate2_city']!=''?$cities.=', '.$row['corporate2_city']:$cities; $row['corporate3_city']!=''?$cities.=', '.$row['corporate3_city']:$cities; $row['corporate4_city']!=''?$cities.=', '.$row['corporate4_city']:$cities; $row['corporate5_city']!=''?$cities.=', '.$row['corporate5_city']:$cities; $row['corporate6_city']!=''?$cities.=', '.$row['corporate6_city']:$cities; $row['corporate7_city']!=''?$cities.=', '.$row['corporate7_city']:$cities; $row['corporate8_city']!=''?$cities.=', '.$row['corporate8_city']:$cities; $row['corporate9_city']!=''?$cities.=', '.$row['corporate9_city']:$cities; $row['corporate10_city']!=''?$cities.=', '.$row['corporate10_city']:$cities; $styles=rtrim(str_replace('||',', ',$row['styles']),', '); if($row['additional_styles']!=''){ $styles.=', '.rtrim(str_replace('||',', ',$row['additional_styles']),', '); } $search_results.='

'.$gallery_name.'

'.$cities.'

'.$styles.'

'; $search_results.=build_follow_button_gallery2($gallery_id,$followed_galleries,$user_id); $search_results.='
'; } } elseif($gallery!=''){ $search_results=''; $default_view=' hidden'; $search_galleries=''; $alpha_view=' hidden'; $sql="SELECT establishment_name,id,logo,gallery_image,corporate1_city,corporate2_city,corporate3_city,corporate4_city,corporate5_city,corporate6_city,corporate7_city,corporate8_city,corporate9_city,corporate10_city,styles,additional_styles FROM users WHERE id='$gallery' AND frozen!='1' AND gallery_type='$type'"; $result=mysqli_query($conn,$sql)or die(mysqli_error($conn)); while($row=mysqli_fetch_array($result)){ $gallery_id=$row['id']; $gallery_name=$row['establishment_name']; $row['gallery_image']!=''?$img=$row['gallery_image']:$img=$row['logo']; $cities=$row['corporate1_city']; $row['corporate2_city']!=''?$cities.=', '.$row['corporate2_city']:$cities; $row['corporate3_city']!=''?$cities.=', '.$row['corporate3_city']:$cities; $row['corporate4_city']!=''?$cities.=', '.$row['corporate4_city']:$cities; $row['corporate5_city']!=''?$cities.=', '.$row['corporate5_city']:$cities; $row['corporate6_city']!=''?$cities.=', '.$row['corporate6_city']:$cities; $row['corporate7_city']!=''?$cities.=', '.$row['corporate7_city']:$cities; $row['corporate8_city']!=''?$cities.=', '.$row['corporate8_city']:$cities; $row['corporate9_city']!=''?$cities.=', '.$row['corporate9_city']:$cities; $row['corporate10_city']!=''?$cities.=', '.$row['corporate10_city']:$cities; $styles=rtrim(str_replace('||',', ',$row['styles']),', '); if($row['additional_styles']!=''){ $styles.=', '.rtrim(str_replace('||',', ',$row['additional_styles']),', '); } $search_results.='

'.$gallery_name.'

'.$cities.'

'.$styles.'

'; $search_results.=build_follow_button_gallery2($gallery_id,$followed_galleries,$user_id); $search_results.='
'; } } elseif($style!=''){ $default_view=' hidden'; if($image=='0'){ $search_galleries=' hidden'; $text_view=''; $image_view=' hidden'; $alpha_view=''; } elseif($image==''){ $default_view=' hidden'; $search_galleries=''; $text_view=' hidden'; $image_view=''; $alpha_view=' hidden'; }elseif($image=='0'){ $default_view=' hidden'; $search_galleries=' hidden'; $text_view=''; $image_view=' hidden'; $alpha_view=' hidden'; }else{ $search_galleries=''; $text_view=' hidden'; $image_view=''; $alpha_view=' hidden'; } $sql="SELECT establishment_name,id,logo,gallery_image,corporate1_city,corporate2_city,corporate3_city,corporate4_city,corporate5_city,corporate6_city,corporate7_city,corporate8_city,corporate9_city,corporate10_city,styles FROM users WHERE establishment_name!='' AND frozen!='1' AND gallery_type='$type' AND (styles LIKE '%$style%' OR additional_styles LIKE '%$style%')"; $result=mysqli_query($conn,$sql)or die(mysqli_error($conn)); while($row=mysqli_fetch_array($result)){ $gallery_id=$row['id']; $gallery_name=$row['establishment_name']; $row['gallery_image']!=''?$img=$row['gallery_image']:$img=$row['logo']; $cities=$row['corporate1_city']; $row['corporate2_city']!=''?$cities.=', '.$row['corporate2_city']:$cities; $row['corporate3_city']!=''?$cities.=', '.$row['corporate3_city']:$cities; $row['corporate4_city']!=''?$cities.=', '.$row['corporate4_city']:$cities; $row['corporate5_city']!=''?$cities.=', '.$row['corporate5_city']:$cities; $row['corporate6_city']!=''?$cities.=', '.$row['corporate6_city']:$cities; $row['corporate7_city']!=''?$cities.=', '.$row['corporate7_city']:$cities; $row['corporate8_city']!=''?$cities.=', '.$row['corporate8_city']:$cities; $row['corporate9_city']!=''?$cities.=', '.$row['corporate9_city']:$cities; $row['corporate10_city']!=''?$cities.=', '.$row['corporate10_city']:$cities; $styles=rtrim(str_replace('||',', ',$row['styles']),', '); if($row['additional_styles']!=''){ $styles.=', '.rtrim(str_replace('||',', ',$row['additional_styles']),', '); } $search_results.='

'.$gallery_name.'

'.$cities.'

'.$styles.'

'; $search_results.=build_follow_button_gallery2($gallery_id,$followed_galleries,$user_id); $search_results.='
'; } }else{ $sql="SELECT establishment_name,id,logo,gallery_image,corporate1_city,corporate2_city,corporate3_city,corporate4_city,corporate5_city,corporate6_city,corporate7_city,corporate8_city,corporate9_city,corporate10_city,styles FROM users WHERE establishment_name!='' AND frozen!='1' and gallery_type='$type'"; $search_results=''; $result=mysqli_query($conn,$sql)or die(mysqli_error($conn)); while($row=mysqli_fetch_array($result)){ $gallery_id=$row['id']; $gallery_name=$row['establishment_name']; $row['gallery_image']!=''?$img=$row['gallery_image']:$img=$row['logo']; $cities=$row['corporate1_city']; $row['corporate2_city']!=''?$cities.=', '.$row['corporate2_city']:$cities; $row['corporate3_city']!=''?$cities.=', '.$row['corporate3_city']:$cities; $row['corporate4_city']!=''?$cities.=', '.$row['corporate4_city']:$cities; $row['corporate5_city']!=''?$cities.=', '.$row['corporate5_city']:$cities; $row['corporate6_city']!=''?$cities.=', '.$row['corporate6_city']:$cities; $row['corporate7_city']!=''?$cities.=', '.$row['corporate7_city']:$cities; $row['corporate8_city']!=''?$cities.=', '.$row['corporate8_city']:$cities; $row['corporate9_city']!=''?$cities.=', '.$row['corporate9_city']:$cities; $row['corporate10_city']!=''?$cities.=', '.$row['corporate10_city']:$cities; $styles=str_replace('||',', ',$row['styles']); $search_results.='

'.$gallery_name.'

'.$cities.'

'.$styles.'

'; $search_results.=build_follow_button_gallery2($gallery_id,$followed_galleries,$user_id); $search_results.='
'; } } ?>

SUB GALLERY

FEATURED GALLERIES
SEARCH GALLERIES BY STYLE

GALLERIES

Search Galleries By Artist(s)
Search Galleries By City
Search Galleries By Name

GALLERIES ()

0){ echo "
\n"; echo "

".strtoupper($alpha)."

\n"; echo "
\n"; while($row=mysqli_fetch_array($result)){ echo '

'.$row['establishment_name'].'

'; } // end while() echo '
'; }// end if($results>0 for this letter) }// END foreach(alpha) mysqli_close($con); ?>
'; }else{ $content.=' '; } return $content; } ?>