mohan singh
asked on
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,iVB
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,iVB
ASKER
I have already increase time
but it is not working
but it is not working
can you try to trace the error message? is there any findings?
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
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
i got this as the output.
with:
so is this the whole image or just partial of it?
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>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 imagedefinitely that's possible but we need to debug what you have to make a conclusion.
it is partial image
sir i don`t understand what should i do
sir i don`t understand what should i do
I am inserted a image in database like below
it`s original size is 200x200
but when i fetch it it show like
download--d.png
it`s original size is 200x200but when i fetch it it show like
download--d.png
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.
else, you may post your php codes here so that we try to re-process your issue.
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['proje
echo " <img src='data:image/jpeg;base6
}
but it is show half image only
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['proje
echo " <img src='data:image/jpeg;base6
}
but it is show half image only
And I have already show you how i am fetching dataI 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?
wait a moment, so we got 2 "mohan singh" here ??
sir
in vb.net it is working good
but in php not work
Sir are you got it code
in vb.net it is working good
but in php not work
Sir are you got it code
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.
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.
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
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
can you try this?
$image = $rows['baze64'];
echo " <img src='data:image/jpeg;base64,$image'>";
No it is not working
it show only symbols
when i used
$image = $rows['baze64'];
<img src="data:image/jpeg;base6
it show half image
it show only symbols
when i used
$image = $rows['baze64'];
<img src="data:image/jpeg;base6
it show half image
can you upload your image somewhere online so that I can get it for a try?
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
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
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.
Yee
Finally I Got the solution
Thank Ryan Chong Sir
Finally I Got the solution
Thank Ryan Chong Sir
sorry, can you tell how you solve it?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
yes more of binary no can not retrieve
because size of dbc.defaultlrl is less
Thank You
because size of dbc.defaultlrl is less
Thank You
My problem has solved
thank you Sir
could be a server / page timeout issue? try to increase it and test again.