How to pass connection as global variable ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
...
?>

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux