Mysql access from lp file

[jmir]

You can use MySQL functions in .lp, but it might cause problems if the db server is not available as .lp should not contain any blocking code. Alternatively if you don't need data in real time you can fetch data from MySQL via a script, save data into storage and display it via .lp.
There's no completely secure way to hide the credentials. You should limit db user privileges to only functions/tables that are needed.

I've done as you say, using a script and saving data into storage.

Doing like this there is a little issue... in the page there is a date button (used to compose the sql sentence) and a retrieve data button (to execute the script to fecth sql data and save in storage), if two users have the page loaded at the same time, the values change form both...