The connector for CodeIgniter doesn’t appear to work with the newly released CI 3.
It doesn’t return any data (but doesn’t report any errors).
Just a bit more information is case this can be fixed easily. The result of the Ajax call to the CodeIgniter Gantt controller is:
{ "data":[], "collections": {"links":[]}}If I grab the result of
$res=$this->connection->query($sql);
in db_phpci.php it returns the following:
CI_DB_mysqli_result Object
(
[conn_id] => mysqli Object
(
[affected_rows] => 4
[client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: bf9ad53b11c9a57efdb1057292d73b928b8c5c77 $
[client_version] => 50011
[connect_errno] => 0
[connect_error] =>
[errno] => 0
[error] =>
[error_list] => Array
(
)
[field_count] => 9
[host_info] => someting.amazonaws.com via TCP/IP
[info] =>
[insert_id] => 0
[server_info] => 5.5.40-log
[server_version] => 50540
[stat] => Uptime: 2931533 Threads: 8 Questions: 93719660 Slow queries: 54 Opens: 216311 Flush tables: 1 Open tables: 398 Queries per second avg: 31.969
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 187846
[warning_count] => 0
)
[result_id] => mysqli_result Object
(
[current_field] => 0
[field_count] => 9
[lengths] =>
[num_rows] => 4
[type] => 0
)
[result_array] => Array
(
)
[result_object] => Array
(
)
[custom_result_object] => Array
(
)
[current_row] => 0
[num_rows] =>
[row_data] =>
)So the database connection is valid, but no results are being generated. Like I say – the same code works on CodeIgniter 2, so hopefully it’s a simple fix – I just can’t trace the problem.
Was this ever solved?
I am sitting with a similar situation after upgrading to CI3 but connecting using SQLSRV drivers
GitHub has the updated connectors branch, with support of latest PHP frameworks. The related documentation is still not released yet. We plan to do finish docs and updated tutorials on this week.