PHP: Hypertext Preprocessor (original) (raw)

<?php// create table mytab (mycol number);function query($name, $c) { echo "Querying $name\n"; <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>s</mi><mo>=</mo><mi>o</mi><mi>c</mi><msub><mi>i</mi><mi>p</mi></msub><mi>a</mi><mi>r</mi><mi>s</mi><mi>e</mi><mo stretchy="false">(</mo></mrow><annotation encoding="application/x-tex">s = oci_parse(</annotation></semantics></math>s=ociparse(c, "select * from mytab"); oci_execute($s, OCI_NO_AUTO_COMMIT); <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>r</mi><mi>o</mi><mi>w</mi><mo>=</mo><mi>o</mi><mi>c</mi><msub><mi>i</mi><mi>f</mi></msub><mi>e</mi><mi>t</mi><mi>c</mi><msub><mi>h</mi><mi>a</mi></msub><mi>r</mi><mi>r</mi><mi>a</mi><mi>y</mi><mo stretchy="false">(</mo></mrow><annotation encoding="application/x-tex">row = oci_fetch_array(</annotation></semantics></math>row=ocifetcharray(s, OCI_ASSOC); if (!$row) { echo "No rows\n"; } else { do { foreach ($row as $item) echo $item . " "; echo "\n"; } while (($row = oci_fetch_array($s, OCI_ASSOC)) != false); } }$c1 = oci_connect("hr", "welcome", "localhost/orcl"); <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>c</mi><mn>2</mn><mo>=</mo><mi>o</mi><mi>c</mi><msub><mi>i</mi><mi>n</mi></msub><mi>e</mi><msub><mi>w</mi><mi>c</mi></msub><mi>o</mi><mi>n</mi><mi>n</mi><mi>e</mi><mi>c</mi><mi>t</mi><mo stretchy="false">(</mo><mi mathvariant="normal">"</mi><mi>h</mi><mi>r</mi><mi mathvariant="normal">"</mi><mo separator="true">,</mo><mi mathvariant="normal">"</mi><mi>w</mi><mi>e</mi><mi>l</mi><mi>c</mi><mi>o</mi><mi>m</mi><mi>e</mi><mi mathvariant="normal">"</mi><mo separator="true">,</mo><mi mathvariant="normal">"</mi><mi>l</mi><mi>o</mi><mi>c</mi><mi>a</mi><mi>l</mi><mi>h</mi><mi>o</mi><mi>s</mi><mi>t</mi><mi mathvariant="normal">/</mi><mi>o</mi><mi>r</mi><mi>c</mi><mi>l</mi><mi mathvariant="normal">"</mi><mo stretchy="false">)</mo><mo separator="true">;</mo></mrow><annotation encoding="application/x-tex">c2 = oci_new_connect("hr", "welcome", "localhost/orcl");</annotation></semantics></math>c2=ocinewconnect("hr","welcome","localhost/orcl");s = oci_parse($c1, "insert into mytab values(1234)"); oci_execute($s, OCI_NO_AUTO_COMMIT);query("basic connection", $c1); query("new connection", $c2); oci_commit($c1); query("new connection after commit", $c2);// Output is: // Querying basic connection // 1234 // Querying new connection // No rows // Querying new connection after commit // 1234 ?>