Garry's Mod Wiki

Home / sql.Query

sql.Query

  table or boolean or nil sql.Query( string query )
Search Github

Description

Performs a query on the local SQLite database, returns a table as result set, nil if result is empty and false on error.

To run SQL queries with this function safely, it is crucial to ensure that the concatenated variables in the query string are safe to avoid vulnerabilities like SQL injections. For this, it is recommended to use the sql.SQLStr, which allows arguments to be escaped correctly.

Arguments

1 string query
The query to execute.

Returns

1 table or boolean or nil
false is returned if there is an error, nil if the query returned no data.

Example

Functions that are examples of saving and creating information into the database.

function CreateTable() sql.Query("CREATE TABLE IF NOT EXISTS player_data ( SteamID64 INTEGER PRIMARY KEY, Money INTEGER )") end function SavePlayerToDataBase(ply, money) sql.Query("INSERT OR REPLACE INTO player_data ( SteamID64, Money ) VALUES ( " .. ply:SteamID64() .. ", " .. money .. " )") end function LoadPlayerFromDataBase(ply) return sql.QueryValue("SELECT Money FROM player_data WHERE SteamID64 = " .. ply:SteamID64()) end

Account Management

Special Pages

Wiki List