Skip to main content
N
nikosp57509395
Participant
January 20, 2020
Answered

connect database

  • January 20, 2020
  • 3 replies
  • 1084 views

if connect with database press to recordset after select the table for database 

after open the web page with explore then give me the error 550

aftter change the myql function with mysqli function

open one empty page 

please help me 

thanks

 

This topic has been closed for replies.
Correct answer osgood_

Dreamweaver has nothing in it that supports the mysql(i) function. Dreamweaver used the now out-dated mysql function to connect and query databases. You cant change the connection from mysql to mysqli, it wont work.

3 replies

Y
Community Manager
YalpiCommunity Manager
Community Manager
January 31, 2020

Hello

 

We are working on adding Database and Server Behaviors functionality in Dreamweaver.
This will be based on PHP 7 MySQLi & PDO interfaces.

We would appreciate if you can share more details on your current workflow and how we can help with the new Database and Server Behaviors feature for your dynamic site development.

 

We have shared Dreamweaver roadmap for 2020 here. Please do have a look and let us know your feedback.

You can subscribe to our pre-release program here to get hands on early Dreamweaver builds with these changes as we make progress.

Regards,
Dreamweaver Team

Nancy OShea
Community Expert
Nancy OSheaCommunity Expert
Community Expert
January 20, 2020

Do not use the outdated Server-Behavior panels in DW.  They were removed for a reason.  You need to purchase a 3rd party extension to replace the panels or learn to code manually with PHP and MySqli (improved) or PDO -- your choice.

 

This connection string is an example of MySqli. 

<?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!"
?>

 

Web Assist MySQLi extension for DW.

http://www.webassist.com/dreamweaver-extensions/mysqli

 

DMX Zone Database Connector 2

https://www.dmxzone.com/go/33136/dmxzone-database-connector-2

 

 

 

 

Nancy O'Shea— Product User & Community Expert
    O
    osgood_Correct answer
    Legend
    January 20, 2020

    Dreamweaver has nothing in it that supports the mysql(i) function. Dreamweaver used the now out-dated mysql function to connect and query databases. You cant change the connection from mysql to mysqli, it wont work.

      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices