i need this Databases";

$//$ PHP class declaration and logic

class ShowsLibrary $\{$

public function displayEpisodes$($$showNumber$)\{$

$showRepo $=$ new ShowRepository$()$;

$rows $=$ $showRepo$->$findAll$($$showNumber$)$;

if $($count$($$rows$)<1)\{$

$response $=$ TvAPI::episodes$($$showNumber$)$;

$shows $=$ Show::fromAPIResponse$($$response$)$;

foreach $($$shows as $s$)\{$

$showRepo$->$create$($$s$,$ $showNumber$)$;

$\}$

$\}$ else $\{$

$shows $=$ Show::fromTableRows$($$rows$)$;

$\}$

$//$ Display episodes

foreach $($$shows as $show$)\{$

echo "Name: $\{$$show$->$name$\}|$ Season: $\{$$show$->$season$\}|$ Episode: $\{$$show$->$episode$\}|$ Summary: $\{$$show$->$summary$\}"$;

$\}$

$\}$

$\}$

$?>$ added to name $=$ $name;

$this$->$image $=$ $image;

$this$->$season $=$ $season;

$this$->$episode $=$ $episode;

$this$->$summary $=$ $summary;

$this$->$showNumber $=$ $showNumber;

$\}$

public static function fromTableRows$($$rows$)\{$

return array$\_$map$($function$($$row$)\{$

return new Show$($$row$[\text{'}$name$\text{'}],$ $row$[\text{'}$image$\text{'}],$ $row$[\text{'}$season$\text{'}],$ $row$[\text{'}$episode$\text{'}],$ $row$[\text{'}$summary$\text{'}],$ $row$[\text{'}$show$\_$number'$])$;

$\},$ $rows$)$;

$\}$

public static function fromAPIResponse$($$response$)\{$

return array$\_$map$($function$($$item$)\{$

return new Show$($$item$[\text{'}$name$\text{'}],$ $item$[\text{'}$image$\text{'}],$ $item$[\text{'}$season$\text{'}],$ $item$[\text{'}$episode$\text{'}],$ $item$[\text{'}$summary$\text{'}],$ $item$[\text{'}$show$\_$number'$])$;

$\},$ $response$)$;

$\}$

$\}$

class ShowRepo $\{$

public $database;

public function $\_\_$construct$()\{$

$this$->$database $=$ new SQLite$3(\text{'}$shows$.$db$\text{'})$;

$this$->$database$->$exec$(\text{'}$CREATE TABLE IF NOT EXISTS shows $($id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, image TEXT, season INTEGER NOT NULL, episode INTEGER NOT NULL, summary TEXT NOT NULL, show$\_$number INTEGER NOT NULL$)\text{'})$;

$\}$

public function create$($$show$)\{$

$sql $=$ "INSERT INTO shows $($name$,$ image, season, episode, summary, show$\_$number$)$ VALUES $(?,?,?,?,?,?)"$;

$stmt $=$ $this$->$database$->$prepare$($$sql$)$;

$stmt$->$bindValue$(1,$ $show$->$name$)$;

$stmt$->$bindValue$(2,$ $show$->$image$)$;

$stmt$->$bindValue$(3,$ $show$->$season$)$;

$stmt$->$bindValue$(4,$ $show$->$episode$)$;

$stmt$->$bindValue$(5,$ $show$->$summary$)$;

$stmt$->$bindValue$(6,$ $show$->$showNumber$)$;

$stmt$->$execute$()$;

$\}$

$//$ Add the rest of your code here...

$\}$

class TvAPI $\{$

public static function show$($$showNumber$)\{$

$//$ API call to get show details...

$\}$

$\}$

$?>$