COLUMNNAMES: manages columns' names. More...

Functions
	getColumNames ($t_conn_res)
	Returns the name of the colums in a data table. More...

Variables
	$response = array("errors" => array())
	Prepare default response array with no errors. More...

	$nodetypes = array("0" => "t_type0_data")

Detailed Description

COLUMNNAMES: manages columns' names.

Client perspective:

GET METHOD --> returns columns' names

Description

This script sets the returned content type to JSON, includes the db_connection.php script

It is used to connect to MySQL and execute basic SELECT queries

and then defines the response array.

One function is defined:

 getColumNames()

Returns the name of the colums in a data table.

If the script isn't included it tries to connect to the database, and checks the request method:

if the method is GET it calls the getColumNames() function

When the called function ends the connection to the DB gets terminated, and data (or errors) is collected inside the response array. The response array gets echoed to the client in JSON format

Errors list:

1000 - main: Method not supported by the target resource
1001 - main: No data but also No errors
1010 - getColumNames(): Query returned nothing
1011 - getColumNames(): Error executing query
1012 - getColumNames(): Nodetype not recognised
1013 - getColumNames(): typeid is not set in request

Since: 01_01

Author: Stefano Zenaro (https://github.com/mario33881)

Copyright: MIT

Function Documentation

◆ getColumNames()

getColumNames ( $t_conn_res )

Returns the name of the colums in a data table.

First it checks that typeid is set both in the request and in the $nodetypes array, then a SELECT query is executed to retrieve the column names.

Parameters

array $t_conn_res array with the DB connection object

Returns: array $action_res array with errors or data

Variable Documentation

◆ $nodetypes

$nodetypes = array("0" => "t_type0_data")

◆ $response

$response = array("errors" => array())

Prepare default response array with no errors.

Functions