Pagina - One2xs Forum

Lid · Topicstarter
Berichten: 20.364
Reputatie: 0
Punten: 0,00
Lid sinds: 2008
Laatst gezien: 9 aug 2020
22 nov 2009, 18:26
Ik heb een paginascript en als ik paginas wil toevoegen.

Krijg ik dit:

Notice: Column count doesnt match value count at row 1 in /home/shahiem/domains/habboregio.nl/public_html/map/admin_pagina.php on line 9

Dit is me code
[COLOR= #0000BB]<?php[/COLOR]
    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR]is_auth[COLOR= #007700]([/COLOR][COLOR= #0000BB]4[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]))
    {[/COLOR]
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]act[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]place[/COLOR][COLOR= #007700])
        {[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<h1>Pagina maken</h1>[/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SERVER[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]REQUEST_METHOD[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #DD0000]POST[/COLOR] [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/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"INSERT INTO paginasysteem (titel, inhoud, categorie) VALUES ("[/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]titel[/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]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]inhoud[/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]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]categorie[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]", NOW())"[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/trigger_error"]trigger_error[/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 class="greenerror">Het nieuwsbericht is verzonden, u word nu doorverwezen.<br /><a href="index.php?p=admin_pagina">Of klik hier als u niet kunt wachten.</a></div>[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<meta http-equiv="refresh" content="3;url=index.php?p=admin_pagina">[/COLOR][COLOR= #007700];    
            }[/COLOR]   
            [URL="http://www.php.net/else"]else[/URL]
            [COLOR= #007700]{[/COLOR]
                ?>
                    
                        <form name="textbox" action="index.php?p=admin_pagina&amp;act=place" method="POST">
                        <center><strong>Titel</strong></center>
                            <input type="text" style="width:100%;" name="titel" /><br /><br />
      <select name="categorie">
                    <option value="1">Habbo Hotel</option>
 <option value="2">Veiligheid</option>
                </select><br /><br />
                        <center><strong>Bericht</strong></center>
                            <textarea style="width:100%;" rows="20" id="textboxcom" name="inhoud"></textarea><br />


                            [COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] ubb[COLOR= #007700]([/COLOR][COLOR= #DD0000]textbox[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]text[/COLOR][COLOR= #007700]);[/COLOR] ?><br />
                            <input type="submit" name="submit" value="Plaats nieuws" />
                        </form>
                 
                [COLOR= #0000BB]<?php[/COLOR]
            [COLOR= #007700]}    
        }[/COLOR]
        [URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]act[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]delete[/COLOR] [COLOR= #007700]||[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]act[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]reopen[/COLOR]  [COLOR= #007700]&&[/COLOR] [URL="http://www.php.net/ctype_digit"]ctype_digit[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]]))
        {[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<h1> Beheer berichten </h1>[/COLOR][COLOR= #007700];[/COLOR]
            [COLOR= #0000BB]$nVisible[/COLOR] [COLOR= #007700]= ([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]act[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]delete[/COLOR] [COLOR= #007700]?[/COLOR] [COLOR= #0000BB]0[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]);[/COLOR]
            [COLOR= #0000BB]$numQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT 1 FROM member_news WHERE nId ="[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]])[/COLOR] or [URL="http://www.php.net/trigger_error"]trigger_error[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][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]$numQuery[/COLOR][COLOR= #007700]))
            {[/COLOR]
                [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE member_news SET nVisible = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$nVisible[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]" WHERE nId ="[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]])[/COLOR] or [URL="http://www.php.net/trigger_error"]trigger_error[/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 class="greenerror">Het nieuwsbericht is [/COLOR][COLOR= #007700]. ([/COLOR][COLOR= #0000BB]$nVisible[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]0[/COLOR] [COLOR= #007700]?[/COLOR] [COLOR= #DD0000]verwijderd[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000]terug gezet[/COLOR][COLOR= #007700]) .[/COLOR][COLOR= #DD0000], u word nu doorverwezen.<br /><a href="index.php?p=admin_news">Of klik hier als u niet kunt wachten.</a></div>[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<meta http-equiv="refresh" content="3;url=index.php?p=admin_news">[/COLOR][COLOR= #007700];
            }
        }[/COLOR]
        [URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]act[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]edit[/COLOR] [COLOR= #007700]&&[/COLOR] [URL="http://www.php.net/ctype_digit"]ctype_digit[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]]))
        {[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<h1>Nieuws wijzigen</h1>[/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SERVER[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]REQUEST_METHOD[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #DD0000]POST[/COLOR] [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/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE member_news SET nText = "[/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]text[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]", nTitle = "[/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]titel[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]",UCat = "[/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]UCat[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]"  WHERE nId = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]])[/COLOR] or [URL="http://www.php.net/trigger_error"]trigger_error[/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 class="greenerror">Het nieuwsbericht is aangepast, u word nu doorverwezen.<br /><a href="index.php?p=nieuws&amp;act=leesmeer&amp;id=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]">Of klik hier als u niet kunt wachten.</a></div>[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<meta http-equiv="refresh" content="3;url=index.php?p=nieuws&amp;act=leesmeer&amp;id=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]">[/COLOR][COLOR= #007700];    
            }[/COLOR]   
            [URL="http://www.php.net/else"]else[/URL]
            [COLOR= #007700]{[/COLOR]
                [COLOR= #0000BB]$sQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT nVisible, nText, nTitle,UCat nId FROM member_news WHERE nId ="[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]]);[/COLOR]
                [COLOR= #0000BB]$sFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sQuery[/COLOR][COLOR= #007700]);[/COLOR]
                
                ?>
                    <div id="comment_box">
                    [COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]Je wijzigt : <a href="index.php?p=nieuws&act=leesmeer&id=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nId[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]">[/COLOR] [COLOR= #007700]. ([/COLOR][URL="http://www.php.net/strlen"]strlen[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nTitle[/COLOR][COLOR= #007700]]) >[/COLOR] [COLOR= #0000BB]40[/COLOR] [COLOR= #007700]?[/COLOR] [URL="http://www.php.net/substr"]substr[/URL][COLOR= #007700]([/COLOR]htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nTitle[/COLOR][COLOR= #007700]],[/COLOR] ENT_QUOTES[COLOR= #007700]),[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]40[/COLOR][COLOR= #007700]) .[/COLOR] [COLOR= #DD0000]...[/COLOR] [COLOR= #007700]:[/COLOR] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nTitle[/COLOR][COLOR= #007700]],[/COLOR] ENT_QUOTES[COLOR= #007700]))  .[/COLOR] [COLOR= #DD0000]</a>[/COLOR][COLOR= #007700];[/COLOR] ?><br /><br /> 
                        <form name="textbox" action="index.php?p=admin_news&amp;act=edit&amp;id=[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]];[/COLOR] ?>" method="POST">
                            <input type="hidden" name="nId" value="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]];[/COLOR] ?>" />
                            Titel: <input type="text" style="width:100px;" name="titel" value="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nTitle[/COLOR][COLOR= #007700]],[/COLOR] ENT_QUOTES[COLOR= #007700]);[/COLOR] ?>" /><br />

Categorie:
<select name="UCat">
                    <option value="Habbo NL/BE">Habbo NL/BE</option>
 <option value="Habbo Buitenland">Habbo Buitenland</option>
                    <option value="Habboregio">Habboregio</option>
                    <option value="Competities">Competities</option>
                    <option value="Evenementen">Evenementen</option>
                </select><br /><br />
                            <textarea style="width:100%;" rows="20" id="textbox" name="text">[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nText[/COLOR][COLOR= #007700]],[/COLOR] ENT_QUOTES[COLOR= #007700]);[/COLOR] ?></textarea><br />
                            [COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] ubb[COLOR= #007700]([/COLOR][COLOR= #DD0000]textbox[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]text[/COLOR][COLOR= #007700]);[/COLOR] ?><br />


                            <input type="submit" name="submit" value="Wijzig nieuws" />
                        </form>
                    </div>
                [COLOR= #0000BB]<?php[/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]<h1>Pagina overzicht</h1>[/COLOR][COLOR= #007700];[/COLOR]
            [COLOR= #0000BB]$per_pagina[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]30[/COLOR][COLOR= #007700];[/COLOR]
            [COLOR= #0000BB]$start[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]start[/COLOR][COLOR= #007700]]) &&[/COLOR] [URL="http://www.php.net/ctype_digit"]ctype_digit[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]start[/COLOR][COLOR= #007700]]) ?[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]start[/COLOR][COLOR= #007700]] :[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR]
                
            [COLOR= #0000BB]$pagina[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/ceil"]ceil[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$start[/COLOR] / [COLOR= #0000BB]$per_pagina[/COLOR][COLOR= #007700]) +[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR]
            [COLOR= #0000BB]$paginas_mysql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT count(1) AS aantal FROM paginasysteem"[/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]$fetch_mysql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$paginas_mysql[/COLOR][COLOR= #007700]);[/COLOR]
            [COLOR= #0000BB]$paginas[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/ceil"]ceil[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$fetch_mysql[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]aantal[/COLOR][COLOR= #007700]][/COLOR] / [COLOR= #0000BB]$per_pagina[/COLOR][COLOR= #007700]);[/COLOR]
                
            [COLOR= #0000BB]$sQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT id, titel, inhoud, categorie FROM paginasysteem ORDER BY id DESC LIMIT "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$start[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]","[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$per_pagina[/COLOR][COLOR= #007700]);[/COLOR]
            
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<table><tr><td width="300px"><strong>Titel</strong></td><td width="150px"><strong>Datum</strong></td><td width="150px"><strong>Opties</strong></td></tr>[/COLOR][COLOR= #007700];[/COLOR]    
            [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sQuery[/COLOR][COLOR= #007700]))
            {[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<tr><td><a href="index.php?p=nieuws&act=leesmeer&id=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]">[/COLOR] [COLOR= #007700]. ([/COLOR][URL="http://www.php.net/strlen"]strlen[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]titel[/COLOR][COLOR= #007700]]) >[/COLOR] [COLOR= #0000BB]40[/COLOR] [COLOR= #007700]?[/COLOR] [URL="http://www.php.net/substr"]substr[/URL][COLOR= #007700]([/COLOR]htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]titel[/COLOR][COLOR= #007700]],[/COLOR] ENT_QUOTES[COLOR= #007700]),[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]40[/COLOR][COLOR= #007700]) .[/COLOR] [COLOR= #DD0000]...[/COLOR] [COLOR= #007700]:[/COLOR] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nTitle[/COLOR][COLOR= #007700]],[/COLOR] ENT_QUOTES[COLOR= #007700]))  .[/COLOR] [COLOR= #DD0000]</a></td><td><a href="index.php?p=admin_news&act=edit&id=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nId[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]">Wijzig</a>[/COLOR] [COLOR= #007700]. ([/COLOR][COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nVisible[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]1[/COLOR] [COLOR= #007700]?[/COLOR] [COLOR= #DD0000] <a href="index.php?p=admin_news&amp;act=delete&amp;id=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nId[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]">Verwijder</a></div>[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000] <a href="index.php?p=admin_news&amp;act=reopen&amp;id=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nId[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]">Zet terug</a></div>[/COLOR][COLOR= #007700]) .[/COLOR] [COLOR= #DD0000]</div>[/COLOR][COLOR= #007700];
            }[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]</table><br />[/COLOR][COLOR= #007700];[/COLOR]
            
            [URL="http://www.php.net/for"]for[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$j[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$pagina[/COLOR][COLOR= #007700]-[/COLOR][COLOR= #0000BB]5[/COLOR][COLOR= #007700];[/COLOR][COLOR= #0000BB]$j[/COLOR] [COLOR= #007700]<[/COLOR] [COLOR= #0000BB]$pagina[/COLOR][COLOR= #007700]+[/COLOR][COLOR= #0000BB]5[/COLOR][COLOR= #007700];[/COLOR][COLOR= #0000BB]$j[/COLOR][COLOR= #007700]++) 
            {[/COLOR]
               [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$j[/COLOR] [COLOR= #007700]>[/COLOR] [COLOR= #0000BB]0[/COLOR] [COLOR= #007700]&&[/COLOR] [COLOR= #0000BB]$j[/COLOR] [COLOR= #007700]<=[/COLOR] [COLOR= #0000BB]$paginas[/COLOR][COLOR= #007700]) 
               {[/COLOR]
                  [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$j[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]$pagina[/COLOR][COLOR= #007700])
                  {[/COLOR]
                     [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]<strong>[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$pagina[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]</strong>&nbsp;[/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]"<a href=index.php?p=admin_news&start="[/COLOR] [COLOR= #007700]. (([/COLOR][COLOR= #0000BB]$j[/COLOR][COLOR= #007700]-[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700])*[/COLOR][COLOR= #0000BB]$per_pagina[/COLOR][COLOR= #007700]) .[/COLOR] [COLOR= #DD0000]">"[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$j[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]"</a>&nbsp;"[/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]<h1>Pagina beheer</h1>[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div class="rederror">Je bent niet bevoegd om deze pagina te bekijken</div>[/COLOR][COLOR= #007700];
    }[/COLOR]
?>
Rik
Lid
Berichten: 18.393
Reputatie: 0
Punten: 0,04
Lid sinds: 2008
Laatst gezien: 18 mei 2026
22 nov 2009, 18:28
Regel 9 :
mysql_query("INSERT INTO paginasysteem (titel, inhoud, categorie) VALUES (" . mysql_real_escape_string($_POST[titel]) . ", " . mysql_real_escape_string($_POST[inhoud]) . ", " . mysql_real_escape_string($_POST[categorie]) . ", NOW())") or trigger_error(mysql_error());

Je probeerd met 3 dingen 4 waardes toe te voegen, dat kan niet