MySQLi - Tag Archive

How to resolve Fatal error: Class ‘mysqli’ not found / Unable to load dynamic library ‘c:\PHP\ext\php_mysql.dll’ – Access is denied.

After much digging around on the net and of course Google I managed to cobble together a trouble shooting process to find out why I was getting the error message:
Fatal error: Class ‘mysqli’ not found in E:\mysite\sql.php on line 17
PHP Warning: PHP Startup: Unable to load dynamic library ‘c:\PHP\ext\php_mysql.dll’ – Access is denied. in Unknown [...]

MySQLi & PHP – Cannot execute stored procedure twice

Just a quick note to try and stop other peoples misery while using the newer MySQL client (mySQLi) and executing multiple stored procedures.
My ENVs: PHP5 / MySQL 5 / Window 2003 Server / mySQLi
If you are failing to understand why you can’t execute a stored procedure twice, here’s the answer:
The Stored Procedure:
DELIMITER $$
CREATE
PROCEDURE `testdb`.`getCategoryInfo`(thisCatid INT)
BEGIN
SELECT [...]

Adobe Adobe CS3 Apache Asterisk C++ Captivate CodeBlog Count Down CPanel Drivers Firefox IE iPhone iPod Touch MySQL MySQLi OpenSSL PHP PopTop PPTP SipX Site Security Skype TechEd 2010 Usage Checker VB.NET Virtual Machine Vista VMWare VPN wakoopa WebClient WHM Windows 7 Windows Gadgets Windows Server WordPress Zen Internet

WP Cumulus Flash tag cloud by Roy Tanck requires Flash Player 9 or better.