Creation of user defined function

Print

To add a new user defined function, click on the link on the properties page of the database. sqlitemanager_function1.png


You are now on the screen to create this function.
There are two types of user function:
The functions of standard treatment
The group functions in this case two functions must be defined, a function will be called at each line, the other will be at the end to finalize the result it is up to you to manage context.


sqlitemanager_function2.png -> sqlitemanager_function3.pngsqlitemanager_function4.png


Enter the code of your function by failing PHP tags ().
Remember to enter the number of arguments expected by your office. sqlitemanager_function5.png

sqlitemanager_function6.png


To use:
sqlitemanager_function7.png -> sqlitemanager_function8.png


Note that for all standard PHP functions there is a method to call without first declaring:
eg md5 function you can type in SQL: SELECT php ( 'md5', 'value') FROM label;