Hi, i'm not sure where to post this, really, but here goes..

I have a site where i want admin users to edit content, usually through texarea and input tags, like text descriptions, prices, etc. For the textarea, i've been fiddling with TinyMCE, but it's not exactly fulfilling my expectations.

My main concerns are to strip odd stuff from the user text, filter sql injection (although these specific users won't screw around), keep the strings unicode and keep the html format (b and i tags, although i use span with styles). All to eb stored in a MySQL database (already set to utf8_bin). I've searched some php functions (like mysql_real_escape_string) but haven't found the correct combination yet.

TinyMCE - or something similar - seemed to be ideal, but... it uses javascript, which i'd like to avoid (but don't think will be able to); only works on IE and Firefox (i also tried Midori and Opera).

I don't want to use a CMS.

Any suggestions?

Oh, look, i've just typed this in a similar thingy!

I'd suggest widgEditor - back when it was available as a plugin for my favourite CMS (CMS Made Simple), I made it the default for all editors, and they were as satisfied as I was (I don't normally use WYSIWYG, though - I like my HTML to stay as lean and correct as possible). widgEditor does a pretty neat job overall, I think. And it's Free Software - get it here.

Sadly, I'm no coder to revive the plugin (it's no longer compatible with recent versions of the CMS). I've tried, but I seem to miss important steps. Sicut transit gloria mundi...

M.

Maybe you're looking for a solution as used in this thread

this is one reason i don't use a "wysiwyg" . i use gedit or emacs

thank you both for the input.

John VV, the other two posters got what i wanted. Are you gonna suggest gedit or emacs as a webapp to your website users? I wasn't asking for an IDE, but rather a "fancy" way for website users to submit preformatted text i can send/get to/from a database.

Btw, what's the best approach when handling CRLF? (I've been trying Wim's solution since <b> and <i> (and <br>) are enough for me.)

edit: Hmm... well i could use [ br ], or nl2br or keep on searching...

nl2br is, in my opinion, the most intuitive for your users; if they put a newline in the textarea, they will get a newline. Using [ br ] requires extra handling that not everybody will understand.