Jednoduche vyhladavanie v databaze

Skôr som dúfal v nejake konkrétne riešenie ako dokumentáciu, bohuzial z nej som to velmi nepochopil

Vďaka za odpoveď, niečo podobne som skúšal už predtým, bohužial mi to vyhodilo error:
Cannot read an undeclared property Nette\Forms\Controls\SubmitButton::$onSuccess. Kedze som videl onSuccess videl pouzivat uz Xkrat , predpokladal som ze robim nieco zle. Nejake rady teda na tento onSuccess?

Edit: Upravil som si formular a uz sa tam formular zobrazuje, sice hadze error ale snad na to pridem , vďaka za pomoc

Editoval Andurit (19. 11. 2013 21:03)

Mám to nejako takto:

<?php
public function searchsucceeded($searchword)
	{
	$selection = $this->banned->findAll->select('*')->where("name LIKE ?", "%$searchword%");
	return $selection;
    }

    protected function createComponentSearchForm()
	{
 		$form = new Form;
        $form->addText('name', 'Vyhľadať ban...vložte nick hráča');
        $form->addSubmit('search', 'Hľadať');
        $form->onSuccess[] = callback($this, 'searchsucceeded');
        return $form;
	}

?>

Pricom po odoslaní formulára mi to hádže chybu : Call to undefined method Nette\Callback::select() , pripadne where(). Doteraz som mal dojem select a where su preddefinovane. Zrejme sa mýlim alebo mam chybu niekde inde.

Toto je z modelu:

<?php
	public function findAll()
	{
		return $this->database->table('banlist');
	}
?>

p.s. skúsil som použit aj tvoj placeholder, prave dlhsie som uvažoval ako ho tam rozumne vložiť. Bohužiaľ vždy s chybou Cannot read an undeclared property BannedPresenter::$search.

Mal si pravdu, skoda tie () som si mohol všimnuť. Placeholder som urobil chybu. Teraz uz vidim kde ked si tu dal tento posledny priklad.

Každopádne k veci. /banned/?do=searchForm-submit krasne žiaden error, kedze hore mam v render default nieco ako : $this->template->banned = $this->banned->findAll()->order(‚id‘)->order(‚admin‘);
tak sa mi LOGICKY vzdy nacita toto a nie výsledok môho formu. Pošlem tu celý prezenter skus na to mrknut ak mas cas.

<?php
<?php

use Nette\Application\UI\Form;


class BannedPresenter extends BasePresenter
{
	/** @var AlbumRepository */
	private $banned;


	public function inject(Banned $banned)
	{
		$this->banned = $banned;
	}


	protected function startup()
	{
		parent::startup();
		echo "SOM PICA";
	}

	public function LoggedUser()
	{
		if (!$this->user->isLoggedIn()) {
			if ($this->user->logoutReason === Nette\Http\UserStorage::INACTIVITY) {
				$this->flashMessage('Bol si odhlasený.');
			}
			$this->redirect('banned', array('backlink' => $this->storeRequest()));
		}
	}


	/********************* view default *********************/


	public function renderDefault()
	{
		$this->template->banned = $this->banned->findAll()->order('id')->order('admin');
		$vp = new VisualPaginator($this, 'vp');
		$paginator = $vp->getPaginator();
		$paginator->itemsPerPage = 20;
		$paginator->itemCount = $this->template->banned->count('*');
		$this->template->banned = $this->banned->findAll()->order('id, admin')->limit($paginator->itemsPerPage,$paginator->offset);
	}


	/********************* views add & edit *********************/


	public function renderAdd()
	{
		$this['albumForm']['save']->caption = 'Add';
		//$this['searchForm']['search']->caption = 'Hľadať';
	}

	public function renderEdit($id = 0)
	{
		$form = $this['albumForm'];
		if (!$form->isSubmitted()) {
			$banned = $this->banned->findById($id);
			if (!$banned) {
				$this->error('Record not found');
			}
			$form->setDefaults($banned);
		}
	}


	/********************* view delete *********************/


	public function renderDelete($id = 0)
	{
		$this->template->banned = $this->banned->findById($id);
		if (!$this->template->banned) {
			$this->error('Record not found');
		}
	}


	/********************* component factories *********************/


	/**
	 * Edit form factory.
	 * @return Form
	 */
	protected function createComponentAlbumForm()
	{
		$this->LoggedUser();
		$form = new Form;
		$form->addText('name', 'Zabanovany:')
			->setRequired('Vlozte nick zabanovaneho hraca.');

		$form->addText('reason', 'Dovod:')
			->setRequired('Prosim vlozte dovod banu.');

		$form->addSubmit('save', 'Save')
			->setAttribute('class', 'default')
			->onClick[] = $this->albumFormSucceeded;

		$form->addSubmit('cancel', 'Cancel')
			->setValidationScope(NULL)
			->onClick[] = $this->formCancelled;

		$form->addProtection();
		return $form;
	}


	public function albumFormSucceeded($button)
	{
		$values = $button->getForm()->getValues();
		$id = (int) $this->getParameter('id');
		if ($id) {
			$this->banned->findById($id)->update($values);
			$this->flashMessage('Ban bol upravený.');
		} else {
			$this->banned->insert($values);
			$this->flashMessage('Ban bol pridany.');
		}
		$this->redirect('default');
	}


	protected function createComponentDeleteForm()
	{
		$form = new Form;
		$form->addSubmit('cancel', 'Cancel')
			->onClick[] = $this->formCancelled;

		$form->addSubmit('delete', 'Delete')
			->setAttribute('class', 'default')
			->onClick[] = $this->deleteFormSucceeded;

		$form->addProtection();
		return $form;
	}


	public function deleteFormSucceeded()
	{
		$this->banned->findById($this->getParameter('id'))->delete();
		$this->flashMessage('Ban bol zmazany!');
		$this->redirect('default');
	}


	public function formCancelled()
	{
		$this->redirect('default');
	}

	public function searchsucceeded($searchword)
	{
	return $this->banned->findAll()->select('*')->where("name LIKE ?", "%$searchword%");
    }

    protected function createComponentSearchForm()
	{
 		$form = new Form;
        $form->addText('name', 'Vlož nick hráča')->setAttribute('placeholder', 'Vyhľadať ban...vložte nick hráča');
        $form->addSubmit('search', 'Hľadať');
        $form->onSuccess[] = callback($this, 'searchsucceeded');
        return $form;
	}
}
?>

Keď to podávaš takto znie to logicky, a je to vcelku jasne. Každopádne, nepochopil som celkom to $search (prakticky tam aj tak hlasi undefined variabile), predpokladam ze tam malo byt $searchword, stranka sa aktualne ale presmeruje na default ale bez vykreslenia len vysledkov z vyhladavania

<?php
public function renderDefault($searchWord = null)
	{
		$this->template->banned = $this->banned->findAll()->order('id')->order('admin');
		$vp = new VisualPaginator($this, 'vp');
		$paginator = $vp->getPaginator();
		$paginator->itemsPerPage = 20;
		$paginator->itemCount = $this->template->banned->count('*');
		if (is_null($searchWord)){
		$this->template->banned = $this->banned->findAll()->order('id, admin')->limit($paginator->itemsPerPage,$paginator->offset);
		} else { $this->template->banned = $this->banned->findAll()->select('*')->where("name LIKE ?", "%$searchWord%"); }
	}
?>

<?php
return  $this->redirect('default', array($searchword));?>
?>

p.s. Link vyzera takto: localhost/www/banned/ takze redirectujem spravne ?

Editoval Andurit (21. 11. 2013 3:11)

Bohužiaľ bez zmeny, ani URL nič.. je nejako mozne aby si mi na seba dal nejaky viac interaktivny kontakt, ako SKYPE/ ICQ alebo nieco podobne (ak budem moc otravovat ,vzdy je tam magicke tlacitko IGNORE :P)

p.s. Kamos mi pred chvilkou poradil to zapisat takto:

<?php
$this->redirect('default', array('searchword' => $searchword));
?>

ak dam to searchword do uvodzoviek tak je link krasny searchword=searchword inak je to stale to iste :P

Editoval Andurit (22. 11. 2013 15:42)