Recommended method of creating Dynamic pages

I have branched this to a new discussion as the former one is rather old. 

If you can code manually, you can create a dynamic site with modern PHP code and MySQL databases.   Below is an example of a PHP connection using MySQLi (improved), where username and password are your server database's username and password. 

 <?php
$servername = "localhost";
$username = "username";
$password = "password";

// Create connection
$conn = new mysqli($servername, $username, $password);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
?> 

If you can't code manually, there are 3rd party extensions you can buy from DMX Zone or Web Assist. 

• https://www.dmxzone.com/go/22072/dmxzone-database-connector-php/
• http://www.webassist.com/dreamweaver-extensions/mysqli

Similarly, there are visual web application builders like Wappler that can help you get the job done. https://wappler.io/

Or you could go completely open source and use WordPress or Drupal to build your site online.  

The best solution will take into account your site requirements, server, skills and budget. 

For dynamic websites you are going to want to use some kind of server-side interaction whether that be php, node, python etc - so Im not sure what you mean when you say 'I'am happy to develop without that' after suggesting you would like to create a dynamic website.

If you dont use some kind of server language (even if its just to process data which is then handed over to client-side rendering) then the website wont be hugely dynamic maybe a little bit of interactivity if you throw in some javascript.

As for php and mysql - yes its still relevant although you should be using mysqli (improved) as the mysql extension is now way outdated. The dynamic server behaviours in Dreamweaver were hidden as a consequence and never updated.

Maybe tell us more about this dynamic website you want to create - someone here will have further suggestions for you.