Google Answers Logo
View Question
 
Q: Need Advice or Quote for Database with Web Forms and Password Protection ( Answered,   0 Comments )
Question  
Subject: Need Advice or Quote for Database with Web Forms and Password Protection
Category: Business and Money > Advertising and Marketing
Asked by: kevinsinclair-ga
List Price: $35.00
Posted: 31 Dec 2002 12:08 PST
Expires: 30 Jan 2003 12:08 PST
Question ID: 135630
I need a database/web application, with web forms - to manage a set of
contacts; I am hoping that someone here can point me to a tutorial
type of website that has this solved, and offers files to download.  I
would think that this kind of application must be very commonly done.

The database would have various fields like name, address, phone, url,
and so on.  It does not need ecommerce.

The web forms would have a form for a user to add their new entry,
another form for a user to modifying their entry, and an
administrators form for deleting an entry.

The forms would be password protected, with a password-recovery
mechanism.  I need a master password to be able to access anything.

This must have been done millions of times online.  I want a shell for
this so I can use it for a few different applications.  My hosting
place (www.Shanje.com) supports MySql so that is the way to go, but I
don't know much about MySql.  But I have a technical background, so I
am hoping if someone has the shell for this, that I can fill it in and
learn as I go.

Budget is an issue, so I am posting here - hoping that some web site
has this all setup online and I can just download the files and a
help/tutorial file. Or I can pay a modest amount if someone can set
this up - to me it sounds simple since there is no ecommerce and no
related functions to
run - its just presenting the data in the database to the screen.  If
some starving programmer wants to be paid for this work, and the cost
is low, I might be able to do it.  Please advise.

I have two uses at first but I expect more later.  The first one has
about 150 contacts.  The 2nd one has potentially several thousand
contacts.  If I need any software, I suppose a 1-site license won't
work, so that is also a cost issue.  I want to do it right even though
the budget is very limited.

My time frame is: the sooner the better.

Kevin Sinclair
kjs@rahul.net
Answer  
Subject: Re: Need Advice or Quote for Database with Web Forms and Password Protection
Answered By: jbf777-ga on 31 Dec 2002 17:50 PST
 
Greetings -
 
I have found some sites/products that may do the trick.  Please be
sure to let me know if you need any additional
information/clarification/links, or if these links or insufficient,
before rating this answer.
  
These 3 products/services seem like they would do what you're looking
for.  Please see the links for complete descriptions.
  
WebData Classic/pro by WebTeacher [Ziff-Davis award-winner]
http://www.webteacher.com/webdata
http://www.webteacher.com/webdata/pro/features.html
There's the classic version, and then the pro version, both at
different price points.  Requires *no programming.*  I think the
classic version may suffice, at $199...
  
eCriteria Simple and Quick Databases
http://www.eCriteria.net
http://www.eCriteria.net/faqs.asp
http://www.eCriteria.net/our_service.asp
Starts $4.95/mo. to $39.95/mo. w/ different customizable levels.  See
the FAQ page.

Baseportal
http://baseportal.com
This is a free, customizable database "portal" which possibly may be
customized to meet your solution.
 
Here are some additional links along the same lines:
  
World Web Dynamics
WWD Help Desk Pro OnLine Rolodex
http://www.worldwebdynamics.com/contacts/
  
Korn Shell Personnel List management
http://dfrench.tripod.com/kshcontact.html
  
RecordKeeper
http://www.recordkeeper.com
  
Super-Tracker
http://www.super-tracker.com
  
Search Strategy [various combinations]:
web-based rolodex
customizable databases
web database customizable passwords

Request for Answer Clarification by kevinsinclair-ga on 01 Jan 2003 11:14 PST
I reviewed the links you gave.  Most are nice applications but won't
do what I need, except the first one - which you seemed to like the
most also - looks very good.  I don't know if the regular or pro is
needed.  I have one need with 150 contacts, and another with thousands
- potentially up to 30,000 contacts (if it gets popular).  I learned
some things as I explored your answer:

1. I need it to run on my server, not hosted by someone; if they went
out of
   business, I am screwed.  That way at least, I have the data.

2. I tried WebData, only for a few minutes and it looks nice though I
did not
   get it to work, but I think it would.  Can you provide any help or
   advice (for additional fee) as I go through that process?  Consult?

3. When would I need the pro version; it can link databases - why do
people
   do that, instead of just have a more complete, single database? 
What are
   the size limits of the regular version - can it do 30,000 contacts,
if
   the overall number of concurrent users is not high?

4. I need users to login to make their changes.  Does it do that?  I
would
   have an admin password, and each user would have their own
password.

5. I need one more thing not originally specified, but I realize it
now:
   before they can create their initial entry, in order to get an
account,
   they have to make a payment - so that means ecommerce.  Argh!  So
once
   they pay, then they get an account.  Should I do this separately? 
I
   could do this as a completely separate system, and email them the 
   account info.  Would that be a good way to do it?  What is the
easiest
   way to do ecommerce online?  I really should just automate it; they
pay,
   then they get an account.  It sounds so natural to me - surely
others
   have done all of the above.  I feel like I am re-inventing the
wheel.

Thanks

Clarification of Answer by jbf777-ga on 01 Jan 2003 12:58 PST
Hi -
 
I'll be happy to help where I can.
  
>I reviewed the links you gave.  Most are nice applications but won't
>do what I need, except the first one.
  
Well, now that you've specified e-commerce, WebData Pro is what you
need.  I'm not sure those others wouldn't do it, but they would
require some more footwork I think.  Good choice on the decision to
store the data on your own servers.  For absolute control over your
data, it's best to have it on your own servers.  In any case, I would
agree, WebData is what you're looking for, for a variety of reasons,
not the least of which is its non-programming interface.
   
>I tried WebData, only for a few minutes and it looks nice though I
>did not get it to work, but I think it would.  Can you provide any
help or
>advice (for additional fee) as I go through that process?  Consult?
  
Unfortunately, I wouldn't be the person for that.  WebData has
customer support however, and since there is no programming involved,
I would imagine any basic knowledge of databases and application use
would get you going, and their tech support will help you over the
hurdles.  They would best support their product.
   
3. When would I need the pro version; it can link databases - why do
people do that, instead of just have a more complete, single database?
 
If you put all your eggs in one basket, and the basket explodes, so do
all your eggs.  If you use multiple baskets, some of your eggs in
each, then you have better damage control, because only a certain
number of eggs will be damaged if one of the baskets is jeopardized.  
The other element is accessibility.  If you have all your eggs in one
basket, and you want to access egg #532-b at the bottom of the basket,
you've got to go through  all your eggs to get to it.  If you use
multiple baskets, with all eggs sorted in each basket, it would be
quicker.   It's a little different with software.. but just to get a
general concept. Hope that wasn't too convoluted. ;)  Incidentally, I
believe the reason Google is so fast is because it distributes its
data.  The bottom line is, with one big database, things can get
bulkier and slower.  But it depends on the access algorithm of the
database and # of records.  In your particular case, I don't think you
have to worry about it.  And because all the individual components of
your data are interdependent, the damage control issue isn't important
either, because, in your case, if you lose part of your data [for
example, addresses] your data is rendered useless.  I would just do
backups routinely, which incidentally the Pro version has a web
interface for.
 
>What are  the size limits of the regular version - can it do 30,000
>contacts, if the overall number of concurrent users is not high?
 
I don't see anything on their web site which says the number of
records for the regular version.  Typically, though, 30,000 is not a
super number of records for a big database application.  Microsoft
Access supports much more than that, and that's used  as an end-user,
personal application.  On the feature list of the Pro version, they
talk about accessing million+ records.
 
4. I need users to login to make their changes.  Does it do that?  I
would have an admin password, and each user would have their own
password.
 
Yes.
 
>5. I need one more thing not originally specified, but I realize it
>now before they can create their initial entry, in order to get an
>account, they have to make a payment - so that means ecommerce. 
>Argh!  So once they pay, then they get an account.  Should I do this
>separately?
>I could do this as a completely separate system, and email them the
>account info.  Would that be a good way to do it?  What is the
>easiest way to do ecommerce online?  I really should just automate
it; >they pay, then they get an account.  It sounds so natural to me -
surely
>others have done all of the above.  I feel like I am re-inventing the
>wheel.
  
Yes, it may seem that way, but most sites have taken the time to
invest in custom programming or customized web-enabled/connected
databases. The Pro version has membership-on-the-fly capability: "a
referrer check allows you to tie this feature to a credit card
processing service. "  My advice to you is to call them directly.  You
know the specifics of your application the best, and they would be
able to assist you the best.  I would imagine they'd be able to point
you in the direction of the most compatible credit-card processing
sites.  There are a LOT of those.  Just search for: accept web credit
cards  on Google.
  
Please let me know if you need more info/clarification...
 
jbf777-ga
GA Researcher
Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy