| Method | Description | mylayer |
pglayer |
| params(string host , string user , string pass , string database , int port ) | data for the connection to host | yes |
yes |
| connect() | it creates a connection to host and it selects the database | yes |
yes |
| pconnect() | it creates a persistent connection to the host and it selects the database | yes |
yes |
| query_exec(string query ) | it executes the query | yes |
yes |
| query_exec_pg(string query, int record) | it executes the query and it allows the pagination | yes |
yes |
| rs_array() | it gives back an Array with the result | yes |
yes |
| rs_rows() | it gives back the number of lines from last query | yes |
yes |
| current_page() | it gives back the running page | yes |
yes |
| number_page() | total number of page | yes |
yes |
| qstring(string query_string) | query to put in line to the sting query | yes |
yes |
| next_page([string label]) | connection for navigation in the pagination | yes |
yes |
| previous_page([string label]) | connection for navigation in the pagination | yes |
yes |
| all_page() | all pages number | yes |
yes |
| affected_rows() | number of rows of the last operation of INSERT, UPDATE or DELETE interested lines | yes |
no |
| totale_record; | total records | yes |
yes |
| exec_result(int number rows, mix name of field or number of field ) | it gives back the result of last query | yes |
yes |
| select_db(string db name) | name of the database to select | yes |
no |
insert_id() |
value of auto increment rows of last insert operation. |
yes |
no |