Update the value of a field in database by 1 using codeigniter

by

From the documentation:

set() will also accept an optional third parameter ($escape), that will prevent data from being escaped if set to FALSE.

So this should work to pass the increment statement directly to the database:

$this->db->set('usage', 'usage+1', FALSE);
$this->db->where('tag', 'java');
$this->db->update('tags');

Because it’s not escaped, if you’re using a variable instead of a fixed number it should be verified as numeric beforehand.

More Related Contents:

  1. CodeIgniter – return only one row?
  2. Normalization in database management system
  3. How to perform compound queries with logical OR in Cloud Firestore?
  4. Database development mistakes made by application developers [closed]
  5. Copying PostgreSQL database to another server
  6. Surrogate vs. natural/business keys [closed]
  7. What is NoSQL, how does it work, and what benefits does it provide? [closed]
  8. database vs. flat files
  9. First name, middle name, last name. Why not Full Name?
  10. Can we update primary key values of a table?
  11. What are the design criteria for primary keys?
  12. Oracle (ORA-02270) : no matching unique or primary key for this column-list error
  13. How do I output the results of a HiveQL query to CSV?
  14. SQLite UPSERT / UPDATE OR INSERT
  15. Elastic search, multiple indexes vs one index and types for different data sets?
  16. In terms of databases, is “Normalize for correctness, denormalize for performance” a right mantra?
  17. Full-text search in NoSQL databases [closed]
  18. Codeigniter – Using Multiple Databases
  19. Import SQL dump into PostgreSQL database
  20. How would I use ON DUPLICATE KEY UPDATE in my CodeIgniter model?
  21. Multivalued Fields a Good Idea?
  22. Elasticsearch query to return all records
  23. Are Cloud Firestore queries still case sensitive?
  24. How should you build your database from source control?
  25. Strange behavior in PowerShell function returning DataSet/DataTable
  26. Populating Spinner From SQLite Database Android
  27. SQL DataType – How to store a year?
  28. Maximum number of rows in a sqlite table
  29. Any example of a necessary nullable foreign key?
  30. Mysql service won’t start, InnoDB init function error

Leave a Comment