db selected=" . $portalInfo['database'];
echo "
conn=";
//echo $conn;
if (!$conn) {
echo "
error=";
echo mysqli_connect_error();
} else {
echo "conn is not false";
}
*/
/*
$s_sql = "SELECT * FROM school";
$s_result = mysqli_query($conn, $s_sql);
while ($s_info = mysqli_fetch_assoc($s_result)){
print_r($s_info);
}
*/
if ($conn == FALSE AND function_exists('sqlConnect')) {
$_SESSION['isSQLConfigCorrect'] = FALSE;
if($_SERVER['SERVER_ADDR'] != '127.0.0.1')
echo "";
echo "conn have failed to connect and going back to old connection method.";
if($_SERVER['SERVER_ADDR'] != '127.0.0.1')
echo "
";
$conn = sqlConnect( $portalInfo['database'] );
}
if ($_SESSION['isSQLConfigCorrect']) {
global $conn;
$_SESSION['connect'] = $conn;
$portalInfo['connect'] = $conn;
//echo "
connected - " . $portalInfo['connect'];
}
/*
if (function_exists('sqlConnect'))
//
else
{
// BITS modification for cascading database servers
$dbhost = 'localhost';
$dbuser = $portalInfo['dbuser'];
$dbpass = $portalInfo['dbpass'];
$dbname = $portalInfo['database'];
//Connect to mysql server
//$conn = mysqli_pconnect($dbhost, $dbuser, $dbpass)
or die ('Error connecting to mysql');
//Select the appropriate database
mysqli_select_db($dbname);
}
*/
if ($_SERVER['SERVER_ADDR'] == "127.0.0.1") {
//echo "This message only shows up in local testing.
\n You are connected through the file elport/include/digiportMachine.inc.
\n There is no need to create a new connection if you are seeing this, unless $conn is closed. ";
}
?>
SELECT * FROM school_constants