Script to automate an import process from .json file to postgre DB.

json_to_postgre.php

<?php 
	# Configure
	$DB_USER = 'admin';
	$DB_PASS = 'qwerty';
	$DB_HOST = 'localhost';
	$DB_NAME = 'postgis-2-0';
	// Param 3 when ran in shell will override this value
	$DB_TABLE = 'public.florida_establishments_garman'; 
	// Param 2 when ran in shell will override this value
	$CATEGORY = 'misc';
	
	// ===============================
	// = Do NOT Edit Below This Line =
	// ===============================
	
	# Params
	$CURRENT_SCRIPT = $argv[0];
	$JSON_FILE = $argv[1];
	$CATEGORY = isset($argv[2]) ? $argv[2]:$CATEGORY;
	$POSTGRE_TABLE = isset($argv[3]) ? $argv[3]:$DB_TABLE;
		
	# Open our file
	$f = file_get_contents($JSON_FILE);
	
	# Make sure file is good
	if( $f === FALSE )
	{
		die('Could not open file.');
	}
	# Open Postgre Connections
	else
	{
		$dbconn = pg_connect("host=$DB_HOST dbname=$DB_NAME user=$DB_USER password=$DB_PASS")
		    or die('Could not connect: ' . pg_last_error());
	}
	
	# Decode JSON into array
	$points = json_decode( $f, true );
	
	# Iterate our points
	foreach($points as $p)
	{
		/*
			$p['Latitude']
			$p['Longitude']
			$p['Establishment']
			$p['Address_Phone']
		*/
		# Sanatize
		$est = str_replace("'","\'",$p['Establishment']);
		$add = str_replace("'","\'",$p['Address_Phone']);
		
		# Insert into DB
		pg_query($dbconn,"INSERT INTO $POSTGRE_TABLE (establishment,address_phone,category,location) VALUES ( '".$est."', '".$add."', '".$CATEGORY."',ST_Makepoint(".$p['Latitude'].",".$p['Longitude'].")  )") or die("Could not execute this insert statement: ".pg_last_error());
	}
?>

hola buenas tardes disculpa hice lo mismo que en tu codigo pero ahora necesito que al guardar varios datos mas en el json se inserten en la base de datos pero me toma el primer valor y no me deja introducirlo como le hago para comparar o que ya no lea los que ya están insertados.