Symfony Criteria() code builder tool

Some of you already know that if you want to get something from database via Symfony you should build a query with help of Criteria() object.

Here is the link to the Symfony book and you can get familiar with this there.
Symfony Criteria()

BUT there are only simple queries samples.

What if you need something like this:

SELECT
Table1.field1, Table1.field2, Table2.field1
FROM
Table1, Table2
WHERE
((Table1.field3=1 OR Table1.field4=1) AND
Table1.field5 < 400000) AND
Table2.field1=Table1.field1

or smth. like that.

I’ve found useful tool that help you to build such queries 🙂

Symfony Criteria code builder tool

AdSense PPA

Just found this in my AdSense control panel 🙂

PPA – Pay Per Action.

If you’ve been working with COPEAC or similar system you probably know how this works.

If not – I can describe in few words.

1. You place Google Ad code on your website.

2. When Visitor clicks on it you don’t get an revenue.

3. If Visitor make a lead (registration action or buy something) you’ll get the revenue.

Revenues are quite big in comparison with AdSense PPC system.

I just started testing it and will provide you with results soon.

Keep in touch.