Dreamweaver - Connection String Password...

Author

Connection String Password...

lupo666

2005-08-09, 7:30 pm

Hi, I am pretty much a newbie and I was trying to build a simple
on-line contacts database, using Dreamweaver, PHP, MySQL... I was able
to create the view, update, delete and insert part fine, but then it
occured to me... security...

I mean: how can I somehow protect the db from unauthorized access?
Since I had to build the connection string, providing the host,
username and password... is there a way to create a web page that will
ask the user to input those and then provide them to the connection
string?

Also, do u believe that is enough to protect the DB? Any other ideas or
programs that work protecting PHP pages?

Thank you in advance for any help, Roberto

bregent

2005-08-09, 7:30 pm

In article <1123617008.961162.308500@g49g2000cwa.googlegroups.com>, lupo666
says...
>
>Hi, I am pretty much a newbie and I was trying to build a simple
>on-line contacts database, using Dreamweaver, PHP, MySQL... I was able
>to create the view, update, delete and insert part fine, but then it
>occured to me... security...
>
>I mean: how can I somehow protect the db from unauthorized access?
>Since I had to build the connection string, providing the host,
>username and password... is there a way to create a web page that will
>ask the user to input those and then provide them to the connection
>string?
>
>Also, do u believe that is enough to protect the DB? Any other ideas or
>programs that work protecting PHP pages?
>
>Thank you in advance for any help, Roberto

Leave the connection string as is. The way to protect the db is by protecting
the pages that access them. You can build this yourself or use the User
Authentication server behaviour. I'm pretty sure there is a behavior for PHP in
later versions of DW. MX 6.1 only has it for asp, jsp and coldfusion. There are
also plenty of 3rd party authentication scripts.

Also, you shouldn't post to this group from usenet - virtually nobody see those
messages.