prepare($sql); $query-> bindParam(':headerCode', $headerCode, PDO::PARAM_STR); $query-> bindParam(':id', $hc, PDO::PARAM_STR); $query->execute(); $sql="UPDATE custom_codes SET content=(:footerCode) WHERE id=:id "; $query = $dbh->prepare($sql); $query-> bindParam(':footerCode', $footerCode, PDO::PARAM_STR); $query-> bindParam(':id', $fc, PDO::PARAM_STR); $status = $query->execute(); if ($status) { $msg="Settings Updated Successfully"; }else{ $error="Error"; } } $sql = "SELECT * from custom_codes "; $query = $dbh -> prepare($sql); $query->execute(); $results=$query->fetchAll(PDO::FETCH_OBJ); if($query->rowCount() > 0){ foreach($results as $result){ $codeType = htmlentities($result->id); if(strpos($codeType, 'header') !== false){ $headerCode = base64_decode(htmlentities($result->content)); }else{ $footerCode = base64_decode(htmlentities($result->content)); } } } ?>

Custom Codes