---

postgres.php File Reference

Go to the source code of this file.

Functions
	dati_sql ($array,$not_null=0,$is_expression=0,$dati='',$default_not_null=0)
	format sql varibles
	insert_sql ($tbSchema='public',$table_name,$array,$not_null=0,$is_expression=0,$dati='',$default_not_null=0)
	format sql insert query
	update_sql ($tbSchema='public',$table_name,$array,$not_null=0,$is_expression=0,$dati='',$default_not_null=0)
	format sql update query
	where_sql ($array,$operator='=',$logic='AND',$tbSchema='public',$tbName='',$not_null=0,$is_expression=0,$dati='',$default_not_null=0)
	format sql where query
	isopostgis ($coord,$type)
	create postig type from array of coordinates and geometry type
	get_table_attributes ($conn,$table,$field= '',$result_type1=PGSQL_ASSOC,$result_type2=PGSQL_BOTH,$namespace= 'public')
	Retrieve the attribute definition of a table.

---

Function Documentation

dati_sql (  $    array, $    not_null = 0, $    is_expression = 0, $    dati = '', $    default_not_null = 0 )

format sql varibles formatta i dati aggiungendo apici se servono o settando a NULL le variabili vuote, o lasciandole vuote se co�ì specificato dal terzo parametro della funzione Parameters: array  sql data not_null=0  var or array that indicates if all or a variable could be a void string or must be NULL dati=  '' name of key of $array to parse (default all) default_not_null=0  if you set $could_be_void as an array, but not for all the values, this set remanent values is_expression=0  var or array that indicates if all or a variable is a sql expression or a value to be enclose into 2 " Returns: parsed array Definition at line 35 of file postgres.php. Referenced by insert_sql(), update_sql(), and where_sql().

get_table_attributes (  $    conn, $    table, $    field = '', $    result_type1 = PGSQL_ASSOC, $    result_type2 = PGSQL_BOTH, $    namespace = 'public' )

Retrieve the attribute definition of a table. Parameters: conn  connection resource table  The name of the table field  (optional) The name of a field to return result_type1  one of predef. constant PGSQL_BOTH, PGSQL_ASSOC , PGSQL_NUM for pg_query() function (for first dimension key of array) result_type2  one of predef. constant PGSQL_BOTH, PGSQL_ASSOC , PGSQL_NUM for pg_query() function (for second dimension key of array) namespace=  'public' name of postgres schema Returns: associative array attributes in order Definition at line 223 of file postgres.php. References table.

insert_sql (  $    tbSchema = 'public', $    table_name, $    array, $    not_null = 0, $    is_expression = 0, $    dati = '', $    default_not_null = 0 )

format sql insert query formatta i dati aggiungendo apici se servono o settando a NULL le variabili vuote, o lasciandole vuote se co�ì specificato dal terzo parametro della funzione Parameters: array  sql data table_name  not_null=0  var or array that indicates if all or a variable could be a void string or must be NULL dati=  '' name of key of $array to insert (default all) default_not_null=0  if you set $not_null as an array, but not for all the values, this set remanent values is_expression=0  var or array that indicates if all or a variable is a sql expression or a value to be enclose into 2 " Returns: parsed sql query Definition at line 92 of file postgres.php. References dati_sql(). Referenced by Pgdb::insert().

isopostgis (  $    coord, $    type )

create postig type from array of coordinates and geometry type Parameters: coord  bidimensional array [east] and [north] or monodimensional if type is point Returns: postgis string Definition at line 198 of file postgres.php.

update_sql (  $    tbSchema = 'public', $    table_name, $    array, $    not_null = 0, $    is_expression = 0, $    dati = '', $    default_not_null = 0 )

format sql update query formatta i dati aggiungendo apici se servono o settando a NULL le variabili vuote, o lasciandole vuote se co�ì specificato dal terzo parametro della funzione Parameters: array  sql data table_name  not_null=0  var or array that indicates if all or a variable could be a void string or must be NULL dati=  '' name of key of $array to parse (default all) default_not_null=0  if you set $not_null as an array, but not for all the values, this set remanent values is_expression=0  var or array that indicates if all or a variable is a sql expression or a value to be enclose into 2 " Returns: parsed sql query Definition at line 128 of file postgres.php. References dati_sql(). Referenced by Pgdb::update().

where_sql (  $    array, $    operator = '=', $    logic = 'AND', $    tbSchema = 'public', $    tbName = '', $    not_null = 0, $    is_expression = 0, $    dati = '', $    default_not_null = 0 )

format sql where query formatta i dati aggiungendo apici se servono o settando a NULL le variabili vuote, o lasciandole vuote se co�ì specificato dal terzo parametro della funzione Parameters: array  sql data array operator=  '=' one operator for all or associative array of operators logic=  'AND' logic opertor to use not_null=0  var or array that indicates if all or a variable could be a void string or must be NULL dati=  '' name of key of $array to parse (default all) tbName=  '' var or array of table names of all or each field(used in query with more fields of different columns that haves the same name) default_not_null=0  if you set $not_null as an array, but not for all the values, this set remanent values is_expression=0  var or array that indicates if all or a variable is a sql expression or a value to be enclose into 2 " Returns: parsed sql query Definition at line 162 of file postgres.php. References dati_sql(). Referenced by Pgdb::delete(), Pgtable::search(), and Pgdb::update().

---