[ciapug] PHP 5 and MySQLI

[David Champion]

First thing I'd check is if you're iterating through your record set 
without moving the record pointer...

-dc

Wyatt, Rich wrote:
> Hello all... 
> 
>  
> 
> 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.
> 
>  
> 
> 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... 
> 
>  
> 
> Am I forgetting to $rslt->close(); a result somewhere or is this
> necessary for every single result set?
> 
>  
> 
> 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?
> 
>  
> 
> 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... )
> 
>  
> 
> 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.
> 
>  
> 
>  
> 
> Thanks,
> 
>  
> 
> Rich S. Wyatt
> 
> Webmaster / Deltek Vision Project Manager
> 
> Bloodgood Sharp Buster Architects and Planners, Inc.
> 
> Corporate-Des Moines
> 
> Office:  515.273.3020            Fax: 515.221.3272
> 
> www.bsbdesign.com <http://www.bsbdesign.com/>  
> 
> National Experience, Regional Sensitivity
> 
>  
> 
>  
> 
> 
> 
> 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.
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> ciapug mailing list
> ciapug at cialug.org
> http://cialug.org/mailman/listinfo/ciapug