MySQL connections through PHP...

[Sa177ir]

For a group project, we have to create a web-app in PHP. We are using MySQL as our DBMS.

The first page of our webapp requires a user to enter in information to connect to a certain database through the MySQL server. This page is the only time the user enters in this information.

The problem is that we have several php scripts that need this user-inputted database in order to open a connection to do some queries. I would open a persistent mysql connection, but it cannot be closed?

I guess I could pass the db information from php script to php script, but that seems inefficient. There has to be a better way.

Any suggestions...?

[Jfisher446]

You could have a php file for the db connection and just include it on every page that needs the connection.

[code]
<?php
include "dbConnect.php";

do whatever
?>
[/code]

[exoskeleton]

i think Jfisher446 was trying to imply the code like this:

[code]

<?php

include("dbConnect.php");

do whatever

?>

[/code]

he just miss the open and close parenthesis..

Hope it will help...Good Luck..

More power...

[Sa177ir]

So...if dbConnect.php does a "post" to grab the user input, will every page that includes it have access to the user input?