select one column value in mysql

Question

I am facing problem to select data from database in mysql.

my table name is:
record enter image description here

my query is:

$query = mysql_query(Select `salt` from record where `id` = '1012');
$row = mysql_fetch_array($query);
echo $row['salt'];

my output

sJ@>L0CeKotpH;kokFo1Z9BwE/ey8(i?nbpQ3ICY;]PRaD7TJE)I3@RYWZTSV]YkO2cduj6eeE0IFGuYE

So please suggest me how to get salt column value from the table.

That looks like quite a reasonable value for a 'salt' column to me. Do you know what the 'salt' usually is? — Ben Hillier, Jun 22 '16 at 07:27
Look at the source of your page. The whole salt will be there. It's the `<` that makes the rest disappear in your browser. — KIKO Software, Jun 22 '16 at 07:28
Why cakephp is there as a tag? it's surely not related to cakephp — Alive to die - Anant, Jun 22 '16 at 07:36

Blank · Accepted Answer · 2016-06-22T08:18:13.293

0

The problem should be caused by echo $row['salt'];

Your column salt has a < in its value, so when echo it, the string after < will be discarded, you can try to run this:

<?php
echo 'sJ@>L0CeKotpH;kokFo1Z9BwE/ey8(i?nbpQ3ICY;]PRaD7TJE)I3@RYWZTSV]YkO2cduj6eeE0IFGuYE<R1GZ+OM2`Oto<W\`U:'
?>

Then you will find the result is

sJ@>L0CeKotpH;kokFo1Z9BwE/ey8(i?nbpQ3ICY;]PRaD7TJE)I3@RYWZTSV]YkO2cduj6eeE0IFGuYE

Edited:

echo htmlspecialchars('sJ@>L0CeKotpH;kokFo1Z9BwE/ey8(i?nbpQ3ICY;]PRaD7TJE)I3@RYWZTSV]YkO2cduj6eeE0IFGuYE<R1GZ+OM2`Oto<W\`U:')

edited Jun 22 '16 at 08:18

answered Jun 22 '16 at 07:49

Blank

But i need value is: sJ@>L0CeKotpH;kokFo1Z9BwE/ey8(i?nbpQ3ICY;]PRaD7TJE)I3@RYWZTSV]YkO2cduj6eeE0IFGuYE – Vishnu Pratap Jun 22 '16 at 08:14
@VishnuPratap Use `htmlspecialchars`. – Blank Jun 22 '16 at 08:18
This function work for me.Thanks a lot for the solution.I also did some R&D for this case and found same case in below link. http://stackoverflow.com/questions/15977525/angle-bracket-mysql-php?answertab=votes#tab-top – Vishnu Pratap Jun 22 '16 at 08:48
@VishnuPratap That's great. :D – Blank Jun 22 '16 at 08:52

score 0 · Answer 2 · answered Jun 22 '16 at 08:11

0

Replace with bellow line then it will display as you want. But in other operations it will be same as it is.

echo str_replace("<","&lt;",$row['salt']);

answered Jun 22 '16 at 08:11

score 0 · Answer 3 · answered Jun 22 '16 at 08:16

0

echo htmlentities($row['salt']);

That should do it.

answered Jun 22 '16 at 08:16

Garena Shells

3 Answers3