\n";
function mquery($query){
$result= pg_query($query);
//echo "$query
";
if (!$result) {
$message = 'Invalid query: ' . pg_last_error() . "\n" . 'Whole query: ' . $query . "\n" ;
echo "$message
";
die($message);
}
return $result;
}
$txt = file_get_contents($fname);
$timestamp=time();
$escaped = pg_escape_string($txt);
$query="INSERT INTO geometry (major,minor,data) VALUES ( '$timestamp' , '0' , '{$escaped}' ) ;";
$result = mquery($query);
$query="SELECT * FROM geometry ;";
$result = mquery($query);
$num = pg_num_rows($result);
echo "Total Number of rows in the table geometry $num
\n";
?>