Skip to main content
Participant
Jan 20, 2020 10:39 AM UTC
Answered

connect database

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 is closed to new replies. Start a new post to keep the conversation going.
osgood_Correct answer
Legend
Jan 20, 2020 11:05 AM UTC

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

Inspiring
Jan 31, 2020 10:53 AM UTC

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

Translate
Nancy OShea
Community Expert
Community Expert
Jan 20, 2020 7:02 PM UTC

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

 

 

 

 

Translate
Nancy O'Shea— Product User & Community Expert
osgood_Correct answer
Legend
Jan 20, 2020 11:05 AM UTC

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.

Translate