login mysql ? how ?

[Anon]

Hi,

Can I create a simple login script which will

login MySQL (or connect to MySQL) and once login, I
won't need to call mysql_connect() in other PHP page.

I found that I need to call mysql_connect()

everytime for each PHP page before mqsql_query(). That
meant I need to save username and password in
PHP session. I think keeping password in session is not
a good idea ...

Please reply via email if possible, thanks.


		KC Cheng
		[e-mail]

[Anon]

ok actually 3 ways to do it.

In my opinion the best would be phplib.
All login data are stored parallel to the webroot.

Inside the pages you can do something like:

$db = new DB_database;
$db->query("SELECT * from Bla");
while ($db->next_record()) {

print $db->f("Name");

}

and the field value of Name from the Table bla will be displayed.

Alternatively you can use:

ADODB is a database wrapper library for PHP. Works with heaps of databases including MySQL, MSSQL, Access, Oracle, PostgreSQL, Interbase, VFP, Sybase, ODBC etc.

Have not worked with it, but it sounds pretty neat. And is an option if you cannot install phplib on the server.

3rd option would be to move the connect with the data to an include folder which you protect via htaccess. So no one can get the info. Probably true for ADODB too, not sure.

So when you open a page you just

require ("/data/login.inc");

and then go ahead to make your queries.

enjoy.