<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"ms sans";}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hello all… <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I recently built a new web server using PHP5 & MySQL 5.
For some reason or another I couldn’t get PHP to compile with both
imagick and the standard mysql library so I used the mysqli (MySQL Improved)
config attribute and have since read through the PHP manual about using this
new class. Very cool.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>However – I seem to be running into problems with page
load. Particularly if, let’s say, I go to the home page which has much
MySQL. If I hit refresh – it bombs… Just sits and loads and loads
and loads… <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Am I forgetting to $rslt->close(); a result somewhere or
is this necessary for every single result set?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I’ve created a mysqli instance in a file called
begin.php… $db = new myslqi(‘host’,’uname’,’pword’,’dbname’);
Can I use that $db-> everywhere or do I need to keep re-instantiating the
class every time in each new script?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I’m just new to PHP 5 so if someone could give me some
example code (other than PHP.NET – while it is explanatory it only shows
how to handle it for one query… )<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Any insights on anything that I might be missing or
overlooking from the perspective of one who is extremely familiar with the PHP4
“way of doing things with mysql” vs how to do them now with PHP5
and the MySQLI way of doing things.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Thanks,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><b><font size=2 color=navy face="ms sans"><span
style='font-size:10.0pt;font-family:"ms sans";color:navy;font-weight:bold'>Rich
S. Wyatt</span></font></b><font color=navy><span style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face="ms sans"><span
style='font-size:10.0pt;font-family:"ms sans";color:navy'>Webmaster / Deltek
Vision Project Manager</span></font><font color=blue><span style='color:blue'><o:p></o:p></span></font></p>
<p class=MsoNormal><strong><b><font size=3 color=navy face="Times New Roman"><span
style='font-size:12.0pt;color:navy'>Bloodgood Sharp Buster Architects and
Planners, Inc.</span></font></b></strong><font color=blue><span
style='color:blue'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face="ms sans"><span
style='font-size:10.0pt;font-family:"ms sans";color:navy'>Corporate-Des Moines</span></font><font
color=blue><span style='color:blue'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face="ms sans"><span
style='font-size:10.0pt;font-family:"ms sans";color:navy'>Office: 515.273.3020
Fax: 515.221.3272<o:p></o:p></span></font></p>
<p class=MsoNormal><u><font size=3 color=navy face="Times New Roman"><span
style='font-size:12.0pt;color:navy'><a href="http://www.bsbdesign.com/"
title="http://www.bsbdesign.com/"><font size=2 color=navy face="ms sans"><span
style='font-size:10.0pt;font-family:"ms sans";color:navy'><span
title="http://www.bsbdesign.com/"><span title="http://www.bsbdesign.com/">www.bsbdesign.com</span></span></span></font></a></span></font></u><u><font
size=2 color=navy face="ms sans"><span style='font-size:10.0pt;font-family:
"ms sans";color:navy'> </span></font></u><font color=blue><span
style='color:blue'><o:p></o:p></span></font></p>
<p class=MsoNormal><em><i><font size=2 color=black face="Times New Roman"><span
style='font-size:10.0pt;color:black'>National Experience, Regional Sensitivity</span></font></i></em><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span><o:p></o:p></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
<DIV><P><HR>
NOTICE: This email (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and may be legally privileged. If you are not the intended recipient, you are hereby notified that any retention, dissemination, distribution, or copying of this communication is strictly prohibited. Please reply to the sender that you have received the message in error then delete it.
</P></DIV>
</body>
</html>