Using the MySQLi extension to update older sites

I would like to have a look at updating some older sites that don't use mySQLi to mySQLi - is this something the extension can be used for, or is it a case of redoing a page (or at least all the database stuff) from scratch?

I have the extension so have been having a look at changing a page to use mySQLi.

I have gotten as far as creating the mySQLi connection, and also added a couple of record sets to a page.

The page is reporting that the recordset is empty even though it should have some records, and displays records in phpMyAdmin. So I'm not really sure how to check it should have records, or how to echo them - I have tried adding a mySQLi recordset, but something isn't right.

The page is here:

http://www.goodsafariguide.com/botswana/indexi.php

It is probably an issue with how you are testing the recordset. The page you have attached must be an older version since it doesn't have the empty message on it at all. Please attach the same version that is live and I can take a look.

Thanks Ray - I had played around a bit more - I have attached a copy of the current page now.

I still don't see a reference to the message "There are currently no Featured Safari Properties in" in the file. Where is that coming from? I'm trying to see why it is appearing, but this file doesn't seem to have it. Can I get FTP access to the server? That will make it easier for me to debug what is going wrong.

Sorry Ray - I had taken that out when i was trying a basic test recordset.

The current version has that added again, and also a test repeat region for rsTest.

You are using some standard MySQL server behaviors and bindings. You need to use the MySQLi "show if empty" and you need to use the bindings from the MySQLi recordset.

For instance you have: <?php echo($row_rsTest['Lodge']); ?>

It should be: <?php echo($rsTest->getColumnVal("Lodge")); ?>

Thanks Ray - are you able to get it to display anything?

I added:

<?php echo($rsTest->getColumnVal("Lodge")); ?>

But its not displaying anything.

Please attach a current version of the page you are working on with replies so I can check the syntax.

Hi Ray - just had another look, and realised I had all the bits right, just not all in the place they needed to be - have fixed that, and it all looks good now.

I think for a long time I didn't really get that the mySQLi extension pretty much does all the main DataBridge functionality - i.e. insert / update / delete records - just doesn't create the pages.

These pages are pretty straightforward to get familiar with redoing them in mySQLi.

One thing - as I was updating an old page, in the attached file, does it still need the code in lines 3-34, or does the rsobj.php file replace that?