Forums

Hi, i'm trying to display the user's image in row of my CC table. As I 'm really not good in php, i have copy the code from another topic (topic about editing image in a form to modify or erase), wich is this one :

<?php
if ( isset($form->data['eleve_portrait']) && $form->data['eleve_portrait'] ) {
  echo "<img src='".JURI::root()."images/elevemid_{eleve_portrait}' style='max-width:120px' />";
} else {
  echo "<img src='".JURI::root()."images/00_no_image.jpg' style='max-width:120px' />";
}
?>

This one work really good in my form, but I can't make it run in my CC table. I just get the "No-image" picture, even if user has uploaded an image...

I have paste it in the cell where i want it display. Max said in another topic I read "Don't do an extra query, actually you are doing a query per row, which is wrong". SO I think this the error i do here, but i just don't know how to do this in a better way...

Does anybody have a suggestion ?

Hi BigStef,

In ChronoConnectivity (the current version) the row data is in $row. Also you usually can't use the curly bracket syntax in PHP. So please try:

<?php
if ( isset($row['eleve_portrait']) && $row['eleve_portrait'] ) {
  echo "<img src='".JURI::root()."images/elevemid_{$row['eleve_portrait']}' style='max-width:120px' />";
} else {
  echo "<img src='".JURI::root()."images/00_no_image.jpg' style='max-width:120px' />";
}
?>

Bob

Hi Bob, this is saturday evening and give me the right solution...
Thanks a lot for that! :-) Works great !

Hi Bob, I have a new case with this topic. I have activated a Multi Tables on this connection, and the code stop working, showing only the "no-image" picture. I have tried to put the MODEL_ID (here : Eleve) before the name of field, like this :

<?php
if ( isset($row['Eleve.eleve_portrait']) && $row['Eleve.eleve_portrait'] ) {
  echo "<img src='".JURI::root()."images/formulaire/elevemid_{$row['Eleve.eleve_portrait']}' style='max-width:120px' />";
} else {
  echo "<img src='".JURI::root()."images/formulaire/00_no_image.jpg' style='max-width:120px' />";
}
?>

But nothing changed, still the "No-Image" picture...

Other fields works great (i.e. : {Eleve.eleve_nom}, {Eleve.eleve_prenom}, etc), but this one a "normal" datas...

After several others tests, I found that Pictures stopped working when I give a MODEL_ID to the main connection (here "Eleve"). When I erase that Model ID, the pictures are back, but of course, the data from second tables are not loaded...

Have any idea ?

Hi BigStef,

The 'dot' will work with the curly brackets: {Eleve.eleve_portrait} where you can use them.

In PHP it's a sub-array: $row['Eleve']['eleve_portrait']

Bob

Note: the curly brackets that ChronoForms uses to let you insert values are similar to but not functionally the same as the curly brackets that PHP uses to let you include a variable in a string.

Hi Bob,
Thanks a lot... Works great ! I was asking myself two things :

1/ Is it better to write a MODEL_ID in lowercase ? (strangely, i found it work better on my multi table)
2/ Do you share the beers we can offer here with Max ? ;-)

Hi BigStef,

1) I don't think it should make any difference. I tend to use all lower case automatically so haven't done any real comparisons.

2) No we don't usually share. If you buy me a beer, I keep that. If you buy a subscription Max keeps that and from time to time he pays me a 'royalty' on the subscription sales income.

Bob

In ChronoConnectivity (the current version) the row data is in $row. Also you usually can't use the curly bracket syntax in PHP. So please try:

<?php
if ( isset($row['eleve_portrait']) && $row['eleve_portrait'] ) {
  echo "<img src='".JURI::root()."images/elevemid_{$row['eleve_portrait']}' style='max-width:120px' />";
} else {
  echo "<img src='".JURI::root()."images/00_no_image.jpg' style='max-width:120px' />";
}
?>

Forgive me for being thick - where does the above "If" else" go in chronoconnectivity?

Hi BionicNelly,

In the Body section of a Custom Listing.

Bob