Skip to main content
Operacional23
Known Participant
October 28, 2021
Question

MYSQLI (PDO) and MSQL

  • October 28, 2021
  • 2 replies
  • 522 views

How do I get Dreamweaver to create MYSQLI and not MYSQL code?

 

    This topic has been closed for replies.

    2 replies

    Legend
    October 28, 2021

    Sorry Dreamweaver dropped the ball many years back, poor management or lack of interest, false promises of introducing new database server behaviours failed to materialise, that killed the program stone-dead whilst the 'uneducated' wasted time on introduicng other failed rubbish, instead of concentrating efforts in the areas where it once excelled. The legacy of DW will be one of a once innovative editor in the hands of the right people, driven into the ground in the hands of those without a clue, sound familar - buy it up and trash it. Leaves a bitter taste in the mouth for those that had used it for years or are still using it.

     

    On a more positive note you can of course buy expensive 3rd party extensions which will give you access to sqli or pdo or failing that you can write your own code. These days Dreamweaver is just a simple over-priced html editor in my opinion, the rest you have to either buy add-ons or write yourself.

     

    Think Im being harsh, well maybe so but even Adobe acknowledge its lack of interset in the web sector as they recomended using VS Code when they killed Brackets, another very innovative project in my opinion, which eventually met a dead end, sound familar.

    Nancy OShea
    Community Expert
    Community Expert
    October 28, 2021

    Hi @Operacional23,

    Get the commercial extension from WebAssist -- MySQLi Server Behaviors

    http://www.webassist.com/dreamweaver-server-behaviors

     

    Example of a MySQLi connection string.  Copy & paste this into a new, blank PHP document.  Save as test.php and run it on a server.

    <?php
    $con = mysqli_connect("localhost","your_username","your_password","database_name");
    
    // Check connection
    if (mysqli_connect_errno())
      {
      echo "Failed to connect to MySQL: " . mysqli_connect_error();
    		}
    		else echo "Successfully connected, happy coding!"
    ?> 
    
    <?php phpinfo() ?>
    

     

    Nancy O'Shea— Product User & Community Expert
    Legend
    October 28, 2021

    That is not really going to get anyone very far is it, they need to be able to do something when they actually connected to a database to make it useful.

     

    What exactly did happen to those new database server behaviours promised, what 3 years ago now? I know they were put on hold at one stage, so they could make the program compatible with the latest OSs whilst everyone else around was not only compatible with the latest OS's but introducing weekly updates which accounted for more than a whole 18ths worth Dreamweaver update cycle. If you look at it its hugley poor and disrespectful to those DW users who have maintained a loyalty over many years.

     

    Didn't the server behaviours make it into the pre-release version? If so whats happening?

    Nancy OShea
    Community Expert
    Community Expert
    October 28, 2021
    quote

    ...If so whats happening?


    By @osgood_

    ==========

    This is all I know: 

    https://helpx.adobe.com/dreamweaver/using/whats-new/2022.html

    DW continues to be maintained for newer hardware and operating systems.

     

    Nancy O'Shea— Product User & Community Expert