Escaping SQL queries in Codeigniter

by

Another way is to use Query Binding which automatically escapes all the values:

$sql = "INSERT IGNORE INTO my_table(lat, lng, date, type) VALUES (?,?,?,?);"; 
$this->db->query($sql, array($data['lat'], $data['lng'], $data['date'], $data['type']));

More Related Contents:

  1. Grouping WHERE clauses in Codeigniter
  2. How to select rows where column value IS NOT NULL using CodeIgniter’s ActiveRecord?
  3. how to select only one value sql
  4. How to create codeigniter dynamic menu from single table
  5. Comma separated numeric values – PHP CodeIgniter
  6. CodeIgniter – foreach loop
  7. PHP – Change value y,n in database [closed]
  8. How to insert multiple rows from array using CodeIgniter framework?
  9. strange character encoding of stored data , old script is showing them fine new one doesn’t
  10. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  11. Find total number of results in mySQL query with offset+limit
  12. How to create Codeigniter batch insert array
  13. How to add an ORDER BY clause using CodeIgniter’s Active Record methods?
  14. How can I Use Prepared Statements in CodeIgniter
  15. What are the differences between backtick and single quote? Can I use IF statement in a query as above?
  16. How to create Codeigniter language files from database?
  17. Trying to get property of non-object – CodeIgniter
  18. Codeigniter Transactions
  19. Inserting NOW() into Database with CodeIgniter’s Active Record
  20. Using utf8mb4 with php and mysql
  21. how do I get month from date in mysql
  22. How can I redirect a 404 Error in a custom 404 page using Codeigniter?
  23. How do I save PHP session data to a database instead of in the file system?
  24. Difference between mysql_fetch_array and mysql_fetch_row?
  25. MySQL, how to insert null dates
  26. Can I detect and handle MySQL Warnings with PHP?
  27. using mysql_close()
  28. Should I disable MySQL strict mode?
  29. Using PDO Prepared Statement and Incrementing a column value
  30. Displaying BLOB image from Mysql database into dynamic div in html

Leave a Comment