Collaborate on Create PDF Invoice for Research and Development with Ease Using airSlate SignNow

Create pdf invoice for Research and Development

[Music] hello world welcome to my channel i am sahil and today i am going to show you how to generate invoice pdf using dome pdf library php and mysql in previous video you have already seen how i have created add more fields and inserted all the items in the database so i will use the same database to fetch all the items and generate an invoice pdf okay so if you have not watched my previous video then first watch that video you can get the link in the description box okay now before starting let me show you the demo okay so here you can see a button pdf invoice so when i click this button then you can see we are redirected to other page with the pdf file okay and here you can see the invoice okay so here in invoice you can see uh i have fetched all the item details like item name price and quantity and i calculated the total amount of this item okay and and so on okay and i have also added gst okay and then grand total and then grand total in rounded figure okay so i will uh generate this type of invoice pdf today in this video okay so let's start so just close this one and so this was our previous project and there i have created this index.php file and this action.php file okay so let me open the previous project okay so this is the previous project okay here you can see this is the add more button and from here we we can add into the database okay and this is the database add more add underscore more and this is the item table items table where there are three items are present okay so i'm not going to insert any more items i am going to implement uh implement to generate invoice pdf okay using dom pdf library so for this uh just go to index.php file and here i will create a button first okay just here i'll create another button so i will use anchor tag and here i will write pdf dot php in href attribute and i will use class btn btn sorry uh btn btn danger and here i will also write the name of the button invoice pdf or whatever you want and i will also use target and here i will use blank okay and if i refresh then you can see in voice pdf now if i click on click on this link then it is redirecting to this pdf.php file okay so next what i will do is i will create a new pdf.php file pdf dot php file okay now inside this file i will create html okay in voice and first i will create a table okay but just above the table i will display the invoice heading okay now just below this uh i will create sorry i will create a table now inside this table i will create table head and inside this table here i will create a tr then th and inside this th i will first display the id and then item then item price then quantity and then total okay now just below this closing t head tag i will use t body tag now inside this uh i will create another tr and then inside td i will just writing static data 1 and item name sorry item name and here i will display the item price so 50 and item quantity so here i will write to then total 100 okay and if i save this and go to the browser and click on this invoice pdf then you can see invoice id item price quantity and total okay now next i will design some more input fields okay so just um okay so just just after this closing t body tag i will create one more tr and here i will create a th tag and i will use call span call a span 4 and i will also use a class class um my tab okay my tab actually my table okay and here i will write gst and here i will write 18 percent okay and just below this i will use another th okay and here i will display the total gst amount okay total calculated gst amount and then i will copy the same thing below this i will display the grand total okay so here here i will write grand total and just use any number to display some static data paste one more time and here just write here just write grant total in grand total round fee okay rounded figure and here i will display the grand total in rounded figure okay and i will create one more tr tag just below this and here i will use td call a span sorry call span pipe and here i will use an id sign and here i'll write signature okay if i save this and refresh then you can see something like this now we have to just use some css to style this so just above here i will use style tag and here first i will select the h2 tag okay and i will use font family vardana okay and then i will use text align center then i will select that table okay and i will use font family arial okay and then i will use border collapse border collapse collapse okay and then i will use with 100 percent if i save this and go to the browser and refresh then you can see the table width is now 100 percent now next what i will do is i will just use td and th select the tdn th and i will use border border one pixel solid and then i will use 444 okay refresh so you can see the border okay now next what i will do is i will just come below and i will also give some padding adding [Music] eight pixel okay sorry padding 8 pixel and if i refresh then you can see some paddings okay and next i will select my table class and here i will use text align right okay text line right so if i refresh then you can see all the all these three are aligned to the right okay and also give text a line to this td and th to left okay save this and go to the browser and rephrase now you can see all the amounts are now displaying the left side okay now next what i will do is i will select the sign using sign id and here i will use padding padding top actually padding top 50 pixel and text align right okay text line right save this now if i repress then you can see the signature here okay now next uh what i will do is first uh first we need to download the dom pdf library okay so for this just open a new tab and here search for dom pdf okay now open this first link dom pdf github link and from here what i will do is just go below and just copy this command this composer command okay open the terminal here okay and paste the command now hit enter to download the dom pdf library into this project okay so just wait until it downloads okay so it is downloading okay so now you can see the dom pdf library has been downloaded now next what i will do is just here at the top in this pdf file here i will open the php tags okay and next here what i will do is i will just uh use require once and then first i will select this vendor and then autoload dot pc file okay so if you go to this vendor directory then there is a auto load dot pc file so we have to include this file inside this pdf.pc file okay now next we have to use use dom pdf dom pdf then dome pdf okay now next we have to create the connection to the database so for this i will just go to this accent.pc file and copy this this code and paste here okay now next i will create a sql variable and from here i will select all the rows select asterisk from items table okay items and then i will create a statement variable and then using connection i will use prepare and then pass the sql here okay statement execute and then i will create a variable rows and then statement then fetch all and here i will use pdo page sock okay and save this now if i just use print r here and just display the row and go to this file and refresh then you can see we are getting all the item details in array okay so we will loop all the items and display in the table okay so here before looping first we will create grand total so for grand total i will create gt equal to zero and i will also use an increment counter dollar i equal to one okay now next what i will do is uh i will just select this from up to here okay cut and then i will create a variable here html html okay and i'll paste all the codes here inside this html okay you can see i have created a variable html and i have cut all the codes up from here doctype from doctor up to this t body opening t body uh tag okay now next for each loop okay for each loop then rows sorry rows as row okay and inside this i will use html and then i will concatenate this time now just cut this here and paste okay now here what i will do is just insert this i will display the counter so here i will use dollar i and in item name i will just display the item name okay so here i will write a row and here i will write name the column name and then here i will just use row and here i will display the price okay so just write price okay so i will display the price in a decimal format okay so i will just cut this twice and i will use php number format function and i will paste inside this and i will use comma two okay so after price i will add two decimal points okay and then uh here i will display the quantity so just write row and then quantity quantity okay and then i will here i will show the total amount of the item okay so here also i will use the number format function sorry number format casey function and inside this i will first select the price and then i will with the quantity so here i will write quantity okay row quantity so whatever is the total price of the item will be uh multiply with the quantity then we will get the total amount okay of the item now next inside this uh i will calculate the grand total price so inside this for each loop i will just use gt and then i will just use plus equal to row price and then i will multiply with row quantity okay row point so here what i'm doing is i am just uh adding all the total price of the items and storing in this gt variable okay now next i will also increment the dollar i variable okay so here just write dollar i and again just just after this closing for each loop i will again use html html variable and here i will configure it again and then inside this i will select the t body t body up to this html okay cut and paste here okay now inside this what i will do is here i will calculate the gst okay so here what i will do is i will use number format okay so number format and inside this first i will uh get the grand total price so gt gt and then multiply with 18 okay so i am just calculating the gst with the 18 okay so we have to write 18 and then divide it by 100 okay 100 and okay so next let me just give some parenthesis here now here i will use two four decimal points okay now next here for the grand total price we have to add this gst price and the grand total price okay so here what i will do is just remove this and here again i will use number format and next i will first select the gt grand total then i will use plus and then i will copy the same thing from here okay copy paste okay and then use two for decimal points okay uh something is wrong here okay so we have to close one more time okay no need to close one more time okay so just right i'm adding grand total with the price that is calculated the gst price and i am adding in the grand total price okay now next in grand total rounded figure what i will do is i will just copy the same thing okay here and i will just use the round round function okay so just select everything to here and just use round round and then paste all this here okay save this so our calculation is also finished now next i will use dom pdf library to generate pdf okay so just below this i will create a sorry i will create an object of dom pdf so here i'll write down pdf equal to new dom pdf okay and then using dom pdf object i will use load html method okay html and here i will pass the html okay next i will create dom using dom object i will use set paper set paper and here we will use a4 and here i will use portrait okay for portrait you can also use landscape if you want but i will use portrait here and then i will use dom pdf render method okay render method and i will also use dom pdf object stream and here we have to write the file name so here i will write invoice dot pdf okay and here okay just keep this up to here save and save and just go to your browser okay and just now if i click on this invoice pdf and wait then you can see we uh the browser is asking to download this invoice.pdf file okay so if i just download this file and open this file then you can see the invoice okay so you can see uh the items with the quantity and then the total is calculated here and so on and you can see the gst calculated is here and the grand total is here and the total uh price in the rounded figure okay now this time if i click on invoice pdf then then the pdf file is downloading but we want to open in new tab so for this here just below just use parentheses okay here i will use attachment okay so in array i will use attach attachment and then i will just use zero okay if i just write attachment 0 and if i rephrase and then and when i click on invoice pdf then it is not downloading instead it is opening in a new tab with all the details of the invoice okay so that's it for now thanks for watching this video please like and share this video and also subscribe to my channel see you soon in the next video [Music] you