Mysql query

[toujour]

Hi,

  where can I find an "how to" for mysql integration ?

For example:
I want insert/read some values in a remote database (in the same LAN).

If there is an example it'll be appreciate.

BR,
Alberto

[Daniel]

Look here, make sure you install correct packages as this thread is very old
https://forum.logicmachine.net/showthrea...797#pid797

[toujour]

thanks for your reply but I don't find the correct link in that thread...all the links are offline (404).
Can you check it, please ?

[Daniel]

Extra packages are always below the firmware links
https://dl.openrb.com/lm-23-imx6/pkg/

[toujour]

ok....and the docs about it, please ?

[admin]

https://forum.logicmachine.net/showthread.php?tid=193

[toujour]

ok, this for request (it works with luamysql package).

Code:

require('luasql.mysql')

env = luasql.mysql()
dbcon = env:connect(DB_NAME, USERNAME, PASSWORD, MYSQL_SERVER_IP, MYSQL_SERVER_PORT)
cursor = dbcon:execute('SELECT * FROM mytable')

while true do
  row = cursor:fetch({}, 'a')

  if row then
    log(row)
  else
    break
  end
end

cursor:close()
dbcon:close()
env:close()