Searching single value from database

Hi,
I don't understand where the $selection is retrieved. It seems like synax error?

This should be ok.
Selection::fetchAll() returns collection of all rows, ->fetch() returns only one row.

class SearchPresenter extends BasePresenter {
  private $database;

  private $selection;

  public function __construct(Nette\Database\Context $database) {
    $this->database = $database;
  }

  public function renderDefault() {
    $this->template->weather = $this->database
                                ->table('weather');
  }

  public function renderSearch() {
    $this->template->weather = $this->database->table('weather')
                                              ->where('location = ?', $location);
  }


  public function createComponentSearchForm() {
    $form = new Form;
    $form->addText('city', 'City:')
      ->setRequired();
    $form->addSubmit('search', 'Search');
    $form->onSuccess[] = [$this, 'searchFormSucceeded'];
    return $form;
  }

  public function searchFormSucceeded($form, $values) {
    $location = $values->city;
    //$loc = $this->getParameter('location');
    $selection = $this->database->table('weather')->select('*');
    $rows = $this->database->table('weather')->fetchAll();
      foreach ($rows as $v) {
        echo $v;
      }

	$this->selection = $selection;
  }

You want to return column? Column of first row? Or all rows with that one column?

I think there might be a problem in my renderSearch? I don't know where to add a ->where clause and what the syntax is in this scenario.

This echos only the ids from my table, no other columns and nothing related to what is in post.

<?php

  public function searchFormSucceeded($form, $values) {
    $location = $_POST['city'];
    $row = $this->database->table('weather')->fetchAll();
      foreach ($row as $v) {
        echo $v;
      }
  }

?>

So in short what I'm trying to do, is have a search bar that can search the database for the entered value and then return or echo one single column. In my example it works with temperatures. I know how to do this in PHP, Nette syntax is quite straightforward – yet I can't seem to find out how to do this. Seems to be missing in the documentation too.

Geez, really that simple huh? I tried something similar before trying what I posted. I came so close.

Anyway, thanks a lot for your help! That works perfectly.

One more question.

I want to show the results in .latte, with an echo it echos it at the top of the page. This might be a beginner question, so I hope you don't mind.

If I want to output $row->temp; in default.latte, how do I do that? I'd probably change echo $row->temp to return $row->temp, but how do I call it in default.latte? In a different project we created a foreach and then it returned all the results from the table, since now it's a single result and echoing it isn't ideal I need a different way.

public function searchFormSucceeded($form, $values) {
    $location = $values->city;
    $rows = $this->database->table('weather')->select('temp')->where('location = ?', $location);
    $this->template->rows = $rows;
  }

And in latte

{foreach $rows as $row}
 {$row->temp}
{/foreach}

The following solved it.

{block content}
{control searchForm}
{ifset $rows}{foreach $rows as $row}
  {$row->temp}
{/foreach}
{/ifset}
{/block content}