Parse error in SQL query defined as a PHP class property

Question

When I define the SQL query below as a PHP class property I get a parse error. If I instead define that same query inside one of the class methods, I get no error. Can someone please tell me how I can define this as a PHP class property correctly? Thank you.

I have other SQL queries defined as properties that work fine, but they do not contain any variables.

private $querySelectDateId = " SELECT healthDateId FROM kidsDate WHERE healthDate = '$healthDate' ";

Answer 1

You can't use a variable in a property declaration, especially a local one in a non local context (also $this->healthDate would not work either). One way could be to declare property value in your __construct():

public function __construct()
{
    $healthDate = '2015-09-27';
    $this->querySelectDateId = " SELECT healthDateId FROM kidsDate WHERE healthDate = '$healthDate' ";
}

Answer 2

private $querySelectDateId;

public function setSelectDateId($healthDate) {
    $this->querySelectDateId = " SELECT healthDateId FROM kidsDate WHERE healthDate = '$healthDate' ";
}

public function getSelectDateId() {
    return $this->querySelectDateId ;
}