Jump to content

[AJUDA] RETORNANDO VALORES DO BANCO MYSQL


Recommended Posts

Bom, estou usando o banco de dados Mysql com DbConnect() e etc...

Só que ao executa uma query, e esperando o valores requisitado retornarem, só que volta somente o valores true, false or nil... e não os valores que solicitei. Ex: username, password, money e etc...

local Connect = nil

function connect(resource)
    Connect = dbConnect( "mysql", "dbname=ssl;host=127.0.0.1;port=3306;charset=utf8", "root", "" )
    if (not Connect) then
        outputDebugString(getResourceName(resource) .. ": Failed to establish connection to the MySQL database server")

        return true
    else
        outputDebugString(getResourceName(resource) .. ": Connected to the MySQL database server")

        return false
    end
end
addEventHandler("onResourceStart",resourceRoot, connect)

function Query( ... )
    if Connect then
        local query = dbQuery(Connect, ... )
        local result = dbPoll(query, -1) 

        return result
    else
        return false
    end
end

function QuerySingle(str, ...)
    if Connect then
        local result = Query(str, ...)
        
        if type(result) == 'table' then
            return result
        end
    else
        return false
    end
end

function QueryExecute(str, ...)

    if Connect then
        local query = dbExec(Connect, str, ...)

        return query
    else
        return false
    end
end

 

Edited by DeanSouza
Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...