MYSQLI (PDO) and MSQL

[Operacional23]

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

[Nancy OShea]

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() ?>

[osgood_]

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]

...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.

[osgood_]

2022.html.............. last updated 26th Oct 2021.....says nothing about what might be happening in 2022.......very little on that page to be inspired about anyway apart from some kind of glorification that DW now runs on Apple Silicon........, most other companies already had their programs silicon enabled and if not updated shortly afterwards.

Does Adobe know MacOS Monterey was officially released 25/10/2021, wake up! wake up!

[Nancy OShea]

...says nothing about what might be happening in 2022

By @osgood_

==========

Right.  No robust "road map" is planned. DW will be minimally maintained with bug & security fixes for the benefit of current users.  

[osgood_]

==========

Right.  No robust "road map" is planned. DW will be minimally maintained with bug & security fixes for the benefit of current users.  

By @Nancy OShea

The question then is how long will the likes of you keep the faith? Once a program is 'dead' I tend to move to something else which is being nurtured.

I only bailed out of the program after years of use because I used to use the server behaviours and wasnt bold enough to start writing my own database code at the time. The lack of action from Adobe to address this issue resulted in me getting stuck in. In hindsight it was the best thing that could have happened otherwise I may still be dependent on DW, so some good came of it BUT its painful to watch the program fall off the cliff in recent years as I have an attachment and was keen to see how it would progress but it seems Adobe had other ideas.

[Nancy OShea]

Oh I'm not dependent on DW.  I write my own code. All my sites are CMSs.  I just like using DW, mostly out of habit I guess.

[osgood_]

Oh I'm not dependent on DW.  I write my own code. All my sites are CMSs.  I just like using DW, mostly out of habit I guess.

By @Nancy OShea

Old habits die hard I guess.......I still use some 'outdated' programs myself as they feel comfortable. Sometimes progress comes with bloat which makes the program feel sluggish and too needy. I mostly like something which just lets me get on with the coding, rather than holding my hand too much.

[osgood_]

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.