[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]