PHP API-PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

PHP API

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 23, 2016 pm 02:37 PM

php api

USING

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);

Copy after login

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.

FUNCTIONS 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_setTimeout(int timeoutsec, int timeoutusec)

Sets the server connect timeout in seconds and milliseconds. Setting either parameter to -1 disables the timeout.

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: oracle8, postgresql, mysql, etc.

string sqlrcon_dbVersion(int sqlrconref)

Returns the version of the database

string sqlrcon_serverVersion(int sqlrconref)

Returns the version of the SQL Relay server software

string sqlrcon_clientVersion(int sqlrconref)

Returns the version of the SQL Relay client software

string sqlrcon_bindFormat(int sqlrconref)

Returns a string representing the format of the bind variables used in the db.

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.

void sqlrcur_validBind(int sqlrcurref, string variable)

Returns true if "variable" was a valid bind variable of 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)