This shows you the differences between two versions of the page.
kurs:sql_top_mit_und_ohne_bind_param [2014/09/10 21:22] |
kurs:sql_top_mit_und_ohne_bind_param [2014/09/10 21:22] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | <code> | ||
+ | <?php | ||
+ | $emp_name = array('Fay','Taylor', 'yyyyyy', 'xxxxxxx','King' ); | ||
+ | |||
+ | |||
+ | $db = oci_connect('hr','hr','orcl'); | ||
+ | $sql = "select first_name, last_name | ||
+ | from employees where last_name = :last_name"; | ||
+ | | ||
+ | $q = oci_parse($db,$sql); | ||
+ | |||
+ | for($i = 0; $i < 100000; $i++) { | ||
+ | $r = rand(0,count($emp_name)-1); | ||
+ | $last_name = $emp_name[$r].$i; | ||
+ | print "i= $i rand = $r last_name = $last_name\n"; | ||
+ | |||
+ | oci_bind_by_name($q, ":last_name", $last_name, SQLT_CHR ); | ||
+ | $r = oci_execute($q, OCI_DEFAULT); | ||
+ | |||
+ | while ($row = oci_fetch_array($q,OCI_ASSOC+OCI_RETURN_NULLS)) { | ||
+ | print_r($row); | ||
+ | } | ||
+ | } | ||
+ | ?> | ||
+ | </code> |