<HTML ><HEAD ><TITLE >mSQL functions</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK REL="HOME" TITLE="PHP Manual" HREF="index.html"><LINK REL="UP" TITLE="Function Reference" HREF="funcref.html"><LINK REL="PREVIOUS" TITLE="udm_set_agent_param" HREF="function.udm-set-agent-param.html"><LINK REL="NEXT" TITLE="msql_affected_rows" HREF="function.msql-affected-rows.html"><META HTTP-EQUIV="Content-type" CONTENT="text/html; charset=ISO-8859-1"></HEAD ><BODY CLASS="reference" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#840084" ALINK="#0000FF" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" >PHP Manual</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="function.udm-set-agent-param.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="function.msql-affected-rows.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="reference" ><A NAME="ref.msql" ></A ><DIV CLASS="TITLEPAGE" ><H1 CLASS="title" >LXII. mSQL functions</H1 ><DIV CLASS="PARTINTRO" ><A NAME="AEN57133" ></A ><DIV CLASS="section" ><H1 CLASS="section" ><A NAME="msql.intro" ></A >Introduction</H1 ><P > These functions allow you to access mSQL database servers. More information about mSQL can be found at <A HREF="http://www.hughes.com.au/" TARGET="_top" >http://www.hughes.com.au/</A >. </P ></DIV ><DIV CLASS="section" ><H1 CLASS="section" ><A NAME="msql.requirements" ></A >Requirements</H1 ><P > </P ></DIV ><DIV CLASS="section" ><H1 CLASS="section" ><A NAME="msql.installation" ></A >Installation</H1 ><P > In order to have these functions available, you must compile PHP with msql support by using the <TT CLASS="option" >--with-msql[=DIR]</TT > option. DIR is the mSQL base install directory, defaults to <TT CLASS="filename" >/usr/local/Hughes</TT >. </P ><DIV CLASS="note" ><BLOCKQUOTE CLASS="note" ><P ><B >Note to Win32 Users: </B > In order to enable this module on a Windows environment, you must copy <SPAN CLASS="emphasis" ><I CLASS="emphasis" >msql.dll</I ></SPAN > from the DLL folder of the PHP/Win32 binary package to the SYSTEM32 folder of your windows machine. (Ex: C:\WINNT\SYSTEM32 or C:\WINDOWS\SYSTEM32) </P ></BLOCKQUOTE ></DIV ></DIV ><DIV CLASS="section" ><H1 CLASS="section" ><A NAME="msql.configuration" ></A >Runtime Configuration</H1 ><P > The behaviour of these functions is affected by settings in <TT CLASS="filename" >php.ini</TT >. </P ><P > <DIV CLASS="table" ><A NAME="AEN57155" ></A ><P ><B >Table 1. mSQL configuration options</B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><THEAD ><TR ><TH ALIGN="LEFT" VALIGN="MIDDLE" >Name</TH ><TH ALIGN="LEFT" VALIGN="MIDDLE" >Default</TH ><TH ALIGN="LEFT" VALIGN="MIDDLE" >Changeable</TH ></TR ></THEAD ><TBODY ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" >msql.allow_persistent</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >"On"</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >PHP_INI_SYSTEM</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" >msql.max_persistent</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >"-1"</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >PHP_INI_SYSTEM</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" >msql.max_links</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >"-1"</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >PHP_INI_SYSTEM</TD ></TR ></TBODY ></TABLE ></DIV > For further details and definition of the PHP_INI_* constants see <A HREF="function.ini-set.html" ><B CLASS="function" >ini_set()</B ></A >. </P ><P > Here is a short explanation of the configuration directives. <P ></P ><DIV CLASS="variablelist" ><DL ><DT ><A NAME="ini.msql.allow-persistent" ></A ><TT CLASS="parameter" ><I >msql.allow_persistent</I ></TT > <A HREF="language.types.boolean.html" ><B CLASS="type" >boolean</B ></A ></DT ><DD ><P > Whether to allow persistent mSQL connections. </P ></DD ><DT ><A NAME="ini.msql.max-persistent" ></A ><TT CLASS="parameter" ><I >msql.max_persistent</I ></TT > <A HREF="language.types.integer.html" ><B CLASS="type" >integer</B ></A ></DT ><DD ><P > The maximum number of persistent mSQL connections per process. </P ></DD ><DT ><A NAME="ini.msql.max-links" ></A ><TT CLASS="parameter" ><I >msql.max_links</I ></TT > <A HREF="language.types.integer.html" ><B CLASS="type" >integer</B ></A ></DT ><DD ><P > The maximum number of mSQL connections per process, including persistent connections. </P ></DD ></DL ></DIV > </P ></DIV ><DIV CLASS="section" ><H1 CLASS="section" ><A NAME="msql.resources" ></A >Resource Types</H1 ><P > </P ></DIV ><DIV CLASS="section" ><H1 CLASS="section" ><A NAME="msql.constants" ></A >Predefined Constants</H1 ><P > The constants below are defined by this extension, and will only be available when the extension has either been compiled into PHP or dynamically loaded at runtime. </P ><P ></P ><DIV CLASS="variablelist" ><DL ><DT ><TT CLASS="constant" ><B >MSQL_ASSOC</B ></TT > (<A HREF="language.types.integer.html" >integer</A >)</DT ><DD ><P > </P ></DD ><DT ><TT CLASS="constant" ><B >MSQL_NUM</B ></TT > (<A HREF="language.types.integer.html" >integer</A >)</DT ><DD ><P > </P ></DD ><DT ><TT CLASS="constant" ><B >MSQL_BOTH</B ></TT > (<A HREF="language.types.integer.html" >integer</A >)</DT ><DD ><P > </P ></DD ></DL ></DIV ></DIV ></DIV ><DIV CLASS="TOC" ><DL ><DT ><B >Table of Contents</B ></DT ><DT ><A HREF="function.msql-affected-rows.html" >msql_affected_rows</A > -- Returns number of affected rows</DT ><DT ><A HREF="function.msql-close.html" >msql_close</A > -- Close mSQL connection</DT ><DT ><A HREF="function.msql-connect.html" >msql_connect</A > -- Open mSQL connection</DT ><DT ><A HREF="function.msql-create-db.html" >msql_create_db</A > -- Create mSQL database</DT ><DT ><A HREF="function.msql-createdb.html" >msql_createdb</A > -- Create mSQL database</DT ><DT ><A HREF="function.msql-data-seek.html" >msql_data_seek</A > -- Move internal row pointer</DT ><DT ><A HREF="function.msql-dbname.html" >msql_dbname</A > -- Get current mSQL database name</DT ><DT ><A HREF="function.msql-drop-db.html" >msql_drop_db</A > -- Drop (delete) mSQL database</DT ><DT ><A HREF="function.msql-dropdb.html" >msql_dropdb</A > -- Drop (delete) mSQL database</DT ><DT ><A HREF="function.msql-error.html" >msql_error</A > -- Returns error message of last msql call</DT ><DT ><A HREF="function.msql-fetch-array.html" >msql_fetch_array</A > -- Fetch row as array</DT ><DT ><A HREF="function.msql-fetch-field.html" >msql_fetch_field</A > -- Get field information</DT ><DT ><A HREF="function.msql-fetch-object.html" >msql_fetch_object</A > -- Fetch row as object</DT ><DT ><A HREF="function.msql-fetch-row.html" >msql_fetch_row</A > -- Get row as enumerated array</DT ><DT ><A HREF="function.msql-field-seek.html" >msql_field_seek</A > -- Set field offset</DT ><DT ><A HREF="function.msql-fieldflags.html" >msql_fieldflags</A > -- Get field flags</DT ><DT ><A HREF="function.msql-fieldlen.html" >msql_fieldlen</A > -- Get field length</DT ><DT ><A HREF="function.msql-fieldname.html" >msql_fieldname</A > -- Get field name</DT ><DT ><A HREF="function.msql-fieldtable.html" >msql_fieldtable</A > -- Get table name for field</DT ><DT ><A HREF="function.msql-fieldtype.html" >msql_fieldtype</A > -- Get field type</DT ><DT ><A HREF="function.msql-free-result.html" >msql_free_result</A > -- Free result memory</DT ><DT ><A HREF="function.msql-freeresult.html" >msql_freeresult</A > -- Free result memory</DT ><DT ><A HREF="function.msql-list-dbs.html" >msql_list_dbs</A > -- List mSQL databases on server</DT ><DT ><A HREF="function.msql-list-fields.html" >msql_list_fields</A > -- List result fields</DT ><DT ><A HREF="function.msql-list-tables.html" >msql_list_tables</A > -- List tables in an mSQL database</DT ><DT ><A HREF="function.msql-listdbs.html" >msql_listdbs</A > -- List mSQL databases on server</DT ><DT ><A HREF="function.msql-listfields.html" >msql_listfields</A > -- List result fields</DT ><DT ><A HREF="function.msql-listtables.html" >msql_listtables</A > -- List tables in an mSQL database</DT ><DT ><A HREF="function.msql-num-fields.html" >msql_num_fields</A > -- Get number of fields in result</DT ><DT ><A HREF="function.msql-num-rows.html" >msql_num_rows</A > -- Get number of rows in result</DT ><DT ><A HREF="function.msql-numfields.html" >msql_numfields</A > -- Get number of fields in result</DT ><DT ><A HREF="function.msql-numrows.html" >msql_numrows</A > -- Get number of rows in result</DT ><DT ><A HREF="function.msql-pconnect.html" >msql_pconnect</A > -- Open persistent mSQL connection</DT ><DT ><A HREF="function.msql-query.html" >msql_query</A > -- Send mSQL query</DT ><DT ><A HREF="function.msql-regcase.html" >msql_regcase</A > -- Make regular expression for case insensitive match </DT ><DT ><A HREF="function.msql-result.html" >msql_result</A > -- Get result data</DT ><DT ><A HREF="function.msql-select-db.html" >msql_select_db</A > -- Select mSQL database</DT ><DT ><A HREF="function.msql-selectdb.html" >msql_selectdb</A > -- Select mSQL database</DT ><DT ><A HREF="function.msql-tablename.html" >msql_tablename</A > -- Get table name of field</DT ><DT ><A HREF="function.msql.html" >msql</A > -- Send mSQL query</DT ></DL ></DIV ></DIV ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="function.udm-set-agent-param.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="function.msql-affected-rows.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >udm_set_agent_param</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="funcref.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >msql_affected_rows</TD ></TR ></TABLE ></DIV ></BODY ></HTML >