• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 431
  • Last Modified:

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?
0
SAbboushi
Asked:
SAbboushi
  • 3
  • 3
1 Solution
 
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
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now