We sell goods on the internet.
Assume a customer buys one good.
ok, we have his persional info and purchase (good) info.
now:
We need to input his data (all info) into our database.
what did you do to input data into database?
possible solutions:
1) create several php pages then input data manually.
2) create a software (application) by other languages (i.e. java or C++) then input data manually.
3) create a software then input data automatically (i.e. read data from a file then input data by the software).
4) other way I don't know.
now I prepare to use solution 1.
is it a bad solution? what you do now?
thanks
need your comments to manage my database
Moderator: General Moderators
-
php12342005
- Forum Commoner
- Posts: 79
- Joined: Mon Mar 21, 2005 3:35 am
It all depends on the "form" you have the data...
An example: you have the data on a printed sheet. This way it can be easily scanned with an OCR tool. On the other hand, if it's handwritten, i don't know how powerful OCR is these days...
But you could ask yourself: Where was this data printed? Is there a way can can get access to the electronial version
Once you have it in an electronical version, it should only be a matter of writing some glue "script/application" that stores it at the right places...
An example: you have the data on a printed sheet. This way it can be easily scanned with an OCR tool. On the other hand, if it's handwritten, i don't know how powerful OCR is these days...
But you could ask yourself: Where was this data printed? Is there a way can can get access to the electronial version
Once you have it in an electronical version, it should only be a matter of writing some glue "script/application" that stores it at the right places...
PHP forms which insert into a database
Hi,
What you need to do is pretty standard.
Structure you PHP pages so that...
When the user accesses a page to order something the information is captured by field in a form (html).
This same information is then submitted by the PHP page to the database (using SQL),
the data is then automatically stored in the DB and you have easy access to it.
The code for doing such things is very common (php manual, forums, etc.)
What you need to do is pretty standard.
Structure you PHP pages so that...
When the user accesses a page to order something the information is captured by field in a form (html).
This same information is then submitted by the PHP page to the database (using SQL),
the data is then automatically stored in the DB and you have easy access to it.
The code for doing such things is very common (php manual, forums, etc.)