Ready Project |BCA Project | MCA Project | BBA Project | MBA Project |INDIA'S BIGGEST COLLEGE PROJECT STORE

23)Consider the following entities and their relationships
BillMaster(billno, custname, billdate )
BillDetails(itemname, qty, rate, discount)
BillMaster and BillDetails are related with one-to-many relationship.
Create a RDB in 3 NF for the above and solve following
Write PHP script to print the bill in following format Accept the Bill number from user.

BillNo :
BillDate :
Customer Name :

Sr.No. Particular Quantity Rate Discount Total


                      slip23-php-

<?php

            $bno  =  $_GET['bno'];


            $con  =  mysql_connect("localhost","root","");

            $d  =  mysql_select_db("bca_programs",$con);


            $q  =  mysql_query("select * from bill_master where bill_no=$bno");


            echo "<center>";

            while($row  =  mysql_fetch_array($q))

            {
                        echo " <h3><br>Bill No : ".$row[0]."                            Bill Date : ".$row[2]."</h3>";

                        echo "<<h3>Customer Name : ".$row[1]."</h3>";

            }


            $i=1;

            $gt=0;

            $q1=mysql_query("select item_name,qty,rate,discount from bill_details,bill_master where bill_details.bill_no=$bno and bill_details.bill_no=bill_master.bill_no");



            echo "<table border=1 width=30% height=10%>";

            echo "<tr><td><b> SrNo. </b></td> <td><b> Particular </b></td> <td><b> Quantity </b></td><td><b> Rate</b></td><td><b> Total </b></td></tr>";    
   
   
           
            while($row1=mysql_fetch_array($q1))

            {

                        $t=$row1[1]*$row1[2];

                        echo "<br><tr><td>".$i++."</td><td>".$row1[0]."</td><td>".$row1[1]."</td><td>".$row1[2]."</td><td>".$t."</td><tr>";

           
                        $gt=$gt+$t;                    
   
            }          

           
            echo "</table>";

            echo "<br><b> Gross Ammount is :: ".$gt."</b>";

            echo "<center>";


            mysql_close();

?>


1.html-

<html>

<body>

<form action="slip_23.php" method="get">

<center><h3>Enter the Bill Number  : <input type=text name=bno><br></h3>

<input type=submit value=SUBMIT></center>

</form>

</body>

</html>

Search

Project Categories

Recent Posts

Sign In