fout bij statistieken
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
<?session_start();
include('include.php');
head();
if(!isset($_SESSION['memberid'])){
echo"U moet ingelogd zijn om uw stats te bekijken!";
}
else{
$query=mysql_query("SELECT * FROM users WHERE id='$memberid'");
while($object=mysql_fetch_object($query)){
echo"<table border=\"0\" width=\"50%\"><tr><td>";
echo"Uw url hosting te verkopen is: <input type=text size='40' value=\"http://www.fyver.nationvoice.com/dealer/koop.php?id=".$memberid."\"><br>";
echo"U heeft al <b>".$object->euro."</b> verdient.<br>";
echo"U heeft <b>".$object->glaasjes." hosting accounts</b> verkocht.<br>";
if($object->ref){
$query_referer=mysql_query("SELECT username FROM users WHERE id='$object->ref'");
while($object_referer=mysql_fetch_object($query_referer)){
echo"Uw referer is <b>".$object_referer->username."</b>.<br>";
}
}
else{echo"U heeft <b>geen</b> referer.<br>";}
$query_ref=mysql_query("SELECT * FROM users WHERE ref='$memberid'");
$referalls=mysql_num_rows($query_ref);
echo"U heeft <b>".$referalls." referalls</b>.<br>Uw ref's zijn:<br>";
while($object_ref = mysql_fetch_object($query_ref)){
echo$object_ref->username."<br>";
}
echo"</tr></td></table>";
}
}
foot();
?>
include('include.php');
head();
if(!isset($_SESSION['memberid'])){
echo"U moet ingelogd zijn om uw stats te bekijken!";
}
else{
$query=mysql_query("SELECT * FROM users WHERE id='$memberid'");
while($object=mysql_fetch_object($query)){
echo"<table border=\"0\" width=\"50%\"><tr><td>";
echo"Uw url hosting te verkopen is: <input type=text size='40' value=\"http://www.fyver.nationvoice.com/dealer/koop.php?id=".$memberid."\"><br>";
echo"U heeft al <b>".$object->euro."</b> verdient.<br>";
echo"U heeft <b>".$object->glaasjes." hosting accounts</b> verkocht.<br>";
if($object->ref){
$query_referer=mysql_query("SELECT username FROM users WHERE id='$object->ref'");
while($object_referer=mysql_fetch_object($query_referer)){
echo"Uw referer is <b>".$object_referer->username."</b>.<br>";
}
}
else{echo"U heeft <b>geen</b> referer.<br>";}
$query_ref=mysql_query("SELECT * FROM users WHERE ref='$memberid'");
$referalls=mysql_num_rows($query_ref);
echo"U heeft <b>".$referalls." referalls</b>.<br>Uw ref's zijn:<br>";
while($object_ref = mysql_fetch_object($query_ref)){
echo$object_ref->username."<br>";
}
echo"</tr></td></table>";
}
}
foot();
?>
Code (php)
1
$query=mysql_query("SELECT * FROM users WHERE id='$memberid'");
maar weet je zeker dat je server dat zo ondersteund en dat je niet het volgende moet nemen?
Code (php)
1
$query=mysql_query("SELECT * FROM users WHERE id='".$_SESSION['memberid']."'");
En zeg welke error je krijgt...
Krijg je geen error? Haal eens al je variablen etc. buiten de quotes...
gebruik verder echo ' i.p.v. echo " dan hoef je HTML niet te escapen.
Haal variabelen buiten de quotes
gebruik <?php i.p.v. <?
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
<?session_start();
include('include.php');
head();
if(!isset($_SESSION['memberid'])){
echo"U moet ingelogd zijn om uw stats te bekijken!";
}
else{
$query=mysql_query("SELECT * FROM users WHERE id='".$_SESSION['memberid']."'");
while($object=mysql_fetch_object($query)){
echo"<table border=\"0\" width=\"50%\"><tr><td>";
echo"Uw url om klicks te krijgen is: <input type=text size='60' value=\"http://www.fyver.nationvoice.com/dealer/koop.php?id=".$memberid."\"><br>";
echo"U heeft al <b>".$object->euro."</b> verdient.<br>";
echo"U heeft <b>".$object->glaasjes." klicks</b> gehad.<br>";
if($object->ref){
$query_referer=mysql_query("SELECT username FROM users WHERE id='$object->ref'");
while($object_referer=mysql_fetch_object($query_referer)){
echo"Uw referer is <b>".$object_referer->username."</b>.<br>";
}
}
else{echo"U heeft <b>geen</b> referer.<br>";}
$query_ref=mysql_query("SELECT * FROM users WHERE ref='$memberid'");
$referalls=mysql_num_rows($query_ref);
echo"U heeft <b>".$referalls." referalls</b>.<br>Uw ref's zijn:<br>";
while($object_ref = mysql_fetch_object($query_ref)){
echo$object_ref->username."<br>";
}
echo"</tr></td></table>";
}
}
foot();
?>
include('include.php');
head();
if(!isset($_SESSION['memberid'])){
echo"U moet ingelogd zijn om uw stats te bekijken!";
}
else{
$query=mysql_query("SELECT * FROM users WHERE id='".$_SESSION['memberid']."'");
while($object=mysql_fetch_object($query)){
echo"<table border=\"0\" width=\"50%\"><tr><td>";
echo"Uw url om klicks te krijgen is: <input type=text size='60' value=\"http://www.fyver.nationvoice.com/dealer/koop.php?id=".$memberid."\"><br>";
echo"U heeft al <b>".$object->euro."</b> verdient.<br>";
echo"U heeft <b>".$object->glaasjes." klicks</b> gehad.<br>";
if($object->ref){
$query_referer=mysql_query("SELECT username FROM users WHERE id='$object->ref'");
while($object_referer=mysql_fetch_object($query_referer)){
echo"Uw referer is <b>".$object_referer->username."</b>.<br>";
}
}
else{echo"U heeft <b>geen</b> referer.<br>";}
$query_ref=mysql_query("SELECT * FROM users WHERE ref='$memberid'");
$referalls=mysql_num_rows($query_ref);
echo"U heeft <b>".$referalls." referalls</b>.<br>Uw ref's zijn:<br>";
while($object_ref = mysql_fetch_object($query_ref)){
echo$object_ref->username."<br>";
}
echo"</tr></td></table>";
}
}
foot();
?>