PHP: Hypertext Preprocessor (original) (raw)

<?php <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>c</mi><mi>o</mi><mi>n</mi><mi>n</mi><mo>=</mo><mi>c</mi><mi>u</mi><mi>b</mi><mi>r</mi><mi>i</mi><msub><mi>d</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>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><mo separator="true">,</mo><mn>33000</mn><mo separator="true">,</mo><mi mathvariant="normal">"</mi><mi>d</mi><mi>e</mi><mi>m</mi><mi>o</mi><mi>d</mi><mi>b</mi><mi mathvariant="normal">"</mi><mo stretchy="false">)</mo><mo separator="true">;</mo></mrow><annotation encoding="application/x-tex">conn = cubrid_connect("localhost", 33000, "demodb");</annotation></semantics></math>conn=cubridconnect("localhost",33000,"demodb");result = cubrid_execute($conn, "SELECT code FROM event WHERE name='100m Butterfly' and gender='M'", CUBRID_ASYNC); <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>r</mi><mi>o</mi><mi>w</mi><mo>=</mo><mi>c</mi><mi>u</mi><mi>b</mi><mi>r</mi><mi>i</mi><msub><mi>d</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 = cubrid_fetch_array(</annotation></semantics></math>row=cubridfetcharray(result, CUBRID_ASSOC); <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>e</mi><mi>v</mi><mi>e</mi><mi>n</mi><msub><mi>t</mi><mi>c</mi></msub><mi>o</mi><mi>d</mi><mi>e</mi><mo>=</mo></mrow><annotation encoding="application/x-tex">event_code = </annotation></semantics></math>eventcode=row["code"];cubrid_close_request($result);$history_req = cubrid_prepare($conn, "SELECT * FROM history WHERE event_code=?"); cubrid_bind($history_req, 1, $event_code, "number"); cubrid_execute($history_req);printf("%-20s %-9s %-10s %-5s\n", "athlete", "host_year", "score", "unit"); while ($row = cubrid_fetch_array($history_req, CUBRID_ASSOC)) { printf("%-20s %-9s %-10s %-5s\n", <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>r</mi><mi>o</mi><mi>w</mi><mo stretchy="false">[</mo><mi mathvariant="normal">"</mi><mi>a</mi><mi>t</mi><mi>h</mi><mi>l</mi><mi>e</mi><mi>t</mi><mi>e</mi><mi mathvariant="normal">"</mi><mo stretchy="false">]</mo><mo separator="true">,</mo></mrow><annotation encoding="application/x-tex">row["athlete"], </annotation></semantics></math>row["athlete"],row["host_year"], <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>r</mi><mi>o</mi><mi>w</mi><mo stretchy="false">[</mo><mi mathvariant="normal">"</mi><mi>s</mi><mi>c</mi><mi>o</mi><mi>r</mi><mi>e</mi><mi mathvariant="normal">"</mi><mo stretchy="false">]</mo><mo separator="true">,</mo></mrow><annotation encoding="application/x-tex">row["score"], </annotation></semantics></math>row["score"],row["unit"]); }cubrid_close_request($history_req);cubrid_disconnect($conn); ?>

athlete host_year score unit Phelps Michael 2004 51.25 time