× If you expect answers you should describe your problem and give as much information's as possible. (SQL-Structure, Template Code, Joomla Version ...) Please read this before posting: joodb.feenders.de/support.html

Problem to show the images

More
7 years 10 months ago #3870 by Dragonevil
Problem to show the images was created by Dragonevil
I have some problems to show the images in a table with data from my db. The image is in a blob field. The others data are shown correctly.

The images are in this path folder: /public_html/images/dcr/congresos
In my catalog-template I use this path to show the images :<img src="/public_html/images/dcr/congresos {joodb field|imagen}" alt="*"></td> But they are not shown.
I have tried changing {joodb field|imagen} for this one {joodb imagen}, also imposible to see the pictures.
I have make some change in the path only to put this <img src="/images/dcr/congresos {joodb field|imagen}
or this <img src="/images/dcr/congresos {joodb imagen} and the result was the same :(

I don´t know what I´m doing wrong. I need your help, please.
Also sorry for my english ;)

Please Log in to join the conversation.

More
7 years 10 months ago - 7 years 10 months ago #3878 by joest
Replied by joest on topic Problem to show the images
Last edit: 7 years 10 months ago by joest.
The following user(s) said Thank You: Dragonevil

Please Log in to join the conversation.

More
7 years 10 months ago - 7 years 10 months ago #3881 by Dragonevil
Replied by Dragonevil on topic Problem to show the images
When I put the database field like a varchar field and I put in the name of the image, I can see in the web the image.
But the field where I upload the images are mediumblob and I have tried different way to connect them but whitout success.
May be is because I don´t understand very well how to do it.
I´m so sorry, but if you could help me I will always be grateful.
Thanks
Last edit: 7 years 10 months ago by Dragonevil.

Please Log in to join the conversation.

More
7 years 10 months ago - 7 years 10 months ago #3882 by Dirk
Replied by Dirk on topic Problem to show the images

Dragonevil wrote: /public_html/images/dcr/congresos
In my catalog-template I use this path to show the images :<img src="/public_html/images/dcr/congresos {joodb field|imagen}" alt="*"></td> But they are not shown.


Generally this is the way to insert images but you made two faults.
/public_html/images/ is you document root on your server. That path ist not accessible by browsers. I guess it is /images/!

Second Problem is the whitespace!
/images/dcr/congresos {joodb field|imagen} will produce something like
/images/dcr/congresos myimge.jpg but you need
/images/dcr/congresos/myimge.jpg

BTW: /images/ is also only correct if you joomla site ist installed at the root.
If your Joomla is installd in a subdirectory the relative path to /images/ is different.
For www.myserver.com/joomla/database.html it would be /joomla/images/ or www.myserver.com/joomla/images/
Last edit: 7 years 10 months ago by joest.
The following user(s) said Thank You: Dragonevil

Please Log in to join the conversation.

More
7 years 10 months ago #3890 by Dragonevil
Replied by Dragonevil on topic Problem to show the images
Thank you for your help.

I have changed in my database the type of field to VARCHAR and put in the name of the image, and in this case I have no problem to see the image. But what I try to do it´s see the imagen when the images are in field as MEDIUMBLOB in my database. But with the path: <img src="/images/dcr/congresos/{joodb field|imagen}" alt="*"> It doesn´t function.
I want to show a database with a lot of images save in a folder in my server. The images are not in my Database. And may be, is there where is my problem :(

I have some questions to try to solve my problem:
- with a mediumblob field, Is it necessary to put the name of all the images??? Or may be this question it´s better, Is it possible to show all the images only with one path?????
- How it´s different the path for varchar field and mediumblob field in the joodb use?

This is the table that I try to show:

<!--<div class="block">-->
<table cellspacing="0" cellpadding="0" class="tablaz">
<tbody>
<tr class="{joodb loopclass}">
<td rowspan="9" width="100"><img src="/images/dcr/congresos/{joodb imagen}" alt="*"></td>
<th width="70">Título</th>
<td>{joodb field|Titulo}</td>
</tr>
<tr>
<th>Autor: </th>
<td>{joodb field|Autor}</td>
</tr>
<tr>
<th>Tipo de participación: </th>
<td>{joodb field|Tipo de participacion}</td>
</tr>
<tr>
<th>Congreso: </th>
<td>{joodb field|Congreso}</td>
</tr>
<tr>
<th>Publicación: </th>
<td>{joodb field|Publicacion}</td>
</tr>
<tr>
<th>ISBN: </th>
<td>{joodb field|ISBN}</td>
</tr>
<tr>
<th>Páginas: </th>
<td>{joodb field|Paginas}</td>
</tr>
<tr>
<th>Año: </th>
<td>{joodb field|Año}</td>
</tr>
<tr>
<th>Lugar de publicación: </th>
<td>{joodb field|Lugar de celebracion}</td>
</tr>
</tbody>
</table>
<!--</div>-->

All the files fonction correctly except the images :(

May be my questions are strange for you, but I have problem to explain better in english and I have not to much knowledge in this subject.
I hope you can understand me and please excuse me again to be heavy.

Thanks again.

Please Log in to join the conversation.

More
7 years 10 months ago #3891 by Dirk
Replied by Dirk on topic Problem to show the images

Dragonevil wrote: But what I try to do it´s see the imagen when the images are in field as MEDIUMBLOB in my database. But with the path: <img src="/images/dcr/congresos/{joodb field|imagen}" alt="*"> It doesn´t function.


Try
<img src="{joodb field|imagen}" alt="*">

If your field imagen is a mediumblob filled with an image. Your image is displayed!
The following user(s) said Thank You: Dragonevil

Please Log in to join the conversation.

Moderators: Dirkjoest