MySQL, php, & Dreamweaver Database Steps

[patiencem53589384]

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?

[BenPleysier · Accepted solution]

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)

[patiencem53589384]

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

[Rob Hecker2]

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.

[anissa_thompson]

In addition, if the site is being hosted by a commercial hosting service (like GoDaddy, BlueHost, Dreamhost, or a myriad of other reputable providers), almost all of them include free MySQL database options in their plans... and along with that, starter tutorials for creating simple tables.

If the prospect of setting up your own PHP environment is daunting or you're pressed for time, this may be the next viable option; however if you have the time and the inclination to pick up some valuable skills, everything Nancy OShea stated above is absolutely on point.

[osgood_]

patiencem53589384  wrote

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

Without being too disrespectful it sounds like you are 2 or 3 years away from actually being able to effectively do what you want by yourself, without it causing you a lot of issues. I dont think you can just go from knowing nothing to knowing how to implement something you have never tackled before, that comes with a lot of trial and error and hours of dedicated learning.

[Nancy OShea]

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 OShea]

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

[ovidiumacoway]

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