CodeIgniter 3.0 Query Builder don't work

Suite and Optimus Suite 5
#1

I download PHP Connector from Github. And I tried to get data from database with using Query Builder, but data was not displayed.
After that I tried to use mysql_connect method. And I got data after using this method.
Help me please to solve problem with Query Builder, please! :frowning:

#2

with using Query Builder

Can you share a snippet of code that doesn’t work for you?

#3

This code work with mysql_connect

[code]
$this->load->database();

    $conn = new DataViewConnector($this->db, "PHPCI");

    $query_select = "SELECT sgn.id as id,
        DATE_FORMAT(MAX(sgn.sdate), '%d.%m.%Y') AS date, obj.id AS obj_id,
        DATE_FORMAT(MAX(sgn.sdate), '%T') AS time, obj.s15 AS region,
        obj.obj AS name, sgn.id_mes AS mes_id";
    $query_from = " FROM sgn, obj, mes, web_users_on_objs AS users";
    $query_where = " WHERE obj.id=sgn.id_obj AND mes.id=sgn.id_mes AND mes.id = '1101' AND obj.id_obs = '1'
        AND obj.id = users.id_obj AND users.id_user = '4'";
    $query_order = " ORDER BY id DESC";
    $query_group_by = "GROUP BY obj.id";

    if ( $this->cert_serial > 0 ) {
        $query_from .= ", vdpo_regions AS regs";
        $query_where .= " AND obj.s15 LIKE regs.name AND regs.id = ".$this->cert_serial;
    }
    $query_string = $query_select.$query_from.$query_where.$query_group_by.$query_order;
    $conn->set_encoding("windows-1251");
    $conn->render_sql($query_string, "id", "date,time,name");[/code]

database config:

[code]
$active_group = ‘default’;
$query_builder = TRUE;

$db[‘default’] = array(
‘dsn’ => ‘’,
‘hostname’ => ‘127.0.0.1’,
‘username’ => ‘master’,
‘password’ => ‘’,
‘database’ => ‘contact’,
‘dbdriver’ => ‘mysqli’,
‘dbprefix’ => ‘’,
‘pconnect’ => TRUE,
‘db_debug’ => TRUE,
‘cache_on’ => FALSE,
‘cachedir’ => ‘’,
‘char_set’ => ‘cp1251’,
‘dbcollat’ => ‘’,
‘swap_pre’ => ‘’,
‘autoinit’ => TRUE,
‘encrypt’ => FALSE,
‘compress’ => FALSE,
‘stricton’ => FALSE,
‘failover’ => array(),
‘save_queries’ => TRUE
);[/code]

#4

This work in Windows, but not work in Linux

#5

Hi,

I don’t see any problems in the attached code.

Please be sure that you are using the correct name cases for all includes. ( while case doesn’t matter on Windows, wrong case will result in error on Linux system )