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

Piec Junkers


adamkorski

Question

Witam,

wg projektu 

Please login or register to see this link.

na raspberry zrobiłem monitor pieca. Super sprawa.

Na Raspberry zrobiłem stronkę php pobierającą dane z Sqlite z raspberry. Potem parsuję stronkę w lua, aby otrzymać dane dla Fibaro i pokazaj je w VD.

 

Jak można przez lua pobrać bezpośrednio dane z Sqlite z raspberry?

 

To musiało by być odpowiednikiem:

<?php

class MyDB extends SQLite3

{

function __construct()

{

$this->open('/home/pi/HT3/sw/var/databases/HT3_db.sqlite');

}

}

$db = new MyDB();

$Device_id = 2000;

 

include 'config.inc.php';

 

print "<html><body>";

 

if(!$db){

print $db->lastErrorMsg();

} else {

$sql_table = 'heizgeraet';

print "$sql_table <br/>";

if (isset($sql_table))

{

// make a select

try {

$sql = "SELECT * FROM ".$sql_table." order by local_date_time DESC limit 1";

$results = $db->query($sql);

 

// retry is databse is locked

if (!$results) {

sleep(5);

$results = $db->query($sql);

}

// print results

if ($results )

{

$row =$results->fetchArray(SQLITE3_ASSOC);

 

if ($row)

{

foreach ($row as $key => $val)

{

++$Device_id;

 

if($Device_id == 2001)

{

print "$key = $Device_id = $val <br>\n";

}

......

Please login or register to see this attachment.

  • Like 1
Link to comment
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

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...