public function getAllFloras() { $db = new Db(); $floras = array(); $results = $db->select("SELECT\r\n research.rid AS 'rid',\r\n research.date AS 'date',\r\n research.weather AS 'weather',\r\n research.plantName AS 'plantName',\r\n research.location AS 'location',\r\n research.additionalNote AS 'additionalNote',\r\n soiltype.soilName AS 'soilType_idsoilType',\r\n research.users_user_id AS 'users_user_id',\r\n users.user_name as 'userName'\r\n FROM research\r\n INNER JOIN soiltype ON\r\n research.soilType_idsoilType = soiltype.idsoilType\r\n INNER JOIN users ON\r\n research.users_user_id = users.user_id\r\n ORDER BY rid DESC;"); foreach ($results as $result) { $flora = new Flora(); $flora->hydrate($result); $floras[] = $flora; } return $floras; }
case 'add_flora': $floraManager = new FloraManager(); $flora = new Flora(); include '../views/guest_flora_add_edit.php'; break; case 'save_flora': $floraManager = new FloraManager(); $arr = array(); $arr["rid"] = isset($_GET["rid"]) ? $_GET["rid"] : ''; $arr["users_user_id"] = 3; $arr["date"] = isset($_GET["date"]) ? $_GET["date"] : ''; $arr["weather"] = isset($_GET["weather"]) ? $_GET["weather"] : ''; $arr["plantName"] = isset($_GET["plantName"]) ? $_GET["plantName"] : ''; $arr["location"] = isset($_GET["location"]) ? $_GET["location"] : ''; $arr["additionalNote"] = isset($_GET["additionalNote"]) ? $_GET["additionalNote"] : ''; $arr["soilType_idsoilType"] = isset($_GET["soilType"]) ? $_GET["soilType"] : ''; $flora = new Flora(); $flora->hydrate($arr); $floraManager->save($flora); include '../views/thank_you.php'; break; default: $floraManager = new FloraManager(); $flora = new Flora(); include '../views/guest_flora_add_edit.php'; break; } ?> </body> </html>