need your comments to manage my database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
php12342005
Forum Commoner
Posts: 79
Joined: Mon Mar 21, 2005 3:35 am

need your comments to manage my database

Post by php12342005 »

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
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

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...
User avatar
AnarKy
Forum Contributor
Posts: 119
Joined: Tue Nov 02, 2004 1:49 am
Location: South Africa

PHP forms which insert into a database

Post by AnarKy »

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.)
Post Reply