subquery in codeigniter active record

by

->where() support passing any string to it and it will use it in the query.

You can try using this:

$this->db->select('*')->from('certs');
$this->db->where('`id` NOT IN (SELECT `id_cer` FROM `revokace`)', NULL, FALSE);

The ,NULL,FALSE in the where() tells CodeIgniter not to escape the query, which may mess it up.

UPDATE: You can also check out the subquery library I wrote.

$this->db->select('*')->from('certs');
$sub = $this->subquery->start_subquery('where_in');
$sub->select('id_cer')->from('revokace');
$this->subquery->end_subquery('id', FALSE);

More Related Contents:

  1. CodeIgniter Disallowed Key Characters
  2. Does CodeIgniter automatically prevent SQL injection?
  3. Convert string to ObjectID in MongoDB
  4. Codeigniter – no input file specified
  5. codeigniter CSRF error: “The action you have requested is not allowed.”
  6. Codeigniter image resize?
  7. Removing specific items from array with MongoDB
  8. How to rewrite the index.php of Codeigniter on Windows Azure
  9. HTTP OPTIONS error in Phil Sturgeon’s Codeigniter Restserver and Backbone.js
  10. Uploading a csv into Codeigniter
  11. Using Mysql WHERE IN clause in codeigniter
  12. Constructor session validation for different functions
  13. How to upload image in CodeIgniter?
  14. COUNT / GROUP BY with active record?
  15. Correct naming structure for CodeIgniter
  16. PostgreSQL next value of the sequences?
  17. How to integrate codeIgniter with netbeans fully
  18. Where do I put image files, css, js, etc. in Codeigniter?
  19. Upstream too big – nginx + codeigniter
  20. how to load view into another view codeigniter 2.1?
  21. how to validate array value in codeigniter
  22. CodeIgniter session class not working in Chrome
  23. codeigniter table join
  24. Codeigniter select query with AND and OR condition
  25. codeigniter : Commands out of sync; you can’t run this command now
  26. Parse error: parse error, expecting `'{” in [closed]
  27. CodeIgniter – best place to declare global variable
  28. How to get data in function extend controller?
  29. Codeigniter session data lost after redirect
  30. How can I have CodeIgniter load specific pages using SSL?

Leave a Comment