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

Пример #1

Файл: exec.dhcpd-leases.php Проект: articatech/artica

function CreateComputerLogs($ip, $mac, $hostname)
{
    $q = new postgres_sql();
    if (!isset($GLOBALS["dhcpd_hosts_checked"])) {
        $q->CREATE_DHCPD_TABLES();
    }
    $ligne = pg_fetch_array($q->QUERY_SQL("SELECT mac FROM dhcpd_hosts WHERE mac='{$mac}'"));
    $time = date("Y-m-d H:i:s");
    if ($ligne["MAC"] == null) {
        $q->QUERY_SQL("INSERT INTO dhcpd_hosts (MAC,created`,updated,ipaddr,hostname) VALUES('{$mac}','{$time}','{$time}','{$ip}','{$hostname}')");
    } else {
        $q->QUERY_SQL("UPDATE dhcpd_hosts SET ipaddr='{$ip}',hostname='{$hostname}',updated='{$time}' WHERE mac='{$mac}'");
    }
}