cannot make a database connection

[elvis is dead]

Due to the upgrade to PHP 7, I need to rebuild a custom application but am unable to successfully connect to the database.

The following error message is generated when using DMXZone Server Connect:

"Invalid target configuration! Check your Web Server URL and the connectivity to it."

Been chatting with DMXZone tech support but they're unable to determine what the issue is. They were able to run internal tests using my config and had no issues.

Repeatedly gone through System Preferences and unable to find anything that might be blocking the connection.

Has anyone had a similar issue and found a solution? Are there options beyond DMXZone?

Here is the enviornment:

MacOS 11.5.2
DW 21.1
Server Type MySQL 5.7.26
PHP 7.3.9
PHP extension mysqli
MAMP 5.7

DMXzone Server Connect 2, version 2.3.1
DMXzone App Connect, version 1.9.21
Database Connector 2, version 2.3.1

[osgood_]

Do you get a connection to your database if you use the code below? Insert code in blank document, save and run it in the browser. Change the connection details obviously ie 'my_user', 'my_password' and 'my_db'

That should at least rule out an internal mis-configuration.

<?php

$mysqli = new mysqli('localhost' , 'my_user' , 'my_password' , 'my_db');

if($mysqli -> connect_errno) {

echo "Failed to connect to MySQL: ".$mysqli -> connect_error;

}

else {

echo "Connected Successfully";

}

?>

[elvis is dead]

Thanks. Connected Successfully was displayed.

Next task is to re-write the code to display the pages ...

[osgood_]

Thanks. Connected Successfully was displayed.

Next task is to re-write the code to display the pages ...

By @elvis is dead

Must be something to do with the DMXZone extension then and incompatiblity with your upgrade, assunming it was working ok previously to your upgrade.

Well re-writing the code probably won't be simple unless you have some experience in querying databases and getting that information back. There's plenty of mysqli/php tutorials on Youtube which will provide the code, but try to find ones no more than about 3 years old.

[Nancy OShea]

Have you looked at Wappler?  Also made by DMX Zone.