Hi there, I am getting a 'no database selected' error when I try to run a query on one of my pages.
[PHP]<?php
session_start() ;
require('safe/fhlogin.inc.php ');
if (!isset($_SESSI ON['wagentje'])) {
$_SESSION['wagentje']['artikels'] = array();
}
$id = $_GET['id'];
if ($_GET['action'] == 'add') {
if (isset($_GET['aantal'])) $aantal = $_GET['aantal']; else $aantal = 1;
if (!isset($_SESSI ON['wagentje']['artikels'][$id])) $_SESSION['wagentje']['artikels'][$id] = 0;
$_SESSION['wagentje']['artikels'][$id] += $aantal;
} else if ($_GET['action'] == 'delete') {
unset($_SESSION['wagentje']['artikels'][$id]);
}
?>
<html>
<head>
</head>
<body>
<?php
$link = new mysqli($dbserve r, $user, $passwd, $dbnaam);
foreach($_SESSI ON['wagentje']['artikels'] as $artikel => $sleutel) {
echo "$artikel\n <br>";
echo mysql_result(my sql_query("SELE CT thumbnail FROM hellinx_artikel WHERE artikelnr=\"$ar tikel\"") or die (mysql_error()) );
}
$link->close() or die("Kan link met $dbserver niet sluiten.");
?>
</body>
</html>[/PHP]
I am positive that the user has the right priviliges and that the login.inc file is correct ( since I use it on other pages and those work)
Thanks :)
[PHP]<?php
session_start() ;
require('safe/fhlogin.inc.php ');
if (!isset($_SESSI ON['wagentje'])) {
$_SESSION['wagentje']['artikels'] = array();
}
$id = $_GET['id'];
if ($_GET['action'] == 'add') {
if (isset($_GET['aantal'])) $aantal = $_GET['aantal']; else $aantal = 1;
if (!isset($_SESSI ON['wagentje']['artikels'][$id])) $_SESSION['wagentje']['artikels'][$id] = 0;
$_SESSION['wagentje']['artikels'][$id] += $aantal;
} else if ($_GET['action'] == 'delete') {
unset($_SESSION['wagentje']['artikels'][$id]);
}
?>
<html>
<head>
</head>
<body>
<?php
$link = new mysqli($dbserve r, $user, $passwd, $dbnaam);
foreach($_SESSI ON['wagentje']['artikels'] as $artikel => $sleutel) {
echo "$artikel\n <br>";
echo mysql_result(my sql_query("SELE CT thumbnail FROM hellinx_artikel WHERE artikelnr=\"$ar tikel\"") or die (mysql_error()) );
}
$link->close() or die("Kan link met $dbserver niet sluiten.");
?>
</body>
</html>[/PHP]
I am positive that the user has the right priviliges and that the login.inc file is correct ( since I use it on other pages and those work)
Thanks :)
Comment