static function findAll($dbh, $withSteps = false)
{
$stmt = $dbh->prepare("select * from " . Recipe::$nameTable);
$stmt->execute();
$result = array();
while ($row = $stmt->fetch()) {
$r = new Recipe();
$r->copyFromRow($row);
$r->getRecipeSteps($dbh);
$r->getRecipeDetails($dbh);
$result[] = $r;
}
return $result;
}
static function findByKeyword($dbh, $searchOne, $withSteps = false)
{
$stmt = $dbh->prepare("SELECT * FROM " . Recipe::$nameTable . " WHERE Name LIKE '%" . $searchOne . "%' AND Description LIKE '%" . $searchOne . "%'");
$stmt->execute();
$newResult = array();
while ($row = $stmt->fetch()) {
$r = new Recipe();
$r->copyFromRow($row);
if ($withSteps) {
$r->getRecipeSteps($dbh);
}
$newResult[] = $r;
}
return $newResult;
}