Welcome to WebmasterWorld Guest from 54.224.253.195

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

ActiveRecord for PHP5

     
1:41 pm on Jun 25, 2009 (gmt 0)

Moderator from CA 

WebmasterWorld Administrator httpwebwitch is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Aug 29, 2003
posts:4059
votes: 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)

4:07 pm on June 25, 2009 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Feb 27, 2003
posts:741
votes: 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?
12:09 pm on June 26, 2009 (gmt 0)

Junior Member

5+ Year Member

joined:July 21, 2008
posts:103
votes: 0


If you are reading then OK, but if you are writing make sure it supports a decent, easy to use write method

e.g. $this->db->update($_POST)

or something similar