How to pass connection as global variable ?
| From: | C.R.Vegelin | Date: | Wed, 11 Jul 2007 08:47:18 +0000 |
| Subject: | How to pass connection as global variable ? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-258595@lists.php.net to get a copy of this message | ||
I have various PHP scripts that use the same database.
The startup script default.php sets the connection once for all the scripts.
This connection is set in $_SESSION to make it a global variable for all scripts.
When switching from page default to page faq, I get errors I can't explain.
Any help is highly appreciated.
TIA, Cor
default.php
----------------
<?php
session_start();
require("menu.php");
...
$link = mysqli_connect($mysqlhost, $mysqluser, $mysqlpsw, $mysqldb) or die("cannot
connect");
$_SESSION['connection'] = $link;
...
?>
faq.php
-----------
<?php
require("menu.php");
$link = $_SESSION['connection'];
$sql = "SELECT Question, Answer FROM myfaqs";
$result = mysqli_query($link, $sql);
// previous line gives:
// Notice: Undefined variable: _SESSION in C:\Inetpub\wwwroot\test\faq.php
// Warning: mysqli_query() expects parameter 1 to be mysqli, null given in
C:\Inetpub\wwwroot\test\faq.php
...
?>