[SQL Relay文档] SQL Relay中PHP API参考手册 (英文)

转载 2006年05月17日 23:27:00

 

SQL-relay PHP module

PHP API


USINGFUNCTIONSAUTHOR

You can use the module by loading it in your PHP script and calling SQL Relay functions.

For example:

dl("sql_relay.so");
$con=sqlrcon_alloc("adasz",9000,"","user1","password1",0,1);
$cur=sqlrcur_alloc($con);
sqlrcur_sendQuery($cur,"select table_name from user_tables");
sqlrcon_endSession($con);
for ($i=0; $i<sqlrcur_rowCount($cur); $i++)
{
  printf("%s/n",sqlrcur_getField($cur,$i,"table_name"));
}
sqlrcur_free($cur);
sqlrcon_free($con);

An alternative to running dl(sql_relay.so) is to put a line like:

extension=sql_relay.so

In your php.ini file. Doing this will improve performance as the library isn't loaded and unloaded each time a script runs, but only once when the web-server is started.


 

  • int sqlrcon_alloc(string server, int port, string socket, string user, string password, int retrytime, int tries)

    Initiates a connection to "server" on "port" or to the unix "socket" on the local machine and authenticates with "user" and "password". Failed connections will be retried for "tries" times on interval "retrytime". If "tries" is 0 then retries will continue forever. If "retrytime" is 0 then retries will be attempted on a default interval.

    If the "socket" parameter is nether NULL nor "" then an attempt will be made to connect through it before attempting to connect to "server" on "port". If it is NULL or "" then no attempt will be made to connect through the socket.*/

     

  • void sqlrcon_free(int sqlrconref)

    Disconnects and terminates the session if it hasn't been terminated already.

     

  • void sqlrcon_endSession(int sqlrconref)

    terminates the session

     

  • void sqlrcon_suspendSession(int sqlrconref)

    Disconnects this client from the current session but leaves the session open so that another client can connect to it using sqlrcon_resumeSession().

     

  • int sqlrcon_getConnectionPort(int sqlrconref)

    Returns the inet port that the client is communicating over. This parameter may be passed to another client for use in the sqlrcon_resumeSession() command. Note: the value returned by this function is only valid after a call to sqlrcur_suspendSession().

     

  • string sqlrcon_getConnectionSocket(int sqlrconref)

    Returns the unix socket that the client is communicating over. This parameter may be passed to another client for use in the sqlrcon_resumeSession() command. Note: the value returned by this function is only valid after a call to sqlrcur_suspendSession().

     

  • int sqlrcon_resumeSession(int sqlrconref, int port, string socket)

    Resumes a session previously left open using sqlrcon_suspendSession(). Returns 1 on success and 0 on failure.

     

  • int sqlrcon_ping(int sqlrconref)

    Returns 1 if the database is up and 0 if it's down.

     

  • string sqlrcon_identify(int sqlrconref)

    Returns the type of database: oracle7, oracle8, postgresql, mysql, etc.

     

  • int sqlrcon_autoCommitOn(int sqlrconref)

    Instructs the database to perform a commit after every successful query.

     

  • int sqlrcon_autoCommitOff(int sqlrconref)

    Instructs the database to wait for the client to tell it when to commit.

     

  • int sqlrcon_commit(int sqlrconref)

    Issues a commit. Returns 1 if the commit succeeded, 0 if it failed and -1 if an error occurred.

     

  • int sqlrcon_rollback(int sqlrconref)

    Issues a rollback. Returns 1 if the rollback succeeded, 0 if it failed and -1 if an error occurred.

     

  • void sqlrcon_debugOn(int sqlrconref)

    Causes verbose debugging information to be sent to standard output. Another way to do this is to start a query with "-- debug/n".

     

  • void sqlrcon_debugOff(int sqlrconref)

    turns debugging off

     

  • int sqlrcon_getDebug(int sqlrconref)

    returns FALSE if debugging is off and TRUE if debugging is on

     

  • int sqlrcur_alloc(int sqlrconref)
  • void sqlrcur_free(int sqlrcur)
  • void sqlrcur_setResultSetBufferSize(int sqlrcurref, int rows)

    Sets the number of rows of the result set to buffer at a time. 0 (the default) means buffer the entire result set.

     

  • int sqlrcur_getResultSetBufferSize(int sqlrcurref)

    Returns the number of result set rows that will be buffered at a time or 0 for the entire result set.

     

  • void sqlrcur_dontGetColumnInfo(int sqlrcurref)

    Tells the server not to send any column info (names, types, sizes). If you don't need that info, you should call this function to improve performance.

     

  • void sqlrcur_mixedCaseColumnNames(int sqlrcurref)

    Columns names are returned in the same case as they are defined in the database. This is the default.

     

  • void sqlrcur_upperCaseColumnNames(int sqlrcurref)

    Columns names are converted to upper case.

     

  • void sqlrcur_lowerCaseColumnNames(int sqlrcurref)

    Columns names are converted to lower case.

     

  • void sqlrcur_getColumnInfo(int sqlrcurref)

    Tells the server to send column info.

     

  • void sqlrcur_cacheToFile(int sqlrcurref, string filename)

    Sets query caching on. Future queries will be cached to the file "filename". A default time-to-live of 10 minutes is also set. Note that once sqlrcur_cacheToFile() is called, the result sets of all future queries will be cached to that file until another call to sqlrcur_cacheToFile() changes which file to cache to or a call to sqlrcur_cacheOff() turns off caching.

     

  • void sqlrcur_setCacheTtl(int sqlrcurref, int ttl)

    Sets the time-to-live for cached result sets. The sqlr-cachemanger will remove each cached result set "ttl" seconds after it's created.

     

  • string sqlrcur_getCacheFileName(int sqlrcurref)

    Returns the name of the file containing the most recently cached result set.

     

  • void sqlrcur_cacheOff(int sqlrcurref)

    Sets query caching off.

     

If you don't need to use substitution or bind variables in your queries, use these two functions.

 

  • int sqlrcur_sendQuery(int sqlrcurref, string query)

    Sends "query" and gets a return set. Returns TRUE on success and FALSE on failure.

     

  • int sqlrcur_sendQueryWithLength(int sqlrcurref, string query, int length)

    Sends "query" with length "length" and gets a result set. This function must be used if the query contains binary data.

     

  • int sqlrcur_sendFileQuery(int sqlrcurref, string path, string filename)

    Sends the query in file "path"/"filename" and gets a return set. Returns TRUE on success and FALSE on failure.

     

If you need to use substitution or bind variables, in your queries use the following functions. See the API documentation for more information about substitution and bind variables.

 

  • void sqlrcur_prepareQuery(int sqlrcurref, string query)

    Prepare to execute "query".

     

  • void sqlrcur_prepareQueryWithLength(int sqlrcurref, string query, int length)

    Prepare to execute "query" with length "length". This function must be used if the query contains binary data.

     

  • void sqlrcur_prepareFileQuery(int sqlrcurref, string path, string filename)

    Prepare to execute the contents of "path"/"filename".

     

  • void sqlrcur_substitution(int sqlrcurref, string variable, string value)
    void sqlrcur_substitution(int sqlrcurref, string variable, long value)
    void sqlrcur_substitution(int sqlrcurref, string variable, double value, short precision, short scale)

    Define a substitution variable. Returns true if the substitution succeeded or false if the type of the data passed in wasn't a string, long or double or if precision and scale weren't passed in for a double.

     

  • void sqlrcur_clearBinds(int sqlrcurref)

    Clear all bind variables.

     

  • void sqlrcur_countBindVariables(int sqlrcurref)

    Parses the previously prepared query, counts the number of bind variables defined in it and returns that number.

     

  • void sqlrcur_inputBind(int sqlrcurref, string variable, string value)
    void sqlrcur_inputBind(int sqlrcurref, string variable, long value)
    void sqlrcur_inputBind(int sqlrcurref, string variable, double value, short precision, short scale)
    void sqlrcur_inputBindBlob(int sqlrcurref, string variable, long length)
    void sqlrcur_inputBindClob(int sqlrcurref, string variable, long length)

    Define an input bind variable. Returns true if the bind succeeded or false if the type of the data passed in wasn't a string, long or double or if precision and scale weren't passed in for a double.

     

  • void sqlrcur_defineOutputBindString(int sqlrcurref, string variable, int length)

    Define a string output bind variable. "length" bytes will be reserved to store the value.

     

  •  
  • void sqlrcur_defineOutputBindInteger(int sqlrcurref, string variable)

    Define an integer output bind variable.

     

  •  
  • void sqlrcur_defineOutputBindDouble(int sqlrcurref, string variable)

    Define a double precision floating point output bind variable.

     

  • void sqlrcur_defineOutputBindBlob(int sqlrcurref, string variable)

    Define a BLOB output bind variable.

     

  • void sqlrcur_defineOutputBindClob(int sqlrcurref, string variable)

    Define a CLOB output bind variable.

     

  • void sqlrcur_defineOutputBindCursor(int sqlrcurref, string variable)

    Define a cursor output bind variable.

     

  • void sqlrcur_validateBinds(int sqlrcurref)

    If you are binding to any variables that might not actually be in your query, call this to ensure that the database won't try to bind them unless they really are in the query.

     

  • int sqlrcur_executeQuery(int sqlrcurref)

    Execute the query that was previously prepared and bound.

     

  • int sqlrcur_fetchFromBindCursor(int sqlrcurref)

    Fetch from a cursor that was returned as an output bind variable.

     

  • int sqlrcur_getOutputBindString(int sqlrcurref, string variable)

    Get the value stored in a previously defined output bind variable.

     

  • int sqlrcur_getOutputBindBlob(int sqlrcurref, string variable)

    Get the value stored in a previously defined output bind variable.

     

  • int sqlrcur_getOutputBindClob(int sqlrcurref, string variable)

    Get the value stored in a previously defined output bind variable.

     

  • int sqlrcur_getOutputBindInteger(int sqlrcurref, string variable)

    Get the value stored in a previously defined output bind variable.

     

  • int sqlrcur_getOutputBindDouble(int sqlrcurref, string variable)

    Get the value stored in a previously defined output bind variable.

     

  • int sqlrcur_getOutputBindLength(int sqlrcurref, string variable)

    Get the length of the value stored in a previously defined output bind variable.

     

  • int sqlrcur_getOutputBindCursor(int sqlrcurref, string variable)

    Get the cursor associated with a previously defined output bind variable.

     

  • int sqlrcur_openCachedResultSet(int sqlrcurref, string filename)

    Opens a cached result set as if a query that would have generated it had been executed. Returns TRUE on success and FALSE on failure.

     

  • int sqlrcur_colCount(int sqlrcurref)

    returns the number of columns in the current return set

     

  • int sqlrcur_rowCount(int sqlrcurref)

    returns the number of rows in the current return set

     

  • int sqlrcur_totalRows(int sqlrcurref)

    Returns the total number of rows that will be returned in the result set. Not all databases support this call. Don't use it for applications which are designed to be portable across databases. -1 is returned by databases which don't support this option.

     

  • int sqlrcur_affectedRows(int sqlrcurref)

    Returns the number of rows that were updated, inserted or deleted by the query. Not all databases support this call. Don't use it for applications which are designed to be portable across databases. -1 is returned by databases which don't support this option.

     

  • int sqlrcur_firstRowIndex(int sqlrcurref)

    Returns the index of the first buffered row. This is useful when buffering only part of the result set at a time.

     

  • int sqlrcur_endOfResultSet(int sqlrcurref)

    Returns 0 if part of the result set is still pending on the server and 1 if not. This function can only return 0 if setResultSetBufferSize() has been called with a parameter other than 0.

     

  • string sqlrcur_errorMessage(int sqlrcurref)

    If a query failed and generated an error, the error message is available here. If the query succeeded then this function returns FALSE

     

  • string sqlrcur_getNullsAsEmptyStrings(int sqlrcurref)

    Tells the client to return NULL fields and output bind variables as empty strings. This is the default.

     

  • string sqlrcur_getNullsAsNulls(int sqlrcurref)

    Tells the client to return NULL fields and output bind variables as NULL's.

     

  • string sqlrcur_getField(int sqlrcurref, int row, int col)

    returns a string with value of the specified row and column

     

  • string sqlrcur_getFieldLength(int sqlrcurref, int row, int col)

    returns the length of the specified row and column

     

  • array sqlrcur_getRow(int sqlrcurref, int row)

    returns an indexed array of the values of the specified row

     

  • array sqlrcur_getRowLengths(int sqlrcurref, int row)

    returns an indexed array of the lengths of the specified row

     

  • array sqlrcur_getRowAssoc(int sqlrcurref, int row)

    returns an associative array of the values of the specified row

     

  • array sqlrcur_getRowLengthsAssoc(int sqlrcurref, int row)

    returns an associative array of the lengths of the specified row

     

  • array sqlrcur_getColumnNames(int sqlrcurref)

    returns the array of the column names of the current return set

     

  • string sqlrcur_getColumnName(int sqlrcurref, int col)

    returns the name of the specified column

     

  • string sqlrcur_getColumnType(int sqlrcurref, string col)
    string sqlrcur_getColumnType(int sqlrcurref, int col)

    returns the type of the specified column

     

  • int sqlrcur_getColumnLength(int sqlrcurref, string col)
    int sqlrcur_getColumnLength(int sqlrcurref, int col)

    returns the length of the specified column.

     

  • int sqlrcur_getColumnPrecision(int sqlrcurref, string col);
    int sqlrcur_getColumnPrecision(int sqlrcurref, int col);

    Returns the precision of the specified column. Precision is the total number of digits in a number. eg: 123.45 has a precision of 5. For non-numeric types, it's the number of characters in the string.

     

  • int sqlrcur_getColumnScale(int sqlrcurref, string col);
    int sqlrcur_getColumnScale(int sqlrcurref, int col);

    Returns the scale of the specified column. Scale is the total number of digits to the right of the decimal point in a number. eg: 123.45 has a scale of 2.

     

  • int sqlrcur_getColumnIsNullable(int sqlrcurref, string col);
    int sqlrcur_getColumnIsNullable(int sqlrcurref, int col);

    Returns 1 if the specified column can contain nulls and 0 otherwise.

     

  • int sqlrcur_getColumnIsPrimaryKey(int sqlrcurref, string col);
    int sqlrcur_getColumnIsPrimaryKey(int sqlrcurref, int col);

    Returns 1 if the specified column is a primary key and 0 otherwise.

     

  • int sqlrcur_getColumnIsUnique(int sqlrcurref, string col);
    int sqlrcur_getColumnIsUnique(int sqlrcurref, int col);

    Returns 1 if the specified column is unique and 0 otherwise.

     

  • int sqlrcur_getColumnIsPartOfKey(int sqlrcurref, string col);
    int sqlrcur_getColumnIsPartOfKey(int sqlrcurref, int col);

    Returns 1 if the specified column is part of a composite key and 0 otherwise.

     

  • int sqlrcur_getColumnIsUnsigned(int sqlrcurref, string col);
    int sqlrcur_getColumnIsUnsigned(int sqlrcurref, int col);

    Returns 1 if the specified column is an unsigned number and 0 otherwise.

     

  • int sqlrcur_getColumnIsZeroFilled(int sqlrcurref, string col);
    int sqlrcur_getColumnIsZeroFilled(int sqlrcurref, int col);

    Returns 1 if the specified column was created with the zero-fill flag and 0 otherwise.

     

  • int sqlrcur_getColumnIsBinary(int sqlrcurref, string col);
    int sqlrcur_getColumnIsBinary(int sqlrcurref, int col);

    Returns 1 if the specified column contains binary data and 0 otherwise.

     

  • int sqlrcur_getColumnIsAutoIncrement(int sqlrcurref, string col);
    int sqlrcur_getColumnIsAutoIncrement(int sqlrcurref, int col);

    Returns 1 if the specified column auto-increments and 0 otherwise.

     

  • int sqlrcur_getLongest(int sqlrcurref, string col)
    int sqlrcur_getLongest(int sqlrcurref, int col)

    Returns the length of the longest field in the specified column.

     

  • void sqlrcur_suspendResultSet(int sqlrcurref)

    Tells the server to leave this result set open when the connection calls suspendSession() so that another connection can connect to it using resumeResultSet() after it calls resumeSession().

     

  • int sqlrcur_getResultSetId(int sqlrcurref)

    Returns the internal ID of this result set. This parameter may be passed to another statement for use in the resumeResultSet() function. Note: the value returned by this function is only valid after a call to sqlrcur_suspendResultSet().

     

  • void sqlrcur_resumeResultSet(int sqlrcurref, int id)

    Resumes a result set previously left open using suspendSession(). Returns 1 on success and 0 on failure.

     

  • void sqlrcur_resumeCachedResultSet(int sqlrcurref, int id, string filename)

    Resumes a result set previously left open using suspendSession() and continues caching the result set to "filename". Returns 1 on success and 0 on failure.

     


 

Adam Kropielnicki
adasz@wp.pl
 
//From: http://sqlrelay.sourceforge.net/sqlrelay/api/php/doc.html
 

SQL Relay使用详解

http://www.ydmsh.com/www/Blog/Show/id/152/ episode01 What Is     此文算是我对这段时间学习SQL Relay的汇总和总结...
  • bestone0213
  • bestone0213
  • 2015年01月22日 10:10
  • 853

继电器(Relay)

继电器(Relay),也称电驿,是一种电子控制器件,它具有控制系统(又称输入回路)和被控制系统(又称输出回路),通常应用于自动控制电路中,它实际上是用较小的电流去控制较大电流的一种“自动开关”。故在电...
  • liubing8609
  • liubing8609
  • 2015年01月03日 15:13
  • 1619

华为DHCP relay配置过程/管理口配置

# ## 华为DHCP中继配置过程—示例篇 # DHCP relay/5700/5352C/云维护 需求概述: DHCP客户端所在的网段为20.20.20.0/24,而DHCP服务器所...
  • hzhvv
  • hzhvv
  • 2016年06月22日 16:36
  • 2733

深度分析DHCP relay和snooping功能

转自:http://blog.sina.com.cn/s/blog_866d4e0501016vxh.html 一、DHCP relay 首先分析一下DHCPrelay是什么协议。在使用D...
  • ahstusujian
  • ahstusujian
  • 2015年01月14日 14:31
  • 4748

Sendmail relay规则及配置文件用法汇总

第一部分 mail relay 规则详解   一. 软件环境:Sendmail 8.9.3至8.12      二. 默认情况下的relay规则      在默认情况下,也就是安装完系统(Sendma...
  • sdulibh
  • sdulibh
  • 2016年06月22日 13:51
  • 1205

mysql 清除relay-log文件方法详解

mysql 清除relay-log文件方法详解 今天在本机的mysql数据目录下发现了许多类似hostname-relay-bin.0000*的文件,该文件一般是在mysql slave实例上存...
  • u010098331
  • u010098331
  • 2016年02月24日 13:00
  • 6642

PHP数据库连接池SQL Relay安装使用

SQL Relay按照其官网http://sqlrelay.sourceforge.net/index.html上所说是:A powerful database connection manageme...
  • unix21
  • unix21
  • 2016年03月01日 17:56
  • 543

PHP数据库连接池SQL Relay安装使用

SQL Relay按照其官网http://sqlrelay.sourceforge.net/index.html上所说是:A powerful database connection manageme...
  • 21aspnet
  • 21aspnet
  • 2016年03月01日 18:25
  • 3813

Relay: 全新的React数据获取框架

React在前端领域开启了一个新的时代。随着Facebook发布并开源React,它迅速成为大量技术公司 运用在生产环境中的一款流行的库。在本文中,我们将会讨论的是一个全新的React附属框架——Re...
  • derek518
  • derek518
  • 2016年02月26日 23:10
  • 803

SQL RELAY开源数据库连接池

本文以SQL RELAY在MYSQL上的应用,应用测试以PHP程序为主 SQL Relay是一个开源的数据库池连接代理服务器 SQL Relay 的主要特点: 基于web应用的高效、可扩...
  • u010839893
  • u010839893
  • 2015年06月15日 13:51
  • 195
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:[SQL Relay文档] SQL Relay中PHP API参考手册 (英文)
举报原因:
原因补充:

(最多只允许输入30个字)