原因:每次写个SQL。都要后台发布,更新。前端代码测试的很麻烦,找到一强大工具DreamFactory
DreamFactory连接SQLServer
Windows
Note: Starting in DreamFactory 2.3, drivers and extensions required for PHP 7 will need to be used, as reflected in these instructions.
- Download and install Microsoft ODBC Driver 11 for SQL Server (if not already installed). Currently this is available here. In 32-bit environments, install the x86 package. In 64-bit environments, install the x64 package.
- Download and install the appropriate SQL Server Native Client (if not already installed and SQL Server is not hosted on the same machine as DreamFactory). In 32-bit environments, install the x86 package. In 64-bit environments, install the x64 package. Currently the Microsoft SQL Server 2012 Native Client is available here, and the Microsoft SQL Server 2008 R2 Native Client is available here.
- DreamFactory uses PHP PDO drivers for DB connections. Full documentation on PDO_SQLSRV is available here. You will need to download and extract the Microsoft Drivers for PHP for SQL Server. Currently these are available here. Be sure to download BOTH x86 zip files
- Copy the DLLs for your version of PHP into your PHP's extensions directory. E.g., for PHP 7, the DLLs are php_pdo_sqlsrv_7_ts.dll and php_sqlsrv_7_ts.dll (which were extracted from the download in the third step). (Rare case: if you are integrating with IIS as your web server, use the non-thread-safe DLLs instead (php_pdo_sqlsrv_7_nts.dll and php_sqlsrv_7_nts.dll).)
- Enable the copied DLLs in your php.ini file. Using the example DLLs from step #4, you would add the following lines to C:\Bitnami\dreamfactory-2.3.0-1\php\php.ini and save:
- extension=php_pdo_sqlsrv_7_ts.dll
- extension=php_sqlsrv_7_ts.dll
Note: If you are using DreamFactory 2.1.0-4 or earlier, you will require drivers and extensions for PHP 5.5 (see below).
- Enable the copied DLLs in your php.ini file. Using the example DLLs from step #4, you would add the following lines to C:\Bitnami\dreamfactory-2.1.0-4\php\php.ini and save:
- extension=php_pdo_sqlsrv_55_ts.dll
- extension=php_sqlsrv_55_ts.dll
- Restart your web server to apply these PHP configuration changes.