error editing data from a PHP page to Mysql table

Asked

Viewed 11 times

0

Because when I try to edit in a table in Mysql and the amount of lenghts is high, the program does not let edit? Ex: I gave a var_dump in the edit query... These are only fields: id, title, txt1, txt2, txt3 but present this way...

C: wamp64 www Ni_x Adm app Sts processes proc_edit_home_fr.php:33:string 'UPDATE sts_home_fr SET title='Title data', txt1='Et si vous... pouviez y Voir plus ? Voir l' Invisible? Si vous étiez capable d'avoir Accès à des informations cachées ? Si vous pouviez Apprendre plus avec Cette information supplémentaire? C'est ce que fait Xpectraltek. Nous fournissons des Solutions d'imagerie qui permettent de Voir au-delà de l'œil humain et d'en tirer des conclusions. ', txt2='Empr', '... (length=631)

Does not display input data for txt3 field...

however, if I edit with little data for each field, it edits quietly.

In the table is: id: (int) primary key title (varchar) 100 txt1 (text) txt2(text) txt3 (text)

When I release var_dump, it continues the processing, but it doesn’t update the table or the visualization resulting from the editing...?

  • Mounting SQL as text before running is causing a syntax error, as its values have simple un-escaped quotes. If you simply escape the quotes, the code will run, but will be vulnerable to SQL injection. Use one of the methods indicated in the top yellow box link.

  • Hello Favaretto. Thanks for your help, but what VC meant by escapades?

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.