<?
header("Content-type: text/html; charset=utf-8");
$db_debug = false;
function microtime_float()
{
    list($usec, $sec) = explode(" ", microtime());
    return ((float)$usec + (float)$sec);
}


function dummy()
{
    return rand(0, 2000000000);
}

$handle=NULL;
$result=NULL;
$connected = 0;

function db_connect()
{
    global $handle;
    global $connected;
    
    $connected++;
    
    if ($connected > 1) 
      return;

    $handle = pg_connect("host=localhost port=5432 dbname=cupman_lsp user=cupman_devdev password=potatisgris13");
    
    
    //  mysql_selectdb("database") or die("Kunde inte välja databas");
}

function db_disconnect()
{
  global $handle;
  global $connected;
  
  $connected--;
  
  if ($connected > 0)
    return;

  pg_close($handle);
}

function db_query( $query )
{
    global $connected;
    
    if ($connected == 0)
      return; 
    
    $start = microtime_float();
    
    $res = pg_query( $query ) or die("Misslyckades med fråga: $query" . pg_last_error());
    
    $end = microtime_float();
    $time = $end-$start;
    global $db_debug;
    if ($db_debug) // && ($time >= 0.099))
      echo "<!-- $time :: $query -->";
    
    return $res;
}

function db_execquery( $query )
{
  db_connect();
  db_query($query);
  db_disconnect();
}


function db_retrieve($query) 
{
  db_connect();
  $res = db_query($query);
  $arr= array();
  while ($row = pg_fetch_array($res))
  {
    $arr[] = $row;
  }
  db_disconnect();
  return $arr;
}

function db_get($query)
{
  db_connect();
  $res = db_query($query);
  $arr= array();
  $row = pg_fetch_array($res);
  db_disconnect();
  return $row;
}

function db_getvalue($query)
{
    $row = db_get($query);
    return $row[0];
}

function db_id()
{
    return db_getvalue("SELECT currval('entitySeq')");
}

?>