How to install odbc extension in php7

When developing web applications using PHP, sometimes you need to use ODBC to connect to the database. ODBC is a standard for connecting different types of databases. If you want to use ODBC to connect to the database in PHP7, you need to install the ODBC extension first.

1. Install ODBC

Run the following command on the Ubuntu system to install ODBC:

sudo apt-get update
sudo apt-get install unixodbc-dev

2. Install ODBC extension

Run the following command to install the ODBC extension:

sudo apt-get install php7.0-odbc

3. Configure ODBC

After installing the ODBC extension, you need to edit the ODBC configuration files odbc.ini and odbcinst.ini.

Edit the odbc.ini file first:

sudo nano /etc/odbc.ini

Add the following content at the end of the file:

[ODBC Data Sources]
mydsn = myodbcdriver

[mydsn]
Driver = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc8w.so
Server = your_server_name
Database = your_database_name 
User = your_username
Password = your_password
Port = your_port
ClientCharset = UTF-8

Pay attention to replacing your_server_name, your_database_name, your_username, your_password, your_port with actual values.

Then edit the odbcinst.ini file:

sudo nano /etc/odbcinst.ini

Add the following content at the end of the file:

[myodbcdriver]
Driver = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc8w.so
UsageCount = 1

4. Test the ODBC connection

In Run the following command on the terminal to test the ODBC connection:

isql -v mydsn

If the connection is successful, the following message will appear:

+---------------------------+
| Connected!                |
|                           |
| sql-statement             |
| help [tablename]          |
| quit                      |
|                           |
+---------------------------+

Enter quit to exit.

5. PHP code to connect ODBC

Connect ODBC in PHP code:

$conn = odbc_connect("mydsn", "your_username", "your_password");
if (!$conn) {
    exit("连接数据库失败！");
}

$sql = "SELECT * FROM your_table";
$rs = odbc_exec($conn, $sql);

while(odbc_fetch_row($rs)) {
    $value = odbc_result($rs, 1);
    echo "$value\n";
}

odbc_close($conn);

Replace mydsn, your_username and your_password with actual values.

6. Summary

Installing the ODBC extension allows PHP7 to connect to the ODBC database. The installation steps include installing ODBC, installing ODBC extensions, configuring ODBC files and testing. After successful installation, you can connect to ODBC and query the database in PHP code.

The above is the detailed content of How to install odbc extension in php7. For more information, please follow other related articles on the PHP Chinese website!