Hoi,
ik wil dat gebruikers kunnen reageren op profielen,
een soort gastenboek dus.
Maar nu heb ik geen idee hoe ik dat samen moet voegen, iemand een idee?
Het gastenboek moet onder biografie komen, op regel 199.
Dit is profiel.php:En dit is de code van mijn gastenboek:Trouwens wil ik ook dat mijn gastenboek een achtergrond kleurtje krijgt,
#DDDDDD ofzo.
Kan dat? Alvast bedankt
ik wil dat gebruikers kunnen reageren op profielen,
een soort gastenboek dus.
Maar nu heb ik geen idee hoe ik dat samen moet voegen, iemand een idee?
Het gastenboek moet onder biografie komen, op regel 199.
Dit is profiel.php:
(profiel.php)
[COLOR= #0000BB]<?php[/COLOR]
[COLOR= #FF8000]/**
* @copyright 2010 Milan Drossaerts
* @author Milan Drossaerts [http://www.dynaspan-media.nl]
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions
* are met:
*
* * Redistributions of source code must retain the above copyright
* notice and this (list of) condition(s).
*/[/COLOR]
[URL="http://www.php.net/if"]if[/URL] [COLOR= #007700](![/COLOR][COLOR= #0000BB]$leden[/COLOR][COLOR= #007700]->[/COLOR]is_ingelogd[COLOR= #007700]())
{[/COLOR]
[COLOR= #0000BB]$layout[/COLOR][COLOR= #007700]->[/COLOR]boven[COLOR= #007700]([/COLOR][COLOR= #DD0000]Profiel[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]Je moet inloggen om profielen te kunnen zien[/COLOR][COLOR= #007700];
}[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/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]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]e[/COLOR][COLOR= #007700]]))
{[/COLOR]
[COLOR= #0000BB]$gQuery[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$mysql[/COLOR][COLOR= #007700]->[/COLOR]query[COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM leden WHERE gebruikersnaam = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$mysql[/COLOR][COLOR= #007700]->[/COLOR]real_escape[COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruiker[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$mysql[/COLOR][COLOR= #007700]->[/COLOR]num_rows[COLOR= #007700]([/COLOR][COLOR= #0000BB]$gQuery[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700])
{[/COLOR]
[COLOR= #0000BB]$layout[/COLOR][COLOR= #007700]->[/COLOR]boven[COLOR= #007700]([/COLOR][COLOR= #DD0000]Niet gevonden | Profiel[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]Dit profiel is niet gevonden[/COLOR][COLOR= #007700];
}[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
[COLOR= #0000BB]$gFetch[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$mysql[/COLOR][COLOR= #007700]->[/COLOR]fetch[COLOR= #007700]([/COLOR][COLOR= #0000BB]$gQuery[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$layout[/COLOR][COLOR= #007700]->[/COLOR]boven[COLOR= #007700]([/COLOR][COLOR= #0000BB]$core[/COLOR][COLOR= #007700]->[/COLOR]entities[COLOR= #007700]([/COLOR][COLOR= #DD0000]Profiel[/COLOR][COLOR= #007700]));[/COLOR]
[URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$cms[/COLOR][COLOR= #007700]->[/COLOR]getInstelling[COLOR= #007700]([/COLOR][COLOR= #DD0000]3[/COLOR][COLOR= #007700]) !=[/COLOR] [COLOR= #DD0000]1[/COLOR][COLOR= #007700])
{[/COLOR]
[COLOR= #0000BB]$avatar[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000][/COLOR][COLOR= #007700];
}[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
[URL="http://www.php.net/if"]if[/URL] [COLOR= #007700](![/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$gFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]avatar[/COLOR][COLOR= #007700]]))
{[/COLOR]
[COLOR= #0000BB]$avatar[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<img src="[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$core[/COLOR][COLOR= #007700]->[/COLOR]entities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$gFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]avatar[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]" style="max-height: 100px; max-width: 100px;" />[/COLOR][COLOR= #007700];
}[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
[COLOR= #0000BB]$avatar[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000][/COLOR][COLOR= #007700];
}
}[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]
<div style="float: left; margin-left: 5px;">[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$avatar[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]</div>
<div style="float: left; margin-left: 10px;"><h1>[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$core[/COLOR][COLOR= #007700]->[/COLOR]entities[COLOR= #007700]([/COLOR][URL="http://www.php.net/ucfirst"]ucfirst[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$gFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruikersnaam[/COLOR][COLOR= #007700]])) .[/COLOR] [COLOR= #DD0000]</h1></div>
<div style="float: right; margin-right: 5px;">
<br />
<table>
<tr>
<td><img src="[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_CONFIG[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]Site_url[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]images/email_add.png" /></td>
<td>
<a href="[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_CONFIG[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]Site_url[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]?p=priveberichten&n&aan=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$core[/COLOR][COLOR= #007700]->[/COLOR]entities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$gFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruikersnaam[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]">Stuur een privebericht naar [/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$core[/COLOR][COLOR= #007700]->[/COLOR]entities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$gFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruikersnaam[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]</a>
</td>
</tr>
</table>
</div>
<div style="clear: both;"></div>
<table>
<td>
<td><img src="[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_CONFIG[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]Site_url[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]images/coins.png" title="credits" />
</td><td><strong>Credits:</strong></td>
<td>[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/stripslashes"]stripslashes[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$core[/COLOR][COLOR= #007700]->[/COLOR]entities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$gFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]credits[/COLOR][COLOR= #007700]])) .[/COLOR] [COLOR= #DD0000]</td>
</tr>
<tr>
<tr>
<td><td><img src="[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_CONFIG[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]Site_url[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]images/shield.png" title="Rang" /> </td><td><strong>Rang:</strong></td>
<td>[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$leden[/COLOR][COLOR= #007700]->[/COLOR]getRang[COLOR= #007700]([/COLOR][COLOR= #0000BB]$gFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]</td>
</tr>
<tr>
<td><td><img src="[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_CONFIG[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]Site_url[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]images/information.png" title="Hobbys" /></td><td><strong>Hobbys:</strong></td>
<td>[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/stripslashes"]stripslashes[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$core[/COLOR][COLOR= #007700]->[/COLOR]entities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$gFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]hobby[/COLOR][COLOR= #007700]])) .[/COLOR] [COLOR= #DD0000]</td>
</tr>
<tr>
<td><td><img src="[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_CONFIG[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]Site_url[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]images/world.png" title="Websites" /></td><td><strong>Websites: </strong></td>
<td>[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/stripslashes"]stripslashes[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$core[/COLOR][COLOR= #007700]->[/COLOR]entities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$gFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]website[/COLOR][COLOR= #007700]])) .[/COLOR] [COLOR= #DD0000]</td>
</tr>
<tr>
<td><td><img src="[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_CONFIG[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]Site_url[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]images/user_comment.png" title="Biografie" /></td><td><strong>Biografie:</strong></td>
<td>[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/stripslashes"]stripslashes[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$core[/COLOR][COLOR= #007700]->[/COLOR]entities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$gFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]bio[/COLOR][COLOR= #007700]])) .[/COLOR] [COLOR= #DD0000]</td>
</tr>
</table>
<em>Profiel laatst bewerkt op: [/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$gFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]profiel_update[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]</em>[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$gFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]$leden[/COLOR][COLOR= #007700]->[/COLOR]getId[COLOR= #007700]())
{[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]
<div style="float: right;">
<table>
<tr><td><img src="[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_CONFIG[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]Site_url[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]images/pencil.png" /></td><td><a href="[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_CONFIG[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]Site_url[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]?p=profiel&e">Bewerk mijn profiel</a></td></tr>
</table>
</div>[/COLOR][COLOR= #007700];
}
}
}[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
[COLOR= #0000BB]$layout[/COLOR][COLOR= #007700]->[/COLOR]boven[COLOR= #007700]([/COLOR][COLOR= #DD0000]Profiel bewerken[/COLOR][COLOR= #007700]);[/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]
[URL="http://www.php.net/if"]if[/URL] [COLOR= #007700](![/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]avatar[/COLOR][COLOR= #007700]]))
{[/COLOR]
[URL="http://www.php.net/if"]if[/URL] [COLOR= #007700](@[/COLOR][URL="http://www.php.net/file_get_contents"]file_get_contents[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]avatar[/COLOR][COLOR= #007700]]))
{[/COLOR]
[COLOR= #0000BB]$mysql[/COLOR][COLOR= #007700]->[/COLOR]query[COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE
leden
SET
hobby = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$mysql[/COLOR][COLOR= #007700]->[/COLOR]real_escape[COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]hobbys[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]",
website = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$mysql[/COLOR][COLOR= #007700]->[/COLOR]real_escape[COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]websites[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]",
bio = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$mysql[/COLOR][COLOR= #007700]->[/COLOR]real_escape[COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]bio[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]",
avatar = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$mysql[/COLOR][COLOR= #007700]->[/COLOR]real_escape[COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]avatar[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]",
profiel_update = NOW()
WHERE
id = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$mysql[/COLOR][COLOR= #007700]->[/COLOR]real_escape[COLOR= #007700]([/COLOR][COLOR= #0000BB]$leden[/COLOR][COLOR= #007700]->[/COLOR]getId[COLOR= #007700]()) .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]Je profiel is geupdated. <a href="[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_CONFIG[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]Site_url[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]?p=profiel&gebruiker=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$leden[/COLOR][COLOR= #007700]->[/COLOR]getName[COLOR= #007700]([/COLOR][COLOR= #0000BB]$leden[/COLOR][COLOR= #007700]->[/COLOR]getId[COLOR= #007700]()) .[/COLOR] [COLOR= #DD0000]">Bekijk profiel</a>[/COLOR][COLOR= #007700];
}[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]Deze avatar bestaat niet.<br />[/COLOR][COLOR= #007700];
}
}[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
[COLOR= #0000BB]$mysql[/COLOR][COLOR= #007700]->[/COLOR]query[COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE
leden
SET
hobby = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$mysql[/COLOR][COLOR= #007700]->[/COLOR]real_escape[COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]hobbys[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]",
website = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$mysql[/COLOR][COLOR= #007700]->[/COLOR]real_escape[COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]websites[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]",
bio = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$mysql[/COLOR][COLOR= #007700]->[/COLOR]real_escape[COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]bio[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]",
avatar = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$mysql[/COLOR][COLOR= #007700]->[/COLOR]real_escape[COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]avatar[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]",
profiel_update = NOW()
WHERE
id = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$mysql[/COLOR][COLOR= #007700]->[/COLOR]real_escape[COLOR= #007700]([/COLOR][COLOR= #0000BB]$leden[/COLOR][COLOR= #007700]->[/COLOR]getId[COLOR= #007700]()) .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]Je profiel is geupdated. <a href="[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_CONFIG[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]Site_url[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]?p=profiel&gebruiker=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$leden[/COLOR][COLOR= #007700]->[/COLOR]getName[COLOR= #007700]([/COLOR][COLOR= #0000BB]$leden[/COLOR][COLOR= #007700]->[/COLOR]getId[COLOR= #007700]()) .[/COLOR] [COLOR= #DD0000]">Bekijk profiel</a>[/COLOR][COLOR= #007700];
}
}[/COLOR]
[COLOR= #0000BB]$pQuery[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$mysql[/COLOR][COLOR= #007700]->[/COLOR]query[COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM leden WHERE id = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$leden[/COLOR][COLOR= #007700]->[/COLOR]getId[COLOR= #007700]() .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$pFetch[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$mysql[/COLOR][COLOR= #007700]->[/COLOR]fetch[COLOR= #007700]([/COLOR][COLOR= #0000BB]$pQuery[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$cms[/COLOR][COLOR= #007700]->[/COLOR]getInstelling[COLOR= #007700]([/COLOR][COLOR= #DD0000]3[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #DD0000]1[/COLOR][COLOR= #007700])
{[/COLOR]
[COLOR= #0000BB]$avatar[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<tr>
<td style="width: 250px;">Avatar:</td>
<td style="width: 250px;"><input type="text" name="avatar" value="[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$pFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]avatar[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]" style="width: 250px" /></td>
</tr>[/COLOR][COLOR= #007700];
}[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
[COLOR= #0000BB]$avatar[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000][/COLOR][COLOR= #007700];
}[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<form action="" method="post">
<table>
[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$avatar[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]
<tr>
<td style="width: 250px;">Hobbys:</td>
<td style="width: 250px;"><input type="text" name="hobbys" value="[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$pFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]hobby[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]" style="width: 250px" /></td>
</tr>
<tr>
<td style="width: 250px;">Websites:</td>
<td style="width: 250px;"><input type="text" name="websites" value="[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$pFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]website[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]" style="width: 250px" /></td>
</tr>
<tr>
<td style="width: 250px;">Biografie:</td>
<td style="width: 250px;"><textarea name="bio" style="width: 250px; height: 100px;">[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$pFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]bio[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]</textarea></td>
</tr>
<tr>
<td style="width: 250px;"></td>
<td style="width: 250px;"><input type="submit" name="submit" value="Profiel aanpassen" style="width: 250px;" /></td>
</tr>
</table>
</form>
<a href="[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_CONFIG[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]Site_url[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]?p=wwaanpassen">Wachtwoord wijzigen?</a>[/COLOR][COLOR= #007700];
}
}[/COLOR]
[COLOR= #0000BB]$layout[/COLOR][COLOR= #007700]->[/COLOR]onder[COLOR= #007700]();[/COLOR]
?>Spoiler tonen
[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/session_start"]session_start[/URL][COLOR= #007700]();[/COLOR]
[URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]connect.php[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<h1>Gastenboek</h1>"[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<hr width=250 align=left/>"[/COLOR][COLOR= #007700];[/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]b[/COLOR][COLOR= #007700]]))
{[/COLOR]
[COLOR= #0000BB]$abericht[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]bericht[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"[b][/b]"[/COLOR][COLOR= #007700];
}[/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]i[/COLOR][COLOR= #007700]]))
{[/COLOR]
[COLOR= #0000BB]$abericht[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]bericht[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"[i][/i]"[/COLOR][COLOR= #007700];
}[/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]u[/COLOR][COLOR= #007700]]))
{[/COLOR]
[COLOR= #0000BB]$abericht[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]bericht[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"[u][/u]"[/COLOR][COLOR= #007700];
}[/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]url[/COLOR][COLOR= #007700]]))
{[/COLOR]
[COLOR= #0000BB]$abericht[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]bericht[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"[url][/url]"[/COLOR][COLOR= #007700];
}[/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]$naam[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]u_Gebruikersnaam[/COLOR][COLOR= #007700]];[/COLOR]
[COLOR= #0000BB]$bericht[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/strip_tags"]strip_tags[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]bericht[/COLOR][COLOR= #007700]]);[/COLOR]
[COLOR= #0000BB]$avatarget[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM leden WHERE gebruikersnaam = $naam"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$avatarrow[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$avatarget[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$avatar[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$avatarrow[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]avatar[/COLOR][COLOR= #007700]];[/COLOR]
[COLOR= #0000BB]$tijd[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/date"]date[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"Y-m-d H:i:s"[/COLOR][COLOR= #007700]);[/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]$naam[/COLOR][COLOR= #007700]))
{[/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]$bericht[/COLOR][COLOR= #007700]))
{[/COLOR]
[COLOR= #0000BB]$submit[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"INSERT INTO gastenboek(naam, avatar, tijd, bericht) VALUES($naam, $avatar, $tijd, $bericht)"[/COLOR][COLOR= #007700]);
}[/COLOR]
[URL="http://www.php.net/else"]else[/URL]
[COLOR= #007700]{[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Je hebt geen bericht ingevuld!"[/COLOR][COLOR= #007700];
}
}[/COLOR]
[URL="http://www.php.net/else"]else[/URL]
[COLOR= #007700]{[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Je bent niet ingelogd! Log eerst in voordat je post."[/COLOR][COLOR= #007700];
}
}[/COLOR]
[COLOR= #0000BB]$queryget[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM gastenboek"[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$queryget[/COLOR][COLOR= #007700]))
{[/COLOR]
[COLOR= #0000BB]$id[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]];[/COLOR]
[COLOR= #0000BB]$naam[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naam[/COLOR][COLOR= #007700]];[/COLOR]
[COLOR= #0000BB]$avatar[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]avatar[/COLOR][COLOR= #007700]];[/COLOR]
[COLOR= #0000BB]$tijd[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]tijd[/COLOR][COLOR= #007700]];[/COLOR]
[COLOR= #0000BB]$bericht[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]bericht[/COLOR][COLOR= #007700]];[/COLOR]
[COLOR= #0000BB]$bericht[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/str_replace"]str_replace[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000][b][/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]<b>[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$bericht[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$bericht[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/str_replace"]str_replace[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000][/b][/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]</b>[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$bericht[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$bericht[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/str_replace"]str_replace[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000][i][/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]<i>[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$bericht[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$bericht[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/str_replace"]str_replace[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000][/i][/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]</i>[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$bericht[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$bericht[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/str_replace"]str_replace[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000][u][/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]<u>[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$bericht[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$bericht[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/str_replace"]str_replace[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000][/u][/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]</u>[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$bericht[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$bericht[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/str_replace"]str_replace[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000][url][/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]<a href="[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$bericht[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$bericht[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/str_replace"]str_replace[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000][/url][/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]">Link</a>[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$bericht[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$bericht[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/str_replace"]str_replace[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000][img][/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]<img src="[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$bericht[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$bericht[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/str_replace"]str_replace[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000][/img][/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]" height="100" width="100" />[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$bericht[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$bericht[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/str_replace"]str_replace[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]:)[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]<img src="adhd.gif">[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$bericht[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]"
<table>
<tr>
<td>
Gepost door $naam
</td>
<td style=text-align: right;>
$tijd
</td>
</td>
<td>
</td>
</tr>
<tr>
<td>
<img src=$avatar hight=100 width=100 style=float: left;>
<div style=margin-top: 0px; float: left;>"[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/nl2br"]nl2br[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$bericht[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]"</div>
</td>
<td>
</td>
</tr>
</table>
"[/COLOR][COLOR= #007700];
}[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"
<form name=gastenboek method=post>
<table width=100%>
<tr>
<td>
Bericht:
</td>
</tr>
<tr>
<td>
<input type=submit name=b value=b><input type=submit name=i value=i><input type=submit name=u value=u><input type=submit name=url value=url>
</td>
</tr>
<tr>
<td>
<textarea cols=20 rows=2 name=bericht>$abericht</textarea>
</td>
</tr>
<tr>
<td>
<input type=submit name=submit value=verstuur>
</td>
</tr>
</table>
</form>
"[/COLOR][COLOR= #007700];[/COLOR]
?>#DDDDDD ofzo.
Kan dat? Alvast bedankt


en ieder gastenboek heeft een andere tabel in de database 