Tried this, where {intro_image} is supposed to be the value in database:

$col[“default”] = “<img width=160 height=90 src=’http://www.mydomain.de/{intro_image}’ >”;

Will not work either.

Should I use the formatter or default? Difference?

Hello,

To use image in datagrid, You need 2 fields.

Referring this demo code: https://www.gridphp.com/demo/demos/editing/file-upload.phps

One for file add/edit purpose which is not shown in listing (line 96-108)

And other one for displaying purpose which is actually shown on listing (line 110-147)

In the later column, You can have this code with placeholder in default property {intro_image}.

Hello,

thank you for adding the crop feature.

I have looked at the example and tried to replicate, but there still has to be something wrong with my code.

As said, I have a database column “intro_image” with value e.g. “images/videos/myvideo.jpg”. I would like to display the image inside the grid and on click link to another page.

Right now I am getting “None” as output 🙂

// intro_image
$col = array();
$col[“title”] = “intro_image”; // caption of column
$col[“name”] = “intro_image”; // database field name
$col[“show”] = array(“list”=>false,”edit”=>true,”add”=>true); // show in list, edit, add
$col[“resizable”] = true;
$col[“width”] = “50”;
$col[“align”] = “left”;
$col[“search”] = false;
$col[“sortable”] = false;
$col[“editable”] = true;
$col[“edittype”] = “file”;
$col[“upload_dir”] = “images/temp”;
$col[“editrules”][“allowedext”] = “png,jpeg,jpg”; // comma separated list of extensions
$col[“editrules”][“allowedsize”] = 5 * 640 * 360; // allowed size in bytes e.g. 3 MB = 3 x 1024 x 1024
$cols[] = $col;

// virtual column
$col = array();
$col[“title”] = “image”;
$col[“name”] = “image”;
$col[“width”] = “360”;
$col[“editable”] = true;
$col[“on_data_display”] = array(“display_image”,””);
function display_image($data) {
$upload_url = explode(“/”,$_SERVER[“REQUEST_URI”]);
array_pop($upload_url);
$upload_url = implode(“/”,$upload_url).”/”;
$file = $data[“intro_image”];
$arr = explode(“.”,$file);
$ext = $arr[count($arr)-1];

if (empty($file))
return “None”;
else if (strtolower($ext) == “doc” || strtolower($ext) == “xls” || strtolower($ext) == “docx” || strtolower($ext) == “xlsx” || strtolower($ext) == “pdf”)
return “<a href=’$upload_url/$file’ target=’_blank’>Download File</a>”;
else if (strtolower($ext) == “png” || strtolower($ext) == “jpg” || strtolower($ext) == “jpeg”)
return “<a href=’$upload_url/$file’ target=’_blank’><img height=50 src=’$upload_url/$file’></a>”;
else
return $file;

}
$col[“show”] = array(“list”=>true,”edit”=>false,”add”=>false,”view”=>true);
$col[“editoptions”][“dataInit”] = “function(o){jQuery(o).parent().html(o.value);}”;
$cols[] = $col;

I think I found one mistake I made. I need to select all columns I want to show:

$g->select_command = “SELECT
title
FROM
pages
WHERE
app_id = 6
“;

Thanks correct. If you provide sql query, only selected fields will be there in dataset.

I’ve sent you latest build as well.