Is it possible to convert a timestamp to human readable date (in any language) with CodeIgniter 3.1.9. As much as possibe, I would like to use helper (date helper). Input : 2018-11-01 17:12:26. …
Tag: codeigniter
How to use between clause in select statement in codeigneiter
I’m trying to get data from database by taking one data row from one table and use those values as where condition. and then i tried pass json string to controller class. but i’m unable to reach this. how should i write this code This is code i used to get data. Answer Use this for between
How to count the number of rows with a date from a certain year in CodeIgniter?
I have the following query. $query = $this->db->query(‘SELECT COUNT(*) FROM iplog.persons WHERE begin_date LIKE ‘2014%”); I need to count the number of columns with a begin_date in the year …
How to print SQL statement in codeigniter model
I have a sql statement in my model, I then say My query always fails, how do I get php to print the exact sql statement being sent to my database? And display that on my php view, page Answer To display the query string: To display the query result: The Profiler Class will display benchmark results, queries you have