How to execute my SQL query in CodeIgniter

by 
    $sql="Select * from my_table where 1";    
    $query = $this->db->query($sql);
    return $query->result_array();

More Related Contents:

  1. Combine multiple sql / mysql queries in one query
  2. CakePHP find method with JOIN
  3. CodeIgniter MSSQL connection
  4. How to print SQL statement in codeigniter model
  5. MySQL Join Multiple Rows as Columns
  6. How print in Jquery / Datatables [closed]
  7. Im trying to create some temporary tables in mysql using php
  8. How can I prevent SQL injection in PHP?
  9. SQL injection that gets around mysql_real_escape_string()
  10. How to include a PHP variable inside a MySQL statement
  11. Sending email with gmail smtp with codeigniter email library
  12. Use global variables in a class
  13. Examples of SQL Injections through addslashes()?
  14. Achieve hierarchy, Parent/Child Relationship in an effective and easy way
  15. How to set proper codeigniter base url?
  16. CodeIgniter: “The filetype you are attempting to upload is not allowed.”
  17. Redirect with CodeIgniter
  18. Codeigniter Routes regex – using dashes in controller/method names
  19. What are the differences between backtick and single quote? Can I use IF statement in a query as above?
  20. MYSQL Select from tables based on multiple rows
  21. How to populate HTML dropdown list with values from database
  22. Trying to get property of non-object – CodeIgniter
  23. Enabling $_GET in codeigniter
  24. Remove index.php in codeigniter 2.1.0
  25. How do you do multiple SQL statements in one mysql_query?
  26. MySQL/SQL retrieve first 40 characters of a text field?
  27. To Use a PHP Framework or Not? [closed]
  28. File upload required validation in CodeIgniter
  29. Fatal error: Call to a member function query() on null
  30. is_unique for codeigniter form validation

Leave a Comment