I think you may need to change<div><br></div><div><div>foreach($conn->query($sql) as $row) {</div><div><br></div><div>to</div><div><br></div><div>$result = $conn->query($sql)->fetchAll();</div><div>foreach($result as $row) {</div>
<div><br><div class="gmail_quote">On 23 February 2010 16:05, Gnitnop G <span dir="ltr"><<a href="mailto:gnitnop@ymail.com">gnitnop@ymail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<table cellspacing="0" cellpadding="0" border="0"><tbody><tr><td valign="top" style="font:inherit"><div>Oops! I should have said I'm using mysql PDOs.</div>
<div>anyways after a read thru the manual heres what I found.</div>
<div> </div>
<div>"$conn" returns a PDO object<br>"$conn->query($sql)" returns a PDOStatement Object<br>"$query($sql)" returns an array</div>
<div> </div>
<div>since the last line returns an array the $conn object should be iterable.</div>
<div> </div>
<div>Moreover, I have also tested it without a database service for A.php. I removed all db handling code from A.php and am able to login. I have no problem. thats because the dbconnect object is already created by login2.php and its just once. So I am able to login because A.php doesnt include dbconnect.php(just for the test). The problem kicks in when A.php locally includes dbconnect.php. Thats when there is a confiict of object creation. first login2.php creates the object (obviously by doing a $conn = dbConnect('query'); new PDO blah blah..) and then the local script A.php has its own include to dbconnect.php.</div>
<div> </div>
<div>So I can say after testing that the code is fine when the includes are switched off.</div>
<div> </div>
<div>I also tried persistent connections by adding another argument in the new PDO constructor</div>
<div>array(PDO::ATTR_PERSISTENT => true); and then making all $conn=null on completion of each local script, but that didnt seem to work either....probably I was missing something else, but I cut the research since I thought I was going away in a tangent.</div>
<div> </div>
<div>have anyone struck gold yet?</div>
<div> </div>
<div>thanks</div>
<div>greymatter</div>
<div><font face="Consolas" color="#0000bb"></font><br><br>--- On <b>Mon, 22/2/10, Kim Richardson <i><<a href="mailto:krichardson@viewdale.com.au" target="_blank">krichardson@viewdale.com.au</a>></i></b> wrote:<br></div>
<blockquote style="padding-left:5px;margin-left:5px;border-left:rgb(16,16,255) 2px solid"><br>From: Kim Richardson <<a href="mailto:krichardson@viewdale.com.au" target="_blank">krichardson@viewdale.com.au</a>><div class="im">
<br>Subject: Re: [PHPwestoz] problem with includes<br></div>To: <a href="mailto:phpwestoz@lists.linux.org.au" target="_blank">phpwestoz@lists.linux.org.au</a><br>Date: Monday, 22 February, 2010, 15:27<div><div></div><div class="h5">
<br><br>
<div>The output of $conn->query($sql) would be a result set pointer, not an actual array. <br><br>Try <br><br>$result=$conn->query($sql);<br>if($result->num_rows>0)<br>{<br> while($row=$result->fetch_assoc())<br>
{<br> ... do your magic here<br> }<br>}<br><br>On 22/02/2010 9:58 PM, Gnitnop G wrote:
<blockquote type="cite">
<table cellspacing="0" cellpadding="0" border="0">
<tbody>
<tr>
<td style="font-family:inherit;font-size-adjust:inherit;font-stretch:inherit" valign="top">
<div>30 <div id="artdescription"><br> <?php<br> foreach ($conn->query($sql) as $row) {<br> ?><br> <h2><?php echo $row['title']; ?></h2><br> <p><?php $extract = getFirst($row['article']); <br>
echo $extract[0];<br> if ($extract[1]) {<br> <br> echo '<a href="abstractexplanation.php?article_id='.$row['article_id'].'"> More</a>';<br>
}
?></p><br> <?php } ?><br>41 </div></div>
<div> </div>
<div> </div>
<div>ps: according to my sketched-out example, that last error should look like this:</div>
<div> </div>
<div>[Mon Feb 22 12:26:49 2010] [error] [client 127.0.0.1] PHP Warning: Invalid argument supplied for foreach() in C:\\Program Files\\Apache Group\\Apache2\\htdocs\\xxxxxxxx\\B.php on line 31, referer: <a href="http://localhost/xxxxxxxx/B.php" rel="nofollow" target="_blank">http://localhost/xxxxxxxx/B.php</a></div>
<div> </div>
<div> </div>
<div> </div>
<div>--- On <b>Mon, 22/2/10, Keith Moss <i><a href="http://uk.mc246.mail.yahoo.com/mc/compose?to=khan@swcombine.com" rel="nofollow" target="_blank"><khan@swcombine.com></a></i></b> wrote:<br></div>
<blockquote style="padding-left:5px;margin-left:5px;border-left:rgb(16,16,255) 2px solid"><br>From: Keith Moss <a href="http://uk.mc246.mail.yahoo.com/mc/compose?to=khan@swcombine.com" rel="nofollow" target="_blank"><khan@swcombine.com></a><br>
Subject: Re: [PHPwestoz] problem with includes<br>To: "PHP users in Western Australia (or nearby)" <a href="http://uk.mc246.mail.yahoo.com/mc/compose?to=phpwestoz@lists.linux.org.au" rel="nofollow" target="_blank"><phpwestoz@lists.linux.org.au></a><br>
Date: Monday, 22 February, 2010, 11:32<br><br>
<div>Ah I see it's time once again for the annual post to the mailing list :)
<div><br></div>
<div>include_once should indeed work the situation you describe.</div>
<div><br></div>
<div>What was the code around line 31 of journal_pdo.php that was throwing the foreach error?<br><br>
<div class="gmail_quote">On 22 February 2010 13:30, Gnitnop G <span dir="ltr"><<a href="http://uk.mc246.mail.yahoo.com/mc/compose?to=gnitnop@ymail.com" rel="nofollow" target="_blank">gnitnop@ymail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="padding-left:1ex;margin:0px 0px 0px 0.8ex;border-left:rgb(204,204,204) 1px solid">
<table cellspacing="0" cellpadding="0" border="0">
<tbody>
<tr>
<td valign="top">
<div> </div>
<div>Hi All!</div>
<div> </div>
<div>I seem to be having a problem with php includes. sketching out my problem with an example will look something like this:</div>
<div> </div>
<div>I have 3 main php pages A.php, B.php and C.php.</div>
<div>I have 3 include files; (1) dbconnect.php, (2) login1.php (3) login2.php</div>
<div> </div>
<div>All main pages; A.php, B.php and C.php includes (1) & (2) in their own page</div>
<div>login1.php includes (3)</div>
<div>login2.php AGAIN includes (1) - (for its local database service)</div>
<div> </div>
<div>Basically, in a nutshell, what I'm trying to achieve here is for a user to be able to login from any main page; i.e. A,B or C; and login1.php has the form that gets included in these pages, apart from these pages already including dbconnect.php. </div>
<div>login1.php then includes login2.php which also includes dbconnect.php for its own use.</div>
<div> </div>
<div>So the problem I'm having here is I get the following error when I try to login from any of the 3 main pages:</div>
<div> </div>
<div>[Mon Feb 22 12:06:40 2010] [error] [client 127.0.0.1] PHP Fatal error: Cannot redeclare dbconnect() (previously declared in C:\\Program Files\\Apache Group\\Apache2\\htdocs\\xxxxxxx\\includes\\dbconnect.php:2) in C:\\Program Files\\Apache Group\\Apache2\\htdocs\\xxxxxxx\\includes\\dbconnect.php on line 22, referer: <a href="http://localhost/xxxxxxx/A.php" rel="nofollow" target="_blank">http://localhost/xxxxxxx/A.php</a> </div>
<div> </div>
<div>I get the same error when clicking from AB or C. Only the referer page in the trace changes and the rest are all the same each time.</div>
<div> </div>
<div>Then, I tried include_once for all .php's but then I run into empty for-each'es as one below:</div>
<div> </div>
<div>[Mon Feb 22 12:26:49 2010] [error] [client 127.0.0.1] PHP Warning: Invalid argument supplied for foreach() in C:\\Program Files\\Apache Group\\Apache2\\htdocs\\kookaburraartgallery\\journal_pdo.php on line 31, referer: <a href="http://localhost/xxxxxxxx/B.php" rel="nofollow" target="_blank">http://localhost/xxxxxxxx/B.php</a></div>
<div> </div>
<div>Can someone help me with this maze, plz.</div>
<div> </div>
<div>thanks</div>
<div>greymatter</div>
<div> </div>
<div> </div>
<div> </div>
<div> </div></td></tr></tbody></table><br><br>_______________________________________________<br>PHPwestoz mailing list<br><a href="http://uk.mc246.mail.yahoo.com/mc/compose?to=PHPwestoz@lists.linux.org.au" rel="nofollow" target="_blank">PHPwestoz@lists.linux.org.au</a><br>
<a href="http://lists.linux.org.au/listinfo/phpwestoz" rel="nofollow" target="_blank">http://lists.linux.org.au/listinfo/phpwestoz</a><br><br></blockquote></div><br><br clear="all"><br>-- <br>Cheers,<br>Keith<br>Australia is merely an island of Antarctica, and of no further significance.<br>
</div></div><br>-----Inline Attachment Follows-----<br><br>
<div>_______________________________________________<br>PHPwestoz mailing list<br><a href="http://uk.mc246.mail.yahoo.com/mc/compose?to=PHPwestoz@lists.linux.org.au" rel="nofollow" target="_blank">PHPwestoz@lists.linux.org.au</a><br>
<a href="http://lists.linux.org.au/listinfo/phpwestoz" rel="nofollow" target="_blank">http://lists.linux.org.au/listinfo/phpwestoz</a><br></div></blockquote></td></tr></tbody></table><br><pre><fieldset></fieldset>
_______________________________________________
PHPwestoz mailing list
<a href="http://uk.mc246.mail.yahoo.com/mc/compose?to=PHPwestoz@lists.linux.org.au" rel="nofollow" target="_blank">PHPwestoz@lists.linux.org.au</a>
<a href="http://lists.linux.org.au/listinfo/phpwestoz" rel="nofollow" target="_blank">http://lists.linux.org.au/listinfo/phpwestoz</a>
</pre></blockquote><br><pre>--
---------------
Kim Richardson
Web Applications Developer
Viewdale IT
Tel: 1300 799 516 - Fax: (07) 3319 8932
<a href="http://www.ausnix.com.au/" rel="nofollow" target="_blank">http://www.ausnix.com.au</a></pre></div><br>-----Inline Attachment Follows-----<br><br>
<div>_______________________________________________<br>PHPwestoz mailing list<br><a href="http://uk.mc246.mail.yahoo.com/mc/compose?to=PHPwestoz@lists.linux.org.au" target="_blank">PHPwestoz@lists.linux.org.au</a><br><a href="http://lists.linux.org.au/listinfo/phpwestoz" target="_blank">http://lists.linux.org.au/listinfo/phpwestoz</a><br>
</div></div></div></blockquote></td></tr></tbody></table><br>
<br>_______________________________________________<br>
PHPwestoz mailing list<br>
<a href="mailto:PHPwestoz@lists.linux.org.au">PHPwestoz@lists.linux.org.au</a><br>
<a href="http://lists.linux.org.au/listinfo/phpwestoz" target="_blank">http://lists.linux.org.au/listinfo/phpwestoz</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Cheers,<br>Keith<br>Australia is merely an island of Antarctica, and of no further significance.<br>
</div></div>