11 February 2020

This snippet shows you how to connect to Azure database for you to run some scripts for an example. In this example we use ODBC class not through PDO. You need to download two packages from your repository or if you are using a distribution where they are not in repository you need to get them from some third party. The packages are msodbcsql and php_odbc. Also you need to enable odbc from php.ini file.

Get packages

Get packages called msodbcsql and php_odbc from repositories or if your distribution doesn't have them, from third party.

Configure php.ini

Enable php-odbc from php.ini file, by uncommenting line "extension=odbc".
Source code viewer
  1. extension=odbc
Programming Language: INI

Connect to database.

Source code viewer
  1. $db = odbc_pconnect(
  2.   'Driver={ODBC Driver 17 for SQL Server};'.
  3.   'Server=tcp:[YOUR_DOMAIN].database.windows.net,1433;'.
  4.   'Database=[YOUR_DATABASE];'.
  5.   'Encrypt=yes;'.
  6.   'TrustServerCertificate=no;'.
  7.   'Connection Timeout=30;', '[YOUR_USERNAME]', '[YOUR_PASSWORD]');
  8.  
  9. if ($db) {
  10.   $stmt = odbc_prepare($db, "SELECT * FROM table WHERE id = ?");
  11.   $success = odbc_execute($stmt, ['12345']);
  12.   if (!$success) {
  13.     print_r(odbc_error());
  14.   }
  15.  
  16.   // ...
  17.  
  18. }
  19. else {
  20.   die('Error connecting...');
  21. }
  22.  
  23. odbc_close_all();
Programming Language: PHP

"Escape" strings

Using the method above to run queries, you have to escape your strings. If the string as preceeding or appending single quote(') then the function tries to get the cell content from a file. This is a working workaround for that.
Source code viewer
  1. foreach ($fields_values as $key => $val) {
  2.   if (strlen($val) > 1 and $val{0} == "'" and $val{strlen($val)-1} == "'") {
  3.     $fields_values[$key] .= ' ';
  4.   }
  5. }
Programming Language: PHP