Handling data files in PHP

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help

Develop in PHP

Handling data files in PHP

Overview

Handling the MySQL, Oracle or PostgreSQL data files

Handling data files via ODBC

See also

Handling data files in PHP

Overview

WEBDEV allows you to create a PHP site that handles data files:

in MySQL format. This data can be handled by the SQL functions of WLanguage or by the HFSQL functions of WLanguage. A MySQL database is required.
via ODBC. This data can be handled by the SQL functions of WLanguage. You have the ability to handle a data source in HFSQL Classic or HFSQL Client/Server format defined in the ODBC administrator.
in PostgreSQL format. This data can be handled by the SQL functions of WLanguage or by the HFSQL functions of WLanguage. A PostgreSQL database is required and the php_pgsql extension must be enabled in the php.ini file.
in Oracle format. This data can be handled by the SQL functions of WLanguage or by the HFSQL functions of WLanguage. An Oracle database is required, the php_oci8 extension must be enabled in the php.ini file and the Oracle client layer must be found on the server.

Remark: Prerequisite:

PHP 5 servers: Minimum recommended version: version 5.3.
PHP 7 servers: Minimum recommended version: version 7.0.22.
PHP 8 servers: Minimum recommended version: version 8.0.10.

Handling the MySQL, Oracle or PostgreSQL data files

To handle the MySQL, Oracle or PostgreSQL data files in PHP with the HFSQL functions:

The type of the data files described in the project analysis must correspond to the targeted database. The connection to the server is described in the analysis.

If this condition is fulfilled, the data files can be directly handled by the HFSQL functions available in PHP.

The browsing Table controls created in the editor are directly linked to the data files described in the data model editor.

Remarks

The use of HFSQL functions on queries with the PHP/MySQL access requires a MySQL server version 4.1 or later.
When reading records in a query (with HReadFirst and HReadNext, for example), the query may executed multiple times.
The names of the files and items found in the database must contain no accented characters and no space characters.
Using queries with parameters: If the SQL code of the query was not entirely generated by the query editor, the name of the query parameters must have the following format: {paramX} where X is the number of the parameter in the order of appearance in the query.
Example: SELECT LastName, FirstName FROM Customer WHERE LastName={Param1} AND FirstName={Param2}

The following functions are currently available in PHP:


FileToPage	Automatically updates the controls of a page with: the values of the bound items in the current record (loaded in memory) of the data file described in the data model editor. This operation is performed regardless of the state of the controls (grayed, inactive or invisible). the values of the bound WLanguage variables. This operation is performed regardless of the state of the controls (grayed, inactive or invisible).
FileToScreen	Automatically updates the controls in a window or page with: the values of the bound items in the current record (loaded in memory) of the data file described in the data model editor. the values of the bound WLanguage variables. This operation is performed regardless of the state of the controls (grayed, inactive or invisible).
HActivateFilter	Enables the filter that was previously created for the specified data file (view or query).
HAdd	Adds: the record found in memory into the data file (query or view). the record found in a Record variable into the data file (query or view).
HBackward	Moves backward several records from the current position in the data file, according to a specified item.
HBuildKeyValue	Builds the value of a composite key to implement a filter (HFilter) or to perform a search (HReadSeekFirst, HReadSeekLast, etc.).
HCancelDeclaration	Used to: Delete a declaration made previously using HDeclare, HDeclareExternal, HDescriveFile. After this operation, the data file is no longer recognized by the HFSQL engine. Free the resources of a query (after calling HExecuteQuery or HExecuteSQLQuery).
HCancelSeek	Cancels the current search criterion.
HChangeConnection	Dynamically changes the connection associated with a data file.
HClose	Closes a data file or all the data files opened by the current user: all the corresponding physical data files are closed for the current user.
HCloseConnection	Closes a connection to a database.
HCreation	Creates an empty data file (".FIC" extension) with the index file and the memo file if necessary.
HCreationIfNotFound	Performs the following operations: If the file does not exist, creates an empty data file (".FIC" file) with the index file and the memo file if necessary. The function is equivalent to HCreation. If the file exists, opens the file.
HDeactivateFilter	Temporarily disables the filter on a data file (view or query).
HDelete	Deletes a record from a data file (query or view).
HDescribeConnection	Describes a new connection to an external database.
HError	Returns the number of the last error triggered by the HFSQL engine.
HErrorDuplicates	Used to check whether a duplicate error occurred.
HErrorInfo	Returns a detailed information about the last error triggered by the HFSQL engine.
HExecuteQuery	Declares a query created in the query editor to the HFSQL engine and runs this query.
HExecuteSQLQuery	Initializes a query written in SQL language and declares this query to the HFSQL engine.
HExtractMemo	Extracts the content of a binary memo item from an HFSQL file, a query or an HFSQL view to a physical file (on disk).
HFilter	Defines and enables a filter on a data file, view or query.
HFilterIdentical	Defines and enables a filter used to find the exact value of a string item.
HFilterStartsWith	Defines and enables a "Start with" filter on a file, view or query.
HForward	Moves several records forward from the current position in the data file, according to a specified item.
HFound	Checks whether the current record corresponds to the current filter or search.
HFreePosition	Deletes a position saved by HSavePosition.
HGetCurrentPosition	Returns the approximate position of current record in the data file.
HLinkMemo	Used to associate a file with a binary memo item or to cancel the existing link between a file and a binary item.
HListConnection	Returns the list of connections currently described in the application.
HListDatabase	Lists the Client/Server databases associated with a connection.
HModify	Modifies the specified record or the record found in memory in the data file (query or view).
HNbRec	Returns the number of records in a file, query or HFSQL view: active records, crossed records, deleted records, etc.
HOpen	Opens a data file.
HOpenConnection	Opens a connection to a specific database.
HOut	Used to find out whether the record on which you want to be positioned is located outside the data file, filter, view or query.
HReadFirst	Sets the position on the first record according to a browse item.
HReadLast	Sets the position on the last record of a data file according to a browse item.
HReadNext	Sets the position on the next data file record according to a browse item.
HReadPrevious	Sets the position on the previous record of a file according to a browse item.
HReadSeek	Sets the position on the first record whose value for a specific item is greater than or equal to a sought value (generic search).
HReadSeekFirst	Sets the position on the first record whose value for a specific item is strictly equal to a sought value (exact-match search).
HReadSeekLast	Sets the position on the last record whose value for a specific item is less than or equal to a sought value (exact-match search).
HReset	Initializes: one or all variables of file items with their default values. one or all items of a Record variable with their default values.
HRestorePosition	Restores the context of a previously saved file (HSavePosition): current record, filter, pointers.
HSavePosition	Stores the current file context: current record, filter, pointers.
ScreenToFile	Automatically initializes: the memory value of the a data file fields with the value of the fields in the window. the value of the WLanguage variables with the value of the window controls. This function is also available for WEBDEV pages.

Handling data files via ODBC

To handle data files via ODBC:

Define an ODBC data source.
To create a data source on HFSQL Classic or Client/Server files, see ODBC driver on HFSQL Classic and Client/Server.
Remark: To use the SQL functions in PHP, you must define a "system" ODBC data source (and not a "user" ODBC data source).
Use SQLConnect to connect to the database. In this case, the type of the database is "ODBC".
Use the SQL functions to handle your data.