.\" This man page is automatically generated using
.\" kayadoc2man from the Kaya development tools and the -xmldocs compile 
.\" option. Editing it directly is not encouraged.
.\" It is under the same license as the source .k file that it was
.\" generated from.
.TH "MyDB.connect" "3kaya" "August 2014" "Kaya" "Kaya module reference"
.SH "NAME"
MyDB::connect \- Connect to a database.
.SH "SYNOPSIS"
.B MyDB connect(
\fIString host, String user, String pwd, String db, Int port=0\fP
.B ")"
.SH "ARGUMENTS"
.PP
.B "host"
The database host to connect to
.PP
.B "user"
The database user to connect as
.PP
.B "pwd"
The password for that user
.PP
.B "db"
The database to connect to
.PP
.B "port"
The port that the database server is running on. This defaults to zero, which is suitable when connecting to a server on 'localhost'. The usual MySQL port for remote servers is 3306.
.SH "DESCRIPTION"
.PP
Use this function to connect to the database. You can then use the functions from
.BR "DB(3kaya)"
to query the database.
.IP "" -4
 db = MyDB::connect("localhost","web","WHSpWXPPh5","mysite");
 res = exec(db,"SELECT * FROM pagedata WHERE page_id = 10");
.SH "AUTHORS"
Kaya standard library by Edwin Brady, Chris Morris and others (kaya@kayalang.org). For further information see http://kayalang.org/
.SH LICENSE
The Kaya standard library is free software; you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License (version 2.1 or any later version) as published by the Free Software Foundation.
.SH "RELATED"
.PD 0
.PP
.BR "DB(3kaya)"
.PD 0.4v