TIMB / DBI_AdvancedTalk_200307 / sld019.htm 

            

              
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67

              
<!--  Presentation generated by Internet Assistant for Microsoft PowerPoint 97 -->
<HTML>
<HEAD>
<meta name="GENERATOR" content="Microsoft Internet Assistant for Microsoft PowerPoint 97">
 <TITLE>Bind those columns!</TITLE> 
</HEAD>
<BODY     >
<CENTER>
<TABLE WIDTH=100%> 
     <TR> <TD WIDTH=100% ALIGN=CENTER>
         <A HREF="sld001.htm">First</A>&nbsp;&nbsp;
         <A HREF="sld018.htm">Previous</A>&nbsp;&nbsp;
         <A HREF="sld020.htm">Next</A>&nbsp;&nbsp;
         <A HREF="sld096.htm">Last</A>&nbsp;&nbsp;
&nbsp;&nbsp;         <A HREF="index.htm">Index</A>&nbsp;&nbsp;
         <A HREF="dbi.perl.org">Home</A>&nbsp;&nbsp;
         <A HREF="tsld019.htm">Text</A>&nbsp;&nbsp;
     </TD> </TR>
     <TR> <TD WIDTH=100% ALIGN=CENTER>
         <IMG SRC="img019.gif" usemap="#Objmap" WIDTH=800 HEIGHT=600 BORDER=0>
     </TD> </TR>
</TABLE>
<P>Slide 19 of 96</P>
</CENTER>
<!-- <UL>
<H2>Bind those columns!</H2>
</UL></P>
<P><UL>
<LI><H2>Compare
</H2>
<UL>
while($row = $sth-&#062fetchrow_arrayref) {
<BR><BR>  print “$row-&#062[0]: $row-&#062[1]\n”;
<BR>}
</UL></UL><UL>
<LI><H2>
</H2>
</UL><UL>
<LI><H2>with
</H2>
<UL>
$sth-&#062bind_columns(\$key, \$value);
<BR><BR>while($sth-&#062fetchrow_arrayref) {
<BR>  print “$key: $value\n”;
<BR>}
<LI>
</UL></UL><UL>
<LI><H2>No row assignment code!
</H2>
</UL><UL>
<LI><H2>No column access code!
</H2>
</UL><UL>
<H2>                              ... just magic
</H2>
</UL><UL>
<LI><H2>
</H2>
</UL></P>
<P>  -->
</Body>
</HTML>