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"; } ?>