User Tools

Site Tools


kurs:sql_top_mit_und_ohne_bind_param
<?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);
   }
}
?>
kurs/sql_top_mit_und_ohne_bind_param.txt · Last modified: 2014/09/10 21:22 (external edit)