Question

[FlyingSpoon]

So I want to get some data from my database and insert it into a table or make it into a table so I can run a few things e.g.

local general = {}

addEventHandler("onResourceStart", root,
function()
	local q = dbQuery(connection, "SELECT * FROM table")
	local r = dbPoll(q, -1)
	
	general = {
	{r["first"], r["second"]}
	}
end)

function run()
for i, v in ipairs(general) do
  	outputChatBox(v[1].." - "..v[2], player)
end
addCommandHandler("runme", run)

How would I go about doing this?

[NeXuS™]

addEventHandler("onResourceStart", root,
function()
	local q = dbQuery(function(nrQ)
		local rQ = dbPoll(nrQ, 0)
		for i, k in pairs(rQ) do
			table.insert(general, {k["first"], k["second"]})
		end
	end, connection, "SELECT * FROM table")
end)

I'd never use dbPoll with -1 timeout, as it can cause freezes. dbPoll returns a table of all data,

{
	{
		["first"] = "first", 
		["second"] = "second"
	}, 
	{
		...
	},  
	{
		...
	}
}

so you have to loop through it.

Edited February 11, 2018 by NeXuS™

[FlyingSpoon]

Worked, but why is the loop as a variable?

local q = dbQuery(function(nrQ))

And what is nrQ?

 

[FlyingSpoon]

Oh I get the dbQuery part now,

handle dbQuery ( [ function callbackFunction, [ table callbackArguments, ] ] element databaseConnection, string query [, var param1 [, var param2 ...]] )

That you can enter a function before the connection, I didn't know that. Is nrQ the query?

 

[NeXuS™]

Yes, nrQ is the query.