• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

connecting my form to a mysql database

New Here ,
Jan 06, 2017 Jan 06, 2017

Copy link to clipboard

Copied

Hello!

I am having some trouble connecting my form on dreamweaver to my database that i have set up on my cpanel.

What I am trying to do is create a registration form that connects to the database that I have on the phpmyadmin page on my cpanel. This way users can register and their information will be saved on the mysql database.

one of the issues is that i am not quite sure what to put under  the MySQL Connection which are found when adding a database in the Database window on DW.

connect.PNG

another issue is that i have a FTP host already connected to the website but not a testing server. i assumed that i already have one set up due to this

sdfsdfsfdf.PNGsdfsfddfafdf.PNG

If anyone can help me with this matter, that would be awesome!

Views

1.2K

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
community guidelines

correct answers 1 Correct answer

Community Expert , Jan 08, 2017 Jan 08, 2017

Developing a CRUD usually requires a local Apache testing server on your computer.  Obviously, you don't want to deploy an app on your remote server until you know it works properly.  You must test locally first.

I use Wamp testing server on my Windows computer.  But you could use Xampp or Mamp or Mamp Pro for Mac. 

Install the server and define it in your Site Definition Settings.  See screenshots below for details.

CC-testingServer1.jpg

Servers:

CC-testingServer2.jpg

Basic tab:

CC-testingServer3.jpg

Advanced Tab:

CC-testingServer4.jpg

Final Screen (notice Local/Network connection is

...

Votes

Translate

Translate
Community Expert ,
Jan 06, 2017 Jan 06, 2017

Copy link to clipboard

Copied

You are on the wrong track if you want to use the deprecated Server Behaviours panels. They have been removed because they do not create modern code.

You could purchase a commercial product, but in your case you may like to look at PHP CRUD Tutorial (part 1)

The reason for suggesting the tutorial is simple. It is of no use putting data into a database if you cannot access that data for viewing and maintenance. The tutorial will guide you through a CRUD (create, read, update, delete) system.

If you prefer the commercial product have a look at

Wappler, the only real Dreamweaver alternative.

Votes

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
community guidelines
Community Expert ,
Jan 08, 2017 Jan 08, 2017

Copy link to clipboard

Copied

LATEST

Developing a CRUD usually requires a local Apache testing server on your computer.  Obviously, you don't want to deploy an app on your remote server until you know it works properly.  You must test locally first.

I use Wamp testing server on my Windows computer.  But you could use Xampp or Mamp or Mamp Pro for Mac. 

Install the server and define it in your Site Definition Settings.  See screenshots below for details.

CC-testingServer1.jpg

Servers:

CC-testingServer2.jpg

Basic tab:

CC-testingServer3.jpg

Advanced Tab:

CC-testingServer4.jpg

Final Screen (notice Local/Network connection is for Testing server.  FTP connection is to Remote server.)

CC-testingServer-final.jpg

Once your Apache server is installed & running on your computer, go to your remote server and export the MySQL data & tables  with PhpMyAdmin. 

Then launch your testing server's PhpMyAdmin and import the SQL file.

Nancy

Nancy O'Shea— Product User, Community Expert & Moderator

Votes

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
community guidelines