![]() |
|
S/NO. | DRUG NAME | CATEGORY | UOM | GROUP | BALANCE IN STOCK | UNIT COST | STOCK VALUE | MIN STOCK | QTY TO REORDER |
---|---|---|---|---|---|---|---|---|---|
S/NO. | DRUG NAME | CATEGORY | UOM | GROUP | BALANCE IN STOCK | UNIT COST | STOCK VALUE | MIN STOCK LEVEL | QTY TO REORDER | '.$str123.' | '; } else{ return ''.$str123.' | '; } } return false; } function getIndicator($str123){ $str123 = trim($str123); $tempstr = str_replace('__','_',$str123); if($str123==''){ return ''.$str123.' | '; } else { $str1234=array(); $str1234=explode('_',$tempstr); $cnt = count( $str1234); if($str1234[$cnt-1]==''){ return ''.$str123.' | '; } else{ return ''.$str123.' | '; } } } require('connect/configdrug.php'); $sql = "SELECT * FROM ntihcdrugs WHERE DISCONTINUE = 'NO' ORDER BY DRUGNAME ASC"; $res = $conn->query($sql); while($row=$res->fetch_assoc()){ echo '
'.$row["id"].' | '. getIndicator($row["DRUGNAME"]). getIndicator($row["CATEGORY"]). getIndicator($row["UNITOFMEASURE"]). getIndicator($row["BREAKDOWN"]). getIndicator($row["BALANCEINSTOCK"]). getIndicator($row["UNITPRICE"]). getIndicator($row["STOCKVALUE"]). getIndicator($row["REORDERLEVEL"]). ''.$row["QTYTOREORDER"].' |