phpMyAdmin supports RTF editing?

I have a MySQL database.  I want to store rich text in some blob fields and need a way to manage this (get the rich text in there / modify it).  An Expert said that phpMyAdmin supports RTF editing.  I've installed it but cannot find this capability.

How can I use phpMyAdmin to edit blob fields that contain Rich Text?
SAbboushiAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Steve BinkCommented:
Not to my knowledge, but that doesn't mean someone could not add it.  Or you can code your own mini-gateway specifically for that purpose.  There are plenty of RTF editor controls.
0
SAbboushiAuthor Commented:
>> Or you can code your own mini-gateway specifically for that purpose.
How would I begin?

>> There are plenty of RTF editor controls.
I am working with TinyMCE - is this what you mean by RTF editor controls?
0
Steve BinkCommented:
Well, TinyMCE is advertised as a rich text editor, it is really meant for HTML.  My experiences with it were good, but I only used it to edit HTML in a WYSIWYG-style environment on a web page.  Same goes for ckEditor, which I now prefer (thanks ProtectedSource!).  You will need to find a control capable of actually writing in RTF format.  I'm not familiar with any control that does right off hand, and unfortunately do not have time for proper due diligence on the topic.

To make your own gateway is relatively simple.  Start with a page that calls a file on your server, and drops it into a text area form control:

<?
$x=file_get_contents('myfile.txt');
echo "<textarea name=\"mytextarea\">",htmlentities($x,ENT_QUOTES),"</textarea>";
?>

From there, modify the page so the user can select the file, if necessary.  Allow the user to save changes (file_put_contents() and $_POST['mytextarea']).  Then replace the text area control with your RTF editor.  
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Become a Certified Penetration Testing Engineer

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

SAbboushiAuthor Commented:
K - thanks for the overview.  htmlentities to avoid script injection?
0
Steve BinkCommented:
You can always entity-ize the file contents.  It can't hurt, and will prevent someone from closing your </textarea> tag unexpectedly.  IIRC, TinyMCE and ckEditor both use precautions against that, so make sure your efforts are not being duplicated.
0
SAbboushiAuthor Commented:
k thanks-
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.