Bureaucrats, editor, reviewer, Administrators
13,550
edits
Changes
Jump to navigation
Jump to search
no edit summary
==sql:init==
{| width='100%'
|-
==sql:connect==
{| width='100%'
|-
==sql:prepare==
{| width='100%'
|-
==sql:commit==
{| width='100%'
|-
==sql:rollback==
{| width='100%'
|-
==sql:close==
{| width='100%'
|-
|-
| '''Summary'''
| This function closes a connection to a relational database. {{Code|$connection}} specifies the connection handle.<br/>Opened connections will automatically be closed after the XQuery expression has been evaluated, but if you open many connections, it is recommendable to explicitly close them again with this function.
|-
| '''Errors'''
==Direct queries==
A simple select statement can be executed on the following way:
return sql:execute($conn, $q),
(: Return table contents :)
sql:execute($conn, "select * from person"), sql:close($conn)
)
</pre>
