<?PHP
	include'session.php';
	include'../connection.php';
	include'../functions.php';
	/*
	echo $qu_MST = "CREATE TABLE `INVOICE_MST` 
	(
	    `MST_ID` int(11) NOT NULL AUTO_INCREMENT,
        `INV_NO` varchar(100) DEFAULT NULL,
        `CUSTOMER_NAME` varchar(255) DEFAULT NULL,
        `CUSTOMER_MOBILENO` varchar(10) DEFAULT NULL,
        `ADDRESS` text DEFAULT NULL,
        PRIMARY KEY (`MST_ID`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1";
    
    if(mysqli_query($con,$qu_MST))
    {
        echo "Success";
    }
    else
    {
        echo "Failed";
    }
exit();
*/



$qu1 = "insert into `INVOICE_MST`(`MST_ID`,`INV_NO`,`CUSTOMER_NAME`,`CUSTOMER_MOBILENO`,`ADDRESS`) values (1,'INV01','DIVYESH PATEL','9825121212','VALSAD, GUJARAT')";
$qu2 = "insert into `INVOICE_MST`(`MST_ID`,`INV_NO`,`CUSTOMER_NAME`,`CUSTOMER_MOBILENO`,`ADDRESS`) values (2,'INV02','ROSHNI PATEL','8457878878','CHIKHLI, GUJARAT')";
$qu3 = "insert into `INVOICE_MST`(`MST_ID`,`INV_NO`,`CUSTOMER_NAME`,`CUSTOMER_MOBILENO`,`ADDRESS`) values (3,'INV03','DITYA PATEL','7487878788','JESPOR, VALSAD')";

CREATE TABLE `INVOICE_DET` (
  `DET_ID` int(11) NOT NULL AUTO_INCREMENT,
  `MST_ID` int(11) DEFAULT NULL,
  `PRODUCT_NAME` varchar(255) DEFAULT NULL,
  `AMOUNT` double(11,2) DEFAULT NULL,
  PRIMARY KEY (`DET_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

insert into `INVOICE_DET`(`DET_ID`,`MST_ID`,`PRODUCT_NAME`,`AMOUNT`) values (1,1,'DOMAIN WWW.SHINERWEB.COM',899);
insert into `INVOICE_DET`(`DET_ID`,`MST_ID`,`PRODUCT_NAME`,`AMOUNT`) values (2,1,'DATABASE MYSQL',3499);
insert into `INVOICE_DET`(`DET_ID`,`MST_ID`,`PRODUCT_NAME`,`AMOUNT`) values (3,1,'EMAIL SERVICES',799);
insert into `INVOICE_DET`(`DET_ID`,`MST_ID`,`PRODUCT_NAME`,`AMOUNT`) values (4,2,'DOMAIN WWW.GOOGLE.COM',4500);
insert into `INVOICE_DET`(`DET_ID`,`MST_ID`,`PRODUCT_NAME`,`AMOUNT`) values (5,2,'EMAIL SERVICES',799);
insert into `INVOICE_DET`(`DET_ID`,`MST_ID`,`PRODUCT_NAME`,`AMOUNT`) values (6,3,'DOMAIN WWW.FACEBOOK.COM',7999);


	
	
	
	
	
?>
