Client editing and inserting news articles into DB

coppercoins

I'm having a little trouble developing a form that will allow a client to place articles they write into a news website.

I have a textarea on a form that will allow them to paste their text, and I have created a table cell (next to the textarea) that shows them the HTML tags to manually enter so they can format paragraphs, etc. but I wanted a better way of handling it. I attempted in failure to use javascript to create buttons that would insert the tags for them, something like a dummied down version of the vB Code used on this site. Any suggestions?
When I place a test article into the textarea and submit it by assigning it to a PHP variable and passing it to the next page (for proofreading) it shows the entire article, but when I insert it into the DB (blob field) it truncates it. Why?

I have tentatively solved the problem by creating a number of textareas each with different variable assignments, passing each of them to the next page for proofreading, then inserting each of them into separate fields in the DB (MySQL) but this method is sloppy and more difficult on the client (not to mention more difficult to explain).

If I simply had a very basic "click button" editor that places tags and special characters where necessary, then had a method for placing a 1,000 word article with HTML formatting into a single BLOB field so it can be successfully selected and displayed on a browser, I would be one happy camper. Suggestions? Help?

Thank you in advance.

coppercoins

Nobody has input for me? I could really use the help.

vornn

I don't know if this is any use, but the code on the submit page, here at PHP Builder, is nice. This is the kind of thing you want to do, right.

If you have a look at the code, you should be able to cut out all of the tools and paste them into your code. It will take some tweeking, but you should end up with something like what you want.

One thing I would do is have a search on the old net for some Javascript button tute's which will allow you to do whay you want.

http://www.javascriptsearch.com/ sounds like the place to start.

I have a similar project, where the kids at the school in which I work, want to upload the reviews that they do, onto their website. I created a table, reviews, and added the following fields, ID, Title, Review, Submitter, Date, Approved, ApprovedDate.

The review is stored in a text field. everything else is either tinetext or date.

I'm looking a a script that will allow them to enter the review on one form, and click one button to submit. The article will then be displayed for them and, once checked, another click uploads into the database.

The review then needs approving before it is live.

Hope this helps.

🙂