include APPPATH.'views/includes/settings.php'; foreach ($content as $ta): $metatitle = $ta->product_name; $metadescription = $ta->product_desc; $metakeywords = $ta->product_name; endforeach; $patterns_prod = array("
","
"); $parent_id = $option_price = ''; foreach ($content as $el): $parent_id = $el->category_name; $name_prod = $el->product_name; $desc_prod = $el->product_desc; endforeach; if($el->meta_title !=""){ $metatitle = $el->meta_title; }else{ $metatitle = $metatitle; } if($el->meta_desc !=""){ $metadescription = $el->meta_desc; }else{ $metadescription = $metadescription; } if($el->meta_key !=""){ $metakeywords = $el->meta_key; }else{ $metakeywords = $metakeywords; } $category_name = $this->db->query("SELECT categ_name FROM categories WHERE id='".$parent_id."'"); $whois_category = $category_name->row()->categ_name; $drop_price_sel = $this->db->query("SELECT id,strength_vol, FORMAT(strength_price,2) AS Price FROM strength WHERE strength_product='".$el->prodid."' ORDER by id ASC LIMIT 1"); $drop_price = $this->db->query("SELECT id,strength_vol, strength_price,IFNULL(CONCAT(' / ',prod_package),'') AS prod_package,prod_inventory,weight_s FROM strength WHERE strength_product='".$el->prodid."' ORDER by id ASC"); $pr = $drop_price_sel->row('Price'); foreach($drop_price->result() as $opt){ if($el->inventory !="0.00"){ $option_price .= '\n'; }else{ $option_price .= '\n'; } } //don't show prices if(!$iduser){ $disabled = "disabled"; $show_stars = " style='display:none'"; }else{ $disabled = ""; $show_stars = ""; } $drop_Style = 'font-size:1.2em !important;'; $label_dropdown = "Choose Your Options"; if($el->amazon_link !=''){ $amazon_link = '
';
}else{
$amazon_link = '';
}
if($el->indigo_link !=''){
$indigo_link = '
';
}else{
$indigo_link = '';
}
if($el->alibaba_link !=''){
$alibaba_link = '
';
}else{
$alibaba_link = '';
}
$no_purchase = '';
foreach($el->author as $author){
$author_name = $author->author_name;
$author_pic = $author->a_id;
$author_books = $author_b->books;
$bio = $author->bio;
$portrait = $author->portrait;
$bio = $author->bio;
}
$title_coming = $el->com_soon;
//not allowed coming soone
if($el->prod_parent == 2){
$no_purchase = " display:none !important";
}
?>