I have a table USER (ID, Name), and now i want to show Name on PHP page, but field Name have format RTF (Rich Text Format) so view not correct. For example: {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fswiss\fprq2\fcharset163 Verdana Ref;}{\f1\fswiss\fprq2\fcharset163 Verdana Ref;}{\f2\fnil\fcharset128 MS Mincho;}{\f3\fnil\fcharset129 MS Mincho;}{\f4\fnil\fcharset134 MS Song;}{\f5\fnil\fcharset136 MS Song;}{\f6\fswiss\fprq2\fcharset161 Verdana Ref;}{\f7\fswiss\fprq2\fcharset162 Verdana Ref;}{\f8\fswiss\fprq2\fcharset177 Verdana Ref;}{\f9\fswiss\fprq2\fcharset178 Verdana Ref;}{\f10\fswiss\fprq2\fcharset186 Verdana Ref;}{\f11\fswiss\fprq2\fcharset204 Verdana Ref;}{\f12\fswiss\fprq2\fcharset222 Verdana Ref;}{\f13\fswiss\fprq2\fcharset238 Verdana Ref;}{\f14\fswiss\fprq2\fcharset130 Verdana Ref;}} {\colortbl ;\red0\green0\blue0;}\viewkind4\uc1\pard\lang1066\f0\cf1\fs18 \par
xem \ul tec\ulnone \par
}.
How i can do?
Help me!
Thanks!

You are going to have to find yourself a PHP rtf parser class that can parse out the control codes and render the text as HTML. There are a few on the net that you can try but keep in mind that the RTF specification is being updated all the time with new control codes. So if the parser class does not ignore codes it doesn't understand it may crash. Good parsers will ignore control codes it doesn't understand and it will keep a look out for \bin or binary control codes when counting curly braces during parsing.

If it was me I wouldn't have had this field in RTF format to begin with. Databases should try and keep styling information out of its content. Styling should be controlled by stylesheets or a program rendering the data itself.

The following link does have a parser as part of the "accepted solution". Keep in mind though that this page will put limits on how often you can view the answer, so once you see it, copy and paste it to notepad and save it immediately. You will need to scroll down to the second half of the page to accepted solution.

Enjoy!

Expert Exchange RTF Parser class as accepted solution