Exemple #1
0
function majStatus($a_matos, $a_action)
{
    $qry = "Select groupe from materiel where materielID = {$a_matos}";
    $sqlCmdMatos = "update materiel set etat='{$a_action}' where materielID={$a_matos}";
    $sqlCmdGroupe = "update materiel set etat='{$a_action}' where groupe={$a_matos}";
    try {
        $db = new sqlite3($GLOBALS['dbaseName']);
        $result = $db->query($qry);
        $row = $result->fetchArray();
        $group = $row[0];
        if ($group == $a_matos) {
            $sqlCmd = $sqlCmdGroupe;
        } else {
            $sqlCmd = $sqlCmdMatos;
        }
        logMe("LIB : majStatus(\"{$sqlCmd}\")");
        $db->exec($sqlCmd);
        $db->close();
    } catch (Exception $e) {
        logme("ERROR : {$e}");
        return;
    }
}
Exemple #2
0
/* Get connection to statement */
$db = new sqlite3($dbname);
/* Prepared Statement creation */
$statement = $db->prepare('SELECT * FROM weather WHERE timestamp > :id;');
/* Bind Value to prepared statement */
$statement->bindValue(':id', $monthago);
/* Results array */
$results = $statement->execute();
/* While loop to extract results array for charting */
while ($row = $results->fetchArray()) {
    $timestamp[] = $row["timestamp"];
    $temperature[] = $row["temperature"];
    $humidity[] = $row["humidity"];
}
/* Close DB Connection */
$db->close();
////////////////////////////////////////////////////////////////
// Organise Data for Graphing
//
/* Load date time data */
$MyData->addPoints($timestamp, "Timestamp");
/* Load Temperature data */
$MyData->addPoints($temperature, "Temperature");
/* Load Humidity data */
$MyData->addPoints($humidity, "Humidity");
/* Set X-Axis */
$MyData->setAbscissa("Timestamp");
/* Set X-Axis name */
$MyData->setXAxisName("Time");
/* Setup Series Y-Axis 0 */
$MyData->setSerieOnAxis("Temperature", 0);