Dear all, I would like to create pdf invoices using the free FPDF library from [url removed, login to view] I have a shopping cart in PHP. There is an "order" table that contains all information about the orders placed by the visitors of the website. The idea is to use the data in this table to create the invoices. There is one design question I have: Should I store the invoices in another "invoice" table..? Or should I just create the invoices directly from the "order" table. As for the coding I only ask for the creation of the PHP functions to create a pdf invoice file on the fly. Desing recommendations are also welcomed. But I can take care of managing the invoices if an "invoice" table is needed. Thanks
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
create table if not exists order ( id int unsigned not null auto_increment, firstname varchar(50) not null, lastname varchar(50) not null, company varchar(50) not null, email varchar(50) not null, telephone varchar(20) not null, mobilePhone varchar(20) not null, message text not null, invoiceAddressId int unsigned not null, shippingAddressId int unsigned not null, orderDateTime datetime not null, status varchar(10) NOT NULL, paymentType varchar(10) NOT NULL, primary key (id), unique (id) ); The solution must work on PHP [url removed, login to view] and must use FPDF from [url removed, login to view]