Formulation Details
>>
Application : | |
Manufacturer : | |
Marketing Agent : |
>>
session_start(); include("includes/connection.php"); include("includes/lpgHelper.php"); if (!array_key_exists('id', $_REQUEST) || $_REQUEST['id'] === 0) { header("Location:index.php"); } $sideBanner = ''; $queryNmsProducts = "SELECT ep.*, u.verified, u.companyName, u.userID, u.stateID, u.countryID, u.city, u.businessTypeID, ec.* FROM formulations ep, formulationcategories ec, users u where ep.formulationID=" . $_REQUEST['id'] . " and ep.`userID` = u.`userID` and ep.`status`=1 and ep.categoryID = ec.categoryID"; $resultNmsProducts = mysqli_query($conn, $queryNmsProducts); if (mysqli_num_rows($resultNmsProducts) != 0) { $rowProduct = mysqli_fetch_array($resultNmsProducts); } $enquiryUrl = "productEnquiry.php?sid=".$rowProduct['userID']."&pid=".$_REQUEST['id'].'&type=fp'; $baseImagePath = "images/formulations"; $imageList = explode(",", $rowProduct['imageList']); $userURL = "productDetailsPage.php?type=cm&id=" . $rowProduct['userID']; if ($rowProduct['verified'] == '1') { $userURL = "cu/home_userProfile.php?id=" . $rowProduct['userID']; } $breadCrumbsURL = "searchFormulations.php?scat=".$rowProduct['categoryID']; //country and State $queryCountry = "select countryName,stateName from states s,countries c where stateID=" . $rowProduct['stateID'] . " and s.countryID = c.countryID"; $resultCountry = mysqli_query($conn, $queryCountry); $rowCountry = mysqli_fetch_array($resultCountry); //Business Type $queryStr = "select * from businesstypes where businessTypeID=" . $rowProduct['businessTypeID']; $resultUsers = mysqli_query($conn, $queryStr); if (mysqli_num_rows($resultUsers) != 0) { $rowBusinessTypes = mysqli_fetch_array($resultUsers); } //location $location = ""; if ($rowProduct['city'] != "") { $location .= $rowProduct['city'] . ", "; } if ($rowCountry['stateName'] != "") { $location .= $rowCountry['stateName'] . " - "; } if ($rowCountry['countryName'] != "") { $location .= $rowCountry['countryName']; } ?>
Application : | |
Manufacturer : | |
Marketing Agent : |