Search code examples
htmlmysqljoomlasobipro

Get image from SQL Table


I'm using SobiPro on my Joomla 3.x website and I have a custom field, in my entries, which is an image, it is stored in my table named XXXX_sobipro_field_data I have a fid (field id) which is equal to 23 for the Image field. But the data looks like this for every entries: jVFNT8JAEL37KzZ70kQp/US34WCgIEQ+AjUeyULXdgjtVrqgaPrf3d1WRA/E27438+a9maXEJZ8FcQiOqKDYp8SsMXuHF4XtGvcGj4HCnsK3EsOGjWnKsF8Qs0mway5gxRvrPNaMVXV0qWAhqC4gpmO2POuu5dj+ccIcPqqarPyw4SHXbE2N5ICKqqwgpTEz1jmrrGyC52wlgGdFj++ySJEtgjuT0SgYh9gv9RAJp09h0FU7OPVOiUg3qtuSad8gEkkbezZGCYM4Efqtqh7BD5pRkTwV3iX4WbUfCWk3KDp8w7d6GWV5mkBfFUhTSRU/C+7DyYygOLpRW6C92Wiiy10BWYwGwz4aToM+2nvW1TV63dENiANqo5Z7IXcpS22vT6DCOd/3KIyCLyHfcoNlYgsSu64Babz4/TFSK5JdutRa65xWt/1Ry1NL9A/fFf+jlD/AtxBDRvXFbe+c/FRafgE=
But I need to display the image, how am I supposed to deal with such a thing ?

EDIT

I did this : (It works but only with .png images)

<?php
$sid = $_GET["id"];
$db = mysql_connect("localhost", "admin", "root")
    or die("Impossible de se connecter : " . mysql_error());
mysql_select_db('database_name',$db); 

$sql = 'SELECT baseData, sid, fid FROM XXXX_sobipro_field_data WHERE sid = ' . $sid; 
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error()); 

while($data = mysql_fetch_assoc($req)) 
{ 
    if ($data["fid"] == 22) {
        $title = $data["baseData"];
    }
    if ($data["fid"] == 19) {
        $desc = $data["baseData"];
    }
    if ($data["fid"] == 17) {
        $activity = $data["baseData"];
    }
    if ($data["fid"] == 23) {
        $enc_image = $data["baseData"];
        $dec_image = unserialize(base64_decode($enc_image));
    }
}
?>
<p>
  <?php 
    echo "<span class=\"img\"><img src=\" ".$dec_image['original']." \" alt=\"\"> </img>  </span>";
  ?>
    <span class="title"><?php echo $title; ?></span>
    <br />
    <span class="activity"><?php echo $activity; ?></span>
    <br />
    <span class="desc"><?php echo $desc; ?></span>
</p>
<?php 
  mysql_close($db);
?>

Solution

  • Fixed this problem.

    $entries[$key]['field_avatar'] = $entry->get('field_avatar');
    
    // Encrypt Image
    $enc_image = $entries[ $key ]['field_avatar'];
    
    // Decrypt image 
    **$dec_image = SPConfig::unserialize( $enc_image );**