<?php
$db = pg_connect("host=db.test port=5432 dbname=root user=root password=root");

$email = pg_query($db, "SELECT count(0) FROM users WHERE conf_link IS NOT NULL");
$users = pg_query($db, "SELECT count(0) FROM user");

$comments = pg_query($db, "SELECT count(0) FROM comments");