Webwereld

xxx aantal tekens

Gestart doorLars7 reacties44 weergaven
Log in om mee te praten

8 berichten · pagina 1 van 1

Lars

Lid · Topicstarter

Berichten
3.416
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Hallo,

Ik heb hier een nieuws script en ik wil dat die de nieuwsberichten op de homepage limiteerd tot een xxx aantal tekens en de rest komt met lees meer.
Hier is het script: 

[COLOR= #0000BB]<?php[/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]leesmeer[/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]
    [COLOR= #0000BB]$sQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM member_recensie 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]
    [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]
    
    [COLOR= #0000BB]$nameQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT uId, uName, uCol FROM member_accounts WHERE uId = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nAuthor[/COLOR][COLOR= #007700]]);[/COLOR]
    [COLOR= #0000BB]$nameFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$nameQuery[/COLOR][COLOR= #007700]);[/COLOR]
    
    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nVisible[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700])
    {[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div class="nieuwsdiv">[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div class="nieuws_heading"><strong>[/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]</strong><br />[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<i>Door <a href="index.php?p=profiel&amp;id=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$nameFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]"><span style="color:[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$nameFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uCol[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000];font-weight: bold;">[/COLOR] [COLOR= #007700].[/COLOR] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$nameFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uName[/COLOR][COLOR= #007700]],[/COLOR] ENT_QUOTES[COLOR= #007700]) .[/COLOR] [COLOR= #DD0000]</span></a>, [/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nDate[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]</i>[/COLOR] [COLOR= #007700]. ([/COLOR]is_auth[COLOR= #007700]([/COLOR][COLOR= #0000BB]3[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]) ?[/COLOR] [COLOR= #DD0000]<div style="float:right"><a href="index.php?p=admin_recensie&amp;act=edit&amp;id=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nId[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]">Edit</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_recensie&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_recensie&amp;act=reopen&amp;id=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$nFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nId[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]">Zet terug</a></div>[/COLOR][COLOR= #007700]) :[/COLOR] [COLOR= #DD0000][/COLOR][COLOR= #007700]) .[/COLOR] [COLOR= #DD0000]</div>[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] ParseUbb[COLOR= #007700]([/COLOR]htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nText[/COLOR][COLOR= #007700]],[/COLOR] ENT_QUOTES[COLOR= #007700]),[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]);[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]</div><br />[/COLOR][COLOR= #007700];[/COLOR]
        
        [COLOR= #0000BB]$cQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT cId, cVisible, cAuth, cText, cDate FROM member_recensie_comment WHERE cNewsId ="[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] . ([/COLOR]is_auth[COLOR= #007700]([/COLOR][COLOR= #0000BB]3[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]) ==[/COLOR] TRUE [COLOR= #007700]?[/COLOR] [COLOR= #DD0000][/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000] AND cVisible = 1[/COLOR][COLOR= #007700]) .[/COLOR] [COLOR= #DD0000]" ORDER BY cId ASC"[/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]$cQuery[/COLOR][COLOR= #007700]))
        {[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<br /><h1>Comments</h1>[/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$cFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$cQuery[/COLOR][COLOR= #007700]))
            {[/COLOR]
                [COLOR= #0000BB]$nameQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT uId, uName, uCol FROM member_accounts WHERE uId = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$cFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cAuth[/COLOR][COLOR= #007700]]);[/COLOR]
                [COLOR= #0000BB]$nameFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$nameQuery[/COLOR][COLOR= #007700]);[/COLOR]
                
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div class="comment">[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div class="comment_heading"><i>Door <a href="index.php?p=profiel&amp;id=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$nameFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]"><span style="color:[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$nameFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uCol[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000];font-weight: bold;">[/COLOR] [COLOR= #007700].[/COLOR] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$nameFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uName[/COLOR][COLOR= #007700]],[/COLOR] ENT_QUOTES[COLOR= #007700]) .[/COLOR] [COLOR= #DD0000]</span></a>, [/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$cFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cDate[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]</i>[/COLOR] [COLOR= #007700]. ([/COLOR]is_auth[COLOR= #007700]([/COLOR][COLOR= #0000BB]3[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]) ?[/COLOR] [COLOR= #DD0000]<div style="float:right"><a href="index.php?p=recensie_edit_comment&amp;act=edit&amp;id=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$cFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cId[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]&amp;nId=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]">Edit</a>[/COLOR] [COLOR= #007700]. ([/COLOR][COLOR= #0000BB]$cFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cVisible[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]1[/COLOR] [COLOR= #007700]?[/COLOR] [COLOR= #DD0000] <a href="index.php?p=recensie_edit_comment&amp;act=delete&amp;id=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$cFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cId[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]&amp;nId=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]">Verwijder</a></div>[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000] <a href="index.php?p=recensie_edit_comment&amp;act=reopen&amp;id=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$cFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cId[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]&amp;nId=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]">Zet terug</a></div>[/COLOR][COLOR= #007700]) :[/COLOR] [COLOR= #DD0000][/COLOR][COLOR= #007700]) .[/COLOR] [COLOR= #DD0000]</div>[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] ParseUbb[COLOR= #007700]([/COLOR]htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$cFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cText[/COLOR][COLOR= #007700]],[/COLOR] ENT_QUOTES[COLOR= #007700]),[/COLOR] [COLOR= #0000BB]2[/COLOR][COLOR= #007700]);[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]</div><br />[/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]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]) &&[/COLOR] is_auth[COLOR= #007700]([/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]))
        {[/COLOR]
        ?>
            <div id="comment_box">
                [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] ?>
                <form name="textbox" action="index.php?p=recensie_reageer" method="POST">
                    <input type="hidden" name="NewsID" 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] ?>" />
                    <textarea cols="40" rows="5" id="textbox" name="text"></textarea><br />
                    <input type="submit" name="submit" value="Verzend comment" />
                </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]<div class="rederror">U moet ingelogd zijn om te reageren. <a href="index.php?p=login">Log hier in</a> of <a href="index.php?p=registreer">maak een account aan.</a></div>[/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]<div class="rederror">Deze recensie is verwijderd</div>[/COLOR][COLOR= #007700];    
    }       
}[/COLOR]
[URL="http://www.php.net/else"]else[/URL]
[COLOR= #007700]{[/COLOR]
    [COLOR= #0000BB]$per_pagina[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]5[/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 member_recensie WHERE nVisible = 1"[/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 * FROM member_recensie "[/COLOR] [COLOR= #007700]. ([/COLOR]is_auth[COLOR= #007700]([/COLOR][COLOR= #0000BB]3[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]) ==[/COLOR] TRUE [COLOR= #007700]?[/COLOR] [COLOR= #DD0000][/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000]WHERE nVisible = 1[/COLOR][COLOR= #007700]) .[/COLOR] [COLOR= #DD0000]" ORDER BY nDate 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/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]
        [COLOR= #0000BB]$nameQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT uName, uCol FROM member_accounts WHERE uId = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nAuthor[/COLOR][COLOR= #007700]]);[/COLOR]
        [COLOR= #0000BB]$nameFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$nameQuery[/COLOR][COLOR= #007700]);[/COLOR]
        
        [COLOR= #0000BB]$countQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT count(cId) AS commentCount FROM member_recensie_comment WHERE cNewsId = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nId[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]" AND cVisible = 1"[/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]
        [COLOR= #0000BB]$countFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$countQuery[/COLOR][COLOR= #007700]);[/COLOR]
         
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div class="nieuwsdiv">[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<div class="nieuws_heading"><strong>[/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]</strong><br />[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<i>Door <a href="index.php?p=profiel&amp;id=[/COLOR] [COLOR= #007700].[/COLOR] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nAuthor[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]"><span style="color:[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$nameFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uCol[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]; font-weight: bold;">[/COLOR] [COLOR= #007700].[/COLOR] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$nameFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uName[/COLOR][COLOR= #007700]],[/COLOR] ENT_QUOTES[COLOR= #007700]) .[/COLOR] [COLOR= #DD0000]</span></a>, [/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nDate[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]</i>[/COLOR] [COLOR= #007700]. ([/COLOR]is_auth[COLOR= #007700]([/COLOR][COLOR= #0000BB]3[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]) ?[/COLOR] [COLOR= #DD0000]<div style="float:right"><a href="index.php?p=admin_recensie&amp;act=edit&amp;id=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nId[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]">Edit</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_recensie&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_recensie&amp;act=reopen&amp;id=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$nFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nId[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]">Zet terug</a></div>[/COLOR][COLOR= #007700]) :[/COLOR] [COLOR= #DD0000][/COLOR][COLOR= #007700]) .[/COLOR] [COLOR= #DD0000]</div>[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] ParseUbb[COLOR= #007700]([/COLOR]htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nText[/COLOR][COLOR= #007700]],[/COLOR] ENT_QUOTES[COLOR= #007700]),[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]) .[/COLOR] [COLOR= #DD0000]<br /><br /><a href="index.php?p=recensie&amp;act=leesmeer&amp;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] [COLOR= #0000BB]$countFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]commentCount[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]) comments[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR]is_auth[COLOR= #007700]([/COLOR][COLOR= #0000BB]3[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]))
        {[/COLOR]
            [COLOR= #0000BB]$hiddencountQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT count(cId) AS hiddencommentCount FROM member_recensie_comment WHERE cNewsId = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nId[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]" AND cVisible = 0"[/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]
            [COLOR= #0000BB]$hiddencountFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$hiddencountQuery[/COLOR][COLOR= #007700]);[/COLOR]
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$hiddencountFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]hiddencommentCount[/COLOR][COLOR= #007700]] >[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700])
            {[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000] (+[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$hiddencountFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]hiddencommentCount[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000] verborgen)[/COLOR][COLOR= #007700];
            }
        }[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]</a>[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]</div><br /><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=recensie&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]    
?>


Ik hoop dat iemand me kan helpen
0
Shahiem

Lid

Berichten
20.364
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Met substr
0
Lars

Lid · Topicstarter

Berichten
3.416
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Shahiem schreef:
Met substr
Als je uitgelegd hoe dat werkt zou het wat makkelijker zijn..
Of als iemand het zou willen toepassen graag..
0
Andydewit

Lid

Berichten
1.168
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/substr"]substr[/URL][COLOR= #007700]([[/COLOR]text[COLOR= #007700]],[[/COLOR]bij hoeveelste letter hij begint[COLOR= #007700]],[[/COLOR]bij hoeveelste hij eindigt[COLOR= #007700]]);[/COLOR]
?>


voorbeeld:

[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/substr"]substr[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"hier de text, een variabele kan ook."[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]10[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #FF8000]// Dit zal outputten: hier de te[/COLOR]
?>
0
Boude

Lid

Berichten
2.837
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Ik heb nu substr($topic[subject], 8) Maar hij zegt te. Als ik nu 0,8 doe laat hij alles zien..
0
One2xs

Bot

Berichten
93.699
Reputatie
0
Punten
1,27
Lid sinds
Laatst gezien
echo .(strlen($topic[subject]) > 8 ? substr($sFetch[nText], 0, 8).
... : htmlentities($topic[subject], ENT_QUOTES)).;

Zoeits?
0
Boude

Lid

Berichten
2.837
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Thx nielsie het was 0, 8 erachter bloos..
0
Shahiem

Lid

Berichten
20.364
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Die 8 houdt in hoeveel tekst je wilt.
0

Jouw reactie

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

Editor laden…

Praat mee met de One2xs-community.

Inloggen om te reageren