PHP: Hypertext Preprocessor (original) (raw)

cubrid_unbuffered_query

(PECL CUBRID >= 8.3.0)

cubrid_unbuffered_query — Perform a query without fetching the results into memory

Description

This function performs a query without waiting for that all query results have been complete. It will return when the results are being generated.

Parameters

query

A SQL query.

conn_identifier

The CUBRID connection. If the connection identifier is not specified, the last connection opened by cubrid_connect() is assumed.

Return Values

For SELECT, SHOW, DESCRIBE or EXPLAIN statements returns a request identifier resource on success.

For other type of SQL statements, UPDATE, DELETE, DROP, etc, returns [true](reserved.constants.php#constant.true) on success.

[false](reserved.constants.php#constant.false) on failure.

Examples

Example #1 cubrid_unbuffered_query() example

`<?php
$link = cubrid_connect("localhost", 30000, "demodb", "dba", "");
if (!$link)
{
die('Could not connect.');
} query="select∗fromcode";<spanclass="katex"><spanclass="katex−mathml"><mathxmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>r</mi><mi>e</mi><mi>s</mi><mi>u</mi><mi>l</mi><mi>t</mi><mo>=</mo><mi>c</mi><mi>u</mi><mi>b</mi><mi>r</mi><mi>i</mi><msub><mi>d</mi><mi>u</mi></msub><mi>n</mi><mi>b</mi><mi>u</mi><mi>f</mi><mi>f</mi><mi>e</mi><mi>r</mi><mi>e</mi><msub><mi>d</mi><mi>q</mi></msub><mi>u</mi><mi>e</mi><mi>r</mi><mi>y</mi><mostretchy="false">(</mo></mrow><annotationencoding="application/x−tex">result=cubridunbufferedquery(</annotation></semantics></math><spanclass="katex−html"aria−hidden="true"><spanclass="base"><spanclass="strut"style="height:0.6944em;"><spanclass="mordmathnormal">res<spanclass="mordmathnormal">u<spanclass="mordmathnormal">lt<spanclass="mspace"style="margin−right:0.2778em;"><spanclass="mrel">=<spanclass="mspace"style="margin−right:0.2778em;"><spanclass="base"><spanclass="strut"style="height:1.0361em;vertical−align:−0.2861em;"><spanclass="mordmathnormal">c<spanclass="mordmathnormal">u<spanclass="mordmathnormal">b<spanclass="mordmathnormal"style="margin−right:0.02778em;">r<spanclass="mordmathnormal">i<spanclass="mord"><spanclass="mordmathnormal">d<spanclass="msupsub"><spanclass="vlist−tvlist−t2"><spanclass="vlist−r"><spanclass="vlist"style="height:0.1514em;"><spanstyle="top:−2.55em;margin−left:0em;margin−right:0.05em;"><spanclass="pstrut"style="height:2.7em;"><spanclass="sizingreset−size6size3mtight"><spanclass="mordmathnormalmtight">u<spanclass="vlist−s"><spanclass="vlist−r"><spanclass="vlist"style="height:0.15em;"><spanclass="mordmathnormal">nb<spanclass="mordmathnormal">u<spanclass="mordmathnormal"style="margin−right:0.10764em;">ff<spanclass="mordmathnormal">ere<spanclass="mord"><spanclass="mordmathnormal">d<spanclass="msupsub"><spanclass="vlist−tvlist−t2"><spanclass="vlist−r"><spanclass="vlist"style="height:0.1514em;"><spanstyle="top:−2.55em;margin−left:0em;margin−right:0.05em;"><spanclass="pstrut"style="height:2.7em;"><spanclass="sizingreset−size6size3mtight"><spanclass="mordmathnormalmtight"style="margin−right:0.03588em;">q<spanclass="vlist−s"><spanclass="vlist−r"><spanclass="vlist"style="height:0.2861em;"><spanclass="mordmathnormal">u<spanclass="mordmathnormal"style="margin−right:0.03588em;">ery<spanclass="mopen">(query,query = "select * from code"; <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>r</mi><mi>e</mi><mi>s</mi><mi>u</mi><mi>l</mi><mi>t</mi><mo>=</mo><mi>c</mi><mi>u</mi><mi>b</mi><mi>r</mi><mi>i</mi><msub><mi>d</mi><mi>u</mi></msub><mi>n</mi><mi>b</mi><mi>u</mi><mi>f</mi><mi>f</mi><mi>e</mi><mi>r</mi><mi>e</mi><msub><mi>d</mi><mi>q</mi></msub><mi>u</mi><mi>e</mi><mi>r</mi><mi>y</mi><mo stretchy="false">(</mo></mrow><annotation encoding="application/x-tex">result = cubrid_unbuffered_query(</annotation></semantics></math>result=cubridunbufferedquery(query, query="select∗fromcode";<spanclass="katex"><spanclass="katex−mathml"><mathxmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>r</mi><mi>e</mi><mi>s</mi><mi>u</mi><mi>l</mi><mi>t</mi><mo>=</mo><mi>c</mi><mi>u</mi><mi>b</mi><mi>r</mi><mi>i</mi><msub><mi>d</mi><mi>u</mi></msub><mi>n</mi><mi>b</mi><mi>u</mi><mi>f</mi><mi>f</mi><mi>e</mi><mi>r</mi><mi>e</mi><msub><mi>d</mi><mi>q</mi></msub><mi>u</mi><mi>e</mi><mi>r</mi><mi>y</mi><mostretchy="false">(</mo></mrow><annotationencoding="application/x−tex">result=cubridunbufferedquery(</annotation></semantics></math><spanclass="katex−html"aria−hidden="true"><spanclass="base"><spanclass="strut"style="height:0.6944em;"><spanclass="mordmathnormal">res<spanclass="mordmathnormal">u<spanclass="mordmathnormal">lt<spanclass="mspace"style="margin−right:0.2778em;"><spanclass="mrel">=<spanclass="mspace"style="margin−right:0.2778em;"><spanclass="base"><spanclass="strut"style="height:1.0361em;vertical−align:−0.2861em;"><spanclass="mordmathnormal">c<spanclass="mordmathnormal">u<spanclass="mordmathnormal">b<spanclass="mordmathnormal"style="margin−right:0.02778em;">r<spanclass="mordmathnormal">i<spanclass="mord"><spanclass="mordmathnormal">d<spanclass="msupsub"><spanclass="vlist−tvlist−t2"><spanclass="vlist−r"><spanclass="vlist"style="height:0.1514em;"><spanstyle="top:−2.55em;margin−left:0em;margin−right:0.05em;"><spanclass="pstrut"style="height:2.7em;"><spanclass="sizingreset−size6size3mtight"><spanclass="mordmathnormalmtight">u<spanclass="vlist−s"><spanclass="vlist−r"><spanclass="vlist"style="height:0.15em;"><spanclass="mordmathnormal">nb<spanclass="mordmathnormal">u<spanclass="mordmathnormal"style="margin−right:0.10764em;">ff<spanclass="mordmathnormal">ere<spanclass="mord"><spanclass="mordmathnormal">d<spanclass="msupsub"><spanclass="vlist−tvlist−t2"><spanclass="vlist−r"><spanclass="vlist"style="height:0.1514em;"><spanstyle="top:−2.55em;margin−left:0em;margin−right:0.05em;"><spanclass="pstrut"style="height:2.7em;"><spanclass="sizingreset−size6size3mtight"><spanclass="mordmathnormalmtight"style="margin−right:0.03588em;">q<spanclass="vlist−s"><spanclass="vlist−r"><spanclass="vlist"style="height:0.2861em;"><spanclass="mordmathnormal">u<spanclass="mordmathnormal"style="margin−right:0.03588em;">ery<spanclass="mopen">(query,link);

while ( row=cubridfetch(row = cubrid_fetch(row=cubridfetch(result))
{
var_dump($row);
}cubrid_close_request($result);
cubrid_disconnect($link);
?>`

Notes

Note:

The benefits of cubrid_unbuffered_query() come at a cost: you cannot use cubrid_num_rows() andcubrid_data_seek() on a result set returned fromcubrid_unbuffered_query().

Found A Problem?

There are no user contributed notes for this page.