>>> Is there a tutorial / summary of how MYSQL
works with Perl ? (in
addition to my main question below)
I suggest the DBI module, a Database independent interface
for Perl. . It defines a set of methods, variables, and
conventions that provide
a consistent database interface, independent of the actual
database
being used.
>>>
My main query - Does Perl have a " mysql close"
command ?
in PHP - We have to 'open' a connection, - & 'close' it
- with
everything else between those commands.
If you use the DBI module, exists two methods for this:
my $dbh = DBI->connect($data_source, $username,
$password);
# ...
# ... work any stuff
# ...
$dbh->disconnect();
HTH.
perl -e '$_="tMM naaCt
Feocmama_itpUilucoGa";$_.=$1,print $2 while
s/(..)(.)//;print substr$_,1,1;'
"...just because I don't know the meaning of my art,
does not mean it has no meaning..." S.D.
----- Mensagem original ----
De: Gordon Stewart <gordonisnz gmail.com>
Para: perl-beginner@yahoogroups.com
Enviadas: Sexta-feira, 29 de Dezembro de 2006 11:01:11
Assunto: [PBML] Perl & MYSQL...
Hi,
Mainly Ive been dealing with PHP & MYSQL, for the last
few years..
I've recently enquired about an international website, &
doing a
subdomain / country-specific section for our part of the
world.
EG :- http://nz.website.
com/ (the NZ section doesnt exist - currently)
Anyway, the main webdesigner - said 'yes' to getting some
help re
re-designing the main site (with or without the NZ
section)...
He is dealing with Perl & MYSQL / CSV files - I'll wait
till the next
few days - re a reply...
But - im getting a head-start.. .
MY MAIN QUESTION :-
Is there a tutorial / summary of how MYSQL works with Perl ?
(in
addition to my main question below)
I've googled up one site :-
http://www.perlscri
ptsjavascripts. com/tutorials/ mysql/index. html
& it seems pretty straightforward - I'll just have to
get used to Perl again...
My main query - Does Perl have a " mysql close"
command ?
in PHP - We have to 'open' a connection, - & 'close' it
- with
everything else between those commands.
Though the above site doesn't say anything about closing the
connection.. .
--
G
NZ community groups - communitykwister. com
Freecycle Auckland :-
http://groups. yahoo.com/
group/AucklandFr eecycle/
<!--
#ygrp-mlmsg
{font-size:13px;font-family:arial,helvetica,clean,sans-serif
;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99%
arial,helvetica,clean,sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text p{
margin:0 0 1em 0;
}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;
}
#ygrp-vitnav{
padding-top:10px;
font-family:Verdana;
font-size:77%;
margin:0;
}
#ygrp-vitnav a{
padding:0 1px;
}
#ygrp-actbar{
clear:both;
margin:25px 0;
white-space:nowrap;
color:#666;
text-align:right;
}
#ygrp-actbar .left{
float:left;
white-space:nowrap;
}
.bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;
font-size:77%;
padding:15px 0;
}
#ygrp-ft{
font-family:verdana;
font-size:77%;
border-top:1px solid #666;
padding:5px 0;
}
#ygrp-mlmsg #logo{
padding-bottom:10px;
}
#ygrp-vital{
background-color:#e0ecee;
margin-bottom:20px;
padding:2px 0 8px 8px;
}
#ygrp-vital #vithd{
font-size:77%;
font-family:Verdana;
font-weight:bold;
color:#333;
text-transform:uppercase;
}
#ygrp-vital ul{
padding:0;
margin:2px 0;
}
#ygrp-vital ul li{
list-style-type:none;
clear:both;
border:1px solid #e0ecee;
}
#ygrp-vital ul li .ct{
font-weight:bold;
color:#ff7900;
float:right;
width:2em;
text-align:right;
padding-right:.5em;
}
#ygrp-vital ul li .cat{
font-weight:bold;
}
#ygrp-vital a {
text-decoration:none;
}
#ygrp-vital a:hover{
text-decoration:underline;
}
#ygrp-sponsor #hd{
color:#999;
font-size:77%;
}
#ygrp-sponsor #ov{
padding:6px 13px;
background-color:#e0ecee;
margin-bottom:20px;
}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;
margin:0;
}
#ygrp-sponsor #ov li{
list-style-type:square;
padding:6px 0;
font-size:77%;
}
#ygrp-sponsor #ov li a{
text-decoration:none;
font-size:130%;
}
#ygrp-sponsor #nc {
background-color:#eee;
margin-bottom:20px;
padding:0 8px;
}
#ygrp-sponsor .ad{
padding:8px 0;
}
#ygrp-sponsor .ad #hd1{
font-family:Arial;
font-weight:bold;
color:#628c2a;
font-size:100%;
line-height:122%;
}
#ygrp-sponsor .ad a{
text-decoration:none;
}
#ygrp-sponsor .ad a:hover{
text-decoration:underline;
}
#ygrp-sponsor .ad p{
margin:0;
}
o {font-size:0;}
.MsoNormal {
margin:0 0 0 0;
}
#ygrp-text tt{
font-size:120%;
}
blockquote{margin:0 0 0 4px;}
.replbq {margin:4;}
-->
__________________________________________________
Fale com seus amigos de graça com o novo Yahoo! Messenger
http://br.messenger.ya
hoo.com/
[Non-text portions of this message have been removed]
Unsubscribing info is here: h
ttp://help.yahoo.com/help/us/groups/groups-32.html
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://g
roups.yahoo.com/group/perl-beginner/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http
://groups.yahoo.com/group/perl-beginner/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:perl-beginner-digest@yahoogroups.com
mailto:perl-beginner-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
perl-beginner-unsubscribe@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.c
om/info/terms/
|