PHP save_static_db_in_storage примеры использования

Пример #1

Файл: gpio_control.php Проект: krisjanis-gross/remote-pi

function save_pin_status($pin_nr,$command,$save_db_to_storage) {

	// save DB
	$static_db = open_static_data_db();
	$results = $static_db->query('update pins set enabled = ' . $command . ' where id = ' . $pin_nr . ' ;');
	$static_db->close();
	if ($save_db_to_storage) save_static_db_in_storage();

}

Пример #2

Файл: json_encrypted_API.php Проект: krisjanis-gross/remote-pi

function save_trigger($trigger_id, $description)
{
    $static_db = open_static_data_db();
    //error_log(">>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>" . $trigger_id .  $description);
    if ($trigger_id == 0) {
        $results = $static_db->query('INSERT INTO triggers values (NULL,"' . $description . '",0);');
    } else {
        $results = $static_db->query('UPDATE triggers SET `description` = "' . $description . '" where `id` = ' . $trigger_id . ';');
    }
    $static_db->close();
    save_static_db_in_storage();
}