Edited text to database

Question

I have a question about sending big documents to the database. When i insert my edited word doc with colors on some words into tinyMCE the text display properly. But sending to the database fails because of commas in the text i guess. Is there a simple way to fix this?

I'd be willing to bet it's because you don't escape your inputs properly, or use prepared statements. But with no code, who knows. — Jonnix, Sep 10 '16 at 19:53

score 1 · Accepted Answer · answered Sep 10 '16 at 19:59

1

 $yourtext = $conn->real_escape_string($yourtext); //$conn is the mysql connection

if this succeed then it was a escaping problem

answered Sep 10 '16 at 19:59

Accountant م

6,975
3
41
61

that was simple and stupid of me i didn't try that! Thank you very much!! :) – Marvinoo_ Sep 10 '16 at 20:19
@Marvinoo_ you are welcome :) – Accountant م Sep 10 '16 at 20:31

score 0 · Answer 2 · answered Sep 10 '16 at 20:20

0

You can use real_escape_string function,and also you can use a trick so that firstly save all contents of tinyMCE into a temporary file then you can read or insert the file into your database.

answered Sep 10 '16 at 20:20

Ashouri

906
4
19

Edited text to database

2 Answers2