Issues with adding form data to a database.....
Moderator: General Moderators
Issues with adding form data to a database.....
I have a problem when I try to paste a large amount of text from the web. It doesnt add the text to the database and I think it has something to do with the formatting in the text. When I paste the text in Word and auto format it so its Word standard and then paste it in, it works fine. But strictly pasting it does not work. Is this a known issue or is there a way to fix this? Thanks......
- sam
- Forum Contributor
- Posts: 217
- Joined: Thu Apr 18, 2002 11:11 pm
- Location: Northern California
- Contact:
Before doing the insert query make sure you run the text through the:
function...
Cheers Moe
Code: Select all
addslashes();Cheers Moe
Where are you pasting the data? Are you using phpMyAdmin, or some other method? If you are pasting into a <textarea> on a web page, all formatting will be lost, but if you are using some sort of graphical front-end it is possible that the text retains its formatting, which would be your problem. If you are pasting directly into a php script then the above suggestion would be necessary.