[php_lover]

IS grocery crud working with SQL Server 2008 and my second question is this possible that i coneect same grocerry crud with both Database SQL Server 2008 as well as mysql

coz i want to fetch some data from SQL Server and some data from mysql

 

[sachin vairagi]

hi  php_lover, you can try this :-

 

 

 

1. In application/config/database.php, put this lines

 

$db['mssql']['hostname'] = 'hostname';

$db['mssql']['username'] = 'username';

$db['mssql']['password'] = 'password';

$db['mssql']['database'] = 'db_name';

$db['mssql']['dbdriver'] = 'mssql';

$db['mssql']['dbprefix'] = '';

$db['mssql']['pconnect'] = TRUE;

$db['mssql']['db_debug'] = TRUE;

$db['mssql']['cache_on'] = FALSE;

$db['mssql']['cachedir'] = '';

$db['mssql']['char_set'] = 'utf8';

$db['mssql']['dbcollat'] = 'utf8_general_ci';

$db['mssql']['swap_pre'] = '';

$db['mssql']['autoinit'] = TRUE;

$db['mssql']['stricton'] = FALSE;

 

 

2. in your model

 

    function __construct()

    {


        $this->mssql = $this->load->database('mssql', TRUE);

        parent::__construct();

 

    }

 

3. your query will be as follows

 

function get_data()

{

         $query=$this->mssql->select('*');

         $query=$this->mssql->from($table);

         $query=$this->mssql->where($where);

         $query=$this->mssql->order_by($orderby,'ASC');

         $query=$this->mssql->get();

 

        if ($query->num_rows() > 0) {

                foreach ($query->result() as $row) {

                    $data[] = $row;

                }

                return $data;

            }

            

            return false;

}
 
 

[php_lover]

Thanks @Sachin101  my friend i love India

[Wibi Wiblink]

but how do i render from the sql server? i used mysql & mssql. mysql running render like ussual.

 

$crud->set_table('tbl');
$crud->columns('col1','col2','col3','col4');
$crud->set_subject('blabla');
$output = $crud->render();

 

but how in mssql?

 

thank's before