close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Trouble creating a PHP database connection in CS4

Thread began 3/12/2010 5:00 pm by gkjpease399719 | Last modified 3/17/2010 4:51 pm by Eric Mittman | 713 views | 3 replies |

gkjpease399719

Trouble creating a PHP database connection in CS4

Mac OS X
Dreamweaver CS4
PowerStore3
1&1 server

I am attempting to create a PHP database in DW.

I was instructed to do this in the "Setting up a testing server for a Mac OS X", found in the Dynamic Development Tutorials. I successfully created MAMP and Defined a Dynamic Site in Dreamweaver.

I'm then told, "You've now defined your dynamic site in Dreamweaver, and you are ready to start creating your website's dynamic pages. Your first step should be to create a database connection to tell Dreamweaver what kind of pages you intend to create with this site and where your database is stored."

The next step of "creating a PHP database connection" is where I am stumped. I could not test successfully in DW from the MySQL connection window.

After talking to 1&1 support (double checked all the fields to see that they were correctly filled) they say that I can not access the data base using a remote server. At least I think that is what I understand them to mean.

I did not set-up PS3 using DW but instead directly uploaded to 1&1 first. Should I start out by loading PS3 into DW? If so, please direct me to the instructions for doing this. Or is there a simpler way?

This has led me to this next question: How do I accomplish the following as instructed by Lynda.com in "Defining a DW site"? It first states, "If you have copied your files into place of your php apache server web root folder, your now ready to define your DW site that's associated with php." I'm guessing that means I first need to copy my PS3 files (specifically which ones) into DW, before I go defining a site as directed in the WA instructions, "Setting up a testing server for a Mac OS X". So, any help here as well?

I am getting a grasp of this stuff bit by bit, albeit painfully slow. As everyone now has concluded, I'm "dull" as well as very "green" #%@!

Thanks for your help :)

Sign in to reply to this post

Eric Mittman

It sounds like you are about ready for local development but are just missing the db connection. To get that worked out you should use a copy of your live db, if you can export it from the live database you will import it locally into your MySQL. Once that is done you can then establish a connection to it from within DW. However, if you make any changes to the db you will need to export it from your local copy and import it into your live db to sync the records.

For the files you should copy all of the files from your web root into your local DW site root.

Are you trying to make any dynamic type of changes to the PowerStore? If not you could go without the db connection if you would just like to make design changes to the pages. In DW you could open up the pages and templates to alter the style and design, then upload to the live server when done.

Sign in to reply to this post

gkjpease399719

Thanks for your reply.

Please guide me through something that I'm sure is quite simple, but..... How do I? - "use a copy of your live db, if you can export it from the live database you will import it locally into your MySQL."

Also, I understand that developing a dynamic site is the only way to go now days. So, yes I will indeed eventually want to make dynamic type of changes to PowerStore.

Again, thanks for your help!

Sign in to reply to this post

Eric Mittman

How exactly you go about transferring your data from one db to another will depend on the tool that you use. If you use phpMyAdmin there should be an export tab you can select and it will let you create a .sql file that is a backup of your db. You can then import the backup on your live site or visa versa. We have some free training for those new to db manipulation, it is called the database starter kit, here is a link to it:

database-for-php/

Please post back with any questions that you have about this or any other part.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...