I have a database that I want to pull only certain rows that have dates in specified ranges. I'm not sure how to do this properly in active record. Right now it looks like I'm running a standard my...

When trying to create a record in a table using phpActiveRecord I get the following error: Invalid datetime format: 1292 Incorrect datetime value: '2013-06-20 11:59:08 PDT' for column 'created_at'...

I am having problems getting my sparks install to work with my codeigniter install here are the steps I took which were as follows: I went to my root of my codeigniter project folder through my ...

Using phpactiverecord from http://www.phpactiverecord.org/, is there any way to see the generated SQL query for debugging, other than viewing the database server's query log?

I'm using php-activerecord for a short while now and i absolutely love it. Php-activerecord is an open source ORM library based on the ActiveRecord pattern. However, i recently tried to use it in c...

What would be a good way to search a field, ignoring spaces in the search term AND the field? Example: SELECT * FROM tablename WHERE NOSPACES(fieldname) LIKE '%{search term with spaces removed}%...

I would like to have a simple a method, that can give back PHP Activerecord results as simple/associative arrays, not an array of ActiveRecord Objects. In Ruby I believe this is done perhaps with...

I'm picking up PHP Active Record and dealing with associations. I have two related objects using a "Has_Many" and "Belongs_to" (parent/child) and trying to create a child record when creating a new...

I am working with an app which uses phpActiveRecord and mySQL to pull in data from a sensor network and plot it onto a number of flot.js graphs on the client. There are several timeframes the user...

I have an model with a relation, and I want to instantiate a new object of the relations type. Example: A person has a company, and I have a person-object: now I want to create a company-objec...