Core Function MySQLConnect - Revision history

UberFoX: 1 revision

2015-06-14T12:38:54Z

1 revision

← Older revision

Revision as of 12:38, 14 June 2015

UberFoX: 1 revision

2014-08-11T21:40:42Z

1 revision

← Older revision

Revision as of 21:40, 11 August 2014

UberFoX: /* Example */

2014-07-30T01:35:35Z

Example

← Older revision		Revision as of 01:35, 30 July 2014
Line 66:		Line 66:
	println("Failed to get data...");		println("Failed to get data...");
	}		}
−	~~MySQLClose($CONN);~~
	}		}
	Else		Else
Line 72:		Line 71:
	println("Failed to select db...");		println("Failed to select db...");
	}		}
		+	MySQLClose($CONN);
	}		}
	Else		Else

Alexpja: /* Remarks */

2011-12-11T06:32:59Z

Remarks

← Older revision		Revision as of 06:32, 11 December 2011
Line 33:		Line 33:
	=== Remarks ===		=== Remarks ===

−	Sputnik includes an easy to use built-in MySQL support since i use SQL a lot in my scripts.	+	Sputnik includes an easy to use built-in MySQL support since I use SQL a lot in my scripts.

	=== Example ===		=== Example ===

UberFoX: Created page with "

 MySQLConnect( , ,  )

=== Description === Connect to a MySQL database. === Parameters === ==== ip/ip:port ==== The IP example "127.0..."

2011-12-01T18:31:07Z

Created page with "<pre> MySQLConnect( <ip/ip:port>, <login>, <password> ) </pre> === Description === Connect to a MySQL database. === Parameters === ==== ip/ip:port ==== The IP example "127.0..."

New page

<pre>
MySQLConnect( <ip/ip:port>, <login>, <password> )
</pre>

=== Description ===

Connect to a MySQL database.

=== Parameters ===

==== ip/ip:port ====

The IP example "127.0.0.1"

OR

The IP and port example "127.0.0.1:3016"

==== login ====

The MySQL login to use for the connection.

==== password ====

The MySQL password to use for the connection.

=== Return Value ===

Success: Returns the MySQL object.

Failure: Returns 0.

=== Remarks ===

Sputnik includes an easy to use built-in MySQL support since i use SQL a lot in my scripts.

=== Example ===

<syntaxhighlight lang="sputnik">
$CONN = MySQLConnect("127.0.0.1", "root", "777");
If($CONN)
{
println("Connected...");
If(MySQLSelectDB($CONN, "sp2"))
{
//MySQLQuery("UPDATE bla bla bla....");
//MySQLQuery("INSERT bla bla bla....");
println("Selected db...");
$Data = MySQLFill($CONN, "SELECT * FROM players");
If($Data)
{
println("Got data...");
$Fields = MySQLFields($Data);
$Rows = MySQLRows($Data);
println("Data has '$Fields' Field(s) and '$Rows' Row(s)...");
While( $Row = MySQLFetch($Data) )
{
$Name = $Row["Name"];
$Pass = $Row["Pass"];
println("Name '$Name' Pass '$Pass'");
}
//MySQLFetchReset($Data); //Uncomment if you wish to loop through this table again
}
Else
{
println("Failed to get data...");
}
MySQLClose($CONN);
}
Else
{
println("Failed to select db...");
}
}
Else
{
println("Failed to connect...");
}
</syntaxhighlight>

[[Category:Core Function]]