Considerations for connecting PHP to the Access Database: phpaccess

Considerations for connecting PHP to the Access Database: phpaccess

Note the following:

When installing the access database, you need to install the office version that matches with the local system. If the Windows 7 64-bit system is used, it is best to install office2010 if the Office is 64-bit...

This is because I have experienced the pain from 2003-2007-2010, especially when installing 2010. Because I have installed the 2003 version of office, I need to completely clear the 2003 version of office.

If you want to install 2010, you should try to install 2010. However, if you do not install, you can also choose o (* ￣ ▽ ￣ *) o.

Step 1

After installing office 2010, I pass it directly. You can search Baidu. Pay attention to how many bits are installed with the local operating system !!

Step 2

After installing the office, first open your -- control panel -- Management Tools -- (Data Source) ODBC -- System DNS -- add -- access Database

Note:You can also set your account and password in ODBC. Click Advanced.

Step 3

The PHP code for connecting to access data is as follows:

I want to talk about the number of PHP connections in several ways: PDO driver, ado, And the ODBC connection method I am talking about today,

Summary

The above is all the considerations for connecting PHP to the Access database. I hope this article will be helpful for you to connect to the Access database using PHP. If you have any questions, please leave a message for discussion.