Looking for suggestions to secure database Options

[CharlesEF]

Hi All,

I'm going to setup a MySQL database on my hosting server. I will use HTML to build the inferface to the database, I guess like everyone else does. Since I don't want anyone to know the location or username/password of the database I'm 'assuming' that I should not use javascript to open the database connection. I think I should use PHP to open the connection. In the past I have opened the connection once and left it open until I was done (intranet). I see no reason to open/close the database every time I pull or put information into it.

Since I'm new to PHP I want to get some feedback from the pros. I'm thinking I should use PHP to handle all database operations which means each html page would post to itself or a script to do this.

Is my thinking wrong?


Thank you for any input,

Charles