PHP: cubrid_fetch_object - Manual (original) (raw)
`<?php conn=cubridconnect("localhost",33000,"demodb");<spanclass="katex"><spanclass="katex−mathml"><mathxmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>r</mi><mi>e</mi><mi>s</mi><mo>=</mo><mi>c</mi><mi>u</mi><mi>b</mi><mi>r</mi><mi>i</mi><msub><mi>d</mi><mi>e</mi></msub><mi>x</mi><mi>e</mi><mi>c</mi><mi>u</mi><mi>t</mi><mi>e</mi><mostretchy="false">(</mo></mrow><annotationencoding="application/x−tex">res=cubridexecute(</annotation></semantics></math></span><spanclass="katex−html"aria−hidden="true"><spanclass="base"><spanclass="strut"style="height:0.4306em;"></span><spanclass="mordmathnormal">res</span><spanclass="mspace"style="margin−right:0.2778em;"></span><spanclass="mrel">=</span><spanclass="mspace"style="margin−right:0.2778em;"></span></span><spanclass="base"><spanclass="strut"style="height:1em;vertical−align:−0.25em;"></span><spanclass="mordmathnormal">c</span><spanclass="mordmathnormal">u</span><spanclass="mordmathnormal">b</span><spanclass="mordmathnormal"style="margin−right:0.02778em;">r</span><spanclass="mordmathnormal">i</span><spanclass="mord"><spanclass="mordmathnormal">d</span><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;"></span><spanclass="sizingreset−size6size3mtight"><spanclass="mordmathnormalmtight">e</span></span></span></span><spanclass="vlist−s"></span></span><spanclass="vlist−r"><spanclass="vlist"style="height:0.15em;"><span></span></span></span></span></span></span><spanclass="mordmathnormal">x</span><spanclass="mordmathnormal">ec</span><spanclass="mordmathnormal">u</span><spanclass="mordmathnormal">t</span><spanclass="mordmathnormal">e</span><spanclass="mopen">(</span></span></span></span>conn,"SELECT∗FROMcode");vardump(cubridfetchobject(conn = cubrid_connect("localhost", 33000, "demodb"); <span class="katex"><span class="katex-mathml"><math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>r</mi><mi>e</mi><mi>s</mi><mo>=</mo><mi>c</mi><mi>u</mi><mi>b</mi><mi>r</mi><mi>i</mi><msub><mi>d</mi><mi>e</mi></msub><mi>x</mi><mi>e</mi><mi>c</mi><mi>u</mi><mi>t</mi><mi>e</mi><mo stretchy="false">(</mo></mrow><annotation encoding="application/x-tex">res = cubrid_execute(</annotation></semantics></math></span><span class="katex-html" aria-hidden="true"><span class="base"><span class="strut" style="height:0.4306em;"></span><span class="mord mathnormal">res</span><span class="mspace" style="margin-right:0.2778em;"></span><span class="mrel">=</span><span class="mspace" style="margin-right:0.2778em;"></span></span><span class="base"><span class="strut" style="height:1em;vertical-align:-0.25em;"></span><span class="mord mathnormal">c</span><span class="mord mathnormal">u</span><span class="mord mathnormal">b</span><span class="mord mathnormal" style="margin-right:0.02778em;">r</span><span class="mord mathnormal">i</span><span class="mord"><span class="mord mathnormal">d</span><span class="msupsub"><span class="vlist-t vlist-t2"><span class="vlist-r"><span class="vlist" style="height:0.1514em;"><span style="top:-2.55em;margin-left:0em;margin-right:0.05em;"><span class="pstrut" style="height:2.7em;"></span><span class="sizing reset-size6 size3 mtight"><span class="mord mathnormal mtight">e</span></span></span></span><span class="vlist-s"></span></span><span class="vlist-r"><span class="vlist" style="height:0.15em;"><span></span></span></span></span></span></span><span class="mord mathnormal">x</span><span class="mord mathnormal">ec</span><span class="mord mathnormal">u</span><span class="mord mathnormal">t</span><span class="mord mathnormal">e</span><span class="mopen">(</span></span></span></span>conn, "SELECT * FROM code");var_dump(cubrid_fetch_object(conn=cubridconnect("localhost",33000,"demodb");<spanclass="katex"><spanclass="katex−mathml"><mathxmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>r</mi><mi>e</mi><mi>s</mi><mo>=</mo><mi>c</mi><mi>u</mi><mi>b</mi><mi>r</mi><mi>i</mi><msub><mi>d</mi><mi>e</mi></msub><mi>x</mi><mi>e</mi><mi>c</mi><mi>u</mi><mi>t</mi><mi>e</mi><mostretchy="false">(</mo></mrow><annotationencoding="application/x−tex">res=cubridexecute(</annotation></semantics></math></span><spanclass="katex−html"aria−hidden="true"><spanclass="base"><spanclass="strut"style="height:0.4306em;"></span><spanclass="mordmathnormal">res</span><spanclass="mspace"style="margin−right:0.2778em;"></span><spanclass="mrel">=</span><spanclass="mspace"style="margin−right:0.2778em;"></span></span><spanclass="base"><spanclass="strut"style="height:1em;vertical−align:−0.25em;"></span><spanclass="mordmathnormal">c</span><spanclass="mordmathnormal">u</span><spanclass="mordmathnormal">b</span><spanclass="mordmathnormal"style="margin−right:0.02778em;">r</span><spanclass="mordmathnormal">i</span><spanclass="mord"><spanclass="mordmathnormal">d</span><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;"></span><spanclass="sizingreset−size6size3mtight"><spanclass="mordmathnormalmtight">e</span></span></span></span><spanclass="vlist−s"></span></span><spanclass="vlist−r"><spanclass="vlist"style="height:0.15em;"><span></span></span></span></span></span></span><spanclass="mordmathnormal">x</span><spanclass="mordmathnormal">ec</span><spanclass="mordmathnormal">u</span><spanclass="mordmathnormal">t</span><spanclass="mordmathnormal">e</span><spanclass="mopen">(</span></span></span></span>conn,"SELECT∗FROMcode");vardump(cubridfetchobject(res));// if you want to operate LOB object, you can use cubrid_fetch_object($res, CUBRID_LOB)class demodb_code {
public $s_name = null;
public $f_name = null;
public function
toString() {
var_dump($this);
}
}var_dump(cubrid_fetch_object($res, "demodb_code"));// if you want to operate LOB object, you can use cubrid_fetch_object($res, "demodb_code", CUBRID_LOB)class demodb_code_construct extends demodb_code {
public function __construct($s, $f) { this−>sname=this->s_name = this−>sname=s; this−>fname=this->f_name = this−>fname=f;
}
}var_dump(cubrid_fetch_object($res, 'demodb_code_construct', array('s_name', 'f_name')));// if you want to operate LOB object, you can use cubrid_fetch_object($res, 'demodb_code_construct', array('s_name', 'f_name'), CUBRID_LOB)var_dump(cubrid_fetch_object($res));cubrid_close_request($res);
cubrid_disconnect($conn);
?>`
object(stdClass)#1 (2) { ["s_name"]=> string(1) "X" ["f_name"]=> string(5) "Mixed" } object(demodb_code)#1 (2) { ["s_name"]=> string(1) "W" ["f_name"]=> string(5) "Woman" } object(demodb_code_construct)#1 (2) { ["s_name"]=> string(6) "s_name" ["f_name"]=> string(6) "f_name" } object(stdClass)#1 (2) { ["s_name"]=> string(1) "B" ["f_name"]=> string(6) "Bronze" }