Zend Framework create a sql function

Question

I would like to create a sql query in Zend Framework in the Abstract.php or in model? but I have a hard time figure out how to do it. I am new in zend framework.

The query that I want to create looks like that:

delete from users where id not in(select * from(select min(n.id)from users n group by n.email)x);

But in zend:

$results = $db->query('delete
                from users
                where id not in(
                    select * from(
                        min(n.id)
                        from users n
                        group by n.email
                )x)');

Look like the $db got a undefined variable, what kind of database function should the db call? My database is being call in the application.ini

That's not even the slightest bit valid PHP code. Look at stackoverflow.com/a/5380654/1902010 for something similar to what you're trying to do. — ceejayoz
– ceejayoz, Commented Feb 11, 2013 at 21:53
I'd imagine you change select() to delete(), but you'd want to learn PHP and read the documentation before you go doing destructive changes to data like that. — ceejayoz
– ceejayoz, Commented Feb 11, 2013 at 22:08
Which database adapter are you using? It should be set in your ini file. — James Woodruff
– James Woodruff, Commented Feb 12, 2013 at 1:41

Nilesh Gupta · Accepted Answer · 2013-02-13 10:50:03Z

2

you have to write this syntex for executing your custom query..

$db->getAdapter()->query('delete
                from users
                where id not in(
                    select * from(
                        min(n.id)
                        from users n
                        group by n.email
                )x)');

answered Feb 13, 2013 at 10:50

Nilesh Gupta

3671 silver badge2 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Zend Framework create a sql function

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related