REXYGEN Community Forum

soxso2011

Member

From: India

Registered: 2015-11-25

Posts: 37

HMI at Remote Server using MySQL/Webudi

Sir,
I have moved my HMI folder to a domian name, www.controlsoft.in, and the pages are opening now!! I have also established ODBC connection with a database with mysql server. Now I want to reflect these mysql db values in my HMI. How to integrate Webudi graphics with mysql db.
So finally Rex core will run at local windows machine, the data will be fed to remote mysql and from remote mysql to HMI will reflect the data.
So for localhost this was the calling script:
{alias: 'BLOCK_NO', desc: 'BLOCK NO', cstring: 'read_mcp3422_task.REXLANGSCH1-16:output_blockno', type: 'AR'},
What will be the calling script from mysql to HMI!

jaroslav_sobota

Administrator

Registered: 2015-10-27

Posts: 535

Re: HMI at Remote Server using MySQL/Webudi

Hi soxso2011,
thanks for your question. Very nice idea! Though WebBuDi HMI is not the right tool for this task. It can only read data from the RexCore runtime module, not directly from a database.

There are many frameworks based on PHP, JavaScript, etc. which do what you need. See e.g. http://www.creativebloq.com/design-tool … ion-712402

Jaroslav

---

Monarco HAT for Raspberry Pi - Lightweight I/O for monitoring, archiving and control.
Raspberry Pi in industrial automation!

soxso2011

Member

From: India

Registered: 2015-11-25

Posts: 37

Re: HMI at Remote Server using MySQL/Webudi

Thanks for the reply. I will design php-mysql interface for HMI.