Home » Documentation » MySQLDriver

MySQLDriver

The MySQLDriver allows for interaction with MySQL servers.

Constructors

Name Description
Constructor  Initializes a new instance of the MySQLDriver class.
Arguments:
(void)
(ConnectionString)

Destructors

Name Description
Destructor  Closes all open connections on destruction of the object.

Methods

Name Description
Close  Terminates the connection to the host.
Escape  Escapes special characters in the specified string for use in SQL statements.
Arguments:
(Value)
ExecuteNonQuery  Executes SQL statements that do not return data.
GetDataArray  Returns a data array containing data queried from the host.
GetDataRow  Returns a data row containing data queried from the host.
GetDataSet  Returns a data set containing data queried from the host.
GetDataString  Returns a string containing data returned from the host and optionally prepends and appends returned data with the specified arguments.
Arguments:
(void)
(RowSeperatedBy)
(RowSeperatedBy, FieldsSeperatedBy)
(RowSeperatedBy, FieldsSeperatedBy, FieldsEnclosedBy)
(RowSeperatedBy, FieldsSeperatedBy, FieldsEnclosedBy, ReturnHeaders)
GetDataTable  Returns a data table containing data returned from the host.
GetFoundRows  Returns the number of found rows from the last query executed.
GetLastInsertID  Returns the last inserted auto increment column number.
GetResultSet  Returns a result set containing data queried from the host.
Open  Opens a connection to the host.
SQLKey  Replaces a specified string with another within the SQLCommand property.
Arguments:
(Key, Value)

Properties

Name Description
ConnectionString  Gets and sets the connection string used to connect to the host.
Host  Gets and sets the host address.
MyConnection  Stores the object used to interact with the remote host.
Password  Gets and sets the password used to authenticate with the host.
Schema  Gets and sets the schema name used in this instance.
SQLCommand  Gets and sets the SQL statements used in this instance.
Username  Gets and sets the username used to authenticate with the host.

Learn

About WebLegsDocumentation

Community

DiscussionsLogin

Contribute

ContributorsWebLegs @ GitHub

Download

PHP, Perl, C#, VB, Java, JS.
WebLegs is proud to be an open source
project, licensed under the GPLv3.
Copyright © 2003-2010 - WebLegs® is a registered trademark of WebLegs, Inc.
Are you a robot?
Your Email:
Create a Username:
Create a Password:
Forgot Password?
Validate Text: Captcha