Database pages not displaying

This is actually an old site I did ages ago, and something has happened that has caused the database pages to not appear. I hadn't changed anything, so not sure what it is. I have checked the following:

- that the files were present and correct as they had been
- that the database and database user were present and correct as they had been
- that the PHP version was up-to-date

I also tried the following:

- updating the code to mySQLi
- created a new database user to check there were no issues with the existing user

None of that has resolved it though, so wondered if you could have a quick look? Its just a straightforward page showing a list of towns. I have also advised the site owners to contact the hosting company.

I have attached the page below. If it looks OK, I'll assume its an issue on the hosting side of things. Thank you.

Add this to the top of your page if you get a blank page to see the error:

<?php

ini_set("display_errors",1);

?>

I did that and it said you hadn't uploaded the file /webassist/mysqli/rsobj.php

So I uploaded that file and the page seems to load now.

Thanks Ray. I have that working now, and also the register page. There is still an issue on the page that shows the list of places when you click on a town on this page:

http://www.keepsafeglos.org/safe_places/

The delete server behavior and repeat regions on the page weren't updated to mySQLi. I updated them and the page seems to load properly now. Make sure to download the updated page for your records.

It looks like you weren't using the delete functionality, so I removed it entirely.

Thanks Ray. I've been going through all the pages in the admin section to SQLi, and its all been nice and straightfoward. None of the stuff I had with DW being picky with some of the safari stuff from before.

I do have an issue with a couple of pages though, which are reporting SQL errors. The user details page and the update user page, ie the ones that are getting the user based on the ID in the URL. I'm not sure of the syntax to try changing anything, but hopefully something pretty minor.

I have attached them below.

You had some hand coded sections that caused the delete and update server behaviors to not update to MySQLi. I've fixed it on those two pages so they should work properly now.

Thanks Ray.