Scripting/Squirrel/Functions/mysql connect: Difference between revisions
Jump to navigation
Jump to search
This wiki is using an old backup from 2020
Some information may be old/missing
No edit summary |
m (Add argument type declaration and cleanup the example.) |
||
| (One intermediate revision by one other user not shown) | |||
| Line 2: | Line 2: | ||
== Syntax == | == Syntax == | ||
<source lang=squirrel> | |||
< | mysql_connect( host, dbuser, dbpassword, dbname); | ||
</source> | |||
== Arguments == | == Arguments == | ||
* ''string'' '''host''' - The host of the MySQL database (Most cases "localhost") | |||
* '''host''' - The host of the MySQL database (Most cases "localhost") | * ''string'' '''dbuser''' - The MySQL user name. | ||
* '''dbuser''' - The MySQL user name. | * ''string'' '''dbpassword''' - The MySQL user password. | ||
* '''dbpassword''' - The MySQL user password. | * ''string'' '''dbname''' - The MySQL database name. | ||
* '''dbname''' - The MySQL database name. | |||
== Example == | == Example == | ||
<source lang=squirrel> | |||
<source lang=squirrel>function onScriptLoad() | function onScriptLoad() { | ||
{ | db <- mysql_connect( "localhost", "vcmp", "test123", "vcmpdb"); | ||
} | |||
}</source> | </source> | ||
=== Notes === | === Notes === | ||
You can also remotely connect to a MySQL database, replace "localhost" with the remote host IP and make sure the host accepts remote connections. | You can also remotely connect to a MySQL database, replace "localhost" with the remote host IP and make sure the host accepts remote connections. | ||
== Related Functions == | == Related Functions == | ||
{{Scripting/Squirrel/Functions/ | {{Scripting/Squirrel/Functions/MySQL Functions}} | ||
[[Category:Scripting/Squirrel/Functions/Mysql_Functions]] | [[Category:Scripting/Squirrel/Functions/Mysql_Functions]] | ||
Latest revision as of 10:30, 26 April 2019
This function will connect to a MySQL database on the server.
Syntax
mysql_connect( host, dbuser, dbpassword, dbname);Arguments
- string host - The host of the MySQL database (Most cases "localhost")
- string dbuser - The MySQL user name.
- string dbpassword - The MySQL user password.
- string dbname - The MySQL database name.
Example
function onScriptLoad() {
db <- mysql_connect( "localhost", "vcmp", "test123", "vcmpdb");
}Notes
You can also remotely connect to a MySQL database, replace "localhost" with the remote host IP and make sure the host accepts remote connections.