Calculator Cells in Grid while using PHP Connector MySQL

Suite and Optimus Suite 5
#1

Hi,

I have a MySQL table “store_record”. I have connected a grid with PHP Connector for MySQL.
Records are perfectly updating. I just want to add another column in grid with calculated total as “Store Total” from MySQL fields “Price” and “Quantity” without adding another field in MySQL table.

Javascript

storeGrid.setHeader("ID, Item Code, Price, Quantity, Store Total, Status");

PHP

$gridConn->render_table("store_record","id","id, iterm_code, price, quantity, status);
#2

You may try to define additional column with the required math formula.
There is no need to load any data to it.
Her you can find an example:
dhtmlx.com/docs/products/dhtmlx … _math.html
and a tutorial:
docs.dhtmlx.com/grid__math.html