Article View: pl.comp.lang.php
Article #220391Re: jak pokazac wynik funkcji mysql w php ?
From: dziobacz
Date: Sat, 29 Aug 2009 09:21
Date: Sat, 29 Aug 2009 09:21
38 lines
2319 bytes
2319 bytes
On 29 Sie, 11:03, pakalk <pak...@gmail.com> wrote:
> On Aug 29, 10:56 am, dziobacz <aaabbbcccda...@gmail.com> wrote:
>
>
>
> > W php my adminie zrobilem funkcje:
>
> > DROP FUNCTION IF EXISTS fun;
> > DELIMITER $$
>
> > CREATE FUNCTION fun(zmienna INT) RETURNS INT
> > BEGIN
> > DECLARE x INT;
> > SET x = zmienna;
> > SET x = x+1;
> > RETURN x;
> > END
>
> > Jak ja teraz w php wywolac - robilem cos takiego:
> > $query = mysql_query("select fun(5)") or die ("cos jest zle");
> > echo $query;
>
> > ale dostaje: Resource id #3
>
> mysql_fetch_costam();
$query = mysql_query("select fun(5) as funkcja") or die ("cos jest
zle");
$wynik = mysql_fetch_assoc($query);
$wartosc = $wynik['funkcja'];
echo $wartosc;
??
Tak jak w wypadku wykonywania zapytania z SELECT ? 4. linie kodu by
uzyskac wynik dzialania funkcji to troche duzo skoro wiadomo, ze
funkcja zawsze zwraca jedna wartosc. Myslalem, ze istnieje lepszy
sposob.
Technical Details
Message-ID:
<fb00016e-0c9a-4ab7-a62d-6361c5ded495@z28g2000vbl.googlegroups.com>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!newsfeed.gazeta.pl!feed.news.interia.pl!news.nask.pl!news.nask.org.pl!newsfeed00.sul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!z28g2000vbl.googlegroups.com!not-for-mailReferences:
<49fe46a5-98c4-41e4-a802-6a167c87be94@r34g2000vba.googlegroups.com> <bb7647dd-3235-4b63-a9b8-fb63f864d6de@e34g2000vbm.googlegroups.com>Show Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!newsfeed.gazeta.pl!feed.news.interia.pl!news.nask.pl!news.nask.org.pl!newsfeed00.sul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!z28g2000vbl.googlegroups.com!not-for-mail From: dziobacz <aaabbbcccdaabb@gmail.com> Newsgroups: pl.comp.lang.php Subject: Re: jak pokazac wynik funkcji mysql w php ? Date: Sat, 29 Aug 2009 02:21:50 -0700 (PDT) Organization: http://groups.google.com Lines: 38 Message-ID: <fb00016e-0c9a-4ab7-a62d-6361c5ded495@z28g2000vbl.googlegroups.com> References: <49fe46a5-98c4-41e4-a802-6a167c87be94@r34g2000vba.googlegroups.com> <bb7647dd-3235-4b63-a9b8-fb63f864d6de@e34g2000vbm.googlegroups.com> NNTP-Posting-Host: 89.77.157.71 Mime-Version: 1.0 X-Trace: posting.google.com 1251537710 20320 127.0.0.1 (29 Aug 2009 09:21:50 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Sat, 29 Aug 2009 09:21:50 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: z28g2000vbl.googlegroups.com; posting-host=89.77.157.71; posting-account=FTpwKgoAAABWuTKca1o8YbX_ip78wnH2 User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; pl; rv:1.9.1.2) Gecko/20090729 Firefox/3.5.2 (.NET CLR 4.0.20506) FirePHP/0.3,gzip(gfe),gzip(gfe) Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit