Database > MySQL database

Unable to insert Long Encrypted text in MYSQL through PHP???

(1/1)

Shiza:

--- Code: ---if(!mysql_query("INSERT INTO voter(encrypt) VALUES('$encrypted')",$con))
{
     echo "not executed<br>" . mysql_error();
}

--- End code ---
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?~M?x??????~L=??\nn?E zR?S?R?]}?/sG?WG?x??G?5T6?%??M??O??? ?????V? W?!' at line 1

$encrypted is about 5000 chararcters..and the data type of encrypt is Longtext.

The Value of $encrypted is:
?kpt%?pg? z?-?0#;f@$????Kv?8?!?>?3C????Qv????f)?,??????\?????^+7??i?P???Z?W??y.??r????$??y?x????&???a ?!?[c???iH5???K?A??u??L?gz?lY-??1E+??69???K!???UCQ? ?E?g???hp/>2y??)???D????y ??u 8??e?:Jf]?w?(????>???,?????#??d???-f? hSl?2B?ri=k???q???L?A$&2<??j ?4?fx??q6{{?Y?t.???????H???c&?]Z? ?`?$iH?\E??-*^??{???Z???3??~c????] w?Y&{?5?/?v?L????K H?@#?<????%f?_-??"?nP0IM??L?} N?g??2m2?2)?<?-U?Q|s??I+-1??^6? ?C?o?n?m?t"}u?z~??|-?R?q??U$|G?Ty|K?????? T?'?~M?x??????~L=??\nn?E zR?S?R?]}?/sG?WG?x??G?5T6?%??M??O??? ?????V? W?!??????2??E?? ??
?1??.? ? ????? ??s?5??_?..........

RaythXC:
Go into PHPMyAdmin, edit the table format, and change the field encrypt type to TEXT (doesn't need a length value)

This should fix the problem. You will also want to do the query as such:


--- PHP Code: ---
if(!mysql_query("INSERT INTO voter(encrypt) VALUES('".addslashes($encrypted)."');",$con))
{
     echo "not executed<br>" . mysql_error();
}

--- End code ---


addslashes() makes it so that special characters (NULL bytes, single quotes, double quotes and backslashes) are escaped and can be entered into the database. Is you can see $encrypted has some of these and as such they themselves will return the error you mentioned. Let me know if this code works.

Laffin:
In all actuality TEXT/LONGTEXT would be the wrong datatype for binary (Yes, encrypted text usually outputs a binary block) Use BLOB for binary fields. I wouldnt use addslashes as well, use mysql_escape_string, which will format your data properly for insertion (remember to still add the quotes)

RaythXC:
He never said anything about it being binary so I have no idea where you got that. All he said was he wanted to store a long string into the database, and the string contains special characters.

mysql_real_escape_string() and addslashes() in this case will do the exact same, though the PHP manual does say that the mysql_real_escape_string is more recommended.

Navigation

[0] Message Index