I have created a database and table using SQL and I am able to scroll through the table using HTML, PHP and SQL. It all works perfectly.
But now I want to create a Report for printing out parts of the table.
I am using Rapid PHP to view the table.
I am using code like below to connect to the table in the Rapid PHP environment.
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "dbadvert01";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
I can navigate to the Database File using the Windows Explorer and have attempted to use that type of navigation to connect to the databases with the Report Builder but I am unable to establish a connection.
Any help would be appreciated.
Mike Smith