<HTML ><HEAD ><TITLE >InterBase 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="ifxus_write_slob" HREF="function.ifxus-write-slob.html"><LINK REL="NEXT" TITLE="ibase_blob_add" HREF="function.ibase-blob-add.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.ifxus-write-slob.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="function.ibase-blob-add.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="reference" ><A NAME="ref.ibase" ></A ><DIV CLASS="TITLEPAGE" ><H1 CLASS="title" >XLIV. InterBase functions</H1 ><DIV CLASS="PARTINTRO" ><A NAME="AEN40295" ></A ><DIV CLASS="section" ><H1 CLASS="section" ><A NAME="ibase.intro" ></A >Introduction</H1 ><P > InterBase is a popular database put out by Borland/Inprise. More information about InterBase is available at <A HREF="http://www.interbase.com/" TARGET="_top" >http://www.interbase.com/</A >. Oh, by the way, InterBase just joined the open source movement! </P ><DIV CLASS="note" ><BLOCKQUOTE CLASS="note" ><P ><B >Note: </B > Full support for InterBase 6 was added in PHP 4.0. </P ><P > This database uses a single quote (') character for escaping, a behavior similar to the Sybase database, add to your <TT CLASS="filename" >php.ini</TT > the following directive: <DIV CLASS="informalexample" ><A NAME="AEN40304" ></A ><P ></P ><TABLE BORDER="0" BGCOLOR="#E0E0E0" CELLPADDING="5" ><TR ><TD ><PRE CLASS="php" >magic_quotes_sybase = On</PRE ></TD ></TR ></TABLE ><P ></P ></DIV > </P ></BLOCKQUOTE ></DIV ></DIV ><DIV CLASS="section" ><H1 CLASS="section" ><A NAME="ibase.requirements" ></A >Requirements</H1 ><P > </P ></DIV ><DIV CLASS="section" ><H1 CLASS="section" ><A NAME="ibase.installation" ></A >Installation</H1 ><P > To enable InterBase support configure PHP <TT CLASS="option" >--with-interbase[=DIR]</TT >, where DIR is the InterBase base install directory, which defaults to <TT CLASS="filename" >/usr/interbase</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" >gds32.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). In case you installed the InterBase database server on the same machine PHP is running on, you will have this DLL already. Therfore you don't need to copy <SPAN CLASS="emphasis" ><I CLASS="emphasis" >gds32.dll</I ></SPAN > from the DLL folder. </P ></BLOCKQUOTE ></DIV ></DIV ><DIV CLASS="section" ><H1 CLASS="section" ><A NAME="ibase.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="AEN40324" ></A ><P ><B >Table 1. InterBase 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" >ibase.allow_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" >ibase.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" >ibase.max_links</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >"-1"</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >PHP_INI_SYSTEM</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" >ibase.default_user</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >NULL</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >PHP_INI_ALL</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" >ibase.default_password</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >NULL</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >PHP_INI_ALL</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" >ibase.timestampformat</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >"%m/%d/%Y%H:%M:%S"</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >PHP_INI_ALL</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" >ibase.dateformat</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >"%m/%d/%Y"</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >PHP_INI_ALL</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" >ibase.timeformat</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >"%H:%M:%S"</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >PHP_INI_ALL</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 ></DIV ><DIV CLASS="section" ><H1 CLASS="section" ><A NAME="ibase.resources" ></A >Resource Types</H1 ><P > </P ></DIV ><DIV CLASS="section" ><H1 CLASS="section" ><A NAME="ibase.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 >IBASE_DEFAULT</B ></TT > (<A HREF="language.types.integer.html" >integer</A >)</DT ><DD ><P > </P ></DD ><DT ><TT CLASS="constant" ><B >IBASE_TEXT</B ></TT > (<A HREF="language.types.integer.html" >integer</A >)</DT ><DD ><P > </P ></DD ><DT ><TT CLASS="constant" ><B >IBASE_UNIXTIME</B ></TT > (<A HREF="language.types.integer.html" >integer</A >)</DT ><DD ><P > </P ></DD ><DT ><TT CLASS="constant" ><B >IBASE_READ</B ></TT > (<A HREF="language.types.integer.html" >integer</A >)</DT ><DD ><P > </P ></DD ><DT ><TT CLASS="constant" ><B >IBASE_COMMITTED</B ></TT > (<A HREF="language.types.integer.html" >integer</A >)</DT ><DD ><P > </P ></DD ><DT ><TT CLASS="constant" ><B >IBASE_CONSISTENCY</B ></TT > (<A HREF="language.types.integer.html" >integer</A >)</DT ><DD ><P > </P ></DD ><DT ><TT CLASS="constant" ><B >IBASE_NOWAIT</B ></TT > (<A HREF="language.types.integer.html" >integer</A >)</DT ><DD ><P > </P ></DD ><DT ><TT CLASS="constant" ><B >IBASE_TIMESTAMP</B ></TT > (<A HREF="language.types.integer.html" >integer</A >)</DT ><DD ><P > </P ></DD ><DT ><TT CLASS="constant" ><B >IBASE_DATE</B ></TT > (<A HREF="language.types.integer.html" >integer</A >)</DT ><DD ><P > </P ></DD ><DT ><TT CLASS="constant" ><B >IBASE_TIME</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.ibase-blob-add.html" >ibase_blob_add</A > -- Add data into created blob </DT ><DT ><A HREF="function.ibase-blob-cancel.html" >ibase_blob_cancel</A > -- Cancel creating blob </DT ><DT ><A HREF="function.ibase-blob-close.html" >ibase_blob_close</A > -- Close blob </DT ><DT ><A HREF="function.ibase-blob-create.html" >ibase_blob_create</A > -- Create blob for adding data </DT ><DT ><A HREF="function.ibase-blob-echo.html" >ibase_blob_echo</A > -- Output blob contents to browser </DT ><DT ><A HREF="function.ibase-blob-get.html" >ibase_blob_get</A > -- Get len bytes data from open blob </DT ><DT ><A HREF="function.ibase-blob-import.html" >ibase_blob_import</A > -- Create blob, copy file in it, and close it </DT ><DT ><A HREF="function.ibase-blob-info.html" >ibase_blob_info</A > -- Return blob length and other useful info </DT ><DT ><A HREF="function.ibase-blob-open.html" >ibase_blob_open</A > -- Open blob for retrieving data parts </DT ><DT ><A HREF="function.ibase-close.html" >ibase_close</A > -- Close a connection to an InterBase database </DT ><DT ><A HREF="function.ibase-commit.html" >ibase_commit</A > -- Commit a transaction</DT ><DT ><A HREF="function.ibase-connect.html" >ibase_connect</A > -- Open a connection to an InterBase database </DT ><DT ><A HREF="function.ibase-errmsg.html" >ibase_errmsg</A > -- Returns error messages </DT ><DT ><A HREF="function.ibase-execute.html" >ibase_execute</A > -- Execute a previously prepared query</DT ><DT ><A HREF="function.ibase-fetch-object.html" >ibase_fetch_object</A > -- Get an object from a InterBase database</DT ><DT ><A HREF="function.ibase-fetch-row.html" >ibase_fetch_row</A > -- Fetch a row from an InterBase database</DT ><DT ><A HREF="function.ibase-field-info.html" >ibase_field_info</A > -- Get information about a field </DT ><DT ><A HREF="function.ibase-free-query.html" >ibase_free_query</A > -- Free memory allocated by a prepared query </DT ><DT ><A HREF="function.ibase-free-result.html" >ibase_free_result</A > -- Free a result set</DT ><DT ><A HREF="function.ibase-num-fields.html" >ibase_num_fields</A > -- Get the number of fields in a result set </DT ><DT ><A HREF="function.ibase-pconnect.html" >ibase_pconnect</A > -- Creates an persistent connection to an InterBase database </DT ><DT ><A HREF="function.ibase-prepare.html" >ibase_prepare</A > -- Prepare a query for later binding of parameter placeholders and execution </DT ><DT ><A HREF="function.ibase-query.html" >ibase_query</A > -- Execute a query on an InterBase database</DT ><DT ><A HREF="function.ibase-rollback.html" >ibase_rollback</A > -- Rolls back a transaction</DT ><DT ><A HREF="function.ibase-timefmt.html" >ibase_timefmt</A > -- Sets the format of timestamp, date and time type columns returned from queries </DT ><DT ><A HREF="function.ibase-trans.html" >ibase_trans</A > -- Begin a transaction</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.ifxus-write-slob.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.ibase-blob-add.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >ifxus_write_slob</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="funcref.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >ibase_blob_add</TD ></TR ></TABLE ></DIV ></BODY ></HTML >