MySQL

API to connect and use MySQL database

Result

void result_set_conv_date('result, function:1) Set the function that will convert a Date or DateTime string to the corresponding value. int result_get_length('result) Return the number of rows returned or affected int result_get_nfields('result) Return the number of fields in a result row object? result_next('result) Return the next row if available. A row is represented as an object, which fields have been converted to the corresponding Neko value (int, float or string). For Date and DateTime you can specify your own conversion function using result_set_conv_date. By default they're returned as plain strings. Additionally, the TINYINT(1) will be converted to either true or false if equal to 0. string result_get('result, n : int) Return the nth field of the current row int result_get_int('result, n : int) Return the nth field of the current row as an integer (or 0) float result_get_float('result, n : int) Return the nth field of the current row as a float (or 0)

Connection

void close('connection) Close the connection. Any subsequent operation will fail on it void select_db('connection, string) Select the database 'result request('connection, string) Execute an SQL request. Exception on error string escape('connection, string) Escape the string for inserting into a SQL request 'connection connect({ host => string, port => int, user => string, pass => string, socket => string?}) Connect to a database using the connection informations
Report an issue | Contribute to this page

©2017 Haxe Foundation