MySQLi database connection

[sicay]

Hi!

Is there any work done to create a database connection for MySQLi in the database module? I'm in the process of migrating a Kohana 3.2 to Kohana 3.4 using PHP 5.5 and I keep getting Database Exception for the deprecated module mysql. I'd like to switch to the mysqli module in PHP to avoid being stuck with the deprecation.

Thanks!

[shadowhand]

You can find a working MySQLi adapter in Ushahidi/Platform.

[sicay]

Thanks for the link! Really appreciated!

[sicay]

It works like a charm! Thanks again!

[sankarm]

Hi,

Using the above module with php 5.5. I'm getting error with mysqli_real_escape_string expecting 2 parameters for this function.

First parameter will be database connection so here in controller or model file how to get database connection to solving this issue.

[sicay]

Can you provide a log or error screen? On my side I don't have this error.

[sankarm]

Hi sicay,

Kindly find the error screen I've attached. In this screen we have used mysqli_real_escape_string in controller file. So in php 5.5 this mysql function need to pass first parameter should be database connection. In controller & model files how can i get database connection link to pass first parameter to solve this issue.

[Andretti]

Use Database::instance()->escape(). If your model class extended Model_Database use: $this->_db->escape(). In your code for mysqli_real_escape_string() first argument need add link identifier of connection if using procedural style (http://php.net/manual/en/mysqli.real-escape-string.php)

[sankarm]

Hi Andretti,

Its works fine.Thanks for your information a lot.

[Shankar_Msr]

@Andretti,

How can i solve above same mysqli_real_escape_string issue with kohana 2.3.4 version. I've used above given solution $this->_db->escape() but its not working. Let me know how solve this issue.

[Andretti]

I didn't work with the Kohana 2.x, so I cannot answer this question. Pay attention to module Database