[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: mysql: Perl Module for MySQL?
From:       Jaromir Dolecek <dolecek () ics ! muni ! cz>
Date:       1997-02-23 18:03:56
[Download RAW message or body]

> On Sun, 23 Feb 1997, Richard Sharpe wrote:
> 
> > Hi,
> > 
> > I am looking at CGI scripting for Database access. Is there a perl module
> > for MySQL?
> 

I would recommend looking at PHP/FI, it's nice scripting language
with optional connectivity to mSQL, MySQL, Postgres .. I'm using 
it and I'm very satisfied ;-) It should be compiled as (Fast)CGI skript
or (and) as Apache module. More info at

http://www.vex.net/php/

It really performs much better than Perl script ;-b I like it very much,
it's simple and powerful.

Example - foo.phtml:

<HTML>
<BODY>
<?echo "<CENTER><H1>Priklad</CENTER></H1>";
        mysql_connect("localhost");

        $result = mysql("boards","select * from list ");
        $num = mysql_numrows($result);
        $i=0;
        echo "<BR><OL>";
        while($i<$num);
                $b_id=mysql_result($result,$i,"b_id");
                $b_name=mysql_result($result,$i,"b_name");
                $b_comment=mysql_result($result,$i,"b_comment");
                echo "<IMG SRC=\"/icons/ball.red.gif\"><A
HREF=\"nastenky.phtml?$b_id\"><B><I>$b_name</I></B></a> -
$b_comment</a><BR>";
                $i++;
        endwhile;
        echo "<IMG SRC=\"/icons/ball.red.gif\"><A
HREF=\"novy.phtml\"><B><I>Vytvorit nove tema</I></B></a><BR>";
        echo "<BR></OL>";
>
</BODY>
</HTML>


-- 
Jaromir Dolecek             	ICS MU, Botanicka 68A, Brno, 60200, Czech Rep.
dolecek@ics.muni.cz			Tel.: +42-5-4151 2266
http://www.ics.muni.cz/~dolecek/
-------------------------------------------------------------------------------
It is better never to have been born.  But who among us has such luck?
One in a million, perhaps.
-------------------------------------------------------------------------------

[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic