Difference between revisions of "LSModule:MySQL"
Jump to navigation
Jump to search
| Line 50: | Line 50: | ||
== Downloads == | == Downloads == | ||
=== Ready to Install === | === Ready to Install === | ||
| − | * [http://www.lavishsoft.com/downloads/modules/LSMMySQL- | + | * [http://www.lavishsoft.com/downloads/modules/LSMMySQL-20070919.zip LSMMySQL-20070919.zip] |
: Compiled with LSModule v17. Install MySQL.dll to the LavishScript Modules folder. Requires libMySQL.dll be installed (download below if needed) | : Compiled with LSModule v17. Install MySQL.dll to the LavishScript Modules folder. Requires libMySQL.dll be installed (download below if needed) | ||
* [http://www.lavishsoft.com/downloads/modules/libmySQL.zip libMySQL.zip] | * [http://www.lavishsoft.com/downloads/modules/libmySQL.zip libMySQL.zip] | ||
Revision as of 00:16, 12 October 2008
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 Install
- Compiled with LSModule v17. Install MySQL.dll to the LavishScript Modules folder. Requires libMySQL.dll be installed (download below if needed)
- Don't have libMySQL.dll? Download and extract libMySQL.dll to the Windows System32 folder.
