Extend HS with own table fields on productpage

-- HikaShop version -- : latest

Hi,

I'd like some directions on how to extend Hikashop.

Case:

I've created my own DB-table containing "color-records".
I'd like to display this colors on my product-page.
I'd like to customise HS in this way that I do not lose customisations after updating to newer release.
I do know how to customise display by HS-overriding-system, I've done this and this works fine.

I'd like to know how to "fetch" the table-data (colors-table), what kind of php-file do I have to create and in which directory and how to pass it to the product-display-view?

In short:

1. read DB-table
2. create colors-dataset
3. pass colours-dataset to the product-display-view

I know how to code this in PHP andI could do this with AJAX by jQuery but that is no what I want, I'd like to fix this the Joomla / Hikashop-way

Any info is appreciated.

Thanks in advance.

Mark

Jerome thanks for quick response.

I thought so but I thought it's bad practice to put DB-actions within views? In this case probably its OK because it's a small imprint but it's not adhering coding-best-practices I guess. On the other hand: why "over coding" for such small functionality.

The case is this:

My color-record consists of:
-color-active
-colorname
-color-image
-colortype
-colorversion

In the frontend (productpage) I build a color-matrix from which the customer can select one color.
Sometimes color are inactive so I only show active colours of that moment.

I've created my own component (with component-creator) for the color-crud function.

Thats why I'd like to integrate my own component (solution) in the frontend of Hikashop.

Anyway thanks for responding.

Mark