View Full Version : Cash Register SQL database

11-09-2007, 12:36 PM
ok i have a data base for my products and i can use it as i would a cash register but i would like for it to print it like an invoice on a template without having the invoice ready printed before hand is there a way to add the template so when i press save and print it prints all the structure and info on a blank page

11-09-2007, 01:37 PM
you want it to print in a template but not in a template? umm thats confusing.

if you are using some type of server-side coding such as PHP you can save the products to a session "shopping cart" and when the user saves the page it can be put into a cookie and/or print you can create a default structure of how to print the page.

if thats not what you are looking for can you please explain it again?

11-10-2007, 08:39 PM
yes that is very helpful thank you but you miss understood

Right at this moment in time i have invoices printed templates and i have to organise data each time and i would like to get this set up as an SLQ or MySQL database

what i want to do is some how store the template in and when i input data it will print data + template eliminating the printed invoice templates i pay for to get done

so in a way i would like to make an SQL database work like a cash register so when i input data like address phone number and other fields it would print on an A4 Sheet of paper with an invoice template so the A4 Page is blank when i place it in the print fead tray

11-12-2007, 04:14 AM
oh well that is just a matter of creating the database how you want it... then creating a html template and a stylesheet for online viewing... if you need help with your database design we would need to know the fields you want in your database (info you will store)

11-22-2007, 02:05 PM

Product Description
Price Ex VAT
Price +VAT


these are the fields that i have written on the Invoice and i would like to make into a database

VAT is a Value Added Tax in ireland on goods and services 21% on a product and about 15% on a service