Results 1 to 7 of 7

Thread: MYSQL to MYSQLI extensions in PHP connectors, etc. ???

  1. #1
    Junior Member
    Join Date
    Dec 2017
    Posts
    5

    Default MYSQL to MYSQLI extensions in PHP connectors, etc. ???

    Hi All,

    Anybody solved this or have a work around for using 5.7 mysql and php db connectors in NO15? Getting fatal errors as the few ADO* objects need to be updated to MYSQLI, etc...

    Anybody solve this issue with or without NO support team?

    Thanks, M.

  2. #2
    Senior Member chuckj's Avatar
    Join Date
    Jan 2010
    Location
    www.beyondfusion.com - Florida
    Posts
    1,259

    Default

    You need to install the MySQL ODBC connector.

    I have it here: http://www.beyondfusion.com/html/links.php
    Chuck Joslin
    www.BeyondFusion.com
    PHP & MySQL development with Fusion
    Fusion support for AllWebMenus (Likno) Contact me for custom AWM menus for your sites.
    Tutorials and Forums

  3. #3
    Junior Member
    Join Date
    Dec 2017
    Posts
    5

    Default Here is more info on my issue...

    Thanks for replies..

    To better explain, I have site with all pages generate .php suffix files to hosting company public/html directory.

    I use php dB connector and interators on few pages that worked fine on NO8 ... I now get the attached when trying to display a MySQL table on php webpage? Redacted my dB connection for privacy.







    Ph
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	A3F1CB25-5613-4620-8C20-A98552FE8265.jpg 
Views:	18 
Size:	112.7 KB 
ID:	2725  
    Last edited by Mateo; 4 Weeks Ago at 01:39 AM.

  4. #4
    Senior Member chuckj's Avatar
    Join Date
    Jan 2010
    Location
    www.beyondfusion.com - Florida
    Posts
    1,259

    Default

    I know for a fact the built-in PHP functions in Fusion work fine with PHP 5.6.x. I know they don't work with PHP 7. The database connection code produced by Fusion isn't supported in PHP 7 and above. Along with the corresponding database functions.

    I've offered to assist NetObjects to update the code, but haven't received a reply.

    I may rewrite the relevant code in the near future and make it available on my web site. Time permitting.

    Your host probably still supports older version of PHP. Rollback to one that works with Fusion generated code for the time being.
    Last edited by chuckj; 4 Weeks Ago at 03:08 AM.
    Chuck Joslin
    www.BeyondFusion.com
    PHP & MySQL development with Fusion
    Fusion support for AllWebMenus (Likno) Contact me for custom AWM menus for your sites.
    Tutorials and Forums

  5. #5
    Junior Member
    Join Date
    Dec 2017
    Posts
    5

    Default

    Thanks Chuck. That is exactly the issue, host is running php 7 I will check into the rollback option...

    I imagine in time NO would have to address if they want keep the product moving forward? something like choose pre or post php 7 ..... I am updating my own php code to the new extensions, Mysqli, etc....

    Cheers!

  6. #6
    Senior Member chuckj's Avatar
    Join Date
    Jan 2010
    Location
    www.beyondfusion.com - Florida
    Posts
    1,259

    Default

    I've personally never used the built-in database capability in Fusion, having been doing PHP programming myself for a number of years.

    The incompatibility with PHP 7 didn't get on my radar right away.

    There's also an issue with JRE 1.8 not supporting database connections locally. You need to also have 1.7.x installed and choose it in application settings.

    All of this should be relatively easy to fix in a future version of Fusion.
    Chuck Joslin
    www.BeyondFusion.com
    PHP & MySQL development with Fusion
    Fusion support for AllWebMenus (Likno) Contact me for custom AWM menus for your sites.
    Tutorials and Forums

  7. #7
    Junior Member
    Join Date
    Dec 2017
    Posts
    5

    Default

    The trick for Fusion peeps is to deal with transition for Users ... Good news, I can roll back php version for now, but at some point the scale will be tipping to lastest extensions ... I’ll keep a watch for Fusion update

    Thanks all,
    Cheers!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •