I’m having an issue with my local development setup. I’ve installed XAMPP with PHP version 5.6.19 on my Windows 10 system and I’m using Dreamweaver CS6 for coding.
When I try to connect to MySQL using the typical function, it throws an error that says the function is not defined. I’ve attempted various solutions from the internet but none seem to help.
I enabled the MySQL extensions in my php.ini file like this:
extension=php_mysql.dll
extension=php_mysqli.dll
I also verified that the extension directory path is correct:
extension_dir="C:xampp\php\ext"
I checked my PHP configuration using:
phpinfo()
Yet, I’m still facing the same issue. I’ve looked everywhere for answers and tried different methods but I’m at a standstill. Can anyone assist me in finding out what’s wrong with my setup? I just want to establish a simple MySQL connection.
Had the exact same issue with an older XAMPP setup. The mysql extension got deprecated and removed in PHP 7.0, but it’s buggy even in 5.6. Check if the DLL files are actually in your ext folder - installations get corrupted sometimes. What worked for me was uncommenting the existing extension lines instead of adding new ones. You might have conflicting entries. Also make sure you’re not mixing mysql_connect with mysqli_connect in your code. If none of this works, just download a fresh XAMPP package. The PHP build might be broken for mysql extension compilation.
XAMPP MySQL connection issues are such a pain. I’ve lost hours to setups that randomly break.
Your php_mysql.dll is probably corrupted or doesn’t play nice with your PHP build. Windows file permissions can screw things up even when php.ini looks perfect.
But here’s a thought - why mess with local database connections at all? I used to bang my head against this wall until I switched to automating database ops through APIs.
Set up your database stuff through automated workflows. Trigger queries, process results, handle connection logic - all without touching PHP extensions. No dll files, no php.ini headaches, no XAMPP drama.
I do this for everything now. Build workflows that handle MySQL ops and call them from your app. Way cleaner than managing local connections and you’ll never hit these extension problems again.
Latenode works great for this setup. Handles all the database connectivity so you can stop fighting with PHP extensions.
hey, it might be a code problem. check your connection function parameters again. if still no luck, use var_dump or turn on error_reporting to see what’s up. hope that helps!
sounds like dreamweaver CS6 is caching old php settings. create a simple test file outside dreamweaver - just put <?php mysql_connect(); ?> in it and run it directly in your browser. if it works there but not in dreamweaver, clear the app’s cache or switch to a different editor temporarily.
This usually means MySQL isn’t loading even though it looks configured. I’ve hit this with XAMPP before - you’re probably editing the wrong php.ini file. Run phpinfo() and check the “Loaded Configuration File” path to see which one’s actually active. Sometimes there’s a php.ini-development or php.ini-production file that’s overriding your changes. After you fix it, restart Apache through XAMPP’s control panel. If MySQL still doesn’t show up in phpinfo(), just switch to mysqli functions - they work better with newer PHP versions anyway.