Jump to content

Welcome to Smart Home Forum by FIBARO

Dear Guest,

 

as you can notice parts of Smart Home Forum by FIBARO is not available for you. You have to register in order to view all content and post in our community. Don't worry! Registration is a simple free process that requires minimal information for you to sign up. Become a part of of Smart Home Forum by FIBARO by creating an account.

 

As a member you can:

  •     Start new topics and reply to others
  •     Follow topics and users to get email updates
  •     Get your own profile page and make new friends
  •     Send personal messages
  •     ... and learn a lot about our system!

 

Regards,

Smart Home Forum by FIBARO Team


  • 0

[HELP] How to connect Mysql with LUA


Question

Posted

Hi all,

I would like to archive the temperature on a sql database with LUA script.

Someone help me?

Please login or register to see this image.

/emoticons/default_icon_rolleyes.gif" alt=":roll:" />

Thx

4 answers to this question

Recommended Posts

  • 0
Posted
Hi all,

I would like to archive the temperature on a sql database with LUA script.

Someone help me?

Please login or register to see this image.

/emoticons/default_icon_rolleyes.gif" alt=":roll:" />

Thx

You must have a php / asp.net script on other server (local or web) to do that. Simply push data from HC2 with LUA to your script who store information in the database... There are many example for this in the forum. You can't directly put data to SQL database with LUA.

  • 0
  • Inquirer
  • Posted
    Hi all,

    I would like to archive the temperature on a sql database with LUA script.

    Someone help me?

    Please login or register to see this image.

    /emoticons/default_icon_rolleyes.gif" alt=":roll:" />

    Thx

    You must have a php / asp.net script on other server (local or web) to do that. Simply push data from HC2 with LUA to your script who store information in the database... There are many example for this in the forum. You can't directly put data to SQL database with LUA.

    Ok thanks, actually a use thingspeak but i want use pchart and MySQL database on my Synology NAS

    • 0
    Posted

    I am going also to do my own script for that.

    • 0
  • Inquirer
  • Posted

    Ok I make graph successfull with highstock et SQL database

    Please login or register to see this image.

    /emoticons/default_icon_mrgreen.gif" alt=":mrgreen:" />

    Thx

    Join the conversation

    You can post now and register later. If you have an account, sign in now to post with your account.

    Guest
    Answer this question...

    ×   Pasted as rich text.   Paste as plain text instead

      Only 75 emoji are allowed.

    ×   Your link has been automatically embedded.   Display as a link instead

    ×   Your previous content has been restored.   Clear editor

    ×   You cannot paste images directly. Upload or insert images from URL.

    ×
    ×
    • Create New...