LSModule:MySQL
Jump to navigation
Jump to search
Contents
Overview
This open-source module provides support for MySQL database interaction
Object Types
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 Run
- Place the following files in your "InnerSpace\LavishScript Modules" folder
- https://svn.isxgames.com/isxScripts/Projects/LSMMySQL/Bin/Release/LSMMySQL.dll
- https://svn.isxgames.com/isxScripts/Projects/LSMMySQL/mysql-connector-c-6.1.1-win32/lib/libmysql.dll
Source Code
- Visual Studio 2012 Project, using Visual Studio 2010 platform, and MySQL Connector 6.1.1 (included)