How to solve the problem of php odbc connecting to mysql error

Solution to php odbc error: 1. Enable the relevant extension in "php.ini"; 2. Download the 32-bit ODBC driver from the official website, install it and configure the data source DSN.

# Recommended: "

PHP Video Tutorial》

Common mistake 1: call to undefined function ****_connect()

This is related to your php. Your php does not recognize this function. This is because in php.ini, many extensions are preceded by semicolons ";". What we have to do is to remove these semicolons. A php.ini of PHP 5.0 probably looks like this:

If ; is added to it, it will not take effect. Even the php that comes with xampp does not have some necessary extension statements written in it... let alone semicolons...,

Add the last two lines of my picture above at the end of the extension, and that's it Can solve this call to undefined... problem.

Common mistake 2: PHP uses odbc to connect to mysql and reports an error sql state im014 in sqlconnect in...

This is even more confusing. This error is because you have not installed the 32-bit ODBC driver. Just go to the official website https://dev.mysql.com/downloads/connector/odbc/ to download the 32-bit installation and configure the data source DSN.

Choose the MySQL ODBC 8.0 Unicode Driver.

After completion, it will look like this

By the way, you don’t need to go to the control panel to find management tools. There is this in the win10 menu:

Wouldn’t it be more convenient to fix the two ODBC ones to the start screen?

I am learning databases recently, and stepping on pitfalls and clearing mines has become my daily routine... I should be too good at it...
Let’s learn together , make progress together!

The above is the detailed content of How to solve the problem of php odbc connecting to mysql error. For more information, please follow other related articles on the PHP Chinese website!