function makeRow($name) { $date = date('Y/m/d H:i'); $db = new MyDB("sqltemptime.db"); if (!$db) { echo $db->lastErrorMsg(); } $sql = <<<EOF INSERT INTO schema (name, type, date) VALUES ('{$name}', 'cooling', '{$date}'); EOF; $ret = $db->exec($sql); if (!$ret) { echo $db->lastErrorMsg(); } else { echo "Data insertet\n"; } $id = $db->lastInsertRowid(); $db->close(); return $id; }
function makeRow($name, $elementHeat, $elementKeepWarm) { $date = date('Y/m/d H:i'); $db = new MyDB("sqltemptime.db"); if (!$db) { echo $db->lastErrorMsg(); } $sql = <<<EOF INSERT INTO schema (name, type, date, elementheating, elementrndheating) VALUES ('{$name}', 'boil', '{$date}', '{$elementHeat}', '{$elementKeepWarm}'); EOF; $ret = $db->exec($sql); if (!$ret) { echo $db->lastErrorMsg(); } else { echo "Data insertet\n"; } $id = $db->lastInsertRowid(); $db->close(); return $id; }