LSModule:MySQL

Overview

This open-source module provides support for MySQL database interaction

Object Types

• mysql
• mysqlresult

Example Usage

/*
 * Require MySQL module during preprocessing, so the variables can be created as part of script structure
 * instead of using DeclareVariable
*/
#if !${LavishScript:LoadModule[MySQL](exists)}
#error MySQL module for LavishScript required.
#endif

function main()
{
   variable mysql DB
   variable mysqlresult Result

/*
 * Connect to db on localhost
 * user/pass: jimmy/jimmys password
 * DB name: db_562
*/
   if !${DB:Connect[localhost,jimmy,jimmys password,db_562](exists)}
   {
      echo Could not connect to MySQL database
      return
   }
   
/*
 * SELECT user_id,user_name,user_email FROM table_users
 * Place result in Result object
*/
  if !${DB:Query["SELECT user_id,user_name,user_email FROM table_users",Result](exists)}
  {
     echo Query failed
     return
  }

  while ${Result:FetchRow(exists)}
  {
     echo User ${Result.GetString[user_id]}: ${Result.GetString[user_name]}
     echo -- Email Address: ${Result.GetString[user_email]}
  }    
}

Downloads

Ready to Install

• LSMMySQL-20090801.LSModule18.zip

Compiled with LSModule v18. Install MySQL.dll to the LavishScript Modules folder. Requires libMySQL.dll be installed

• libmysql-5.1.zip

Don't have libMySQL.dll? Download and extract libMySQL.dll to the Windows System32 folder.

Unofficial LSModule v19 Version

• http://www.cybertech.net/IS/LSMMySQL/LSMMySQL.dll
• http://www.cybertech.net/IS/LSMMySQL/libmysql.dll - libmysql.dll 6.0.2

Source Code

• SVN http://www.isxgames.com/isxScripts/Projects/LSMMySQL

See Also

• MySQL
• LavishScript Modules
• LavishScript