pass a mysql connect to included function . . .

[agalligani]

can I pass an mysql connection . . . for example . . .

$realhost = "localhost";
$username = "root";
$pw = "";
$dbchoice = "newsletter";

$conn = mysql_connect($realhost, $username, $pw) or die("cannot connect to mysql");
$db = mysql_select_db($dbchoice, $conn) or die("No connection to db.");

include "whatever.php";
whatever($conn);

. . . . . well you get the idea. If I do this with a function in the same file it works but doesn't seem to when I include the function from another file.

Is it just because I do the include after the connection is established? DO I declare $conn as global???

Please help. I would rather just have the connect logic once in the damn program and not in every little file I create.

[Roger_Ramjet]

I use an access control script that I include on every page.
It includes my db connection script, verifies the user and leaves me with an established connection.
I never refer to it afterwards in any of my other scripts ie. I code $result = mysql_query($sql) and that is it. You only need to be specifying the connection if you have multiple database connections open, if you don't then why bother.

I have general purpose scripts that run my queries and then include different scripts according to the results, which in turn query the database for additional results. They also use mysql_real_escape_string which will definately fail if there is no db connection already in existance, and this use of mysql_real_escape_string is done by a function that resides in a common functions include file; which is itself included by my accesscontrol.

I just checked my access control script and the order in which I have things coded is as follows

<?php // stAccess.php
require_once 'stHeader.php';

require_once 'stCommon.php';
require_once 'stDb.php';

session_start();

dbConnect("mydb");

// etc
?>

<?php // page1.php
require_once 'stAccess.php';

// etc
?>
 

Never had a problem, even though the common functions file gets included before the db connection is established (had not thought about it before).

So what I'm getting at, at last :rolleyes: , is that you can 'pass' a connection down to included scripts.

[yinrunning]

The thing you can't pass bewteen includes is Object oriented stuff. By stuff, I mean globals and functions.

You're not using Object Oriented code, are you?