Unable to connect Dreamweaver with mysqli

After all these comments, now we know Adobe is not giving a dime for DW.  Is any other app/tool that we can use to design forms, connect with the SQL database and do PHP?. Any input highly appreciated.

There was an old Dreamweave extension called PHAKT by Interakt. Adobe bought Interakt aorund the same time they bought Macroedia from what I can remember.

The PHAKT extension worked inside Dreamweaver exactly the same as the old PHP/MySQL Server Behaviors but utilised the PHP ADOdb Database Abstraction Layer - if Adobe had adopted this for the SB's in Dreamweaver then progression would have been a much easier prospect. Altiohgh not as well known as PDO, PHP ADODB is still under active development and currently supports up to PHP 7.2 and makes switching between database types seamless.

What's more is that the PHAKT server behaviors also worked exactly the same as the old PHP MySQL server behaviors did with and old Interakt extension called MX Kollection which was an advanced set of server beahaviors/tools for creating backend applications. After acquiring Interakt Adobe changed the name of MX Kollection to ADDT (Adobe Dreamweaver Developer Toolbox) which may be more familiar to people, in reality they did very little with MX Kollection (ADDT) and then discontinued it a few years later. Adobe never had any committment to it ....

What happend to the PHAKT extension/server model? I have no idea it was never even looked at or considered by Adobe as far as I can make out?

The Interakt people were from Romania I beleive and very clever developers, I'm pretty sure they ended up working at Adobe and at least one or two are still there as QA Engineers or in some other capacity. Very strange to have these people at your disposal and just bury all their products which were great additions to Dreamweaver in their time and could have been something amazing in 2019 had Adobe  commited resources to them.

I know nothing that happens inside Adobe as they seem to be a very secretive organisation these days, I'd imagine there are a lot of confidentiality agreements being signed on a regular basis. So nobody has a clue what has been going on with Adobe and Dreamweaver but here are the key points/errors IMO that will see the death of Dreamweaver in the next few years.

1) Adobe decided to stop developing Server Behaviors & ditch ADDT - Server behaviors were out of date yes, because Adobe had no committment to them at all and let them just drift along.

2) Adobe introduces 'Live View' it looks like its intended to replace Design View (bit of backlash when design-time stylesheets were removed as I recall, in actual fact the function was just hidden from the UI). Live View is terrible, glitchy,  yes its improved but IMO it is still not great. Second problem is some leading extensions were/are quite tightly integrated into Design View. All in all unsatifactory, who are Adobe consulting or speaking to in order decide which direction they go with Dreamweaver? It doesn't seem like its the real users or extension developers. If I want LIve View I'll use a web browser if I wanted a WYSIWG  I'd want a stable user-friendly tool

3) Out of the blue (at least it seemed it to me anyway) Adobe decides to rip out a very stable code editor from Dreamweaver that just needed a bit of TLC and a few new features and replace it with integrated version of Brackets. Lord knows how much development time when into this, in all honestly it was a bit of disaster. Brackets brought a few new features and host of issues including loss of some populkar features that the old code editor had ..... what the hell was the point onf it? - It was close to a disaster (my opinion anyway).

Any light at the end of the tunnel? Well wrapping of snippets is coming back (its never been removed properly anyway), maybe thats a tiny victory for regular users of Dreamweaver .... I'd like to think we can get the old code editor back in Dreamweaver 20.0  but I know that will never happen and yet the current Dreamweaver team are still fixing issues with the Brackets code editor that was first introduces in Dreamweaver CC 2017 in November 2016.

Who's driving and making the key decisions for Dreamweaver??????????????

...........................

Fingers crossed but confidence is low on what Adobe will do with Dreamweaver, I should point out that the currenr Dreamweaver dev team are not reposnisible for the above issue. They have been trying to correct and fix a lot of the problems with the code editor, code formatting isues etc etc and I think they have managed to tackle most of the problems.

Well, seems like I am not alone, thanks all for your comments. Preran and the staff are aware of this mess/situation. Now lets redirect the issue. Preran, rather than be part of the problem why you and your staff are not part of the solution. Training a person to keep the flow, day by day, is not resolving the issue. We, need a real solution. I believe at your end you have to have enough statistics to show all this complains that can be solve if the company is properly guided. My hope is that you, Preran, can escalated all this claims that have been developing not for lack of knowledge but for been greedy an reluctant to hear all users.

Hi All,

My post was working with DW->Preferences->PHP 5.6.

Already I try with the PHP 7.1 Version, but no difference. As you can see (below), the "connection" file is very different, but I can not connect to the database. DW is unable to find/connect the database. So is one problem or the other.

Like I mentioned before, I believe is nice to work with DW building forms and using PHP commands at the same time. Saving time and headaches.

Hi Martin,

Sorry to hear you are having trouble in connecting Dreamweaver with Mysqli and unable to pull up databases. Thank you for providing the detailed description of the issue with the help of screenshot.

As Ben and Os have already mentioned that you need to purchase an extension, so I would recommend checking Adobe Exchange from this link: Creative Cloud​.

Thanks,

Harshika

Thank all for your input. The main reason that I selected DW was due to the "ability" to connect with a sql database (wampp, mysql). With no connectivity, seems like DW is loosing market not updating the server behavior. Since I do not have experience with PHP, is nice "developing" PHP code using DW, that is powerful.

Now my question is if still I can use DW to develop my project (need to read/update the database) or move to something else. Please provide me the companies offering the extension.

The (deprecated) Server Behaviours panels should not be used with PHP 7+.

The reason is that PHP 7+ does not recognise MySQL and the SB panels do not create MySQLi or PDO.

You will need to hand code, see https://www.webtutorials.me/crud-operation-php-mysqli/  or purchase an extension from Webassist

Dreamweaver server behaviours are way out-dated. Unless you are running php 5.6 or less they wont work and even if you are using php 5.6 or less you should'nt be using mysql as its been replaced by mysqli (note the 'i') or pdo. Your server is most likely running at least php 7+. Dreamwever currently has nothing that will allow you to connect using mysqli or pdo. Your only options are to buy an extension or write the code yourself.

We have for the last 4/5 years encouraged the dozy blighters at Adobe to re-write the DW server behaviours but you cant tell em whose pockets (money, money, money) are too deep for their brains to be able to think clearly and provider what their users really really want.

If you want to buy an extension give me a shout in the forum and I'll provide a couple of url of companies that offer them