MysQL output regex ..

[rayzun]

Hi and good day!

Found this script on php.net
basically, HEX colour codes to "web safe" colours...

Would anyone offer insight on this idea....

The ouput of a query is a text blob . The text is content, paragraphs etc..
with a few words in the blob being color coded
ex.

 Some text <font color=#616161>some colored text</font> and more and more..

The idea .
grab each similair "#616161>" with regex Im guessing
always a 6 character color code

Loop Using :

function color_mkwebsafe ( $in )
{
   // put values into an easy-to-use array
   $vals['r'] = hexdec( substr($in, 0, 2) );
   $vals['g'] = hexdec( substr($in, 2, 2) );
   $vals['b'] = hexdec( substr($in, 4, 2) );

   // loop through
   foreach( $vals as $val )
   {
       // convert value
       $val = ( round($val/51) * 51 );
       // convert to HEX
       $out .= str_pad(dechex($val), 2, '0', STR_PAD_LEFT);
   }
   return $out;
}

I have not attempted any functions, because this might not be do able.
The text blog contain many "font color="

[laserlight]

Honestly, I think "web safe" colours are a thing of the past. As for the "many font color", that is generally no problem for a computer program, even though it is tedious for a human.

[rayzun]

.I ran into a block

$pattern = '/<font color="#/';
preg_match($pattern, $outputdata, $fontcolor);

<font color="#606060">o</font>

// concatenate back into string

$browserSafe[] = $fontcolor . $colrsixchar . $endbracket; 

}