Adding BBCode to script.

strago · February 28, 2015

Is it possible to add this code

function showBBcodes($db_pagetext) {

 

// BBcode array

$find = array(

'~\[b\](.*?)\[/b\]~s',

'~\[i\](.*?)\[/i\]~s',

'~\[u\](.*?)\[/u\]~s',

'~\[quote\](.*?)\[/quote\]~s',

'~\[size=(.*?)\](.*?)\[/size\]~s',

'~\[color=(.*?)\](.*?)\[/color\]~s',

'~\[url\]((?:ftp|https?)://.*?)\[/url\]~s',

'~\[img\](https?://.*?\.(?:jpg|jpeg|gif|png|bmp))\[/img\]~s'

);

 

// HTML tags to replace BBcode

$replace = array(

'<b>$1</b>',

'<i>$1</i>',

'<span style="text-decoration:underline;">$1</span>',

'<pre>$1</'.'pre>',

'<span style="font-size:$1px;">$2</span>',

'<span style="color:$1;">$2</span>',

'<a href="$1">$1</a>',

'<img src="$1" alt="" />'

);

 

// Replacing the BBcodes with corresponding HTML tags

return preg_replace($find,$replace,$db_pagetext);

}

in the code below?

<?php



$records_per_page = 500;

$query = $_GET['thread'];



$q2 = str_replace('-', ' ', $query);





mysql_connect("localhost", "root", "password") or die(mysql_error());

mysql_select_db("DATABASE") or die(mysql_error());



//Get the page string

$page = isset($_GET['thread']) ? mysql_real_escape_string(trim($_GET['thread'])) : '';



if(!empty($page))

{

        //Create the BASE query

        $FROM = "FROM post WHERE `threadid` = '$query'";



        //Create and execute query to get total count of records

        $query = "SELECT COUNT(*) {$FROM}";

        $result = mysql_query($query) or die(mysql_error());

        $total_records = mysql_result($result, 0);

        $total_pages = ceil($total_records / $records_per_page);

        

        //Get selected page (or set to page 1)

        $page = isset($_GET['page']) ? intval($_GET['page']) : 1;

        //Ensure page is between 1 and total pages

        $page = max(min($total_pages, $page), 1);

        //Calc limit start value

        $limit = ($page - 1) * $records_per_page;

        

        //Create and execute query to get current page's records

        $query = "SELECT threadid, title, postid, username, dateline, pagetext {$FROM} ORDER by `postid` ASC LIMIT {$limit}, {$records_per_page}";

        $result = mysql_query($query) or die(mysql_error());

        $grab = mysql_fetch_array($result);





        

echo "<html><head><title>Title - $grab[title]</title>

<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"/>

</head><body>

<H1>$grab[title]</H1>";







        //Determine if there were results

        if(!mysql_num_rows($result))

        {

                echo "No results";

        }

        else

        {

                //Create results output

                mysql_data_seek($result, 0);

                while ($row = mysql_fetch_assoc($result))

                {

                $db_pagetext = $row["pagetext"];



//http://www.digitcodes.com/create-simple-php-bbcode-parser-function/



$db_pagetext = str_ireplace('[i]', '<i>', $db_pagetext);

$db_pagetext = str_ireplace('[/i]', '</i>', $db_pagetext);



$db_pagetext = str_ireplace('[b]', '<b>', $db_pagetext);

$db_pagetext = str_ireplace('[/b]', '</b>', $db_pagetext);



$db_pagetext = str_ireplace('[u]', '<u>', $db_pagetext);

$db_pagetext = str_ireplace('[/u]', '</u>', $db_pagetext);



                         $results[]="<HR>Posted by {$row['username']}<P>$db_pagetext";

                }

                echo implode("<br>\n", $results);

                

        }

}

echo `Footer text goes here.`

?>

Ch0cu3r · February 28, 2015

Paste that function into your code or save it to another php file and include it, preferably before this line if(!empty($page))

Then replace these liines

db_pagetext = str_ireplace('[i]', '<i>', $db_pagetext);

$db_pagetext = str_ireplace('[/i]', '</i>', $db_pagetext);



$db_pagetext = str_ireplace('[b]', '<b>', $db_pagetext);

$db_pagetext = str_ireplace('[/b]', '</b>', $db_pagetext);



$db_pagetext = str_ireplace('[u]', '<u>', $db_pagetext);

$db_pagetext = str_ireplace('[/u]', '</u>', $db_pagetext);

With the call to the showBBcodes function

$db_pagetext  = showBBcodes($db_pagetext);

Sign In

Adding BBCode to script.

Recommended Posts

strago

Link to comment

Share on other sites

Ch0cu3r

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information