function metadata($table = "") { $count = 0; $id = 0; $res = array(); if ($table) { $this->connect(); $id = pg_exec($this->Link_ID, "SELECT * FROM {$table}"); if ($id < 0) { $this->Error = pg_ErrorMessage($id); $this->Errno = 1; $this->halt("Metadata query failed."); } } else { $id = $this->Query_ID; if (!$id) { $this->halt("No query specified."); } } $count = pg_NumFields($id); for ($i = 0; $i < $count; $i++) { $res[$i]["table"] = $table; $res[$i]["name"] = pg_FieldName($id, $i); $res[$i]["type"] = pg_FieldType($id, $i); $res[$i]["len"] = pg_FieldSize($id, $i); $res[$i]["flags"] = ""; } if ($table) { pg_FreeResult($id); } return $res; }
function metadata($table) { $count = 0; $id = 0; $res = array(); $this->connect(); $id = pg_exec($this->Link_ID, "select * from {$table}"); if ($id < 0) { $this->Error = pg_ErrorMessage($id); $this->Errno = 1; $this->halt('Metadata query failed.'); } $count = pg_NumFields($id); for ($i = 0; $i < $count; $i++) { $res[$i]['table'] = $table; $res[$i]['name'] = pg_FieldName($id, $i); $res[$i]['type'] = pg_FieldType($id, $i); $res[$i]['len'] = pg_FieldSize($id, $i); $res[$i]['flags'] = ''; } pg_FreeResult($id); return $res; }
function metadata($table) { $count = 0; $id = 0; $res = array(); $this->connect(); $id = pg_exec($this->Link_ID, "select * from {$table} LIMIT 1"); if ($id < 0) { $this->Error = pg_ErrorMessage($id); $this->Errno = 1; $this->Errors->addError("Metadata query failed: " . $this->Error); return 0; } $count = pg_NumFields($id); for ($i = 0; $i < $count; $i++) { $res[$i]["table"] = $table; $res[$i]["name"] = pg_FieldName($id, $i); $res[$i]["type"] = pg_FieldType($id, $i); $res[$i]["len"] = pg_FieldSize($id, $i); $res[$i]["flags"] = ""; } pg_FreeResult($id); return $res; }
function metadata($table) { $count = 0; $id = 0; $res = array(); $this->connect(); $id = pg_exec($this->Link_ID, "select * from {$table}"); if ($id < 0) { $this->Error = pg_ErrorMessage($id); $this->Errno = 1; $this->halt("Metadata query failed."); } $count = pg_NumFields($id); for ($i = 0; $i < $count; $i++) { $res[$i]["table"] = $table; $name = pg_FieldName($id, $i); $res[$i]["name"] = $name; $res[$i]["type"] = pg_FieldType($id, $i); //zot: phplib is wrong, $name in field size should be $i //Mike got the line above corrected. $res[$i]["len"] = pg_FieldSize($id, $i); $res[$i]["flags"] = ""; } pg_FreeResult($id); return $res; }