Creation of user defined function

Print
PDF

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;

Add comment

Security code
Refresh

Creation of user defined function - SQLiteManager
Facebook MySpace Twitter Digg Delicious Stumbleupon Google Bookmarks 

Author

SQLiteManager now is managed by the corporation WebInfoPro in order to remake to live this project all while remaining under license GPL

Contact

Vous pouvez nous contacter par email sur sqlitemanager@gmail.com

Who's online?

We have 879 guests online