CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> PHP

 Displaying JPG on Grid from DB ?

Print topic Send  topic

Author Message
Michael
Posted: 02/17/2005, 5:34 PM

Hello, I'm trying CodeCharge but it doesn't seems to show the JPG (store
to a blob field) from MySQL. Is there any way ?

Thanks a lot
Anothersledhead


Posts: 44
Posted: 02/17/2005, 5:43 PM

CodeCharge doesn't by default store images themselves in the database. They store the image name in the database and you have to map the image name to your upload folder where you uploaded the images.
View profile  Send private message
Michael
Posted: 02/17/2005, 5:52 PM

> CodeCharge doesn't by default store images themselves in the database. They
> store the image name in the database and you have to map the image name to your
> upload folder where you uploaded the images.

Emm, so there is no way to display a JPG from a MySQL Blob Field ?
peterr


Posts: 5971
Posted: 02/17/2005, 5:58 PM

We don't recommend storing images in such a way, however you can display BLOB images using standard PHP code. See http://www.phpaddict.com/forum2/849.html
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com
View profile  Send private message
Michael
Posted: 02/18/2005, 3:23 AM

> We don't recommend storing images in such a way, however yes, you can display
> BLOB images using standard PHP code. See
> http://www.phpaddict.com/forum2/849.html

Hi! the article tells to put the below code to display the image, (i've
made the display_pici.php file with the code of the forum) but i don't
know where to put the value it in the image link component.
(<?php print "<img src=\"display_pici.php?id=$record_id\">"; ?>)

Any help ? Thanks!
Nicole

Posts: 586
Posted: 02/18/2005, 5:22 AM

Michael,
In CCS you can use a Label control to display image. Set its Content property to HTML and in its Before Show event refer to display_pici.php file:
  
global $form_name;  
$form_name->LabelName->SetValue("<img border=0 src=\"display_pici?id=".$record_id. "\" width=200 height=200>");  

_________________
Regards,
Nicole
View profile  Send private message
Michael
Posted: 02/18/2005, 8:44 AM

> In CCS you can use a Label control to display image. Set its Content property
> to HTML and in its Before Show event refer to display_pici.php file:
>
  
> global $form_name;  
> $form_name->LabelName->SetValue("<img border=0  
> src=\"display_pici?id=".$record_id. "\" width=200 height=200>");  
> 

hi! it doesn't seems to find the record id ? i get an image holder only.

Thanks!
peterr


Posts: 5971
Posted: 02/18/2005, 9:00 AM

You will need to replace $record_id with something that contains the id of the image that you want to display.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.