[ciapug] PHP 5 and MySQLI

[Wyatt, Rich]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://cialug.org/pipermail/ciapug/attachments/20060210/7b2e24af/attachment.htm