Cookies in een mysql query

Status
Niet open voor verdere reacties.

qwerty12345

Gebruiker
Lid geworden
9 apr 2007
Berichten
39
Ok, ik heb het volgende stukje script:
PHP:
$user = $_COOKIE["usNick"] 
$visits = "SELECT visits FROM tb_users WHERE username='$user'";

Nu wilk ik dus de visits weten, dit doe ik met:
PHP:
<? echo $visits; ?>

Maar dan krijg ik de volgende foutmeldin:
Code:
Parse error: syntax error, unexpected T_VARIABLE in /home/larsm/domains/thebigbusiness.gethost.nl/public_html/BuxSiteBeta/members.php on line 68

Line 68 is de line die begint met $visits = blablabla

Dus hoe los ik dit op?

Mvg,
qwerty12345
 
Op de lijn erboven ben je een ';' vergeten.
 
Ja dat werkt, maar nog niet goed.

Dit is mijn hele script:
PHP:
<html>
<head>
<title>iBux</title>
	<link rel="stylesheet" type="text/css" href="css.css">
	<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body>


<center>





<?




include('header.php');

?>





<div id="menuWrapper"><div id="menu" class="cBlock">
	<ul>
		<li><a href="index.php"><span>Home</span></a></li>
		<li><a href="surf.php"><span>Surf Ads</span></a></li>
		<li class="selected"><a href="members.php"><span>Members</span></a></li>
		<li><a href="logout.php"><span>Logout</span></a></li>
		<li><a href="faq.php"><span>FAQ</span></a></li>
		<li><a href="advertise.php"><span>Advertise</span></a></li>
		<li><a href="contact.php"><span>Contact</span></a></li>

	</ul>
</div></div>





<div id="bodyWrapper1"><div id="bodyWrapper2" class="cBlock"><div id="bodyWrapper3"><div id="bodyWrapper4">


<table style="border:0px #666 solid;padding-top:7px;padding-bottom:7px;" bgcolor="" width="900"><tr><td>
<font size="2" face="verdana">

<?
if(!isset($_COOKIE["usNick"]) && !isset($_COOKIE["usPass"]))
{
exit();
}

if($_COOKIE["usNick"]=="admin")
{
echo "<b><a href=\"admin.php\">Admin</a></b> - ";
}

 include('menum.php'); ?>
<br><br>
<?
 include('config.php');
$user = $_COOKIE["usNick"]; 
$visits = mysql_query("SELECT visits FROM tb_users WHERE username='$user'");
$referals = mysql_query("SELECT referals FROM tb_users WHERE username='$user'");
$referalvisits = mysql_query("SELECT referalvisits FROM tb_users WHERE username='$user'");
$money = mysql_query("SELECT paid FROM tb_users WHERE username='$user'");
$paid = mysql_query("SELECT money FROM tb_users WHERE username='$user'");
?>
To refer others, use <b><? require("url.php"); echo $url; ?>/?r=<? echo $user; ?></b>
<br><br>

<table width="33%" cellpadding="0" cellspacing="0" style="padding-bottom:10px;">
<tr>
<td style="border-bottom:1px #000 solid;padding:2px;">
<font style="font-size:11px;" face="verdana">
<b>Your Statistics</b>
</font>
</td>
<td style="border-bottom:1px #000 solid;padding:2px;">&nbsp;

</td>
</tr>
<tr>
<td style="padding:2px;">
<font style="font-size:11px;" face="verdana">
# of Website Visits
</font>
</td>
<td align="right" style="padding:2px;">
<font style="font-size:11px;" face="verdana"><b>
<? echo $visits; ?>
</b></font>
</td>
</tr>
</table>

<table width="33%" cellpadding="0" cellspacing="0" style="padding-bottom:10px;">
<tr>
<td style="border-bottom:1px #000 solid;padding:2px;">
<font style="font-size:11px;" face="verdana">
<b>Your Referral Statistics</b>
</font>
</td>
<td style="border-bottom:1px #000 solid;padding:2px;">&nbsp;

</td>
</tr>
<tr>
<td style="padding:2px;">
<font style="font-size:11px;" face="verdana">
# of Referrals (<a href="referals.php"><b>View</b></a>)
</font>
</td>
<td align="right" style="padding:2px;">
<font style="font-size:11px;" face="verdana"><b>
<? echo $referals; ?>
</b></font>
</td>
</tr>
<tr>
<td style="padding:2px;">
<font style="font-size:11px;" face="verdana">
# of Referral Website Visits
</font>
</td>
<td align="right" style="padding:2px;">
<font style="font-size:11px;" face="verdana"><b>
<? echo $referalvisits; ?>
</b></font>
</td>
</tr>
</table>

<table width="33%" cellpadding="0" cellspacing="0" style="padding-bottom:10px;">
<tr>
<td style="border-bottom:1px #000 solid;padding:2px;">
<font style="font-size:11px;" face="verdana">
<b>Balance Information</b>
</font>
</td>
<td style="border-bottom:1px #000 solid;padding:2px;">&nbsp;

</td>
</tr>
<tr>
<td style="padding:2px;">
<font style="font-size:11px;" face="verdana">
Account Balance (<a href="convert.php"><b>cashout</b></a>)
</font>
</td>
<td align="right" style="padding:2px;">
<font style="font-size:11px;" face="verdana"><b>
$<? echo $money; ?>
</b></font>
</td>
</tr>
<tr>
<td style="padding:2px;">
<font style="font-size:11px;" face="verdana">
Total Amount Paid
</font>
</td>
<td align="right" style="padding:2px;">
<font style="font-size:11px;" face="verdana"><b>
$<? echo $paid; ?>
</b></font>
</td>
</tr>
</table>


</font>
</td></tr></table>


</div></div></div></div>



<?

include('menu1.php');

?>


</body>
</html>

En dit is de output:
[SMALLIMG]http://s2.screenshots.cc/upload/77f76e28.jpg[/SMALLIMG]

Zoals je kunt zien komt er dus een hele verkeerde output uit.
Iemand hier een oplossing voor?

Mvg,
qwerty12345
 
Laatst bewerkt door een moderator:
Ja, je snapt namelijk niet precies hoe het allemaal werkt, maar het is niet zo heel moeilijk.


PHP:
$sQuery = 'SELECT a, b, c, d FROM table WHERE id = 1';
$aResult = mysql_query($sQuery) or die(mysql_error());
$aRow = mysql_fetch_assoc($aResult);

echo $aRow['a'];
echo $aRow['b'];

Je kunt dus al die waarden ophalen in één query, het is fout om dat in meerdere query's te doen.

Regel 1: de query in een variabele zetten.
Regel 2: de query uitvoeren.
Regel 3: het resultaat in een array zetten.

Regel 5 en 6: de informatie uit de database weergeven.
 
Ja dat snapte ik wel, want dat had ik eerst.
Nu heb ik dat vanjou aangepast aan mijn pagina en krijg ik dit:

Code:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/larsm/domains/thebigbusiness.gethost.nl/public_html/BuxSiteBeta/members.php on line 76

Line 76:
PHP:
$aRow = mysql_fetch_assoc($aResult);

Mvg,
qwerty12345
 
Je moet wel in de rest van je code ook de goede variabelenamen gebruiken.
 
Ja dat heb ik, kijk mijn script maar:
PHP:
<html>
<head>
<title>iBux</title>
	<link rel="stylesheet" type="text/css" href="css.css">
	<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body>


<center>





<?




include('header.php');

?>





<div id="menuWrapper"><div id="menu" class="cBlock">
	<ul>
		<li><a href="index.php"><span>Home</span></a></li>
		<li><a href="surf.php"><span>Surf Ads</span></a></li>
		<li class="selected"><a href="members.php"><span>Members</span></a></li>
		<li><a href="logout.php"><span>Logout</span></a></li>
		<li><a href="faq.php"><span>FAQ</span></a></li>
		<li><a href="advertise.php"><span>Advertise</span></a></li>
		<li><a href="contact.php"><span>Contact</span></a></li>

	</ul>
</div></div>





<div id="bodyWrapper1"><div id="bodyWrapper2" class="cBlock"><div id="bodyWrapper3"><div id="bodyWrapper4">


<table style="border:0px #666 solid;padding-top:7px;padding-bottom:7px;" bgcolor="" width="900"><tr><td>
<font size="2" face="verdana">

<?
if(!isset($_COOKIE["usNick"]) && !isset($_COOKIE["usPass"]))
{
exit();
}

if($_COOKIE["usNick"]=="admin")
{
echo "<b><a href=\"admin.php\">Admin</a></b> - ";
}

 include('menum.php'); ?>
<br><br>
<?
 include('config.php');
$user = $_COOKIE["usNick"]; 
//$visits = mysql_query("SELECT visits FROM tb_users WHERE username='$user'");
//$referals = mysql_query("SELECT referals FROM tb_users WHERE username='$user'");
//$referalvisits = mysql_query("SELECT referalvisits FROM tb_users WHERE username='$user'");
//$money = mysql_query("SELECT paid FROM tb_users WHERE username='$user'");
//$paid = mysql_query("SELECT money FROM tb_users WHERE username='$user'");
$sQuery = "SELECT visits, referals, referakvisits, money, paid FROM table username='$user'";
$aResult = mysql_query($sQuery);
$aRow = mysql_fetch_assoc($aResult);
?>
To refer others, use <b><? require("url.php"); echo $url; ?>/?r=<? echo $user; ?></b>
<br><br>

<table width="33%" cellpadding="0" cellspacing="0" style="padding-bottom:10px;">
<tr>
<td style="border-bottom:1px #000 solid;padding:2px;">
<font style="font-size:11px;" face="verdana">
<b>Your Statistics</b>
</font>
</td>
<td style="border-bottom:1px #000 solid;padding:2px;">&nbsp;

</td>
</tr>
<tr>
<td style="padding:2px;">
<font style="font-size:11px;" face="verdana">
# of Website Visits
</font>
</td>
<td align="right" style="padding:2px;">
<font style="font-size:11px;" face="verdana"><b>
<? echo $aRow['visits'];  ?>
</b></font>
</td>
</tr>
</table>

<table width="33%" cellpadding="0" cellspacing="0" style="padding-bottom:10px;">
<tr>
<td style="border-bottom:1px #000 solid;padding:2px;">
<font style="font-size:11px;" face="verdana">
<b>Your Referral Statistics</b>
</font>
</td>
<td style="border-bottom:1px #000 solid;padding:2px;">&nbsp;

</td>
</tr>
<tr>
<td style="padding:2px;">
<font style="font-size:11px;" face="verdana">
# of Referrals (<a href="referals.php"><b>View</b></a>)
</font>
</td>
<td align="right" style="padding:2px;">
<font style="font-size:11px;" face="verdana"><b>
<? echo $aRow['referals'];  ?>
</b></font>
</td>
</tr>
<tr>
<td style="padding:2px;">
<font style="font-size:11px;" face="verdana">
# of Referral Website Visits
</font>
</td>
<td align="right" style="padding:2px;">
<font style="font-size:11px;" face="verdana"><b>
<? echo $aRow['referalvisits'];  ?>
</b></font>
</td>
</tr>
</table>

<table width="33%" cellpadding="0" cellspacing="0" style="padding-bottom:10px;">
<tr>
<td style="border-bottom:1px #000 solid;padding:2px;">
<font style="font-size:11px;" face="verdana">
<b>Balance Information</b>
</font>
</td>
<td style="border-bottom:1px #000 solid;padding:2px;">&nbsp;

</td>
</tr>
<tr>
<td style="padding:2px;">
<font style="font-size:11px;" face="verdana">
Account Balance (<a href="convert.php"><b>cashout</b></a>)
</font>
</td>
<td align="right" style="padding:2px;">
<font style="font-size:11px;" face="verdana"><b>
$<? echo $aRow['money'];  ?>
</b></font>
</td>
</tr>
<tr>
<td style="padding:2px;">
<font style="font-size:11px;" face="verdana">
Total Amount Paid
</font>
</td>
<td align="right" style="padding:2px;">
<font style="font-size:11px;" face="verdana"><b>
$<? echo $aRow['paid'];  ?>
</b></font>
</td>
</tr>
</table>


</font>
</td></tr></table>


</div></div></div></div>



<?

include('menu1.php');

?>


</body>
</html>

Mvg,
qwerty12345
 
PHP:
<html> 
<head> 
<title>iBux</title> 
    <link rel="stylesheet" type="text/css" href="css.css"> 
    <link href="style.css" rel="stylesheet" type="text/css"> 
</head> 
<body> 


<center> 





<? 




include('header.php'); 

?> 





<div id="menuWrapper"><div id="menu" class="cBlock"> 
    <ul> 
        <li><a href="index.php"><span>Home</span></a></li> 
        <li><a href="surf.php"><span>Surf Ads</span></a></li> 
        <li class="selected"><a href="members.php"><span>Members</span></a></li> 
        <li><a href="logout.php"><span>Logout</span></a></li> 
        <li><a href="faq.php"><span>FAQ</span></a></li> 
        <li><a href="advertise.php"><span>Advertise</span></a></li> 
        <li><a href="contact.php"><span>Contact</span></a></li> 

    </ul> 
</div></div> 





<div id="bodyWrapper1"><div id="bodyWrapper2" class="cBlock"><div id="bodyWrapper3"><div id="bodyWrapper4"> 


<table style="border:0px #666 solid;padding-top:7px;padding-bottom:7px;" bgcolor="" width="900"><tr><td> 
<font size="2" face="verdana"> 

<? 
if(!isset($_COOKIE["usNick"]) && !isset($_COOKIE["usPass"])) 
{ 
exit(); 
} 

if($_COOKIE["usNick"]=="admin") 
{ 
echo "<b><a href=\"admin.php\">Admin</a></b> - "; 
} 

 include('menum.php'); ?> 
<br><br> 
<? 
 include('config.php'); 
$user = $_COOKIE["usNick"];  
//$visits = mysql_query("SELECT visits FROM tb_users WHERE username='$user'"); 
//$referals = mysql_query("SELECT referals FROM tb_users WHERE username='$user'"); 
//$referalvisits = mysql_query("SELECT referalvisits FROM tb_users WHERE username='$user'"); 
//$money = mysql_query("SELECT paid FROM tb_users WHERE username='$user'"); 
//$paid = mysql_query("SELECT money FROM tb_users WHERE username='$user'"); 
$sQuery = "SELECT visits, referals, referakvisits, money, paid FROM tb_users WHERE username= '".$user."'"; 
$aResult = mysql_query($sQuery); 
$aRow = mysql_fetch_assoc($aResult); 
?> 
To refer others, use <b><? require("url.php"); echo $url; ?>/?r=<? echo $user; ?></b> 
<br><br> 

<table width="33%" cellpadding="0" cellspacing="0" style="padding-bottom:10px;"> 
<tr> 
<td style="border-bottom:1px #000 solid;padding:2px;"> 
<font style="font-size:11px;" face="verdana"> 
<b>Your Statistics</b> 
</font> 
</td> 
<td style="border-bottom:1px #000 solid;padding:2px;">&nbsp; 

</td> 
</tr> 
<tr> 
<td style="padding:2px;"> 
<font style="font-size:11px;" face="verdana"> 
# of Website Visits 
</font> 
</td> 
<td align="right" style="padding:2px;"> 
<font style="font-size:11px;" face="verdana"><b> 
<? echo $aRow['visits'];  ?> 
</b></font> 
</td> 
</tr> 
</table> 

<table width="33%" cellpadding="0" cellspacing="0" style="padding-bottom:10px;"> 
<tr> 
<td style="border-bottom:1px #000 solid;padding:2px;"> 
<font style="font-size:11px;" face="verdana"> 
<b>Your Referral Statistics</b> 
</font> 
</td> 
<td style="border-bottom:1px #000 solid;padding:2px;">&nbsp; 

</td> 
</tr> 
<tr> 
<td style="padding:2px;"> 
<font style="font-size:11px;" face="verdana"> 
# of Referrals (<a href="referals.php"><b>View</b></a>) 
</font> 
</td> 
<td align="right" style="padding:2px;"> 
<font style="font-size:11px;" face="verdana"><b> 
<? echo $aRow['referals'];  ?> 
</b></font> 
</td> 
</tr> 
<tr> 
<td style="padding:2px;"> 
<font style="font-size:11px;" face="verdana"> 
# of Referral Website Visits 
</font> 
</td> 
<td align="right" style="padding:2px;"> 
<font style="font-size:11px;" face="verdana"><b> 
<? echo $aRow['referalvisits'];  ?> 
</b></font> 
</td> 
</tr> 
</table> 

<table width="33%" cellpadding="0" cellspacing="0" style="padding-bottom:10px;"> 
<tr> 
<td style="border-bottom:1px #000 solid;padding:2px;"> 
<font style="font-size:11px;" face="verdana"> 
<b>Balance Information</b> 
</font> 
</td> 
<td style="border-bottom:1px #000 solid;padding:2px;">&nbsp; 

</td> 
</tr> 
<tr> 
<td style="padding:2px;"> 
<font style="font-size:11px;" face="verdana"> 
Account Balance (<a href="convert.php"><b>cashout</b></a>) 
</font> 
</td> 
<td align="right" style="padding:2px;"> 
<font style="font-size:11px;" face="verdana"><b> 
$<? echo $aRow['money'];  ?> 
</b></font> 
</td> 
</tr> 
<tr> 
<td style="padding:2px;"> 
<font style="font-size:11px;" face="verdana"> 
Total Amount Paid 
</font> 
</td> 
<td align="right" style="padding:2px;"> 
<font style="font-size:11px;" face="verdana"><b> 
$<? echo $aRow['paid'];  ?> 
</b></font> 
</td> 
</tr> 
</table> 


</font> 
</td></tr></table> 


</div></div></div></div> 



<? 

include('menu1.php'); 

?> 


</body> 
</html>
 
Nu is het:
Code:
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/larsm/domains/thebigbusiness.gethost.nl/public_html/BuxSiteBeta/members.php on line 75

Thnx voor de snelle reacties;)

Mvg,
qwerty12345
 
Ja, dan moet je debuggen. Echo de query, zet het mysql_error()-gedeelte erachter, etc.
 
Ok, maar het kan dus niet op de manier die ik eerst had (alles apart), want dat lijkt mij makkelijker. Maar ik snapte niet waarom die rare teksten kwamen (zie screen) !?

EDIT: Ik heb iets gevonden: http://www.flashfocus.nl/forum/showthread.php?t=8443
Maar ik snap niet echt hoe ik dat kan doen in mijn script? Zou iemand dat kunnen doen/willen vertellen?
 
Laatst bewerkt:
Status
Niet open voor verdere reacties.

Nieuwste berichten

Terug
Bovenaan Onderaan