if (isset($_REQUEST['type']) && $_REQUEST['type'] != "") {
if ($_REQUEST['type'] == 'cr') {
$queryProducts = "SELECT * FROM `chemicalrequirements` WHERE requirementID=" . $_REQUEST['id'];
$resultProducts = mysqli_query($conn, $queryProducts);
if (mysqli_num_rows($resultProducts) != 0) {
$rowProduct = mysqli_fetch_array($resultProducts);
?>
Required Quantity : |
$quantity = explode("-", $rowProduct['quantity']);
echo $quantity[0] . " " . $quantity[1];
?>
|
Posted on : |
|
//not-registered User
if ($rowProduct['existingUser'] != 1) {
$contactName = $rowProduct['contactName'];
$companyName = $rowProduct['companyName'];
$contactNumber = $rowProduct['contactNo'];
$emailID = $rowProduct['emailID'];
} else {
$queryUser = "SELECT `contactName`,`companyName`,`businessPhone`,`userName` FROM `users` WHERE `userID`=" . $rowProduct['userID'];
$resultUser = mysqli_query($conn, $queryUser);
if (mysqli_num_rows($resultUser) != 0) {
$rowUser = mysqli_fetch_array($resultUser);
$contactName = $rowUser['contacttName'];
$companyName = $rowUser['companyName'];
$contactNumber = $rowUser['businessPhone'];
$emailID = $rowUser['userName'];
}
}
?>
Contact Name: |
|
Contact Number: |
|
Email Id: |
|
}
}
else if ($_REQUEST['type'] == 'fml') {
$queryProducts = "SELECT * FROM `chemicalproducts` WHERE productID=" . $_REQUEST['id'] . " and chemicalTypeID='4'";
$resultProducts = mysqli_query($conn, $queryProducts);
if (mysqli_num_rows($resultProducts) != 0) {
while ($rowProducts = mysqli_fetch_array($resultProducts)) {
$queryformulations = "SELECT * FROM `formulations` where formulationID=" . $rowProducts['formulationID'];
$resultformulations = mysqli_query($conn, $queryformulations);
if (mysqli_num_rows($resultformulations) != 0) {
$rowFormulation = mysqli_fetch_array($resultformulations);
$userQuery = "select companyName from users where userID=" . $rowProducts['userID'];
$resultUser = mysqli_query($conn, $userQuery);
$rowUser = mysqli_fetch_array($resultUser);
?>
$imageList = explode(",", $rowFormulation['imageList']);
//show gallery images
$baseImagePath = "images/formulations";
showImageGallery($imageList, $baseImagePath);
?>
Description: |
|
Application: |
|
Manufacturer: |
|
Marketing Agent: |
|
Posted by : |
|
$dateStr = $rowProducts['addedDate'];
if (date("Y-m-d") == $rowProducts['addedDate']) {
$dateStr = 'Today';
} elseif (date("Y-m-d", strtotime('-1 day')) == $rowProducts['addedDate']) {
$dateStr = 'Yesterday';
}
echo $dateStr;
?>
|
}
}
}
}
else if ($_REQUEST['type'] == 'ep') {
$queryProducts = "SELECT * FROM `equipmentproducts` where equipmentID=" . $_REQUEST['id'];
$resultProducts = mysqli_query($conn, $queryProducts);
if (mysqli_num_rows($resultProducts) != 0) {
$rowProduct = mysqli_fetch_array($resultProducts);
$userQuery = "select companyName from users where userID=" . $rowProduct['userID'];
$resultUser = mysqli_query($conn, $userQuery);
$rowUser = mysqli_fetch_array($resultUser);
?>
$imageList = explode(",", $rowProduct['imageList']);
//show gallery images
$baseImagePath = "images/equipmentProducts";
showImageGallery($imageList, $baseImagePath);
?>
Description: |
|
Posted by : |
|
$dateStr = $rowProduct['addedDate'];
if (date("Y-m-d") == $rowProduct['addedDate']) {
$dateStr = 'Today';
} elseif (date("Y-m-d", strtotime('-1 day')) == $rowProduct['addedDate']) {
$dateStr = 'Yesterday';
}
echo $dateStr;
?>
|
}
}
else if ($_REQUEST['type'] == 'bns') {
$queryProducts = "SELECT * FROM `usedequipmentproducts` where usedEquipmentID=" . $_REQUEST['id'];
$resultProducts = mysqli_query($conn, $queryProducts);
if (mysqli_num_rows($resultProducts) != 0) {
$rowProduct = mysqli_fetch_array($resultProducts);
$userQuery = "select companyName from users where userID=" . $rowProduct['userID'];
$resultUser = mysqli_query($conn, $userQuery);
$rowUser = mysqli_fetch_array($resultUser);
?>
$imageList = explode(",", $rowProduct['imageList']);
//show gallery images
$baseImagePath = "images/usedEquipmentProducts";
showImageGallery($imageList, $baseImagePath);
?>
Description: |
|
Posted by : |
|
Year of Manufacture : |
|
$dateStr = $rowProduct['addedDate'];
if (date("Y-m-d") == $rowProduct['addedDate']) {
$dateStr = 'Today';
} elseif (date("Y-m-d", strtotime('-1 day')) == $rowProduct['addedDate']) {
$dateStr = 'Yesterday';
}
echo $dateStr;
?>
|
}
} else if ($_REQUEST['type'] == 'pmp') {
$queryProducts = "SELECT * FROM `packingproducts` where packingID=" . $_REQUEST['id'];
$resultProducts = mysqli_query($conn, $queryProducts);
if (mysqli_num_rows($resultProducts) != 0) {
$rowProduct = mysqli_fetch_array($resultProducts);
$userQuery = "select companyName from users where userID=" . $rowProduct['userID'];
$resultUser = mysqli_query($conn, $userQuery);
$rowUser = mysqli_fetch_array($resultUser);
$catQuery = "select packingCategoryName from packingcategories where packingCategoryID=" . $rowProduct['packingCategoryID'];
$resultCat = mysqli_query($conn, $catQuery);
$rowCat = mysqli_fetch_array($resultCat);
$subcatQuery = "select packingSubCategoryName from packingsubcategories where packingSubCategoryID=" . $rowProduct['packingSubCategoryID'];
$resultSubcat = mysqli_query($conn, $subcatQuery);
$rowSubcat = mysqli_fetch_array($resultSubcat);
?>
$imageList = explode(",", $rowProduct['imageList']);
//show gallery images
$baseImagePath = "images/packingProducts";
showImageGallery($imageList, $baseImagePath);
?>
Category: |
|
Specifications: |
|
Description: |
|
Posted by : |
|
$dateStr = $rowProduct['addedDate'];
if (date("Y-m-d") == $rowProduct['addedDate']) {
$dateStr = 'Today';
} elseif (date("Y-m-d", strtotime('-1 day')) == $rowProduct['addedDate']) {
$dateStr = 'Yesterday';
}
echo $dateStr;
?>
|
}
} else if ($_REQUEST['type'] == 'js') {
$queryProducts = "SELECT * FROM `jobs` WHERE jobID=" . $_REQUEST['id'];
$resultProducts = mysqli_query($conn, $queryProducts);
if (mysqli_num_rows($resultProducts) != 0) {
$rowProduct = mysqli_fetch_array($resultProducts);
$userQuery = "select companyName from users where userID=" . $rowProduct['userID'];
$resultUser = mysqli_query($conn, $userQuery);
$rowUser = mysqli_fetch_array($resultUser);
?>
Description: |
|
Experience: |
|
Salary Range: |
|
Posted by : |
|
$dateStr = $rowProduct['addedDate'];
if (date("Y-m-d") == $rowProduct['addedDate']) {
$dateStr = 'Today';
} elseif (date("Y-m-d", strtotime('-1 day')) == $rowProduct['addedDate']) {
$dateStr = 'Yesterday';
}
echo $dateStr;
?>
|
}
} else if ($_REQUEST['type'] == 'cm') {
$queryProducts = "SELECT * FROM `users` WHERE userID=" . $_REQUEST['id'];
$resultProducts = mysqli_query($conn, $queryProducts);
if (mysqli_num_rows($resultProducts) != 0) {
$rowProduct = mysqli_fetch_array($resultProducts);
$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);
?>
City: |
|
Country->Province: |
|
Established in: |
|
|
Contact Name: |
|
Mobile: |
|
if ($rowProduct['businessPhone'] != "") {
echo '
Business Phone: |
' . $rowProduct['businessPhone'] . ' |
';
}
if ($rowProduct['fax'] != "") {
echo '
Fax: |
' . $rowProduct['fax'] . ' |
';
}
if ($rowProduct['website'] != "") {
echo '
Website: |
' . $rowProduct['website'] . ' |
';
}
?>
|
}
} else if ($_REQUEST['type'] == 'nms') {
if (isset($_REQUEST['id']) && $_REQUEST['id'] != "") {
$queryNmsProducts = "SELECT * FROM `nonmovingstocks` WHERE nmsID='" . $_REQUEST['id'] . "' and `active`=1";
$resultNmsProducts = mysqli_query($conn, $queryNmsProducts);
if (mysqli_num_rows($resultNmsProducts) != 0) {
$rowProduct = mysqli_fetch_array($resultNmsProducts);
}
$chemicalID = $rowProduct["chemicalID"];
}
$productsQuery = "select * from chemicals where chemicalID=" . $chemicalID;
$resultChemicals = mysqli_query($conn, $productsQuery);
if (mysqli_num_rows($resultChemicals) != 0) {
$rowChemicals = mysqli_fetch_array($resultChemicals);
?>
$imageList = array();
$imageList[0] = $rowChemicals["structure"];
$baseImagePath = "images/chemicalProducts";
//showGallery($imageList, $baseImagePath);
$imagePath = getImgPath($rowChemicals["structure"], $baseImagePath);
?>
CAS NO: |
|
Molecular Formula: |
|
Molecular Weight: |
|
/* $synList = explode(";", $rowChemicals["synonyms"]);
if (sizeof($synList) !== 0) {
$str = 'Synonyms: | ';
for ($i = 0; $i < sizeof($synList); $i++) {
$str .= ' ' . $synList[$i] . ' ';
}
$str .= ' |
';
echo $str;
}*/
?>
Contact Details
Available Quantity : |
$quantity = explode("-", $rowProduct['quantity']);
echo $quantity[0] . " " . $quantity[1];
?>
|
Available Pack Size : |
$packSize = explode("-", $rowProduct['packSize']);
echo $packSize[0] . " " . $packSize[1];
?>
|
Manufacture Year : |
|
Posted on : |
|
|
Contact Name: |
Anjaneyulu |
Contact Number: |
+91-95539-69696 |
Email ID: |
nms@localpharmaguide.com |
|
}
} else {
$chemicalID = $_REQUEST['id'];
$productsQuery = "select * from chemicals where chemicalID=" . $chemicalID;
$resultChemicals = mysqli_query($conn, $productsQuery);
if (mysqli_num_rows($resultChemicals) != 0) {
$rowChemicals = mysqli_fetch_array($resultChemicals);
?>
$imageList = array();
$imageList[0] = $rowChemicals["structure"];
$baseImagePath = "images/chemicalProducts";
//showGallery($imageList, $baseImagePath);
$imagePath = getImgPath($rowChemicals["structure"], $baseImagePath);
?>
CAS NO: |
|
Molecular Formula: |
|
Molecular Weight: |
|
if ($rowChemicals['mp'] != "") {
echo ' MP : | ' . $rowChemicals['mp'] . ' | ';
}
if ($rowChemicals['bp'] != "") {
echo ' BP : | ' . $rowChemicals['bp'] . ' | ';
}
if ($rowChemicals['fp'] != "") {
echo ' FP : | ' . $rowChemicals['fp'] . ' | ';
}
if ($rowChemicals['fema'] != "") {
echo ' fema : | ' . $rowChemicals['fema'] . ' | ';
}
if ($rowChemicals['merck'] != "") {
echo ' merck : | ' . $rowChemicals['merck'] . ' | ';
}
if ($rowChemicals['brn'] != "") {
echo ' brn : | ' . $rowChemicals['brn'] . ' | ';
}
if ($rowChemicals['density'] != "") {
echo ' Density : | ' . $rowChemicals['density'] . ' | ';
}
if ($rowChemicals['vapourDensity'] != "") {
echo ' Vapour Density : | ' . $rowChemicals['vapourDensity'] . ' | ';
}
if ($rowChemicals['vapourPressure'] != "") {
echo ' Vapour Pressure : | ' . $rowChemicals['vapourPressure'] . ' | ';
}
if ($rowChemicals['refractiveIndex'] != "") {
echo ' Refractive Index : | ' . $rowChemicals['refractiveIndex'] . ' | ';
}
if ($rowChemicals['storageTemparature'] != "") {
echo ' Storage Temparature : | ' . $rowChemicals['storageTemparature'] . ' | ';
}
if ($rowChemicals['solubility'] != "") {
echo ' Solubility : | ' . $rowChemicals['solubility'] . ' | ';
}
if ($rowChemicals['waterSolubility'] != "") {
echo ' Water Solubility : | ' . $rowChemicals['waterSolubility'] . ' | ';
}
?>
|
if ($rowChemicals['application'] != "") {
echo ' Application : | ' . $rowChemicals['application'] . ' | ';
}
if ($rowChemicals["synonyms"] != "") {
$synList = explode(";", $rowChemicals["synonyms"]);
if (sizeof($synList) !== 0) {
$displayItems = 3;
if (sizeof($synList) < $displayItems) {
$displayItems = sizeof($synList);
}
$str = 'Synonyms: | ';
for ($i = 0; $i < $displayItems; $i++) {
$str .= ' ' . $synList[$i];
if (sizeof($synList) > $displayItems && $i == $displayItems - 1) {
$str .= ' ...more';
}
$str .= ' ';
}
$str .= ' | ';
echo $str;
}
}
if ($rowChemicals['drugsUsing'] != "") {
$drugsUsingList = explode(";", $rowChemicals["drugsUsing"]);
if (sizeof($drugsUsingList) !== 0) {
$str = 'Drugs Using: | ';
for ($i = 0; $i < sizeof($drugsUsingList); $i++) {
$str .= ' ' . $drugsUsingList[$i] . ' ';
}
$str .= ' | ';
echo $str;
}
}
?>
|
}
}
}
?>