PHP - 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 [...]

July 31st, 2008  |  By Oliver  |  Tags: , ,   |  Posted in Web Platforms  |  No Comments »
(No Ratings Yet)
Loading ... Loading ...

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 [...]

July 14th, 2008  |  By Oliver  |  Tags: ,   |  Posted in Web Development  |  1 Comment »
(2 votes, average: 4.50 out of 5)
Loading ... Loading ...

How to get a list of a tables field / column names from MySQL using PHP – getFieldNames() Function

A simple function to replicate the funcationality of the depreciated mysql_list_fields() function. It returns a simple array with a numeric index of the column / field names.
$database – String – The database you want to use
$connect_string – String – Your connection string
$table – String – The name of the table you wish to list the [...]

May 13th, 2008  |  By Oliver  |  Tags: ,   |  Posted in Web Development  |  No Comments »
(No Ratings Yet)
Loading ... Loading ...

How to pipe logs from Apache to PHP / How to seperate Apache log files with PHP

I recently needed to do this for a client to customise and merge the logged data from Apache into a presentable format. A by-product of this was the ability to also roll the log file on a daily basis.I found limited information regarding how to do this most of which were methods that were faulty [...]

March 6th, 2008  |  By Oliver  |  Tags: ,   |  Posted in Web Platforms  |  1 Comment »
(No Ratings Yet)
Loading ... Loading ...