dorunprep.php

This script executes a prepared SQL statement.

A batch of the same prepared statement with different sets of parameter values may be executed in a single call.

The entire set of statements is executed within a database transaction, which is rolled back if an error occurs and the database can handle transactions.

The current session must contain the connection parameters for database access.

dorunprep.php processes the following HTTP parameters:

PHPSESSID

(required) the session ID returned from dologin.php

stm-id

(required) is the prepared SQL statement identifier returned by doprepare.php

return-keys

(optional) true if server generated keys of inserted rows shall be returned. false by default.

permit-results

(optional) true if SQL statements may return result sets. true by default.

format

(optional) the format used to transmit the SQL result set. Can be either xml (default) or csv.

delimiter

(optional) the column delimiter used for CSV downloads. Default is a semicolon (;).

quote

(optional) the quote character used to enclose complex column values in CSV format. Defaults to a double quote (").

param:$j:$i

where $j = 0, 1, ... is the index of the parameter set within a batch (always 0 if a single execution is requested) and $i = 0, 1, ... is the index of a parameter within the prepared statement defines the value of a parameter

type:$j:$i

where $j = 0, 1, ... is the index of the parameter set within a batch (always 0 if a single execution is requested) and $i = 0, 1, ... is the index of a parameter within the prepared statement defines the type of a parameter and must be one of Boolean, Int, String, Timestamp, Time, Date, or Null

The response structure returned by dorunprep.php is the same as for dosql.php.