[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/functions.php on line 4770: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3884)
[phpBB Debug] PHP Warning: in file /includes/functions.php on line 4772: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3884)
[phpBB Debug] PHP Warning: in file /includes/functions.php on line 4773: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3884)
[phpBB Debug] PHP Warning: in file /includes/functions.php on line 4774: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3884)
Forum eduweb.pl • Wyświetl temat - MySQL procedura
Strona 1 z 2

MySQL procedura

Post: 22 maja 2014, o 14:56
autor: torq
Witam i proszę o pomoc bo już długi czas próbuję zrobić procedurę wyświetlania całej tabeli z bazy i nie daję rady. Używam procedur to insert, update, delete ale nijak nie daję rady z procedurą wyświetlania. Jedyne co mi działa to wyświetlanie pojedynczego wiersza, kiedy chcę wyświetlić więcej to niestety dostaję komunikat z błędem, że wynikiem jest wiele wierszy. Niestety nie mogę tego zrobić za pomocą normalnego zapytania SELECT- musi to być procedura.
Proszę o pomoc.

Re: MySQL procedura

Post: 22 maja 2014, o 15:00
autor: Yasiek
jesli sie rozpisze a znowu powiesz ze juz nie potrzebne to Cie znajde :D
dawaj - jakie masz tam w tej tabeli pola??
a najlepiej pokaz strukture tworzenia tej tabeli

Re: MySQL procedura

Post: 22 maja 2014, o 15:27
autor: torq

Re: MySQL procedura

Post: 22 maja 2014, o 15:30
autor: Seapage
Jakiego zapytania używałeś? Wklej kod jak możesz to postaramy się zedytować twój aktualny sposób ;)

Re: MySQL procedura

Post: 22 maja 2014, o 15:39
autor: torq

Re: MySQL procedura

Post: 22 maja 2014, o 15:45
autor: Yasiek

Re: MySQL procedura

Post: 22 maja 2014, o 16:11
autor: torq
Yasiek ja wiem, ze selectem można to zrobić i to nie jest problem. Problem w tym że ja to MUSZĘ zrobić procedurą. W bazie wszystko działa jak trzeba ale żeby wynik ten sam wyświetlić w php to już problem. Nie mam problemu z innymi procedurami, które służą do edycji, wstawiani czy usuwania bo tylko daję id albo parametry które mają być zmienione. Problem zrodził się dopiero kiedy chcę wyświetlić wynik procedury bez parametrów

Re: MySQL procedura

Post: 22 maja 2014, o 16:16
autor: Yasiek
jedyne co musisz zrobic w spwojej procedurze to ustawic paramert OUT i zdefiniowac co chcesz dostac z powrotem
czyli przy tworzeniu procedury musisz zdefiniowac mojaprocedura(OUT paramert, OUT parametr ) itd :D

a z innymi proceddurami nie masz problemu bo domyslny parametr to IN, a one nic nie oddaja. w momencie domyslnych ustawien (IN) w chwili oddania czegokolwiek przez procedure ma wartosc null

Re: MySQL procedura

Post: 22 maja 2014, o 16:30
autor: torq

Re: MySQL procedura

Post: 22 maja 2014, o 16:32
autor: Yasiek
zgada sie - teraz musissz utworzyc kursor i zapisac te wyniki do np tymczasowej tabeli - ptem juz tylko z niej zrobic selecta w php
:)