Can't connect to data base RRS feed

  • Question

  • 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

    Monday, May 6, 2019 10:23 PM

All replies

  • Hi

    Have your enabled the option like “extension=mysqli.so” in php.ini? How to install MySQLi

    What the error about when you could not connect to the mysql database ? offer the log.

    Hope it can help you.

    Best Regards,

    Eric Liu

    Best Regards, Eric Liu MSDN Community Support Please remember to click Mark as Answer if the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread.

    Tuesday, May 7, 2019 3:06 AM