Does cPanel Work with Current Dreamweaver in 2021 January

[J1001]

Hello, 

I am learning to connect a databse to a Dreamweaver site. Is cPanel currently compatible with Dreamweaver to create a working database with a website?

Thank you very much,

J

[J1001]

Please excuse the typos.

[osgood_]

Yes, cPanel has nothing to do with Dreamweaver. cPanel is just a websites remote control panel where you manage the remote website, one of those management options being to create and work with databases.

Your workflow should be to use a local server environment such as xampp or mamp, both are free to download to your local production environment. You create your database in one of those environments and at the end of the website build you export the local database as a file and import that file into your remote environment using cPanel

[J1001]

What database language do you think I should use? Thank you

[osgood_ · Accepted solution]

The most popular would be a combination of php and mysql or though there are others but php/mysql is the easiest to learn.

Depends what you want to do really. If you are just building a website with information pulled from a database, products for sale, maybe a blog, news, etc then l would choose php/mysql. If on the other hand you are building a real time application where you might require instant feedback, like a gaming app or auction app then probably node.js would be better suited for its speed.

There are plenty of good tutorials on youtube which address both solutions just do a search for php/mysql or node.js. Be sure to only take note of those which are no more than about 2 years old as workflows and techniques change at a fast  pace.

[J1001]

Very helpful. Thank you.

[osgood_]

I'd recommend this youtube channel:

https://www.youtube.com/c/TheNetNinja/videos

There are a good set of videos on php/mysql posted about approx 2years ago.

This one starts at No 23 (you might want to look from the beginning of the series)

https://www.youtube.com/watch?v=N2L9KZo2szY

[Ben M · Accepted solution]

Cpanel is a face for managing your server and not something that is intended to be compatible with Dreamweaver. So if you are trying to connect to a database, Cpanel provides you with a visual interface to create that database for your website, associated users, tables, etc. Dreamweaver's tools for connecting to a database are outdated so your best bet is to create your own code or seek out third party extensions that can help do this for you.

But keep in mind this is if you are trying to build your web/app from scratch.  If you are just trying to use a CMS like a Wordpress, Drupal, etc. then this isn't something you need to worry about unless you are working on the development side and not the front-end side.

[J1001]

I am very new as I've said. Can you put me on the best path according to your knowledge and experience that helps me create a website using HTML and CSS and uses some sort of database language? I just need to know the search terms. Right now I believe I can use Dreamweaver pretty dynamically as it is just an HTML and CSS editor, but I am confused when it comes to the server side. Do I use PHP or SQL? What database language should I use? Where should I host this database in your experience? I just don't know where to start but I am committed to continuing my learning. This is where my learning has brought me and I am stuck. Thanks for the help!

[Nancy OShea]

To manually build advanced, database driven websites on Linux hosting requires a good grasp of how to use the following and about 6  - 12 months to learn everything you don't know.

• MySQL = server-side database,
• XML, JSON = client-side database,
• PHP = server-side programming,
• SQL = the language used to query MySQL database records,
• phpMyAdmin = server software for interacting with server-side databases,
• HTML = static page content & structure,
• CSS = layout, styles, animations...,
• JavaScript = client-side programming, interactive elements,
• Local testing servers = Xampp, Mamp or Wamp for Windows or Mac.
• Assorted Frameworks = Bootstrap, jQuery, Node, Vue, React, etc...
• SEO = Search Engine Optimization.

If you want instant gratification, use WordPress with a premium theme instead.  Most good hosting plans provide the means for one-step WordPress installation on your server.  WordPress uses PHP & a MySQL database.

Good luck!

[Nancy OShea]

You need to crawl before you can walk.  I urge you to take some structured courses in Front End and Back End development.  

Front End =  HTML & CSS and to a lesser extent client-side JavaScript. 

Read chapters, do code exercises and take quizzes at the end.
- https://www.w3schools.com/html/
- https://www.w3schools.com/css/
- https://www.w3schools.com/js/

If your server supports PHP & MySQL databases, that's where you should begin your Back End programming journey. Bookmark these links.

• https://www.udemy.com/topic/php/
• https://www.udemy.com/topic/MySQL
• https://www.phpmyadmin.net/
• https://www.php.net/docs.php

[#12]

Hi, got my cpanel license not long ago. While I understood that Dreamweaver doesn't have to be compatible with CPanel, there is still something unclear for me.

[#13]

Hi, got my c-Panel [3rd party link removed by moderator] not long ago. While I understood that Dreamweaver doesn't have to be compatible with CPanel, there is still something unclear for me. So, the thing is that I want to self-host my site using a vps server. Now, I wonder whether I should expect any trouble managing my database due to using a vps. Sorry if I didn't make myself clear enough. I am new to website creation. Hope to acquire more experience and knowledge with your help, guys.

[Nancy OShea]

VPS and cPanel alone have nothing to do with using Dreamweaver -- a standalone code editor.

If you have trouble come back and post more details.

[BenPleysier]

If you are worried about the database, why not use Docker?

https://nocinit.com/blog/how-to-install-docker-on-cpanel-servers-tutorial/

[B i r n o u]

not being sure to clearly understand what you're asking for... please, let me rephrase the all context... then you could tell us where the problem lies

A server is a place where reside all your files composing your website and eventually database.

you will have different type of access to your server

• cpanel is an interface that help you to manage and administrate your server
• ftp access, will help you to transfer files from your local place to the server
• http access will be the front door for your web users to visit your place (generally located in one unique place on the server by a folder called, depending on your hosting system, www, public_html, hhtpdocs...))

a server offers you the possibility to host one or more databases.

this database can be administered on the server side by third party solutions such as i.e PHPMyAdmin, which is an interface allowing to create tables, and to manipulate them, on the same way that a construction company builds a house and sets up the furniture, decorations and other supplies before the residents arrive

now your web site will be able to connect to this database and interfere with it by allowing the web users (who would be, remaining in the previous metaphor, the inhabitants of this place).

for that your files developed (or not) with Dreamweaver (with handwritten code, or based on extensions) will have to use tools like PDO, or MySQLite, based on PHP language, to connect to this database (placed on your server)

so... now that we've got everything out of the way... what would be the database management issues you're referring to?
At what point in this process would you think you would have problems?
Would they be problems, maintenance, deployment, security, scaling, replication, backup, update, access, ...?

x (x)