Recommendation for a PHP ORM library?

[laredotornado]

Hi,

I'm using PHP 5.2. I am looking for some library or framework that
can map/generate PHP objects to MySQL database tables. I found
Propel, though a Google search, but it requires me to turn off magic
quotes in my php.ini file and too many of my applications depend on
that setting.

Anyway, your experiences and recommendations are greatly appreciated,
- Dave

[Olaf Schinkel]

la***********@gmail.com schrieb:

Hi,

I'm using PHP 5.2. I am looking for some library or framework that
can map/generate PHP objects to MySQL database tables. I found
Propel, though a Google search, but it requires me to turn off magic
quotes in my php.ini file and too many of my applications depend on
that setting.

Are you sure?
I found in the code:
--------------------------------
this->value = $_POST[$varName];
if ( ini_get( 'magic_quotes_gpc' ) )
$this->value = $this->rStripSlashes( $this->value );
--------------------------------

So it will checked, if MQ is on or not.

[Jerry Stuckle]

la***********@gmail.com wrote:

Hi,

I'm using PHP 5.2. I am looking for some library or framework that
can map/generate PHP objects to MySQL database tables. I found
Propel, though a Google search, but it requires me to turn off magic
quotes in my php.ini file and too many of my applications depend on
that setting.

Anyway, your experiences and recommendations are greatly appreciated,
- Dave

So, fix your applications. Test for magic quotes as Olaf suggested,
then turn them off.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[Michael Fesser]

..oO(la***********@gmail.com)

>I'm using PHP 5.2. I am looking for some library or framework that
can map/generate PHP objects to MySQL database tables. I found
Propel, though a Google search, but it requires me to turn off magic
quotes in my php.ini file and too many of my applications depend on
that setting.

You should start fixing your applications, because magic quotes will
be completely removed from PHP 6. They never worked properly and won't
prevent SQL injection.

Micha

[laredotornado]

On Jul 3, 9:53*pm, Olaf Schinkel <[e-mail]:

[e-mail] schrieb:Hi,

I'm using PHP 5.2. *I am looking for some library or framework that
can map/generate PHP objects to MySQL database tables. *I found
Propel, though a Google search, but it requires me to turn off magic
quotes in my php.ini file and too many of my applications depend on
that setting.

Are you sure?
I found in the code:
--------------------------------
this->value *= * * * $_POST[$varName];
* * * * * * * * * * * * if ( ini_get( 'magic_quotes_gpc' ) )
* * * * * * * * * * * * * * * * $this->value = $this->rStripSlashes( $this->value );
--------------------------------

So it will checked, if MQ is on or not.

Oh, I hadn't looked at the Propel source code. I just read from their
installation page that it was a requirement for that to be turned
off. So have you used Propel as an ORM tool and is it working well
for you? Thanks, - Dave

[Peter D.]

On Jul 3, 10:23*pm, "[e-mail]"
<[e-mail]:

Hi,

I'm using PHP 5.2. *I am looking for some library or framework that
can map/generate PHP objects to MySQL database tables. *I found
Propel, though a Google search, but it requires me to turn off magic
quotes in my php.ini file and too many of my applications depend on
that setting.

Anyway, your experiences and recommendations are greatly appreciated,
- Dave

I use Propel with the symfony PHP framework. I think it is excellent
but it does have some drawbacks like limited support for many to many
relationships. Also, if not coded correctly it can make some simple
database query go very slowly due to have to create many objects.
Joins for example are done very slow if not used correctly.

If you do use Propel be sure to read the docs. If done correctly it
can be a blast!