check.php

<?php
include('connect_db.php');
session_start();
if(isset($_POST['customer_id']))
{
$c_id=$_POST['customer_id'];
	$cname=$_POST['customer_name'];
	$age=$_POST['age'];
	$sex=$_POST['sex'];
	$postal=$_POST['postal_address'];
	$phone=$_POST['phone'];
	
	$_SESSION['custId']=$c_id;
	$_SESSION['custName']=$cname;
	$_SESSION['age']=$age;
	$_SESSION['sex']=$sex;
	$_SESSION['postal_address']=$postal;
	$_SESSION['phone']=$phone;
						
}

if(isset($_POST['drug_name']))
{
	$drug=$_POST['drug_name'];
	$strength=$_POST['strength'];
	$dose=$_POST['dose'];
	$quantity=$_POST['quantity'];
	$sql=mysql_query("INSERT INTO tempPrescri(customer_id,customer_name,age,sex,postal_address,phone,drug_name,strength,dose,quantity)
						VALUES('{$_SESSION['custId']}','{$_SESSION['custName']}','{$_SESSION['age']}','{$_SESSION['sex']}','{$_SESSION['address']}','{$_SESSION['phone']}','{$drug}','{$strength}','{$dose}','{$quantity}')");
						
						$_SESSION['quantity']=$quantity;
	$get_cost=mysql_query("SELECT cost FROM stock WHERE drug_name='{$drug}'");
	$cost=mysql_fetch_array($get_cost);
	$tot=$quantity*$cost[0];
	
	$file=fopen("receipts/docs/".$_SESSION['custId'].".txt", "a+");
	fwrite($file, $drug.";".$strength.";".$dose.";".$quantity.";".$cost[0].";".$tot."\n");
	fclose($file);
	echo "<table width=\"100%\" border=1>";
        echo "<tr> 
		<th>Drug</th> 
		<th>Strength </th>
		<th>Dose</th>
		<th>Quantity </th></tr>";
        // loop through results of database query, displaying them in the table
		 $result = mysql_query("SELECT * FROM tempPrescri")or die(mysql_error());
        while($row = mysql_fetch_array($result)) 
		{
                // echo out the contents of each row into a table
                echo "<tr>";
                
				echo '<td>' . $row['drug_name'] . '</td>';
				echo '<td>' . $row['strength'] . '</td>';
				echo '<td>' . $row['dose'] . '</td>';
				echo '<td>' . $row['quantity'] . '</td>';
				}

}

if(isset($_POST['invoice_no']))
{
$invoice=$_POST['invoice_no'];

	$receipt=$_POST['receipt_no'];
	$amount=$_POST['amount'];
	$payment=$_POST['payment_type'];
	$serial=$_POST['serial_no'];
	
	$_SESSION['receiptNo']=$receipt;
	$_SESSION['amount']=$amount;
	$_SESSION['paymentType']=$payment;
	$_SESSION['serialNo']=$serial;
$getDetails=mysql_query("SELECT invoice,drug,cost,quantity FROM invoice_details WHERE invoice='{$invoice}'");
$getQuantity=mysql_query("SELECT quantity FROM invoice_details WHERE invoice_id='{$invoice}'");
$file=fopen("receipts/docs/".$_SESSION['invoiceNo'].".txt", "w");
	
	
	echo "<table width=\"100%\" border=1>";
        echo "<tr> 
		
		<th>Drug </th>
		<th>Unit cost</th>
		<th>Quantity </th>
		<th>Total Cost(Ksh.)</th></tr>";
while($item5=mysql_fetch_array($getDetails))
			{
			$getDrug=mysql_query("SELECT drug_name FROM stock WHERE stock_id='{$item5['drug']}'");
						
			$drug=mysql_fetch_array($getDrug);
			$qtty=mysql_fetch_array($getQuantity);
			$tot=$item5['cost']*$item5['quantity'];
			$total[]=$tot;
			fwrite($file, $drug[0].";".$item5['cost'].";".$item5['quantity'].";".$tot.";\n");	
				
				echo "<tr>";
                echo '<td>' . $drug[0] . '</td>';
				echo '<td align="right">' . number_format($item5['cost'],2) . '</td>';
				echo '<td align="right">' . $item5['quantity'] . '</td>';
				echo '<td align="right">' . number_format($tot,2). '</td>';
				echo "</tr>";
						
			}
	$zote=array_sum($total);
echo "<tr>";
                echo '<td><strong>TOTAL</strong></td>';
				echo '<td></td>';
				echo '<td></td>';
				echo '<td align="right">' . number_format($zote,2) . '</td>';
				echo "</tr>";	
fwrite($file, "TOTAL;;;".$zote.";\n");
fclose($file);
echo "</table>"; 				
}
?>