PDA

Click to See Complete Forum and Search --> : database I think?!

chris6969
04-30-2003, 02:08 PM
Good morning, This is what I am going to need if you can help let me know? I need some type of system that when new or old clients call I can pull up there information by either putting in there home phone number or ssn number or name. Does anyone know where I can get a program like that? Isnt that a database? Are their free ones online I could not find one I searched the internet.
Jona
04-30-2003, 02:15 PM
Yes. It requires a database and a server-side language (such as, PHP, ASP, CGI/Perl). http://phpscriptsearch.com/ or http://hotscripts.com/ may be useful.
AdamGundry
04-30-2003, 04:20 PM
Do you mean a web-based system, or just a program on your home computer? If the latter, database software such as Microsoft Access should do the sort of thing you need.

Depending on where you live, there may be legislation related to electronic storage of personal data. In the UK, there is the Data Protection Act (http://www.dataprotection.gov.uk/).

Adam
Falconix
04-30-2003, 10:24 PM
From what I understand of your post...

1) You'd defenitely need to use some sort server side scripting language, such as Perl (w/CGI), PHP, ASP, JSP, etc. PHP and Perl are free, but they must be installed on your server to work. See www.php.net .

2) You don't necessarily need a database program; PHP and Perl (not sure about the others) both support file databases. These are fairly simple though, and the best idea would be a relational database. MySQL is a great free one; you can get it at www.mysql.com .
chris6969
05-01-2003, 05:24 PM
yeah its just for my home computer. I have alot of clients and I want to be able to keep track of their information by entering in there last name or ssn or something.
Jona
05-01-2003, 05:27 PM
You'll probably need an online database in that case. Although, there is a server that runs on the local host (http://aprelium.com/ ), I'm not sure that it will be able to do that--unless you use a flatfile database (search through a text file).
chris6969
05-01-2003, 05:31 PM
all I want is a program that I can enter in names and when I want to retrieve them all i have to do is enter in their last name! I dont need anything server side right?
Jona
05-02-2003, 09:55 AM
You must have server-side and database to do this. Period.
AdamGundry
05-02-2003, 09:55 AM
Quite right - the others have misinterpreted you because this forum is intended for web design questions, not general questions on computer use.

You need a standard database package such as MS Access, DBase, Foxpro, etc.

Adam