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

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

Cpanel / WHM – Couldn’t find MySQL manager or server or missing mysql.sock or missing hostname.pid

We have just leased a nice new dedicate box to run a few high-hit ecommerce sites. Our new dedicated servers are usually pre-loaded with WHM/Cpanel (Cuts ttl) as was the case with this one.
We recieved confirmation that the server had been setup and was live and proceeded to re-configure it for the specific sites. WHM [...]

SQL Security

SQL injection attacks pose a major security threat to un-guarded application code. Learn how to better protect your queries and code from these types of malicious attacks in this article by Angus Mackay. See his site for more info.

http://www.colinmackay.net/tabid/57/Default.aspx

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.