prepare($sql); $query-> bindParam(':bannerTop', $bannerTop, PDO::PARAM_STR); $query-> bindParam(':ad_type', $bt, PDO::PARAM_STR); $query->execute(); $sql="UPDATE ads SET ad_code=(:bannerContent) WHERE ad_type=:ad_type "; $query = $dbh->prepare($sql); $query-> bindParam(':bannerContent', $bannerContent, PDO::PARAM_STR); $query-> bindParam(':ad_type', $bc, PDO::PARAM_STR); $query->execute(); $sql="UPDATE ads SET ad_code=(:bannerSidebar) WHERE ad_type=:ad_type"; $query = $dbh->prepare($sql); $query-> bindParam(':bannerSidebar', $bannerSidebar, PDO::PARAM_STR); $query-> bindParam(':ad_type', $bs, PDO::PARAM_STR); $query->execute(); $sql="UPDATE ads SET ad_code=(:popads) WHERE ad_type=:ad_type "; $query = $dbh->prepare($sql); $query-> bindParam(':popads', $popads, PDO::PARAM_STR); $query-> bindParam(':ad_type', $pa, PDO::PARAM_STR); $query->execute(); $msg="Settings Updated Successfully"; } $sql = "SELECT * from ads "; $query = $dbh -> prepare($sql); $query->execute(); $results=$query->fetchAll(PDO::FETCH_OBJ); $cnt=1; if($query->rowCount() > 0){ foreach($results as $result){ $adType = htmlentities($result->ad_type); if(strpos($adType, 'banner-content') !== false){ $bannerContent = base64_decode(htmlentities($result->ad_code)); }elseif(strpos($adType, 'banner-sidebar') !== false){ $bannerSidebar = base64_decode(htmlentities($result->ad_code)); }elseif(strpos($adType, 'banner-top') !== false){ $bannerTop = base64_decode(htmlentities($result->ad_code)); }else{ $popAds = base64_decode(htmlentities($result->ad_code)); } } } ?>

Settings

Ads bannner for header : 728*90
Ads bannner for content : 728 * xxx
Ads bannner for sidebar : 300 * xxx
Popads code