Tijden veranderen
Informatie uit database halen werkt niet
Code (php)
1
2
3
4
5
6
2
3
4
5
6
<?
$login = $_SESSION["login"];
$bonussql = "SELECT `bonus` FROM `saldo` WHERE `login` = $login";
$bonus = mysql_query($bonussql);
session_register("bonus");
?>
$login = $_SESSION["login"];
$bonussql = "SELECT `bonus` FROM `saldo` WHERE `login` = $login";
$bonus = mysql_query($bonussql);
session_register("bonus");
?>
Hoe kan dit?
Code (php)
1
2
3
4
5
6
7
2
3
4
5
6
7
<?
$bonussql = "SELECT `bonus` FROM `saldo` WHERE `login` = '" . $_SESSION['login'] . "'";
$bonusres = mysql_query($bonussql);
$bonus = mysql_fetch_array($bonusres, MYSQL_ASSOQ);
echo($bonus['bonus']);
?>
$bonussql = "SELECT `bonus` FROM `saldo` WHERE `login` = '" . $_SESSION['login'] . "'";
$bonusres = mysql_query($bonussql);
$bonus = mysql_fetch_array($bonusres, MYSQL_ASSOQ);
echo($bonus['bonus']);
?>
Zou ook moeten werken.
echo("Mijn naam is $naam!"); werkt maar:
echo("Mijn naam is " , $naam . "!"); is beter!
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
2
3
4
5
6
7
8
9
10
11
12
13
<?
$bonussql = "SELECT bonus FROM saldo WHERE login = '" . $_SESSION['login'] . "'";
$bonusres = mysql_query($bonussql);
if (mysql_num_rows($bonusres) >= 1)
{
$bonus = mysql_result($bonusres, 0);
session_register(bonus);
}
echo "bonus is: " . $bonus;
?>
$bonussql = "SELECT bonus FROM saldo WHERE login = '" . $_SESSION['login'] . "'";
$bonusres = mysql_query($bonussql);
if (mysql_num_rows($bonusres) >= 1)
{
$bonus = mysql_result($bonusres, 0);
session_register(bonus);
}
echo "bonus is: " . $bonus;
?>
bedankt allemaal