Advertisement
Guest User

Untitled

a guest
Apr 24th, 2014
42
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.07 KB | None | 0 0
  1. $mytbl = new MyTable();
  2. $myresults = $mytbl->fetchAll(
  3. "(col1 LIKE 'val1' AND col2 LIKE 'val2')
  4. OR (col1 LIKE 'val2' AND col2 LIKE 'val1'))
  5. AND col3 = 'val3');
  6.  
  7. $mytbl->fetchAll(
  8. "(col1 LIKE ? AND col2 LIKE ?)
  9. OR (col1 LIKE ? AND col2 LIKE ?))
  10. AND col3 = ?,
  11. array(
  12. $db->quote($val1),
  13. $db->quote($val2),
  14. $db->quote($val2),
  15. $db->quote($val1),
  16. $db->quote($val3)));
  17.  
  18. $mytbl->fetchAll(
  19. $mytbl->select()
  20. ->where("(col1 LIKE ? AND col2 LIKE ?)
  21. OR (col1 LIKE ? AND col2 LIKE ?)) AND col3 = ?,
  22. array(
  23. $db->quote($val1),
  24. $db->quote($val2),
  25. $db->quote($val2),
  26. $db->quote($val1),
  27. $db->quote($val3))));
  28.  
  29. $mytbl->fetchAll(
  30. "(col1 LIKE ? AND col2 LIKE ?)
  31. OR (col1 LIKE ? AND col2 LIKE ?))
  32. AND col3 = ?",
  33. array($val1, $val2, $val3, $val4, $val5));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement