LSModule:MySQL:mysql (Object Type)

From Lavish Software Wiki
Jump to: navigation, search

Description

Object Type Vitals
mysql
Defined By MySQL Module
Inherits none
Reduces To NULL
Variable Object Type mysql
Uses Sub-Types no
C/C++ Type MYSQL *

A MySQL database connection

Members

  • bool Connected: TRUE if connected to a database
  • uint AffectedRows: Number of rows affected by the previous query (see mysql_affected_rows() documentation)
  • uint InsertID: Insert ID of an insert that used auto_increment (see mysql_insert_id() documentation)

Methods

  • Connect[host,user,pass,db]: Connect to MySQL database db on host with user/pass, using the default MySQL port
  • Connect[host,user,pass,db,port]: Connect to MySQL database db on host:port with user/pass
  • Ping: Pings the MySQL server (see mysql_ping() documentation)
  • Query[sql]: Performs the given query, ignoring any result set
  • Query[sql,mysqlresult object]: Performs the given query, initializing the given mysqlresult object with the result

See Also