PHP and SQL help, PLEASE!?

B

brett m

New member
My company needs a "Customer Data Sheet" form to be set up.

I know how to set up the form and process it to an SQL database using .php.

But what I need it to do is to be able to create a unique ID so more then one person can go to that ID (maybe a search or a drop down) into each record and be able to change it at any time.

I will also need it to be able to export to Excel (I am sure .phpAdmin will do this, or is there an easier way?)

I will also need to have my co-workers to be able to login to keep it secure.

Is there any free .php scripts out there that could help me? Thanks
Why are all "web developers" snobs? Just answer the f'ing question.
 
I'm not completely sure what you are asking for with the unique ID, but here's how to export to excel:

// The easiest approach is to export as a CSV. To do this, use the following header....

header("Content-type: application/csv\nContent-Disposition: \"inline; filename=dates_of_year.csv\"");

// ... and then simply print each field delimited by a comma. Users will be able to open
// the exported page directly from excel.
 
Back
Top