Convert mysql database function to mysqli

[santosh22]

Hi,

I am using a grid function which creates a data grid based on the query provided. this is rich & now i find that i need to convert all functions into mysqli compatible. 

 

below are the error lines

 

            // execute the query through the "database" object

            $this->queryResult = $this->dbRefference->query($this->query);

            // get the total number of records in the result (ignoring the LIMIT)

            $this->totalRecords = $this->dbRefference->foundRows;

 

this shows error as "Notice: Undefined property: mysqli_ext::$foundRows "

 

attaching the file for reference.

 

any help is highly appreciated.

 

Thanks

class.datagrid-backup.php

[boompa]

This is the manual page for mysqli.

 

Do you see anything called foundRows there? Maybe there's something else there that accomplishes what you want.

 

Please learn to read your errors, understand them, and reference the PHP manual.

Edited July 6, 2013 by boompa

[mac_gyver]

you need to modify the database class to use mysqli statements, not replace the database class with an instance of the mysqli class. what was the original code for the database class? perhaps it is already using mysqli or pdo and you don't need to do anything?

[jcbones]

Seeing the error points to a class called  mysqli_ext, I would say this class is dependent on that class.  $foundRows should contain the resultSet from your query.

[boompa]

Ah! Not using mysqli I didn't realize this was some sort of wrapper or something. My bad.

 

And I missed the attached file. Damn, I'm slipping!

Edited July 6, 2013 by boompa

[santosh22]

Thanks, I was looking for a guidance or standard where the conversion of mysql to mysqli is provided. I will dig more into internet and get it done. 

[santosh22]

Well, I have completed the changes. By doing this, I am using a single object in all of my components that access db in a php page. i m hopeful that it will improve my performance, else i will again see you guys in this forum.

 

thanks for all your help. This forum is really helpful for every question I have.