Help for this page

Select Code to Download


  1. or download this
    $script = 'SELECT foo FROM bar WHERE item1 = ' . $item1;
if(defined($item2)) { $script .= ' and item2 = ' . $item2; }
if(defined($item3)) { $script .= ' and item3 = ' . $item3; }
  2. or download this
    $script = 'SELECT foo FROM bar WHERE item1 = ?';
if(defined($item2)) { $script .= ' and item2 = ?';
if(defined($item3)) { $script .= ' and item2 = ?';
  3. or download this
    $sql->execute($item1,$item2,$item3);