How to show an image whose path is in the database?

Question

I’m using Extjs 4 and PHP.

I have an image saved in a server folder and its path is saved in my database. I tried to do something like this:

Code in the controller:

onVerImgClick: function(btn, o, e0pts){
    var grid = btn.up('grid');
    var records = grid.getSelectionModel().getSelection();
    var produtoId = records[0].data.id;
    //var image = Ext.create('ExtMVC.view.verImagem');
    Ext.Ajax.request({
        method: 'POST',
        url: 'php/importadorDadosImagem.php',
        success: function(response){
            var array = Ext.decode(response.responseText);
            var cont = 0;
            var caminho;
            while(cont < array.data.length){
                if(produtoId == array.data[cont].idProduto){
                    caminho = array.data[cont].imagem;
                }
                cont++;
            }
            cont = 0;
            if(caminho != null){
                var image = Ext.create('ExtMVC.view.verImagem');
                image.getEl().set({
                    src: caminho
                });
            }
        }
    });
}

mage.js

Ext.define('ExtMVC.view.verImagem', {
   extend: 'Ext.window.Window',
   alias: 'widget.verimagem',
   autoShow: true,
   modal: true,
   width: 400,
   height: 400,
   items: [
       {
           xtype: 'component',
           autoEl: {
               tag: 'img',
               src: ' '
           }
       }
   ]
});

importadorDadosImage.php

<?php
include("connect.php");

$queryString = "SELECT idProduto, imagem FROM imagens";

//consulta sql
$query = mysql_query($queryString) or die(mysql_error());

//faz um looping e cria um array com os campos da consulta
$dados = array();
while($dado = mysql_fetch_assoc($query)) {
    $dados[] = $dado;
}

$total = count($queryString);

echo json_encode(array(
    "success" => mysql_errno() == 0,
    "total" => $total,
    "data" => $dados
));

This way, no error is shown. However, the image does not appear.

Answer 1

Good morning, have you ever first tried connecting to the database by PHP? you have to have in the database the following information, name and extension of the image, then in php you put in a variable, the full address of the root folder to the folder where the image is, then concatenate with the name and extension of the image, ai just insert into a javascript variable and assign in your code to display the image.

example

SQL = name | ext = image.ext

PHP = server/folder/subfolder/image.ext

EJS = http://server/folder/subfolder/image.ext