Mysql not retrieving full data from database

Question

I'm storing passwords in my Mysql database , these passwords have special characters . The passwords are storing fine but while retrieving these passwords , incomplete passwords are displayed , the password is not shown after less than sign '<'

For eg : this is the password -> abcxyz abcxyz

Umm... storing passwords is usually a really bad idea... I hope you are at the very least encrypting or hashing those passwords. — Michael Aaron Safyan, Nov 11 '12 at 10:31

Zbigniew · Answer 1 · 2012-11-11T10:33:12.937

3

I assume that you're displaying in on webiste using HTML. Then < is used to start a HTML tag , this is why you can't see them, but if you'll view source code then it should be there. If string contains special characters then you should escape them, e.g. with htmlspecialchars function.

As a side note, you shouln't store password as plain text (or display them).

edited Nov 11 '12 at 10:33

answered Nov 11 '12 at 10:22

Zbigniew

27,184
6
59
66

score 0 · Answer 2 · edited Jun 20 '20 at 09:12

0

You should never store passwords as plain text! Never!

It is a security problem. Store a (salted) hash of it and you will also get rid of your problem since a hash does not contain special characters.

edited Jun 20 '20 at 09:12

Community

1
1

answered Nov 11 '12 at 10:30

juergen d

201,996
37
293
362

score 0 · Answer 3 · edited May 23 '17 at 11:43

if you store special character in your database then it's not a good idea.for security reason use

//convert password into the hash as a 32-character hexadecimal number
1) md5 — Calculate the md5 hash of a string 
2) mysql_real_escape_string — Escapes special characters in a string for use in an SQL statement.

this link will helpful if talk about database handling:-

How can I prevent SQL injection in PHP?

Mysql not retrieving full data from database

3 Answers3

You should never store passwords as plain text! Never!