Skip to main content

Codeigniter MSSQL connection




We can connect the Microsoft SQL Server 2008 R2 rdbms to php with codeigniter framework.

For that we need to install sqlsrv driver on our server. 
SqlSrv is a php driver for MS SQL  and is available from Microsoft: » http://msdn.microsoft.com/en-us/sqlserver/ff657782.aspx.

For earlier version of php before 5.3, the Mssql driver was needed. The Mssql extension is not available anymore on Windows with PHP 5.3 or later.

After we have sqlsrv driver extension added on server, we can check it on our phpinfo page. The sqlsrv should be there. We may need to install the odbc driver too depending on our system configuration.
If there is a problem with connecting sql server database, we can debug to know the error.



Then we need to add the following configuration on our database configuration file.


$db['default'] = array(
'dsn' => '',
'hostname' => '.\sqlexpress',
'username' => '',
'password' => '',
'database' => 'dbname',
'dbdriver' => 'sqlsrv',
'dbprefix' => '',
'pconnect' => FALSE,
'db_debug' => TRUE,
'cache_on' => FALSE,
'cachedir' => '',
'char_set' => 'utf8',
'dbcollat' => 'utf8_general_ci',
'swap_pre' => '',
'encrypt' => FALSE,
'compress' => FALSE,
'stricton' => FALSE,
'failover' => array(),
'save_queries' => TRUE
);


Comments

Post a Comment

Popular posts from this blog

Magento 2.3 Admin panel blank issue

After the Installation of Magento from the composer, we cannot access the admin panel. Also, the deploy command doesn't work. (On Windows 10 OS). Note: Magento 2.3 supports Linux OS. Windows and Mac OS is not supported. This is a Magento bug. Wrong paths to Windows are generated. The fixed fix is Magento 2.3.0 - 2.3.3 #/vendor/magento/framework/View/Element/Template/File/Validator.php:140 the string if (0 === strpos($realPath, $directory)) {     return true; } to replace $realDirectory = $this->fileDriver->getRealPath($directory); if (0 === strpos($realPath, $realDirectory)) {    return true; } Magento 2.2.7 /vendor/magento/framework/View/Element/Template/File/Validator.php:113 code protected function isPathInDirectories($path, $directories) {     if (!is_array($directories)) {         $directories = (array)$directories;     }     foreach ($directories as $directory) {   ...
3 comments
Read more

Magento webservice

Magento provides webservice with the ability to manage your eCommerce stores by providing calls for working with resources such as customers, categories, products, and sales orders. It also allows you to manage shopping carts and inventory. A SOAP v2 API version has been available since Magento 1.3, and a WS-I compliant version has been available since Magento 1.6. The Magento API supports SOAP and XML-RPC, where SOAP is the default protocol. With SOAP api, To connect to Magento SOAP web services, load the WSDL into your SOAP client from either of these URLs: http://hostname/api/soap/?wsdl where hostname  is the domain for your Magento host As of v1.3, you may also use the following URL to access the Magento API v2, which has been added to improve compatibility with Java and .NET: http://magentohost/api/v2_soap?wsdl=1 The following PHP example shows how to make SOAP calls to the Magento API v1: require_once('app/Mage.php'); Mage::app(); try { $client = n...
Post a Comment
Read more

Magento zip code limit validation

By Default Magento give number of validation classes.you just need to use the class name.Its easy find the html tag where their is mobile number html and add a class attribute to that input type and under the class add the following classes  "validate-length maximum-length-10 minimum-length-10 validate-digits" validate-length maximum-length-10 minimum-length-10 validate-digits Reference: http://inchoo.net/magento/out-of-the-box-form-validation-in-magento/
1 comment
Read more