[insert_php]
global $wpdb; $get_brands = $wpdb->get_results(“SELECT * FROM pifl_terms as pt INNER JOIN pifl_term_taxonomy as ptt ON pt.term_id=ptt.term_id WHERE ptt.taxonomy=’pwb-brand’ ORDER BY pt.name ASC”); foreach($get_brands as $get_brand){
$get_termmeta_link = $wpdb->get_results(“SELECT * FROM pifl_termmeta WHERE meta_key=’pwb_brand_banner_link’ AND term_id=$get_brand->term_id”); if(!empty($get_termmeta_link)){
$get_termmeta_img_id = $wpdb->get_results(“SELECT * FROM pifl_termmeta WHERE meta_key=’pwb_brand_image’ AND term_id=$get_brand->term_id”); } }
[/insert_php]
We have 17 brands of our own covering a variety of products from drinks to household goods. All of our products are designed to be on par with, if not, a better quality than the market leaders at a 30-40% lesser price. For example, our English Breeze & Flower Garden air fresheners have 2% perfume instead of the industry norm of 1% resulting in a longer lasting fragrance. Aside from our own brands that have become household names in 80 + countries within just 23 years, we also represent multinationals in various parts of the world. For example, we are the official distributor for Mondelēz in GCC & Africa, for Kraft-Heinz in Africa, for Nestle and Unilever in Africa & the Middle East and so on…
Our Brands
[insert_php] foreach($get_brands as $get_brand){
$parent_cat_list = ”;
$get_termmeta_category = $wpdb->get_results(“SELECT * FROM pifl_termmeta WHERE meta_key=’pwb_brand_category’ AND term_id=$get_brand->term_id”);
if(!empty($get_termmeta_category[0]->meta_value)){
$parent_cat_list = $get_termmeta_category[0]->meta_value;
} $get_termmeta_link = $wpdb->get_results(“SELECT * FROM pifl_termmeta WHERE meta_key=’pwb_brand_banner_link’ AND term_id=$get_brand->term_id”); if(!empty($get_termmeta_link)){
$get_termmeta_img_id = $wpdb->get_results(“SELECT * FROM pifl_termmeta WHERE meta_key=’pwb_brand_image’ AND term_id=$get_brand->term_id”);
echo’
‘;
echo’
->meta_value.'” link=”‘.$get_termmeta_link[0]->meta_value.'”]
‘;
echo’
‘;
} }
[/insert_php]
[insert_php] foreach($get_brands as $get_brand){ $get_parent_cat = $wpdb->get_results(“SELECT rel1.* FROM pifl_term_relationships as rel JOIN pifl_term_relationships as rel1 ON rel1.object_id=rel.object_id WHERE rel.term_taxonomy_id=$get_brand->term_taxonomy_id”);
$parent_cat_list = ”;
foreach($get_parent_cat as $parent_cat){
$get_parent_cat_name = $wpdb->get_row(“SELECT trm.slug FROM pifl_term_taxonomy as tax JOIN pifl_terms as trm ON trm.term_id=tax.term_id WHERE tax.term_taxonomy_id=$parent_cat->term_taxonomy_id AND trm.term_id!=$get_brand->term_id”);
$parent_cat_list .= $get_parent_cat_name->slug.” “;
} $get_termmeta_link = $wpdb->get_results(“SELECT * FROM pifl_termmeta WHERE meta_key=’pwb_brand_banner_link’ AND term_id=$get_brand->term_id”); if(empty($get_termmeta_link)){
$get_termmeta_img_id = $wpdb->get_results(“SELECT * FROM pifl_termmeta WHERE meta_key=’pwb_brand_image’ AND term_id=$get_brand->term_id”);
if(!empty($get_termmeta_img_id[0]->meta_value)){
$get_termmeta_category = $wpdb->get_results(“SELECT * FROM pifl_termmeta WHERE meta_key=’pwb_brand_category’ AND term_id=$get_brand->term_id”);
if(!empty($get_termmeta_category[0]->meta_value)){
$parent_cat_list = $get_termmeta_category[0]->meta_value;
}
echo’
‘;
echo’
->meta_value.'” link=”‘.$get_termmeta_link[0]->meta_value.'”]
‘;
echo’
‘;
}
} }
[/insert_php]
English
Arabic
Bengali
Chinese (Simplified)
French
German
Hindi
Persian
Portuguese
Russian
Spanish
Swahili
