How do i use this php parser with mysql?

how do i use this parser with mysqli?
coz i wanna use it with my chat System that i have
Yes i know theres an exmpale but that does not help me at all


* A simple DisqusShortCode Parser function
* @author shoaiyb sysa
* @see

//Shortcode Parser function

function disqusParser($text) {
	// NOTE : I had to update this sample code with below line to prevent obvious attacks as pointed out by many users.
	// Always ensure that user inputs are scanned and filtered properly.
	$text  = htmlspecialchars($text, ENT_QUOTES, $charset);

	// BBcode array
	$find = array(
 /* '~\[b\](.*?)\[/b\]~s',
		'~\[img\](https?://.*?\.(?:jpg|jpeg|gif|png|bmp))\[/img\]~s' */

	// HTML tags to replace Shortcodes
	$replace = array(
 /* '<b>$1</b>',
		'<span style="text-decoration:underline;">$1</span>',
		'<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,$text);

// How to use the above function:

$shorttext = "This is [b]bold[/b] and this is [u]underlined[/u] and this is in [i]italics[/i] with a [color=red] red color[/color]";
$htmltext = disqusParser($shorttext);
echo $htmltext;


I would think you would store the raw text in the database, then call the function on the text on output to your page.

echo disqusParser($dbResult['text']);

Assuming $dbResult is an array fetched from your database, this will output parsed text to the page.

1 Like

Depends on if you ever want to have people edit the text again. If not, parsing and storing the result is faster and a bit simpler.

1 Like