Syntax error

Jesper · 2012-01-04T15:15:23.000Z

Wat is hier het probleem van? Codeblok: 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 Dit lid bestaat niet! ; } else { mysql_query ( "UPDATE users SET credits = $muntjes; WHERE id = " . mysql_real_escape_string ( $uFetch [ username ]) . "" ) or die ( mysql_error ()); echo De muntjes zijn overgemaakt! Klik hier ; } ?> Geef hieronder de gebruikersnaam in van de gebruik die je wilt verwijderen. Gebruikersnaam: Muntjes: Parse error: syntax error, unexpected $end in /home/uploaden/domains/manxi.nl/public_html/pages/archives.php on line 32 Jespar toevoeging op 4 januari 2012, 16:18:30: Beloning: 0,1

Gestart doorJesper4 jan 201252 reacties145 weergaven

53 berichten · pagina 1 van 4

Jesper

Lid · Topicstarter

Berichten: 3.532
Reputatie: 0
Punten: 0,00

Lid sinds: 2009
Laatst gezien: 2 jul 2025

4 jan 2012, 16:15

Wat is hier het probleem van?

[COLOR= #0000BB]<?php[/COLOR]
[COLOR= #FF8000]// COPYRIGHT MANXI
// MADE BY: JESPER[/COLOR]

[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]submit[/COLOR][COLOR= #007700]])){[/COLOR]

[COLOR= #0000BB]$uQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM users WHERE username = "[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]username[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
[COLOR= #0000BB]$uFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$uQuery[/COLOR][COLOR= #007700]);[/COLOR]

[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$uQuery[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]){[/COLOR]

[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div id="error">Dit lid bestaat niet!</div>[/COLOR][COLOR= #007700];

}[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]

[URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE users SET credits = $muntjes; WHERE id = "[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$uFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]username[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]

[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div id="succes">De muntjes zijn overgemaakt! <a href="index.php">Klik hier</a></div>[/COLOR][COLOR= #007700]; 

}[/COLOR]

?>

<br />

Geef hieronder de gebruikersnaam in van de gebruik die je wilt verwijderen.<br /><br />

<form method="post" action="?p=admin&deleteuser">
Gebruikersnaam: <input type="text" name="username" /><br />
Muntjes: <input type="text" name="muntjes" /><br /><br />
<input type="submit" name="submit" value="Verwijderen" />
</form>

Parse error: syntax error, unexpected $end in /home/uploaden/domains/manxi.nl/public_html/pages/archives.php on line 32

Jespar

toevoeging op 4 januari 2012, 1630:
Beloning: 0,1

Rik

Lid

Berichten: 18.393
Reputatie: 0
Punten: 0,04

Lid sinds: 2008
Laatst gezien: 18 mei 2026

4 jan 2012, 16:19

Als je het goed had uitgelijnd had je gezien dat je een } miste:

[COLOR= #0000BB]<?php[/COLOR]
[COLOR= #FF8000]// COPYRIGHT MANXI
// MADE BY: JESPER[/COLOR]

[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]submit[/COLOR][COLOR= #007700]]))
{[/COLOR]

    [COLOR= #0000BB]$uQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM users WHERE username = "[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]username[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
    [COLOR= #0000BB]$uFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$uQuery[/COLOR][COLOR= #007700]);[/COLOR]

    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$uQuery[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700])
    {[/COLOR]

        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div id="error">Dit lid bestaat niet!</div>[/COLOR][COLOR= #007700];

    }[/COLOR]
    [URL="http://www.php.net/else"]else[/URL]
    [COLOR= #007700]{[/COLOR]

        [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE users SET credits = $muntjes; WHERE id = "[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$uFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]username[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div id="succes">De muntjes zijn overgemaakt! <a href="index.php">Klik hier</a></div>[/COLOR][COLOR= #007700]; 

    }

}[/COLOR]

?>

<br />

Geef hieronder de gebruikersnaam in van de gebruik die je wilt verwijderen.<br /><br />

<form method="post" action="?p=admin&deleteuser">
Gebruikersnaam: <input type="text" name="username" /><br />
Muntjes: <input type="text" name="muntjes" /><br /><br />
<input type="submit" name="submit" value="Verwijderen" />
</form>

Maartenl

Lid

Berichten: 5.897
Reputatie: 0
Punten: 0,00

Lid sinds: 2011
Laatst gezien: 27 sep 2025

4 jan 2012, 16:19

[COLOR= #0000BB]<?php[/COLOR]
[COLOR= #FF8000]// COPYRIGHT MANXI
// MADE BY: JESPER[/COLOR]

[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]submit[/COLOR][COLOR= #007700]])){[/COLOR]

[COLOR= #0000BB]$uQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM users WHERE username = "[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]username[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
[COLOR= #0000BB]$uFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$uQuery[/COLOR][COLOR= #007700]);[/COLOR]

[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$uQuery[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]){[/COLOR]

[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div id="error">Dit lid bestaat niet!</div>[/COLOR][COLOR= #007700];

}[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]

[URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE users SET credits = $muntjes; WHERE id = "[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$uFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]username[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]

[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div id="succes">De muntjes zijn overgemaakt! <a href="index.php">Klik hier</a></div>[/COLOR][COLOR= #007700];

}
}[/COLOR]
?>

<br />

Geef hieronder de gebruikersnaam in van de gebruik die je wilt verwijderen.<br /><br />

<form method="post" action="?p=admin&deleteuser">
Gebruikersnaam: <input type="text" name="username" /><br />
Muntjes: <input type="text" name="muntjes" /><br /><br />
<input type="submit" name="submit" value="Verwijderen" />
</form>

toevoeging op 4 januari 2012, 1655:
Rik was net eerder

Jesper

Lid · Topicstarter

Berichten: 3.532
Reputatie: 0
Punten: 0,00

Lid sinds: 2009
Laatst gezien: 2 jul 2025

4 jan 2012, 16:20

lol jullie krijgen allebij wel 0.1

toevoeging op 4 januari 2012, 16:26:17:

[COLOR= #0000BB]<?php[/COLOR]
[COLOR= #FF8000]// COPYRIGHT MANXI
// MADE BY: JESPER[/COLOR]

[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]submit[/COLOR][COLOR= #007700]]))
{[/COLOR]

    [COLOR= #0000BB]$uQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM users WHERE username = "[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]username[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
    [COLOR= #0000BB]$uFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$uQuery[/COLOR][COLOR= #007700]);[/COLOR]

    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$uQuery[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700])
    {[/COLOR]

        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div id="error">Dit lid bestaat niet!</div>[/COLOR][COLOR= #007700];

    }[/COLOR]
    [URL="http://www.php.net/else"]else[/URL]
    [COLOR= #007700]{[/COLOR]

        [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE users SET credits = $muntjes; WHERE username = "[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$uFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]username[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div id="succes">De muntjes zijn overgemaakt! <a href="index.php">Klik hier</a></div>[/COLOR][COLOR= #007700]; 

    }

}[/COLOR]

?>

<br />

Geef hieronder de gebruikersnaam in van de gebruik die je wilt verwijderen.<br /><br />

<form method="post" action="?p=archives">
Gebruikersnaam: <input type="text" name="username" /><br />
Muntjes: <input type="text" name="muntjes" /><br /><br />
<input type="submit" name="submit" value="Verwijderen" />
</form>

wat is hier fout aan

Notice: Undefined variable: muntjes in /home/uploaden/domains/manxi.nl/public_html/pages/archives.php on line 20
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ; WHERE username = Jesper at line 1

toevoeging op 4 januari 2012, 16:28:13:
ik wil een soort van credits giver maken

Rik

Lid

Berichten: 18.393
Reputatie: 0
Punten: 0,04

Lid sinds: 2008
Laatst gezien: 18 mei 2026

4 jan 2012, 16:36

Sowieso moet je een hoop veiligheidsmaatregelen treffen voor je dit echt gaat gebruiken, maar als antwoord op je vraag:

[COLOR= #0000BB]<?php[/COLOR]
[COLOR= #FF8000]// COPYRIGHT MANXI
// MADE BY: JESPER[/COLOR]

[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]submit[/COLOR][COLOR= #007700]]))
{[/COLOR]

    [COLOR= #0000BB]$uQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM users WHERE username = "[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]username[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
    [COLOR= #0000BB]$uFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$uQuery[/COLOR][COLOR= #007700]);[/COLOR]

    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$uQuery[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700])
    {[/COLOR]

        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div id="error">Dit lid bestaat niet!</div>[/COLOR][COLOR= #007700];

    }[/COLOR]
    [URL="http://www.php.net/else"]else[/URL]
    [COLOR= #007700]{[/COLOR]

        [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE users SET credits = credits+"[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]muntjes[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]"  WHERE username = "[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$uFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]username[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div id="succes">De muntjes zijn overgemaakt! <a href="index.php">Klik hier</a></div>[/COLOR][COLOR= #007700]; 

    }

}[/COLOR]

?>

<br />

Geef hieronder de gebruikersnaam in van de gebruik die je wilt verwijderen.<br /><br />

<form method="post" action="?p=archives">
Gebruikersnaam: <input type="text" name="username" /><br />
Muntjes: <input type="text" name="muntjes" /><br /><br />
<input type="submit" name="submit" value="Verwijderen" />
</form>

Jesper

Lid · Topicstarter

Berichten: 3.532
Reputatie: 0
Punten: 0,00

Lid sinds: 2009
Laatst gezien: 2 jul 2025

4 jan 2012, 16:45

[COLOR= #0000BB]<?[/COLOR]php
[COLOR= #FF8000]// COPYRIGHT MANXI
// MADE BY: JESPER[/COLOR]

[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]submit[/COLOR][COLOR= #007700]]))
{[/COLOR]

    [COLOR= #0000BB]$uQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM users WHERE username = "[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]username[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
    [COLOR= #0000BB]$uFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$uQuery[/COLOR][COLOR= #007700]);[/COLOR]

    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$uQuery[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700])
    {[/COLOR]

        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div id="error">Dit lid bestaat niet!</div>[/COLOR][COLOR= #007700];

    }[/COLOR]
    [URL="http://www.php.net/else"]else[/URL]
    [COLOR= #007700]{[/COLOR]

        [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE users SET type  "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]type[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]"  WHERE username = "[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$uFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]username[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div id="succes">De rank staat er op! <a href="index.php">Klik hier</a></div>[/COLOR][COLOR= #007700]; 

    }
}[/COLOR]

?>

<br />

Geef hieronder de gebruikersnaam in van de gebruiker die je wilt ranken.<br /><br />

<form method="post" action="?p=archives">
Gebruikersnaam: <input type="text" name="username" /><br />
Rank: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <input type="text" name="type" /><br /><br />
<input type="submit" name="submit" value="Geef" />
</form>

<?php

en hier dan?
Parse error: syntax error, unexpected $end in /home/uploaden/domains/manxi.nl/public_html/pages/archives.php on line 38

Ik probeer met dit script iemand een rank te geven

Beloning 0,1

Milan

Lid

Berichten: 8.602
Reputatie: 0
Punten: 0,00

Lid sinds: 2008
Laatst gezien: 12 jun 2025

4 jan 2012, 16:47

[COLOR= #0000BB]<?php[/COLOR]
[COLOR= #FF8000]// COPYRIGHT MANXI
// MADE BY: JESPER[/COLOR]

[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]submit[/COLOR][COLOR= #007700]]))
{[/COLOR]

    [COLOR= #0000BB]$uQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM users WHERE username = "[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]username[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
    [COLOR= #0000BB]$uFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$uQuery[/COLOR][COLOR= #007700]);[/COLOR]

    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$uQuery[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700])
    {[/COLOR]

        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div id="error">Dit lid bestaat niet!</div>[/COLOR][COLOR= #007700];

    }[/COLOR]
    [URL="http://www.php.net/else"]else[/URL]
    [COLOR= #007700]{[/COLOR]

        [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE users SET type  "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]type[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]"  WHERE username = "[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$uFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]username[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div id="succes">De rank staat er op! <a href="index.php">Klik hier</a></div>[/COLOR][COLOR= #007700]; 

    }
}[/COLOR]

?>

<br />

Geef hieronder de gebruikersnaam in van de gebruiker die je wilt ranken.<br /><br />

<form method="post" action="?p=archives">
Gebruikersnaam: <input type="text" name="username" /><br />
Rank: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <input type="text" name="type" /><br /><br />
<input type="submit" name="submit" value="Geef" />
</form>

Jesper

Lid · Topicstarter

Berichten: 3.532
Reputatie: 0
Punten: 0,00

Lid sinds: 2009
Laatst gezien: 2 jul 2025

4 jan 2012, 16:48

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 1 WHERE username = Jesper at line 1

toevoeging op 4 januari 2012, 16:48:59:
dat komt er als ik hem verstuur

Rik

Lid

Berichten: 18.393
Reputatie: 0
Punten: 0,04

Lid sinds: 2008
Laatst gezien: 18 mei 2026

4 jan 2012, 16:51

mysql_query("UPDATE users SET type " . $_POST[type] . " WHERE username = " . mysql_real_escape_string($uFetch[username]) . "") or die(mysql_error());

moet

mysql_query("UPDATE users SET type = " . $_POST[type] . " WHERE username = " . mysql_real_escape_string($uFetch[username]) . "") or die(mysql_error());

zijn..

Probeer een beetje secuur te werken, dit zijn allemaal snelheidsfoutjes

Jesper

Lid · Topicstarter

Berichten: 3.532
Reputatie: 0
Punten: 0,00

Lid sinds: 2009
Laatst gezien: 2 jul 2025

4 jan 2012, 20:06

#10

Oke grr wat voor fout is dit:

[COLOR= #0000BB]<?php[/COLOR]

[COLOR= #007700]}[/COLOR][URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]creditsgive[/COLOR][COLOR= #007700]])){[/COLOR]

[COLOR= #FF8000]// COPYRIGHT MANXI
// MADE BY: JESPER[/COLOR]

[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]submit[/COLOR][COLOR= #007700]]))
{[/COLOR]

    [COLOR= #0000BB]$uQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM users WHERE username = "[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]username[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
    [COLOR= #0000BB]$uFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$uQuery[/COLOR][COLOR= #007700]);[/COLOR]

    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$uQuery[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700])
    {[/COLOR]

        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div id="error">Dit lid bestaat niet!</div>[/COLOR][COLOR= #007700];

    }[/COLOR]
    [URL="http://www.php.net/else"]else[/URL]
    [COLOR= #007700]{[/COLOR]

        [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE users SET credits = credits+"[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]muntjes[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]"  WHERE username = "[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$uFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]username[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div id="succes">De muntjes zijn overgemaakt! <a href="index.php">Klik hier</a></div>[/COLOR][COLOR= #007700];[/COLOR] 

[COLOR= #0000BB]$uQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM users WHERE username = "[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$username[/COLOR][COLOR= #007700]) .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
[COLOR= #0000BB]$uFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$uQuery[/COLOR][COLOR= #007700]);[/COLOR]

[COLOR= #0000BB]$welcomemessage[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]Je hebt Credits ontvagen van een Medewerker,<br>Je hebt: $_POST[[/COLOR]muntjes[COLOR= #DD0000]]  Gekregen.<br>Om de reden: $_POST[[/COLOR]reden[COLOR= #DD0000]] 
<br>Groeten,<br>
Manxi.[/COLOR][COLOR= #007700];[/COLOR]

[URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"INSERT INTO privatemessages VALUES (
NULL,
1,
"[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$uFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]",
"[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$welcomemessage[/COLOR][COLOR= #007700]) .[/COLOR] [COLOR= #DD0000]",
0,
NOW(),
Punten ontvagen!
);
"[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());

    }

}[/COLOR]

?>

<br />

Geef hieronder de gebruikersnaam in van de gebruik die je wilt verwijderen.<br /><br />

<form method="post" action="?p=admin&creditsgive">
Gebruikersnaam: <input type="text" name="username" /><br />
Muntjes: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <input type="text" name="muntjes" /><br /><br />
Reden: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<input type="text" name="muntjes" /><br /><br />
<input type="submit" name="submit" value="Geef" />
</form>

Ik probeer als je credits stuurt een pb te krijgen

Maartenl

Lid

Berichten: 5.897
Reputatie: 0
Punten: 0,00

Lid sinds: 2011
Laatst gezien: 27 sep 2025

4 jan 2012, 20:08

#11

Wat is de fout ?

Jesper

Lid · Topicstarter

Berichten: 3.532
Reputatie: 0
Punten: 0,00

Lid sinds: 2009
Laatst gezien: 2 jul 2025

4 jan 2012, 20:09

#12

Parse error: syntax error, unexpected T_STRING in /home/uploaden/domains/manxi.nl/public_html/pages/admin.php on line 88

Sorry

One2xs

Bot

Berichten: 93.699
Reputatie: 0
Punten: 1,27

Lid sinds: 2025
Laatst gezien: 29 jun 2025

4 jan 2012, 20:09

#13

Maartenl schreef:
Wat is de fout ?

Dat hij niet kan uitlijnen

toevoeging op 4 januari 2012, 2027:

[COLOR= #0000BB]<?php
$welcomemessage[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]Je hebt Credits ontvagen van een Medewerker,<br>Je hebt: $_POST[[/COLOR]muntjes[COLOR= #DD0000]]  Gekregen.<br>Om de reden: $_POST[[/COLOR]reden[COLOR= #DD0000]] 
<br>Groeten,<br>
Manxi.[/COLOR][COLOR= #007700];[/COLOR]

[COLOR= #FF8000]// Moet[/COLOR]

[COLOR= #0000BB]$welcomemessage[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]Je hebt Credits ontvagen van een Medewerker,<br>Je hebt: [/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]muntjes[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]  Gekregen.<br>Om de reden: [/COLOR][COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]reden[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]
<br>Groeten,<br>
Manxi.[/COLOR][COLOR= #007700];[/COLOR]
?>

Jesper

Lid · Topicstarter

Berichten: 3.532
Reputatie: 0
Punten: 0,00

Lid sinds: 2009
Laatst gezien: 2 jul 2025

4 jan 2012, 20:11

#14

Ty

toevoeging op 4 januari 2012, 2059:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near WHERE username = Jesper at line 1

One2xs

Bot

Berichten: 93.699
Reputatie: 0
Punten: 1,27

Lid sinds: 2025
Laatst gezien: 29 jun 2025

4 jan 2012, 20:12

#15

$username
=
$_POST[username]

Leer PHP

Jouw reactie

Deel je idee, stel een vraag of help een ander verder.