🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: be.comp.programming
Article #14205

Re: perl en mysql vraagje

#14205
From: John Bokma
Date: Fri, 23 Mar 2001 23:26
88 lines
2987 bytes
Franky Claeys wrote in message <99fsr9$6np$1@mykenos.hogent.be>...
>hallo,
>
>
>heb hier een probleempje met een perl/cgi scriptje. Hoe ik ook probeer, ik
>krijg het maar niet aan de praat.
>Ik krijg steeds de volgende foutboodschap:
>use of uninitialized value at ticktest.pl line 29 (#1)
>(w) An undefined value was used as if it were already defined. It was
>interpreted as
>a "" or as 0, but maybe it was a mistake. To suppress this warning assign
an
>initial value to your variable.
>
>Ik ben nogal newbie en daardoor zie ik de fout dus niet echt staan in het
>onderstaand script (alhoewel ik voel dat het misschien wel heel voor de
hand
>liggend is).
>Ik gebruik perl en MySQL op een linux redhat 6.1.
>
>bedankt alvast
>
>Frank
>
>www.franksite.net
>
>
>
>
>
1 >#!/usr/bin/perl

Zet even -w achter perl

en voeg use strict; toe

2 >use CGI;
3>use DBI;
4>use diagnostics;
5>use Data::Dumper;
6>
7>$dbh = DBI->connect('dbi:mysql:test', 'root', 'anneleen');
8>
9>$sql="SELECT * from ticklist";
10>
11>$sth=$dbh->prepare($sql);
12>$sth->execute;
13>print <<"END";
14>Content-type:text/html\n\n
15>
16><html>
17><head>

Geen title?

18></head>
19><body bgcolor="#FAEBD7">

Als je de bgcolor aanpast, zet dan ook de andere kleuren.

20>END
21>while (@rows=$sth->fetchrow_array)
22>{
23>    print <<"END";
24><p>testje</p>
25>END
26>for ($i=0; $i<=$#rows; $i++)

Je krijgt deze fout omdat de @rows = $sth->fetchrow_array
best wel eens undef had kunnen geven... (geen rijen).

korter:

print map { "<H1>$_</H1>\n } @rows;

Mocht dat dezelfde fout geven, doe dan:

print map { als boven } @rows if @rows;

[snip]

John

--
Castle Amber - Software Development
Perl / Java / C / C++ developer *available*
email john@castleamber.co.nz for more info
or visit http://castleamber.co.nz/
Technical Details
Message-ID: <99gm5q$3ob$1@lust.ihug.co.nz>
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!news.tele.dk!216.218.192.242!news.he.net!news-hog.berkeley.edu!ucberkeley!nntp-relay.ihug.net!lust.ihug.co.nz!ihug.co.nz!not-for-mail
References: <99fsr9$6np$1@mykenos.hogent.be>

Show Full Headers
Complete Article Headers
X-Google-Language: DUTCH,ASCII-7-bit
X-Google-Thread: 107324,c92c20c634f97d57
X-Google-Attributes: gid107324,public
X-Google-Thread: fcea4,c92c20c634f97d57
X-Google-Attributes: gidfcea4,public
X-Google-ArrivalTime: 2001-03-23 15:30:38 PST
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!news.tele.dk!216.218.192.242!news.he.net!news-hog.berkeley.edu!ucberkeley!nntp-relay.ihug.net!lust.ihug.co.nz!ihug.co.nz!not-for-mail
From: "John Bokma" <postmaster@castleamber.co.nz>
Newsgroups: be.comp.programming,nl.comp.programmeren
Subject: Re: perl en mysql vraagje
Date: Sat, 24 Mar 2001 11:26:20 +1200
Organization: Castle Amber
Lines: 90
Message-ID: <99gm5q$3ob$1@lust.ihug.co.nz>
References: <99fsr9$6np$1@mykenos.hogent.be>
Reply-To: "John Bokma" <john@castleamber.co.nz>
NNTP-Posting-Host: p269-apx1.akl.ihug.co.nz
X-Trace: lust.ihug.co.nz 985390075 3851 203.173.193.15 (23 Mar 2001 23:27:55 GMT)
X-Complaints-To: abuse@ihug.co.nz
NNTP-Posting-Date: Fri, 23 Mar 2001 23:27:55 +0000 (UTC)
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3