PostgreSQL - SELECT PHP - POSTGREST

I have this script and postgrest and it is working very well with postgres database

SELECT id, date_applied, discount_id, code, id_trip, id_lane, timestamtrip,
compass, "OldAmount", "NewAmount", download, id_parking
from tlin."DiscountApplied"
where date_applied > now()::date - 1

I need to do the same in php code. How Do I do this? buecase I have te problem whit this
now()::date - 1

my code does not reconagize it.

Can you help me please?

You need to use PDO or some ORM library (Adodb, RedBean) to acces a databse from PHP.
I think this link could be helpful (http://www.zentut.com/php-pdo/pdo-connecting-to-postgresql/)