Blob image on Mysql Table not show

Topic: Blob image on Mysql Table not show (Read 1881 times) previous topic - next topic

Blob image on Mysql Table not show

June 13, 2019, 02:00:42 PM

Hi folks, I have some little question.

I gotta a msyql table of machines, one field is machine photo , ( Used varchar and Blob to test)

In the local production machine works fine, but when i try to see from other computer explorer in the same lan or in the mobile the image not show.

Can someone know how to fix it?

Thank you in advance.

Re: Blob image on Mysql Table not show

Reply #1 – June 13, 2019, 02:20:17 PM

Example Attached

Re: Blob image on Mysql Table not show

Reply #2 – June 14, 2019, 04:21:51 PM

I saw a possible solution encoding base 64 to see remote img

Example to fix remote image

but i dont know how to encode in this

<th class="title"><i class="fa fa-photo fa-2x"></i> Foto :</th>
<td class="value"><niceimg :path="data.foto" width="400" height="400" ></niceimg> </td>
</tr>
<tr>

Re: Blob image on Mysql Table not show

Reply #3 – June 14, 2019, 05:47:39 PM

@ocalle What version of phprad are you using, classic or studio?

Re: Blob image on Mysql Table not show

Reply #4 – June 14, 2019, 08:24:09 PM

PHPRad Vue Edition Version 2.6.2 thats my license

Re: Blob image on Mysql Table not show

Reply #5 – June 15, 2019, 07:22:25 AM

Please check the image path on your database to make sure it will work on the LAN. Maybe your LAN is running on a different port as your local host.

Please explain what you mean by not showing on the mobile.

You can equally try the classic as it has much features and stable than the VUEjs version which has not been updated recently.

Your license should work on all RadSystems project(Phprad, NodeRad, Pyrad... )

Thanks

Re: Blob image on Mysql Table not show

Reply #6 – June 15, 2019, 03:16:11 PM

Thank you i download the classic then

Re: Blob image on Mysql Table not show

Reply #7 – June 17, 2019, 03:45:46 AM

Hi, I ran across this image issue. In the database the path was http://localhost/files/photo.jpg. So a remote machine wouldnt see the images.
Was easy to delete the photos in the interface and upload again to fix the path instead of retyping the path in the database. Better to setup run local lan connections do testing as ip if not using urls from the get go.
http:// 192.168.1.85/radproject
Also check rights on your folders I had the images dir get a 141 instead of 755 for some reason.

Re: Blob image on Mysql Table not show

Reply #8 – June 19, 2019, 01:54:48 AM

Its workin, i running from the second machine, added an image, but need pay attention in the field properties when u add a new one, need set image type, mb allowed and so on. Thank You this forum is walking dont stop!!!!!!!!!