Inserting NOW() into Database with CodeIgniter’s Active Record

by

I typically use triggers to handle timestamps but I think this may work.

$data = array(
    'name' => $name,
    'email' => $email
);

$this->db->set('time', 'NOW()', FALSE);
$this->db->insert('mytable', $data);

More Related Contents:

  1. how to select only one value sql
  2. How to create codeigniter dynamic menu from single table
  3. Comma separated numeric values – PHP CodeIgniter
  4. CodeIgniter – foreach loop
  5. PHP – Change value y,n in database [closed]
  6. How to insert multiple rows from array using CodeIgniter framework?
  7. strange character encoding of stored data , old script is showing them fine new one doesn’t
  8. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  9. Find total number of results in mySQL query with offset+limit
  10. How can I Use Prepared Statements in CodeIgniter
  11. Grouping WHERE clauses in Codeigniter
  12. What are the differences between backtick and single quote? Can I use IF statement in a query as above?
  13. How to create Codeigniter language files from database?
  14. Trying to get property of non-object – CodeIgniter
  15. Codeigniter Transactions
  16. How to select rows where column value IS NOT NULL using CodeIgniter’s ActiveRecord?
  17. Escaping SQL queries in Codeigniter
  18. Php mysql tabs don’t output [closed]
  19. Update Mysql except when field not null
  20. How print in Jquery / Datatables [closed]
  21. How can I prevent SQL injection in PHP?
  22. jQuery Validate remote method usage to check if username already exists
  23. Sending email with gmail smtp with codeigniter email library
  24. PDO get the last ID inserted
  25. Warning: mysqli_connect(): (HY000/2002): No such file or directory
  26. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  27. Do I really need to do mysql_close()
  28. Stored Procedures, MySQL and PHP
  29. Difference between mysql_fetch_array and mysql_fetch_row?
  30. Aggregated query without GROUP BY

Leave a Comment