public function run()
{
$genres = ['Action', 'Comedy', 'Family', 'History', 'Mystery', 'Sci-Fi'];
foreach ($genres as $genre) {
Genre::create(['name' => $genre, 'slug' => Str::slug($genre)]);
}
}
public function getById($id)
{
$dbh = new PDO($DBConfig::$DB_CONNSTRING, DBConfig::$DB_USERNAME, DBConfig::$DB_PASSWORD);
$sql = "select naam , stamboomnaam, soort, ras, geboortedatum, chipnummer,\n paspoortnummer,kleur, medbeeld, klantid\n from dier , klant where dierId=dier.id and klant.id = " . $id;
$resultset = $dbh->query($sql);
$rij = $resultSet->fetch();
$genre = Genre::create($id, $rij["naam"]);
$dbh = null;
return $dier;
}
public static function getById($id)
{
$dbh = new PDO(DBConfig::$DB_CONNSTRING, DBConfig::$DB_USERNAME, DBConfig::$DB_PASSWORD);
$sql = "SELECT omschrijving FROM mvc_genres WHERE id = " . $id;
$resultSet = $dbh->query($sql);
$rij = $resultSet->fetch();
$genre = Genre::create($id, $rij["omschrijving"]);
$dbh = NULL;
return $genre;
}
public function getById($id)
{
$dbh = new PDO($DBConfig::$DB_CONNSTRING, DBConfig::$DB_USERNAME, DBConfig::$DB_PASSWORD);
$sql = "select naam from dieren \n where id = {$id}";
$resultset = $dbh->query($sql);
$rij = $resultSet->fetch();
$genre = Genre::create($id, $rij["naam"]);
$dbh = null;
return $dier;
}
public function getById($id)
{
$dbh = new PDO(DBConfig::$DB_CONNSTRING, DBConfig::$DB_USERNAME, DBConfig::$DB_PASSWORD);
$sql = "select genre from mvc_genres where id = :id";
$stmt = $dbh->prepare($sql);
$stmt->execute(array(':id' => $id));
$rij = $stmt->fetch(PDO::FETCH_ASSOC);
$genre = Genre::create($id, $rij["genre"]);
$dbh = null;
return $genre;
}
public function getById($id)
{
$dbh = new PDO(DBConfig::$DB_CONNSTRING, DBConfig::$DB_USERNAME, DBConfig::$DB_PASSWORD);
$sql = "select mvc_boeken.id as boek_id, titel, genre_id, genre \n from mvc_boeken, mvc_genres \n where genre_id = mvc_genres.id and mvc_boeken.id = :id";
$stmt = $dbh->prepare($sql);
$stmt->execute(array(':id' => $id));
$rij = $stmt->fetch(PDO::FETCH_ASSOC);
$genre = Genre::create($rij["genre_id"], $rij["genre"]);
$boek = Boek::create($rij["boek_id"], $rij["titel"], $genre);
$dbh = null;
return $boek;
}
public static function getByTitel($titel)
{
$dbh = new PDO(DBConfig::$DB_CONNSTRING, DBConfig::$DB_USERNAME, DBConfig::$DB_PASSWORD);
$sql = "SELECT mvc_boeken.id as boekid, titel, genreid, omschrijving FROM mvc_boeken, mvc_genres WHERE genreid = mvc_genres.id AND titel = '" . $titel . "'";
$resultSet = $dbh->query($sql);
$rij = $resultSet->fetch();
if (!$rij) {
return null;
} else {
$genre = Genre::create($rij["genreid"], $rij["omschrijving"]);
$boek = Boek::create($rij["boekid"], $rij["titel"], $genre);
$dbh = NULL;
return $boek;
}
}
public function getByTitel($titel)
{
$sql = "select mvc_boeken.id as boek_id, titel, genre_id, genre from mvc_boeken, mvc_genres where titel = :titel";
$dbh = new PDO(DBConfig::$DB_CONNSTRING, DBConfig::$DB_USERNAME, DBConfig::$DB_PASSWORD);
$stmt = $dbh->prepare($sql);
$stmt->execute(array(':titel' => $titel));
$rij = $stmt->fetch(PDO::FETCH_ASSOC);
if (!$rij) {
return null;
} else {
$genre = Genre::create($rij["genre_id"], $rij["genre"]);
$boek = Boek::create($rij["boek_id"], $titel, $rij["genre"]);
$dbh = null;
return $boek;
}
}
private static function initGenres(Genre $gender)
{
$datas = array(array('id' => 1, 'name' => 'Hombre'), array('id' => 2, 'name' => 'Mujer'));
foreach ($datas as $data) {
$gender->create();
$gender->save($data);
}
return true;
}
