Participant

Answered

MySQL, php, & Dreamweaver Database Steps

Forum|Forum|8 years ago
June 20, 2017
3 replies
3706 views

Hello!
I need to create a database for a website on ixwebhosting using MySQL and PhP. It needs to be an interactive database that can provide feedback on 150+ organizations and editable for future employees to update. To be more specific, it needs to be a webpage on the website.

1) Can I use DW to create such a database for php?

2) Will the next person need to use DW to edit the database? If so will they specifically need my account?

3) If I were to be drawing up a timeline for this project, could the first step be create the database using DW, then enter it to php, then lastly, connect the database table webpage to the website? OR do I need to synch DW to php first?

This topic has been closed for replies.

Correct answer BenPleysier

1. You can use Dreamweaver to an SQL statement that you can use in a program like phpMyAdmin to create the database

2. No

3.The first step is to determine what information to store in the database.

For more information, have a look at PHP CRUD Tutorial (part 1)

Nancy OShea

Community Expert

IX Web Hosting has several plans ranging from super cheap to VPS. Don't scrimp on hosting. You need Apache/Linux and definitely want your own IP address. SSL certificates are recommended for at least the backend CMS. But if you want to be in good graces with Google, buy SSL certs for the whole site.

Happy coding!

Nancy

Nancy O'Shea— Product User & Community Expert

ovidiumacoway

Participating Frequently

i am hosting my sites for decades with IX lol. good one.

Nancy OShea

Community Expert

Create a PHP work environment by installing an Apache local testing server on your computer. Use WAMP, or XAMPP or MAMP or MAMP PRO (your choice).

Next, plan & create your database carefully with a mind toward organizing data for searches. This will be done with phpMyAdmin both locally and on the remote server.

Then, you need to build a backend CMS. A user-friendly application for employees to log into so they can interact with your databases. This is commonly referred to as CRUD for Create, Read, Update and Delete data,

Finally, you build the front end pages with HTML, PHP & SQL statements so database content can appear on your front facing web pages.

This is not a beginner's project. You will need very good coding skills and a working knowledge of how to create databases with phpMyAdmin. Give yourself ample time to learn & create all this. Do not take this on under a crazy deadline that you can't possibly meet.

Nancy O'Shea— Product User & Community Expert

BenPleysier

Correct answer

Community Expert

1. You can use Dreamweaver to an SQL statement that you can use in a program like phpMyAdmin to create the database

2. No

3.The first step is to determine what information to store in the database.

For more information, have a look at PHP CRUD Tutorial (part 1)

Wappler is the DMXzone-made Dreamweaver replacement and includes the best of their powerful extensions, as well as much more!

patiencem53589384Author

Participant

So I can I create the database on Adobe Dreamworks FIRST, then connect to it later?

Rob Hecker2

Legend

So I can I create the database on Adobe Dreamworks FIRST, then connect to it later?

No. You do not create a database in Dreamweaver. There is no connection between DW and the database engine. You use an interface to the database like PHPmyAdmin or MySQL Workbench to create and manage the database. Then, you use PHP within your web pages in Dreamweaver to send SQL scripts to the database and process the results of recordsets from the database.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded