|
echo $company_name; ?>
Products
|
|
Related Products
|
$releted = "SELECT company_product_id, product_name, product_image FROM " . tbl_company_product . " WHERE product_status='1' and category_id='" . $ary_product['category_id'] . "' order by rand() limit 15";
$run = mysqli_query($link, $releted);
if ($rnum = mysqli_num_rows($run) > 0) {
echo "";
$i = 0;
while ($rrecords = mysqli_fetch_array($run)) {
$product_name = $rrecords['product_name'];
$product_image = $rrecords['product_image'];
$product_id = $rrecords['company_product_id'];
$mod_name = removeSpecialChar($product_name);
$mod_name = substr($mod_name, 0, 64);
$product_url = "Product/" . $product_id . "/" . $mod_name . ".html";
if ($product_image != '' && file_exists(PRODUCT_SAVE_PATH . $product_image)) {
$ary_file = getExtention($product_image);
if ($ary_file) {
$mod_name = removeSpecialChar($product_name);
$imageUrl = SITE_HOST . "productImage/" . $ary_file['filename'] . "/" . $mod_name . "" . $ary_file['ext'];
$ary_img = createthumb(PRODUCT_SAVE_PATH . $product_image, 120, 120);
$product_image_tag = ' ';
} else {
$product_image_tag = ' ';
}
} else {
$product_image_tag = ' ';
}
echo "" . $product_image_tag . " " . wordwrap($product_name, 15, " \n") . " | ";
$i++;
if ($i == "3 ") {
echo " ";
$i = 0;
}
}
echo " ";
} ?>
|
|
$releted = "SELECT company_profile_id, company_name, company_logo FROM " . tbl_company_profile . " WHERE company_published ='Y' and company_industry ='" . $ary_browse_company['company_profile']['company_industry'] . "' and company_industry !='0' order by rand() limit 16";
$run = mysqli_query($link, $releted);
if ($rnum = mysqli_num_rows($run) > 0) {
echo "
|
Related Companies |
";
$i = 0;
while ($rrecords = mysqli_fetch_array($run)) {
$company_name = $rrecords['company_name'];
$company_logo = $rrecords['company_logo'];
$company_id = $rrecords['company_profile_id'];
$mod_name = removeSpecialChar($company_name);
$mod_name = substr($mod_name, 0, 64);
$company_url = "Company/" . $company_id . "/" . $mod_name . ".html";
if ($company_logo != '' && file_exists(COMPANY_SAVE_PATH . $company_logo)) {
$ary_file = getExtention($company_logo);
if ($ary_file) {
$mod_name = removeSpecialChar($company_name);
$imageUrl = SITE_HOST . "companyLogo/" . $ary_file['filename'] . "/" . $mod_name . "" . $ary_file['ext'];
$ary_img = createthumb(COMPANY_SAVE_PATH . $company_logo, 120, 120);
$product_image_tag = ' ';
} else {
$product_image_tag = ' ';
}
} else {
$product_image_tag = ' ';
}
echo "" . $product_image_tag . "
" . wordwrap($company_name, 15, " \n") . " | ";
$i++;
if ($i == "4") {
echo " ";
$i = 0;
}
}
echo "
|
|
";
} ?>
|
|