Sign in to follow this  
ProFes

[QUESTION] About dbConnect

Recommended Posts

Hello. Use MySQL connection, all work perfect. But, how I can use dbQuery from another resource? Or I need always use dbConnect before dbQuery?

local dbname = <Server DBname>
local host = "127.0.0.1" 
local username = <Server Username> 
local password = <Server Password> 

function connectToDatabase()
	DB = dbConnect( "mysql", "dbname="..dbname..";host="..host..";charset=utf8", username, password, "share=1" ) 
end
addEventHandler("onResourceStart", getResourceRootElement(getThisResource()), connectToDatabase, false)

Should I use exports and... ?

Share this post


Link to post

Solved.

Use return DB in connectToDatabase function and local db = exports.MySQL:connectToDatabase() on another resource as db name;

Share this post


Link to post

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
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.