Welcome to WebmasterWorld Guest from 184.108.40.206 , register , free tools , login , search , subscribe , help , library , announcements , recent posts , open posts Subscribe to WebmasterWorld
ActiveRecord for PHP5 httpwebwitch msg:3940215 1:41 pm on Jun 25, 2009 (gmt 0) Hey have any of you used "ActiveRecord" in PHP?
There are a few bloggerware ones out there, and I'm wondering which one I should try.
the example I was given is:
before - in PHP
$result = mysql_query("SELECT * FROM tablename WHERE id = 5");
after - in ActiveRecord
$result = $this->db->get_where('tablename', array('id' => 5))
To me this seems like a good thing, expecially if it has built-in parameterization to prevent SQL injection (which I do manually now, and it's a major PITA)
FourDegreez msg:3940339 4:07 pm on Jun 25, 2009 (gmt 0)
I haven't used that, but I have used other database access abstractions that separate you from the actual SQL. In my experience, you'll always find cases where you can't execute the query you'd like so you'll have to do a work-around. Have you considered using PDO? nick279 msg:3940867 12:09 pm on Jun 26, 2009 (gmt 0)
If you are reading then OK, but if you are writing make sure it supports a decent, easy to use write method
or something similar