how to direct fetch and display image from mssql database if data type is image

I am using odbc connectivity with php 5.4
when i fetch image which size like thumbnail it show correctly
and when i fetch large image it show half image

copy this and paste in url you will get image what i get from database

data:image/jpeg;base64,iVBORw0KGgoAAAANSUhEUgAAAqkAAAHZCAIAAAAqjjXMAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAP+lSURBVHhe7P33jx1Ztuj51V+h113e0ab33nt6MpmW6Q2TTO+99957b0gmvUl6z2K57vvejH4UNIIGwkCCNCM8QdJAGgMBrbX3ilhnnxVx8mSyWG3uK+CDjTiRJ1lsXuB+146IPPnJNyFz+7SwL98HzZk6EDxv9H3I/Leh89+Emfg6dO7jCFkw9U3ooin2Nru+C94H8U8UDP+JffgyaM5gHnwVvCAtWQStgG8Dl0x9E7Bow7Kpr/wWzcx/7b/wtf+c0Ze+M/vyufeUqS+8J/flc89RxbBiUPAa+MyzH3zq0Yc+d+/hPLoUHZ+5t4NP3do+dWsBn7u3os/cWj5za/7UtQn9B6daC+dq8qlzjVT1Z6dK8CfHij85lYM/O1dIZapPnco+cyr5wlH43KEYfHa06DOHy+DPR/IVeeRPh3MtjmST/3A4Q5GmOXLhzwdT/3wo2Voi+NPBBCne4tA58B8OGBw8K51WnLQ4cEJxTBErHIwxiFJEWBwKU4SiPx0M/fP34Z9+x4SCzw+GKULQZ4dA2J/NfHo43MSR0C8Ph315JAR8dTQUfO0QhvAlnfnGMRx87Rj+hUPU547CF07R4EvnGPSVSyz62jUOfON2TIr9yi3mK7co8LV7NPjGIwbhSzrzrWcs+sb7OPrW5wT4zvck873fKXDA/7TG76x07qB/PDgUcP5QQKKFf/LhgBRwJDAVHQ5KRkeCU8DRkFTGIfQCcAxLA0fD0xzCs49GCA6ROcAxKpdxis4DzjH5jEvsReAaV+Aad0mILURucUVucSXux0qB23FQ7HJCcD1ZAtxOle7O/VSVKY/T1cjzTA3wOluLPM82AK9zjcg7vgmxMz7nm5FXQivyTmwDPkntCF/SGd/kDuST3IV8U7qBX2qPHRf6fVP7CLz0TxsISB+0bQgFZgyDoMwRxM7gsTiZPWrL797+74J59RGrPvqj/XYZwg/+aL/FP6r9f3Kus3CpIaz9Iv9/tN/K79t+lnzCq4+OhH5xRLSflZ7aTy9Z+zH8xvZj+I3tZ6Wn9tNL1n4Mv7H9GH5j+zH8xvZj+I3tx/Ab24/hN7Yfw29sP4bf2H4M/97bj+H/7e3H8Bvbb5wA1OM/2m+LVdrtgvabgsybstV+W3ja7TLUGrHkE/Y2u1jddyf+iT6g/cEze2q/xJJPDMknvPrIUH30R/u19n/q2mDhVmeht9+Sf2ex9f97tV+v/r9G+9Fu7f/0QIRBGID9vQJ3/B/a/qOh6CtIvk59CcknXzqaV98s/Fr7jeFXUfW/84oDxupj7M3DL9t/0F/d9FvafzgwiYUf27/H8FP7f1v47bd/7+EHLPnENPzA40w9Yvkn/6LtZy/pDOu9ymb7ocE2LO4HTzs5ELpg9F2Y8G34PrBRwD5D3T8i+J/8fYg5Vn2yz/YvfBUyKwRD7AlW36T9Xwfx5NvFkk++9l8yA+E3b/9XfrP78oXPtKkvfaZMseSTf1T7/+xSb+FaSz5zEbD9Wv616u+v/Z8evajIJ+oc8OejOeRPRzKldCtH0z49dOHTwynWkgDkXzpvcTgeWE0DSM4Efzp0RnHK4uBJxXFFnHAo1iDaIFI4HK4I04V/djDSAE6Gf35YFUp43XWfHYkw9eXRcBZ+bDx7Cb5xivjKOeorJy35ptVXw/+t+3HwtXusrS0+weqD772PUfJZ7NVjdDDgjCDCL9qvh/+8SD5Rwn806AIwhp+Sz8LvFJ7uEJHuGMHDT8ln4afkW4e/wO3YZWCr/e4nePjdT5ftAvf3Rsbwe5+rA9R+W/n/V29/cNYooDOs96pPvgueMfV9yKwNvOK7k+PCrNF3YXMfBftj94CGmN8F+59P2GUPol4j2Yuvg2cV8xZBCwpRfcTSbhdLPjFUH/3R/j21/zOXakv+/2i/CUP7TSYAwRB+8NHbD6WPQF87RiL28hunKIDtN00+YuHX2x/7jUcc+tbzGPnO6zj63vsE+c7n9Pe+Z5B+L19gZ/Tka5TwJ6jtZ+Gn9u8l/Gr7f0P4L+2l/XsMP2DJJ6bhV9v/72/fDyuG3yr/huQTm+0/EDpnA9+s746lmnwfPv9RsD92D7SrCwxLOGFvs4v9zycs+YSlfQ8s12bU8/tt/3dBy6ZY8u1ZZMn/YOwWAPnKd9oUSz75R7Xf1v3+z13rsP1Ay79LJdhv+z9zKFBcJOoc8KlDLvnz0Swpw4pD+p+PpH12JNVaMsAJ4NPDCRZHzgOraQDJmeDPh88qTlscOqU4oTgmHI6zIcZalOZIBPPp4ajPDzER4IsjqjDC0k4+PxppChuP1NLTMb5EX7tEs+pT7FUU/u88TlD11fAbq3/A5ySy1Xg6o548FADbfUThF+0/EpSssQ6/Q3AaVV8NPyVfDT9wjMyg6qvhp+Sz8FPylfCL9rsf18JvbL/HSa36avg9zpTb4nm2irb4Kqq+Gn6f+HrPc6L6rPSAnfmXaz9i7Qes96q/R/u/DTfxXcS8KZZ2ciBiwZR11/fC0mkVSz5hb7OL/c8nLPlE7ffewLfM6GgImDPb/QvfBpr7LmjRlPW9f/tYwj8YSz6RpZ80+sJ73NQ/qv227vdD+2X+RfvBXtqPPnUsBn92KPqzw2XBsUBxkfzJIV+RS/6DQ5aUofqt7deq/3u0nxjybz0BfHYk2iBSUtJ+NMxCPa9gySdfOEagL50ikdjcO0exlwDCL9jY4rOXGH61/Sz8xuof9D0FbAXe1nkdhT/BEn7ZfjX82P7DocKRsAvoaLi4r09gr49E+JX2f2j4L0H499L+vYQfiPab8TpXjbzja5DP+Vpov1e8CD8LvGj8v377Mfkh2WOA8g+ND7Dh926/yC2rPmLJJyz5hCWfWHd9L6xSTVjyCXubXYZ/AQ1LPjGkfXdq+P8LaL8f7vJ5+AFLPvlHtf8zt0YL93qC7f/ctWYv7Qf/xbcfGPL/j2s/lZ61Xwu/of1UetZ+DL+x/bZ2/Bh+Y/up7rbO67T2HwlKNG2/Hn7efhZ+YBV+Q/tZ+IFp+IEefrHp33v7WemNWPIJa78Iv2y/93lRd0q7b0IL+nfZ/oCsXdt/MHRmn+ZMHQqbNzoYJssdMbt3B8JmTB2KmDPF3mYX/JU+Cut5yMLweISGfbtiEeGIYPf5AJzMvg2aRt8ETn0TOAO+DZqV5i2w8daPFhKrdyq+CdgflnC72G1+wquPlPZ/6TMBWOlNeI0pRoit9n/h0ct5doPP3DslEX5dqyCST5oV5u3/0r1BqvvCrRbAEPC5WzXACeBTl3Lmc+dSpEwAhYLTJYTtp95/6lSggJeaPzlmS5lY/f/N0XQg7vcfTf/86AVrKQAngM+OJFocTQDGaUCbCT5S+z89fNziyDFdrMnuX/r8aIwBnIyySrvS/i8coj7Ml47RQNzOt/a1cyz4xiVOozfeFtb+bz0133mdBN97n0IHfE6jg75nwCG/s+h7X80Bv3P0U/v0KJ+yuYfGC4cD4aQ4jy+PBicdDU4BDiGpQnCaY0g6cArNAI5hGbbaT7F3isoEztFZiLb7jK3240s6IycAcb/f/VixQoQf28+e9aPdv+fZClMeZyqRafKp+r4JdcL5Bmz/LthMQI23hbWfp13nf6HXXNoA9J5g+AMzoO4s+RpM/i7UOQCv7ftnjRBIfmDOWFDuOPh9238obFbkOVJG2no9GC5Kz9ZdwHeZYm+zj6f3I2OjAGFvU1i1X82/KfzTaKSQo4A6GSiBx628ekbBkk9Y2u1iabeLJZ/w6utY+yn/9JKx1f4vvIYE70EAEwANATz84B/X/s+ceftl/k3aT/nfY/sx/3+H9n9q5aSC1V1H4edfjdVFqwzhBx+//Rh+tf1q8r91PUZY6RkMv7H9GH5j+zH8xvZj+I3tN04A2H44QKz9GH5qP3AItSSfLu/TRh/Dv/f2s9JT++nlHtuP4d97+21t9/fbftru77H9GP5/2vZj/m22/1Do9P6EzJg6HDprBO0/HA6FhhXibbUegi14+AxbAXz1dzZnSowp+3EkYt4UG00IH0EQjEehi+RgyAI6EGx1XnU4fEH5C4sBSxu/9O+VlghLPmHJJyztdrG028WST1jyiWy/Rn3IXz2vstX+r3yEL32GAE4AGhZ+8I9u/5dOGnzo7wunos8dCz93vETUB/3oWHDMI586ZEuZgJ71+63tR7u2//OjZxXwUvPZkRPC0eOMVfuRbP/nDic+d4BVFQs+OxrDOURJkYpwwqJOqO7MF04x6EvnWPSVSxz4xu04+db9BPjO4yRgsSfG6n/veRJ853kKfe91Gh3wPoMO+pxFh3zPkQN+59FB/wSEP6zPXupP8sMEAOFXN/2W9juGXmDhF/Tn+IBzRAZwicwEdABco7LQ7u03hh8Ywm+//cbw795+u8/3Aag+2qX9xvDv3n5j+P852x8AydfBy6CcseDccfDJYcjtvhgCj46EzZmCbxFFN6xHZImN69HIeVNHIuZMsbfZxVJNaAj4jXjddTQEMKLlYUuUduuEG4TC/2TL31a5vsI+IXGRsI8ZIGwUIPRAwB6xUcAuNgoQNgqQr/1mAKWd8o/njb70HleMEhF+72HWftj9f+nZx3n1ALrfr2gT9Pv9UouiycKjgdhq/2euVVKF6nOXii9cyr5yLrPKv1ORdBno+bd61N9Caf9njjkA22/Jv0P6F0czvnBIs5YKcAL4/GiShUMisJoGEM4ER84pzpDPrJwinx89KYiiW9FmApXVcBCnEKXHCcCKY7SkfbauFEFY2glt6BlKPlUffO16DLD2Y/6p8Qwln6oPDnhZkm9afTX8h/3iAQYeYeax9Mbz2H5ZfbHq4U/SdvwQftl+qr5zWCZwVB7jx/ar1VfD7xad7RKT7RKtXdtnjOHH0rOXAO/3exwvUZQh9xNltp71Y8m3MISfqm/afgq8LVR9v8RWQIG3xVL9lE7BUH3Ek0/+HbcfrxYcCeGrA2ydw2dN1qgFUyz5hL3NLoo9Q/H+jVjyCcWekft4gSqu7eNtwP8KXntQ78IcCJkVDBMAu2VArO8UWODuf+9Y2u1iyScs+YSizvJP5xlb7Yfws2v+eNmfhx/8E7TfKv9K+/X8F5jn39D+zxyzrPL/T9p+eptxAlDbL/Dwg4/dfpZ8pL60HgKskk9Y8omt5CMWfmy/mnyC1aev6ue19ivhT1bbz8IPjD/Ej0OAMfx7ab+x9Ibwa8/67d5+Fn677bcVfrCv9rPw220/D/+/Vvsht/tjqDs6Gj5vLnTGlGP4nDlDrRHbvhP2NruORppjo4BdWF8j9mghORw5b+pIBF7Gt8o/0FpugP8VevziQMg0nv8+eEaw+qUJC4AeI2DYKEDYZQC72GUAu9goQNgoQA==
mohan singhAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ryan ChongCommented:
〉〉and when i fetch large image it show half image 

could be a server / page timeout issue? try to increase it and test again.
0
mohan singhAuthor Commented:
I have already increase time
but it is not working
0
Ryan ChongCommented:
can you try to trace the error message? is there any findings?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

mohan singhWeb developerCommented:
sir there no error message
can you tell me
it is possible to fetch large image from mssql database  which data type is image
and echo is as it is in localhost
if it is possible then tell me how to do
0
Ryan ChongCommented:
i got this as the output.

SnapShot.png
with:

<image src="data:image/jpeg;base64,iVBORw0KGgoAAAANSUhEUgAAAqkAAAHZCAIAAAAqjjXMAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAP+lSURBVHhe7P33jx1Ztuj51V+h113e0ab33nt6MpmW6Q2TTO+99957b0gmvUl6z2K57vvejH4UNIIGwkCCNCM8QdJAGgMBrbX3ilhnnxVx8mSyWG3uK+CDjTiRJ1lsXuB+146IPPnJNyFz+7SwL98HzZk6EDxv9H3I/Leh89+Emfg6dO7jCFkw9U3ooin2Nru+C94H8U8UDP+JffgyaM5gHnwVvCAtWQStgG8Dl0x9E7Bow7Kpr/wWzcx/7b/wtf+c0Ze+M/vyufeUqS+8J/flc89RxbBiUPAa+MyzH3zq0Yc+d+/hPLoUHZ+5t4NP3do+dWsBn7u3os/cWj5za/7UtQn9B6daC+dq8qlzjVT1Z6dK8CfHij85lYM/O1dIZapPnco+cyr5wlH43KEYfHa06DOHy+DPR/IVeeRPh3MtjmST/3A4Q5GmOXLhzwdT/3wo2Voi+NPBBCne4tA58B8OGBw8K51WnLQ4cEJxTBErHIwxiFJEWBwKU4SiPx0M/fP34Z9+x4SCzw+GKULQZ4dA2J/NfHo43MSR0C8Ph315JAR8dTQUfO0QhvAlnfnGMRx87Rj+hUPU547CF07R4EvnGPSVSyz62jUOfON2TIr9yi3mK7co8LV7NPjGIwbhSzrzrWcs+sb7OPrW5wT4zvck873fKXDA/7TG76x07qB/PDgUcP5QQKKFf/LhgBRwJDAVHQ5KRkeCU8DRkFTGIfQCcAxLA0fD0xzCs49GCA6ROcAxKpdxis4DzjH5jEvsReAaV+Aad0mILURucUVucSXux0qB23FQ7HJCcD1ZAtxOle7O/VSVKY/T1cjzTA3wOluLPM82AK9zjcg7vgmxMz7nm5FXQivyTmwDPkntCF/SGd/kDuST3IV8U7qBX2qPHRf6fVP7CLz0TxsISB+0bQgFZgyDoMwRxM7gsTiZPWrL797+74J59RGrPvqj/XYZwg/+aL/FP6r9f3Kus3CpIaz9Iv9/tN/K79t+lnzCq4+OhH5xRLSflZ7aTy9Z+zH8xvZj+I3tZ6Wn9tNL1n4Mv7H9GH5j+zH8xvZj+I3tx/Ab24/hN7Yfw29sP4bf2H4M/97bj+H/7e3H8Bvbb5wA1OM/2m+LVdrtgvabgsybstV+W3ja7TLUGrHkE/Y2u1jddyf+iT6g/cEze2q/xJJPDMknvPrIUH30R/u19n/q2mDhVmeht9+Sf2ex9f97tV+v/r9G+9Fu7f/0QIRBGID9vQJ3/B/a/qOh6CtIvk59CcknXzqaV98s/Fr7jeFXUfW/84oDxupj7M3DL9t/0F/d9FvafzgwiYUf27/H8FP7f1v47bd/7+EHLPnENPzA40w9Yvkn/6LtZy/pDOu9ymb7ocE2LO4HTzs5ELpg9F2Y8G34PrBRwD5D3T8i+J/8fYg5Vn2yz/YvfBUyKwRD7AlW36T9Xwfx5NvFkk++9l8yA+E3b/9XfrP78oXPtKkvfaZMseSTf1T7/+xSb+FaSz5zEbD9Wv616u+v/Z8evajIJ+oc8OejOeRPRzKldCtH0z49dOHTwynWkgDkXzpvcTgeWE0DSM4Efzp0RnHK4uBJxXFFnHAo1iDaIFI4HK4I04V/djDSAE6Gf35YFUp43XWfHYkw9eXRcBZ+bDx7Cb5xivjKOeorJy35ptVXw/+t+3HwtXusrS0+weqD772PUfJZ7NVjdDDgjCDCL9qvh/+8SD5Rwn806AIwhp+Sz8LvFJ7uEJHuGMHDT8ln4afkW4e/wO3YZWCr/e4nePjdT5ftAvf3Rsbwe5+rA9R+W/n/V29/cNYooDOs96pPvgueMfV9yKwNvOK7k+PCrNF3YXMfBftj94CGmN8F+59P2GUPol4j2Yuvg2cV8xZBCwpRfcTSbhdLPjFUH/3R/j21/zOXakv+/2i/CUP7TSYAwRB+8NHbD6WPQF87RiL28hunKIDtN00+YuHX2x/7jUcc+tbzGPnO6zj63vsE+c7n9Pe+Z5B+L19gZ/Tka5TwJ6jtZ+Gn9u8l/Gr7f0P4L+2l/XsMP2DJJ6bhV9v/72/fDyuG3yr/huQTm+0/EDpnA9+s746lmnwfPv9RsD92D7SrCwxLOGFvs4v9zycs+YSlfQ8s12bU8/tt/3dBy6ZY8u1ZZMn/YOwWAPnKd9oUSz75R7Xf1v3+z13rsP1Ay79LJdhv+z9zKFBcJOoc8KlDLvnz0Swpw4pD+p+PpH12JNVaMsAJ4NPDCRZHzgOraQDJmeDPh88qTlscOqU4oTgmHI6zIcZalOZIBPPp4ajPDzER4IsjqjDC0k4+PxppChuP1NLTMb5EX7tEs+pT7FUU/u88TlD11fAbq3/A5ySy1Xg6o548FADbfUThF+0/EpSssQ6/Q3AaVV8NPyVfDT9wjMyg6qvhp+Sz8FPylfCL9rsf18JvbL/HSa36avg9zpTb4nm2irb4Kqq+Gn6f+HrPc6L6rPSAnfmXaz9i7Qes96q/R/u/DTfxXcS8KZZ2ciBiwZR11/fC0mkVSz5hb7OL/c8nLPlE7ffewLfM6GgImDPb/QvfBpr7LmjRlPW9f/tYwj8YSz6RpZ80+sJ73NQ/qv227vdD+2X+RfvBXtqPPnUsBn92KPqzw2XBsUBxkfzJIV+RS/6DQ5aUofqt7deq/3u0nxjybz0BfHYk2iBSUtJ+NMxCPa9gySdfOEagL50ikdjcO0exlwDCL9jY4rOXGH61/Sz8xuof9D0FbAXe1nkdhT/BEn7ZfjX82P7DocKRsAvoaLi4r09gr49E+JX2f2j4L0H499L+vYQfiPab8TpXjbzja5DP+Vpov1e8CD8LvGj8v377Mfkh2WOA8g+ND7Dh926/yC2rPmLJJyz5hCWfWHd9L6xSTVjyCXubXYZ/AQ1LPjGkfXdq+P8LaL8f7vJ5+AFLPvlHtf8zt0YL93qC7f/ctWYv7Qf/xbcfGPL/j2s/lZ61Xwu/of1UetZ+DL+x/bZ2/Bh+Y/up7rbO67T2HwlKNG2/Hn7efhZ+YBV+Q/tZ+IFp+IEefrHp33v7WemNWPIJa78Iv2y/93lRd0q7b0IL+nfZ/oCsXdt/MHRmn+ZMHQqbNzoYJssdMbt3B8JmTB2KmDPF3mYX/JU+Cut5yMLweISGfbtiEeGIYPf5AJzMvg2aRt8ETn0TOAO+DZqV5i2w8daPFhKrdyq+CdgflnC72G1+wquPlPZ/6TMBWOlNeI0pRoit9n/h0ct5doPP3DslEX5dqyCST5oV5u3/0r1BqvvCrRbAEPC5WzXACeBTl3Lmc+dSpEwAhYLTJYTtp95/6lSggJeaPzlmS5lY/f/N0XQg7vcfTf/86AVrKQAngM+OJFocTQDGaUCbCT5S+z89fNziyDFdrMnuX/r8aIwBnIyySrvS/i8coj7Ml47RQNzOt/a1cyz4xiVOozfeFtb+bz0133mdBN97n0IHfE6jg75nwCG/s+h7X80Bv3P0U/v0KJ+yuYfGC4cD4aQ4jy+PBicdDU4BDiGpQnCaY0g6cArNAI5hGbbaT7F3isoEztFZiLb7jK3240s6IycAcb/f/VixQoQf28+e9aPdv+fZClMeZyqRafKp+r4JdcL5Bmz/LthMQI23hbWfp13nf6HXXNoA9J5g+AMzoO4s+RpM/i7UOQCv7ftnjRBIfmDOWFDuOPh9238obFbkOVJG2no9GC5Kz9ZdwHeZYm+zj6f3I2OjAGFvU1i1X82/KfzTaKSQo4A6GSiBx628ekbBkk9Y2u1iabeLJZ/w6utY+yn/9JKx1f4vvIYE70EAEwANATz84B/X/s+ceftl/k3aT/nfY/sx/3+H9n9q5aSC1V1H4edfjdVFqwzhBx+//Rh+tf1q8r91PUZY6RkMv7H9GH5j+zH8xvZj+I3tN04A2H44QKz9GH5qP3AItSSfLu/TRh/Dv/f2s9JT++nlHtuP4d97+21t9/fbftru77H9GP5/2vZj/m22/1Do9P6EzJg6HDprBO0/HA6FhhXibbUegi14+AxbAXz1dzZnSowp+3EkYt4UG00IH0EQjEehi+RgyAI6EGx1XnU4fEH5C4sBSxu/9O+VlghLPmHJJyztdrG028WST1jyiWy/Rn3IXz2vstX+r3yEL32GAE4AGhZ+8I9u/5dOGnzo7wunos8dCz93vETUB/3oWHDMI586ZEuZgJ71+63tR7u2//OjZxXwUvPZkRPC0eOMVfuRbP/nDic+d4BVFQs+OxrDOURJkYpwwqJOqO7MF04x6EvnWPSVSxz4xu04+db9BPjO4yRgsSfG6n/veRJ853kKfe91Gh3wPoMO+pxFh3zPkQN+59FB/wSEP6zPXupP8sMEAOFXN/2W9juGXmDhF/Tn+IBzRAZwicwEdABco7LQ7u03hh8Ywm+//cbw795+u8/3Aag+2qX9xvDv3n5j+P852x8AydfBy6CcseDccfDJYcjtvhgCj46EzZmCbxFFN6xHZImN69HIeVNHIuZMsbfZxVJNaAj4jXjddTQEMKLlYUuUduuEG4TC/2TL31a5vsI+IXGRsI8ZIGwUIPRAwB6xUcAuNgoQNgqQr/1mAKWd8o/njb70HleMEhF+72HWftj9f+nZx3n1ALrfr2gT9Pv9UouiycKjgdhq/2euVVKF6nOXii9cyr5yLrPKv1ORdBno+bd61N9Caf9njjkA22/Jv0P6F0czvnBIs5YKcAL4/GiShUMisJoGEM4ER84pzpDPrJwinx89KYiiW9FmApXVcBCnEKXHCcCKY7SkfbauFEFY2glt6BlKPlUffO16DLD2Y/6p8Qwln6oPDnhZkm9afTX8h/3iAQYeYeax9Mbz2H5ZfbHq4U/SdvwQftl+qr5zWCZwVB7jx/ar1VfD7xad7RKT7RKtXdtnjOHH0rOXAO/3exwvUZQh9xNltp71Y8m3MISfqm/afgq8LVR9v8RWQIG3xVL9lE7BUH3Ek0/+HbcfrxYcCeGrA2ydw2dN1qgFUyz5hL3NLoo9Q/H+jVjyCcWekft4gSqu7eNtwP8KXntQ78IcCJkVDBMAu2VArO8UWODuf+9Y2u1iyScs+YSizvJP5xlb7Yfws2v+eNmfhx/8E7TfKv9K+/X8F5jn39D+zxyzrPL/T9p+eptxAlDbL/Dwg4/dfpZ8pL60HgKskk9Y8omt5CMWfmy/mnyC1aev6ue19ivhT1bbz8IPjD/Ej0OAMfx7ab+x9Ibwa8/67d5+Fn677bcVfrCv9rPw220/D/+/Vvsht/tjqDs6Gj5vLnTGlGP4nDlDrRHbvhP2NruORppjo4BdWF8j9mghORw5b+pIBF7Gt8o/0FpugP8VevziQMg0nv8+eEaw+qUJC4AeI2DYKEDYZQC72GUAu9goQNgoQA=="></image>

Open in new window


so is this the whole image or just partial of it?

it is possible to fetch large image from mssql database  which data type is image
definitely that's possible but we need to debug what you have to make a conclusion.
0
mohan singhWeb developerCommented:
it is partial image  
sir i don`t  understand what should i do
0
mohan singhWeb developerCommented:
I am inserted a image in database like below
 image-200x200.jpgit`s original size is 200x200

but when i fetch it it show like
download--d.png
0
Ryan ChongCommented:
1. can you make sure what you stored in db contains complete data?

else, you may post your php codes here so that we try to re-process your issue.
0
mohan singhWeb developerCommented:
Sir there is two process
1.  Data insert  by our client side which is created in vb.net   language
2.  But I am fetching it in php

 
my code is to fetch data from database


$sql = odbc_exec($conn, "SELECT  * WHERE project_city='$city'");
    while($rows = odbc_fetch_array($sql1)){
       
       
         $image = base64_encode($rows['project_image']);
         
         echo " <img src='data:image/jpeg;base64,$image'>";
    }

but it is show half image only
0
Ryan ChongCommented:
And I have already show you how i am fetching data
I didn't see neither VB.NET nor PHP codes here. am i missing something?

so are both VB.NET and PHP codes working for small images?
and it only got issue for "big" images?
0
Ryan ChongCommented:
wait a moment, so we got 2 "mohan singh" here ??
0
mohan singhWeb developerCommented:
sir
in vb.net it is working good
but in php not work


Sir are you got it code
0
Ryan ChongCommented:
php codes means something starting with <php?> and end with <?>

data:image/jpeg;base64.. was the output, not the php codes.

Think it would be difficult for verification if you got no clue what went wrong.
so try do it step by step...

1. what you need to do next is compare the value stored in MS SQL, and make sure it's as identical as the source?
2. if the answer is wrong then your VB.NET to MSSQL database got something wrong > debug it
3. if the answer is yes then verify your PHP, as already mentioned, increase the server/ page timeout and see what was being returned.
0
mohan singhWeb developerCommented:
Hello Sir
I got the solution for that
but there is little problem can you solve it

sir i am  fire a query  
$query =  select project_image, baze64 from project_master cross apply (select project_image as '*' for xml path('')) T (baze64)  ;
and it is converting all binary image into base64 which correct
but I am unable to get that query variable in php variable

can you help me how to get query variable in php variable in php
0
Ryan ChongCommented:
can you try this?
$image = $rows['baze64'];
echo " <img src='data:image/jpeg;base64,$image'>";

Open in new window

0
mohan singhWeb developerCommented:
No it is not working
it show only  symbols

when i used
$image = $rows['baze64'];
 <img src="data:image/jpeg;base64,<?php   echo base64_encode($image); ?>">
it show half image
0
Ryan ChongCommented:
can you upload your image somewhere online so that I can get it for a try?
0
mohan singhWeb developerCommented:
sorry Sir I cant

Sir can you tell me
1. Is there any problem to fetch binary image in localhost ?
2. When I fetch image (binary data format) always show half image I don't no why

when I fire this query

$query =  select project_image, baze64 from project_master cross apply (select project_image as '*' for xml path('')) T (baze64)  ;

in Microsoft SQL server it convert all binary image data to base64
but When I Fire this query to show half image

I think there is problem in local (Apache)

Sir I if know how it will fix this problem so please help
Thank you
0
Ryan ChongCommented:
can you tell me
1. Is there any problem to fetch binary image in localhost ?
2. When I fetch image (binary data format) always show half image I don't no why
I think there is problem in local (Apache)
this probably was what I have suspected that some timeout issue which could causing the issue.

i can't test remotely so this was what i can suggest so far.

if you need more expert's inputs, you may try to raise the attention via Report Question option.
0
mohan singhWeb developerCommented:
Yee
Finally  I Got the solution

Thank Ryan Chong Sir
0
Ryan ChongCommented:
sorry, can you tell how you solve it?
0
mohan singhWeb developerCommented:
I am just change
 ini_set("odbc.defaultlrl", "4096");  to   ini_set("odbc.defaultlrl", "100K");   in php.ini
and restart the apache Server
then it solved my problem
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ryan ChongCommented:
ok, it seems that text was being cut off

odbc.defaultlrl 4096  - How to increase the limit on characters
https://www.experts-exchange.com/questions/21179615/odbc-defaultlrl-4096-How-to-increase-the-limit-on-characters.html

got to know that
1
mohan singhWeb developerCommented:
yes more of binary no can not retrieve  
because size of dbc.defaultlrl is less
Thank You
0
mohan singhWeb developerCommented:
My problem has solved
0
mohan singhWeb developerCommented:
thank you Sir
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
HTML

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.