View Invoice as a web page?

russellbcv

Is it possible to view an invoice as a web page?

If you were to go to:-

http://www.rbcserver.net/cpanel/invoices.php

You will see a drop down box with "months" - when the user is logged on is there some php coding to extract the appropriate month?

Basically, not to store invoices but to create them when the user makes the request.

I have a table in mysql which contains the following:-

username
month
invoiceref
calls
mins
revenue
occ
vat
bill

Any help with this would be much appreciated.

Yours

Russell

Skull

just select data from the database based on the month and username

e.g

WHERE username='".$username."' AND month=".$_POST['month']."

with the month drop down list values matching the format of the column "month" in your database table. You then just output information from the table onto a template Invoice and your done 😛

russellbcv

Hi P

Thank you for your reply.

I have already created the "list/menu" and manually entered the list values i.e Feb05, Jan05, Dec04 etc....

Have I done this correctly? How would you output information from the table onto a template invoice?

Yours

Russell

justsomeone

Hi Russel,

Creating a template and populating it with dynamic values is easy.

Send me a private message and we can go through it in detail.

russellbcv

I have just sent you a private message.

When is a good time?