Effortlessly Create a Bill Format PDF Download for Management

Bill format pdf download for Management

hi if you want to generate your pdf or if you want to generate your invoice into your pdf file so in this video we will learn how to generate your pdf by using php dynamically and here you can see we already created one demo for you so let's check the demo and how this work now here you can see we created some view buttons download button and upload pdf button so here you can see whenever i click on view pdf at that time this pdf will be displayed inside this browser and here you can see these are invoice data which is displayed inside this pdf now when i click on this download pdf at that time this pdf will be download in our local pc or on your local computer so when i click on this downloaded pdf so here you can see this pdf will be display like this so and upload pdf so whenever i click on this upload pdf your pdf will be uploaded in your one folder so also check that pdf is uploaded or not here you can see we created one predefined demo for you and here we created one folder like uploads and inside this upload folder we uploaded our invoice here you can see the time is 5 0 2 and here also you can see 502 that means your pdf will be like or pdf is this so also we open at that pdf and check that pdf so this is how your pdf will display so in this video we will cover all the functionality like view pdf download pdf and upload your pdf so how is it possible let's check or let's see step by step right so in this video or in this blog now in this video we will cover or we will set up live demo for you to view pdf to download pdf and upload that pdf so step by step we will see how to set up this code for your pdf to generate pdf right so we predefine created one demo for you or write it down one block for you so you can easily set up this code into your project or i also set this link in my video description so you can go through that link so here you can see what is the step one you need to go to phpmyadmin and execute this sample as sql statement and this sample data so simply copy paste this code into your or simply copy paste this sql statement into your file or into your php my admin i copy paste this code and i already execute that data in my sql so you need to go to sql and execute this sample data so i already created that both table invoice mst and invoice detail right this data will be used in our pdf so that's why we use this sample data once you created or executed this sample data into your database now step two you need to make one connection file like database dot database underscore connection dot php right so i already created that file simply you need to create one project folder like generate pdf and inside this folder you need to write or you need to create one file like database underscore connection dot php right once you connect your database i already said this file in in the source code file so you can download that source code from here so you will get all the file and everything right now now first you need to create connection file right once you connected your file now now in step 3 you need to create one file like index.php where we will display our all the data right so here you can see we display our data one by one so for that we created one file like index.php so simply i open that file and explain what is the code so here you can see we created one file and included font awesome bootstrapmen.css and jk main.js which is used for designing and for that and four icons we use fantasman.css bootstrap mean which is used for designing so for that we included this library right now here you can see we create one table and set up some heading like this so here you can see this heading is we created now we get data from the database so how to get a data from the database so first we need to write or we need to include our database connection file now once you include your database connection file we write it down one select query to get data from the database so by using this select query we get data from the database like we need to display our customer data so i simply writing this query now once you get a data we need to we need to show on our page so for that we make one while loop and one by one data will be display on our web page so here you can see we display that data like customer name customer mobile address so here you can see customer name mobile and address and the most important part is this so for we need to suppose we need to view our pdf so for that here you can see we create one file like pdf maker dot php so i simply open data file pdfmaker.php now now here you can see we pass one id which is used to get the data from the database and display data data on pdf so that's why we passed that id we required that id to get the data from the database so that's why we passed that id so here we pass that id so mst id is equal to this this is our dynamically get id now here you can see we pass that dynamically id like this when i hover on this button at that time you can see a dynamically id will be stored inside this mst underscore id right so this is how we pass our id dynamically and also we pass one action like first is for a view pdf second is for download pdf and third is upload pdf so whenever i click on this button at that time xn will be pass is equal to you now when i click on this button when i click on this button at that time our pdfmaker.php file will call so this file will be called so first we required our database connection file so we included that of connection file now second one we need to include tcpdf library what is this api so you for generating your pdf or dynamically generated your pdf for that we require tcpdf library so you you suppose you need to know more about tcpdf so you can go through this and you can get all the documents and everything from tcpdf.org right if you want to learn then you can go through this document and you will get idea how this tcpdf will work right now this library i already share in my source code so you can download from there now this is how you need to include this library now once you include that library here you can see we access our dynamically id by using dollar underscore cat why we are using this dollar underscore card because we pass that value in this url by using this url we get data by using dollar underscore get now here you can see we get a value with get method why we are using a get matter because we are passing our id with url that's why we are using a get method and get a value with dollar underscore gap once you store the that id here you can see we written down one select query to get data from the database based on this id right so by using this id we get that customer data only so whenever we click on any button at that time we pass one id and that id will be used inside this query now once you get the result from the query we store inside this now here you can see we store our already result inside this variable invoice mst results right now this result value will be used in this now here you can see we store our query result inside this variable and that variable value will pass inside this invoice mst data row now that dynamically value will be accessing trog like this invoice mst data row then your attribute name it means your column name so this is how we dynamically set our customer name mobile number and bill number so this master data coming from this master table right so this is your master data and that data will be accessing stroke this invoice mst data now now here you can see we need to use this tcpdf predefined some format some header some header font and everything so simply you need to copy paste this code and you must have to remember if you want to some another page size then you can change as per your requirement right now here we writing some style for invoice designing so simply you need to copy paste this code and here we writing some our branding details like signer web technology contact number website and all that right this is dynamically data and now the most important line level data now here you can see this line level data will be get from the database this data also coming from the database but this data will be line level so how this is possible for that we simply writing one query like select from our second table like invoice detail and here we also pass that id and get the result inside this variable and we make one while loop by using this while loop we one by one data store inside this while loop and set that data in this trtd trtd right now here we calculate some total that the total will be display like this so as per your requirement you writing your logic or you can change this logic as per your requirement right so once your dynamically value will be set up that dynamically value store inside this content variable right and that content variable will continue with dot is equal to then and then your all the dynamically value stored inside this content variable now that contain variable we need to pass inside this write html this is a predefined tcpdf function we must have to pass this content variable inside this function then and then your pdf will be generated or then and then your pdf will be download right now this is our file name we created one file name like this so inv underscore date and time so for that we created take one date and time variable and pass this date and time variable inside this so this is how we created file lamp now the most important here we handle when i click on view button it means when i click on this view when i click on this view we pass action is equal to view but when i click on this download button at that time action is equal to download and when i click on this upload at that time action is equal to upload so here you can see we pass the action view download and upload based on you can you based on your requirement you can also pass this action right so here we check that xn is equal to you then this pdf output method will be used this is a pdefined predefined method you must have to pass this file name and this attribute like i i it means inline view and here you can see we also use this output method same which is used here and but here you can see we pass one attribute like d d it means what it means download your pdf and the last one is upload it means when you need to upload your file in your database or sorry in your folder or on your server at that time you must have to pass f if it means what means file you must have to upload your file on this so at that time here you can see you must have to pass your file location not a file name only here you need to pass your file location so that's why we created file part or folder part here or if you are using a simple uh local exam server so you must have to pass below this part this is local exam server part this is a live server part that's why i taking this location if you are using a local pc so you must have to pass this part now that part and your file name and add attribute f it means file so this is how this code will be work right so here you can see when i click on view at that time our pdf will be display right now suppose if i click on this third view at that time this detail invoice will be display suppose i click on this second one view at that time here you can see rosny patel invoice will be generated so this is how dynamically generate your pdf by using this php code with tcpdf library and here you can see you can also download this pdf so simply by using this dcpdf library you can create or generate or upload your pdf so i hope so whenever you set up this code in your project or if you have any difficulty while setuping this code please write it down your comments in your comment section and if you have any difficulty please tell me i will try to resolve your problem and i hope you like this video and don't forget to subscribe our channel and i also said this all the source code here so you can download your source code from here i already copy paste this source code in my drive so you can download from here and so simply you can copy paste this whole folder from this drive so you can copy this code i hope you will like our video and don't forget to subscribe our channel because once you subscribe our channel you will get so many video so many blogs and everything so thanks for watching and keep subscribe our channel and bye