Highlighted

Way forward?

Community Beginner ,
Feb 28, 2018

Copy link to clipboard

Copied

Some years ago I used Dreamweaver CS5 with PHP (5.6) and MySQL. I used 'Classroom in a book' as my tutorial and with the help from the Dreamweaver community managed to get my personal (non-profit) site working. Apart from changing content and adding new pages (based on previous ones) little has changed. The main change has been that Dreamweaver has been regularly updated (now CC 2018).

I am now seeking to update my website to be HTML5. I've been following various tutorials (Adobe and Kelby One) and they appear to stop short when showing how to extract and display dynamic data etc. The latest 'Classroom in a book' doesn't appear to include this. I've searched on the internet but the more I look the more I get confused. I'm therefore asking for advice on what is the best way forward and where can I get the appropriate tutorials/education.

Thanks in advance.

Cliff

Adobe Community Professional
Correct answer by BenPleysier | Adobe Community Professional

1. For the deprecated SB panels, have a look at restoring them for DWCC<17, https://www.dmxzone.com/go/21842/enable-server-behaviors-and-data-bindings-panel-support-for-dreamweaver-cc/

2. If you want SB panels that look and behave most like the deprecated panels, and also work for the latest versions of DW, have a look at MySQLi Server Behaviors | Dreamweaver extension | WebAssist. These panels use MySQLi (i for improved) rather than MySQL.

3. A better, but more expensive option is to use the SB that DMXZone have produced. which use PDO instead of MySQL.

Both MySQLi and PDO can be used on a MySQL database.

What I am trying to say, before I confused you, is: Grab DWCC15 and install the deprecated SB panels from option 1 and do as @osgood_ suggests, keep using PHP5.6 until you can get your mind around doing something more contemporary.

TOPICS
Learn Dreamweaver

Views

276

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Way forward?

Community Beginner ,
Feb 28, 2018

Copy link to clipboard

Copied

Some years ago I used Dreamweaver CS5 with PHP (5.6) and MySQL. I used 'Classroom in a book' as my tutorial and with the help from the Dreamweaver community managed to get my personal (non-profit) site working. Apart from changing content and adding new pages (based on previous ones) little has changed. The main change has been that Dreamweaver has been regularly updated (now CC 2018).

I am now seeking to update my website to be HTML5. I've been following various tutorials (Adobe and Kelby One) and they appear to stop short when showing how to extract and display dynamic data etc. The latest 'Classroom in a book' doesn't appear to include this. I've searched on the internet but the more I look the more I get confused. I'm therefore asking for advice on what is the best way forward and where can I get the appropriate tutorials/education.

Thanks in advance.

Cliff

Adobe Community Professional
Correct answer by BenPleysier | Adobe Community Professional

1. For the deprecated SB panels, have a look at restoring them for DWCC<17, https://www.dmxzone.com/go/21842/enable-server-behaviors-and-data-bindings-panel-support-for-dreamweaver-cc/

2. If you want SB panels that look and behave most like the deprecated panels, and also work for the latest versions of DW, have a look at MySQLi Server Behaviors | Dreamweaver extension | WebAssist. These panels use MySQLi (i for improved) rather than MySQL.

3. A better, but more expensive option is to use the SB that DMXZone have produced. which use PDO instead of MySQL.

Both MySQLi and PDO can be used on a MySQL database.

What I am trying to say, before I confused you, is: Grab DWCC15 and install the deprecated SB panels from option 1 and do as @osgood_ suggests, keep using PHP5.6 until you can get your mind around doing something more contemporary.

TOPICS
Learn Dreamweaver

Views

277

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Feb 28, 2018 0
Adobe Community Professional ,
Feb 28, 2018

Copy link to clipboard

Copied

You are not saying if you have updated to the CC version of Dreamweaver, so I will assume that you have not.

As far as going HTML5, start off by changing the head section of each document from

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

or similar

to

<!DOCTYPE html>

<html lang="en">

  <head>

    <meta charset="utf-8">

    <meta http-equiv="X-UA-Compatible" content="IE=edge">

    <meta name="viewport" content="width=device-width, initial-scale=1">

Check each document as you make the change. Off hand, I cannot remember if anything will have drastically changed.

Once you have done that, go to HTML Tutorial for further information.

A typical HTML5 document looks like

<!doctype html>

<html>

<head>

<meta charset="utf-8">

<meta http-equiv="X-UA-Compatible" content="IE=edge">

<meta name="viewport" content="width=device-width, initial-scale=1">

<title>About Page template By Adobe Dreamweaver CC</title>

<link href="AboutPageAssets/styles/aboutPageStyle.css" rel="stylesheet" type="text/css">

<!--The following script tag downloads a font from the Adobe Edge Web Fonts server for use within the web page. We recommend that you do not modify it.-->

<script>var __adobewebfontsappname__="dreamweaver"</script><script src="http://use.edgefonts.net/montserrat:n4:default;source-sans-pro:n2:default.js" type="text/javascript"></script>

</head>

<body>

<!-- Header content -->

<header>

  <div class="profileLogo">

    <!-- Profile logo. Add a img tag in place of <span>. -->

    <p class="logoPlaceholder"><!-- <img src="logoImage.png" alt="sample logo"> --><span>LOGO</span></p>

  </div>

  <div class="profilePhoto">

    <!-- Profile photo -->

    <img src="AboutPageAssets/images/profilephoto.png" alt="sample"> </div>

  <!-- Identity details -->

  <section class="profileHeader">

    <h1>JOHN DOE</h1>

    <h3>REALLY AWESOME WEB DESIGNER</h3>

    <hr>

    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in.</p>

  </section>

  <!-- Links to Social network accounts -->

  <aside class="socialNetworkNavBar">

    <div class="socialNetworkNav">

      <!-- Add a Anchor tag with nested img tag here -->

      <img src="AboutPageAssets/images/social.png" alt="sample"> </div>

    <div class="socialNetworkNav">

      <!-- Add a Anchor tag with nested img tag here -->

      <img src="AboutPageAssets/images/social.png"  alt="sample"> </div>

    <div class="socialNetworkNav">

      <!-- Add a Anchor tag with nested img tag here -->

      <img src="AboutPageAssets/images/social.png"  alt="sample"> </div>

    <div class="socialNetworkNav">

      <!-- Add a Anchor tag with nested img tag here -->

      <img src="AboutPageAssets/images/social.png"  alt="sample"> </div>

  </aside>

</header>

<!-- content -->

<section class="mainContent">

  <!-- Contact details -->

  <section class="section1">

    <h2 class="sectionTitle">Content Holder 1</h2>

    <hr class="sectionTitleRule">

    <hr class="sectionTitleRule2">

    <div class="section1Content">

      <p><span>Email :</span> johndoe@email.com</p>

      <p><span>Website :</span> johndoe.com</p>

      <p><span>Phone :</span> (123)456 - 789000</p>

      <p><span>Address :</span> Anytown, Anycountry</p>

    </div>

  </section>

  <!-- Previous experience details -->

  <section class="section2">

    <h2 class="sectionTitle">Content Holder 2</h2>

    <hr class="sectionTitleRule">

    <hr class="sectionTitleRule2">

    <!-- First Title & company details  -->

    <article class="section2Content">

      <h2 class="sectionContentTitle">Title & Company</h2>

      <h3 class="sectionContentSubTitle">Position / Date - Year</h3>

      <p class="sectionContent"> Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. Nam liber tempor cum soluta nobis eleifend option congue nihil imperdiet doming id quod mazim placerat facer possim assum. </p>

    </article>

    <!-- Second Title & company details  -->

    <article class="section2Content">

      <h2 class="sectionContentTitle"> Title & Company</h2>

      <h3 class="sectionContentSubTitle">Position / Date - Year</h3>

      <p class="sectionContent"> Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. Nam liber tempor cum soluta nobis eleifend option congue nihil imperdiet doming id quod mazim placerat facer possim assum. </p>

    </article>

    <!-- Replicate the above Div block to add more title and company details -->

  </section>

  <!-- Links to expore your past projects and download your CV -->

  <aside class="externalResourcesNav">

    <div class="externalResources"> <a href="#" title="Download CV Link">DOWNLOAD CV</a> </div>

    <span class="stretch"></span>

    <div class="externalResources"><a href="#" title="Behance Link">BEHANCE</a> </div>

    <span class="stretch"></span>

    <div class="externalResources"><a href="#" title="Github Link">GITHUB</a> </div>

  </aside>

</section>

<footer>

  <hr>

  <p class="footerDisclaimer">2014  Copyrights - <span>All Rights Reserved</span></p>

  <p class="footerNote">John Doe - <span>Email me</span></p>

</footer>

</body>

</html>

As far as showing dynamic data, that is another matter for a different discussion. Things to keep in mind here is that you do not use the Server Behaviours panels of the old version of Dreamweaver, they will not serve you well.


Ben

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Feb 28, 2018 1
Community Beginner ,
Feb 28, 2018

Copy link to clipboard

Copied

Thank you for your reply.

I have updated Dreamweaver on a regular basis and my version is up to date (v 180.0   build 10136).

I have been doing the tutorial on the Adobe site (pages at Dreamweaver tutorials | Learn how to use Dreamweaver CC ) which seems to be at CC 2017 level. I will have a look at the HTML5 tutorial that you flagged.

My main query is still about how do I manage my data going forward? I currently use PHP 5.6. Do I migrate to PHP 7? Do I need to move to the latest MySQLi? Do I move to a different model/solution? And how do I learn what needs to be done?

Relatively, I don't have large amounts of data on my website. Examples can be found at my genealogy pages at Cliff Baughen .

Thanks again

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Feb 28, 2018 0
Adobe Community Professional ,
Feb 28, 2018

Copy link to clipboard

Copied

Looking at your website, a couple of items jump out at me.  First is the spry.  That was retired many years back so if you want to edit that you would need to either edit the code or build something new to replace it.  As for the PHP, it would be recommended that you potentially update your scripts but as server behaviors have been removed, you would need to find an alternative for that as well unless you are writing your own scripts.  I just did a quick search and found a couple of replacements.  I don't use them personally at the moment so if you have specific questions around them, I would post on the forms or reach out to the developers directly.

MySQLi Server Behaviors | Dreamweaver extension | WebAssist

https://www.dmxzone.com/go/23295/dmxzone-server-connect/?utm_source=extension&utm_medium=link&utm_co...

Also, something else you may want to consider to expedite your transition would be to look into a framework like Bootstrap or Foundation to code your site.  Bootstrap support is in the latest version of Dreamweaver.  There are a lot of components there that can do some of what Spry used to and other functionality to easily add to your site.

Here's the link to everything Bootstrap: http://getbootstrap.com/ 

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Feb 28, 2018 1
LEGEND ,
Feb 28, 2018

Copy link to clipboard

Copied

baughen  wrote

Thank you for your reply.

My main query is still about how do I manage my data going forward? I currently use PHP 5.6. Do I migrate to PHP 7? Do I need to move to the latest MySQLi? Do I move to a different model/solution? And how do I learn what needs to be done?

No need to move to php 7 unless your going to ditch the old mysql functions. It will be good for a few more years yet and I doubt many hosting providers will just drop php 5.6 if they have clients using it, for the forseeable future.

I believe you can get back the DW server behaviours panel in CC2018 if you require to do so.

I would not advise anyone starting a project to use the old mysql function or DW server behaviours but if its a case of you not wanting to convert your current mysql functions to mysqli then you can continue to use the old mysql function until such time as you intend re-work the website from start to finish.

If you want to use mysqli or PDO to connect and query a database DW does not now contain by default anything that will help you, nothing. You would have to buy into a third party extension or write your own code.

Having had a quick look at your current website nothing strikes me as being driven by php?

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Feb 28, 2018 1
Community Beginner ,
Mar 01, 2018

Copy link to clipboard

Copied

Thank you for your response.

I wasn't aware of the deprecation of SPRY. It was current when I built the original website (using Dreamweaver CS5) and fortunately it has continued to work. So this looks like my first task.

I will have a further look at where I go in the future as most of the options seem to involve considerable expenditure.

Thanks

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 01, 2018 0
Community Beginner ,
Mar 01, 2018

Copy link to clipboard

Copied

Thank you for your reply.

As I replied in another response I will have to have another think about the way forward as it can involve considerable expense and time.

As to the use of PHP I can explain the original reasoning.

I used the 'Dreamweaver CS5 Classroom in a book' as my tutorial. (Lesson 14) It says that to build dynamic web applications you had to choose a server model. It gave 3 options (1) ASP (2) Coldfusion and (3) PHP. There were certain limitations that steered you away from ASP. Coldfusion involved heavy (for an individual) costs - I think the current standard license costs over £1500. PHP was free and was well supported. The tutorial focused primarily on PHP. At the time it was a simple decision.

There are 19 data tables on my MySQL data base (plus 14 Wordpress tables). This data is dynamically loaded and displayed in various pages.

As indicated the server behaviours support has been removed.

Thanks

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 01, 2018 0
Adobe Community Professional ,
Mar 01, 2018

Copy link to clipboard

Copied

1. For the deprecated SB panels, have a look at restoring them for DWCC<17, https://www.dmxzone.com/go/21842/enable-server-behaviors-and-data-bindings-panel-support-for-dreamwe...

2. If you want SB panels that look and behave most like the deprecated panels, and also work for the latest versions of DW, have a look at MySQLi Server Behaviors | Dreamweaver extension | WebAssist. These panels use MySQLi (i for improved) rather than MySQL.

3. A better, but more expensive option is to use the SB that DMXZone have produced. which use PDO instead of MySQL.

Both MySQLi and PDO can be used on a MySQL database.

What I am trying to say, before I confused you, is: Grab DWCC15 and install the deprecated SB panels from option 1 and do as @osgood_ suggests, keep using PHP5.6 until you can get your mind around doing something more contemporary.


Ben

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 01, 2018 0