Solved

Dreamweaver error occurs when testing a PHP / MySQL connection

Posted on 2004-10-01
3
205 Views
Last Modified: 2010-08-05
Hello,

I have a problem with the pre-written scripts in Dreamweaver MX for making a database connection to MySQL (PHP).  My ISP requires all script files reside in my /cgi-bin/ folder.

The prewritten scripts for testing connections were placed outside of /cgi-bin/. I reconfigured the site manager with the testing and remote servers inside the /cgi-bin/. The DM dialog windows would not allow me to list the root URL prefix to  ../cgi-bin/.

When I move the files (Connections & mmServerScripts folders) inside /cgi-bin/ and change to mod751, they still do not work and I receive a HTTP 500 error.  I think it is a mapping idiosyncrasy.
 
I have successfully connected to the database with a hand coded PHP connection(www.usmotorclub.com/cgi-bin/lads/try.php) so I know it works.

I need to make a connection through the Dreamweaver MX because it has all the pre-built pages I need to post, query, report, and update this site.

Can the testing files' code, or their location, be altered to work on this host?
Is it common for hosting sites to force all *.php pages into a /cgi-bin/?
Do I need to change ISP's?

Thanks ahead of time,
Kim
0
Comment
Question by:Kimah
  • 2
3 Comments
 
LVL 5

Accepted Solution

by:
bitter_chicken earned 500 total points
ID: 12205997
It is uncommon to force php files to reside there

It is common for CGI files (ie usually perl) - thus CGI bin.

But it is not usual because php files are usually used in place of HTML files, rather than as scripts referenced by a form.

For example, if you wanted your homepage to contain dynamic data, you wouldn't want your visitors to have to browse to http://yoursite/cgi-bin/homepage.php - you want it to appear automatically.

Have you tried creating php files outside of the CGI-BIN? give it a shot - it might work anyway. There is certainly no harm to the ISP.

If not, complain to your ISP, or change providers. Even if you can get the dreamweaver config working within the CGI bin it will limit the functionality of your website

bc :-)
0
 

Author Comment

by:Kimah
ID: 12207004
Thanks, Bitter_Chicken. I going to accept your solution as soon as you write back.

I was able to make the database connection late yesterday with all files saved to the /cgi-bin/, but you are right... I don't want the visitors to have to shop there.  I could use a frame-page or a refresh, but those would not give my clients the exposure they deserve in the search engines.

I have tried to create files outside of the /cgi-bin/ without success. I will contact my ISP this morning about this issue, but he will probably refuse. We have had other issues during the years together and he has not budged on those. People never change, they just get more so.

Can you recomend an ISP for a development grade site?

Kim
0
 
LVL 5

Expert Comment

by:bitter_chicken
ID: 12207425
Hi Kim

Sounds like you're well overdue for ditching your current provider

Recommendation of hosting? Well. I'd recommend my own company, but that is against EE policy.

From the guidelines:
" If you have any kind of financial interest in the company you list (as an employee or participant), it's forbidden. You may, however, put that information in your profile. "

Oh well.. no shameless self promotion

It all depends on what you need. You can check out the hosting section of EE: http://www.experts-exchange.com/Web/Hosting/

When I've looked for hosting in the past, I've found http://www.webhostingtalk.com/ very useful.

At current prices, I wouldn't pay more than US$5/mo for standard php hosting for a low-volume website, but you may have to pay more if 100% uptime, very high volume or good support are necessities.

Good luck with the website,
bc :-)
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
can i use dw to modify this site 1 310
Replace Dreamweaver with what? 8 166
Coldfusion CFMESSAGEBOX Passing Variables 6 117
Opening .cgi Files in DreawWeaver cc 2015 6 121
I still run into .cgi files every now and then. In some instances, I actually prefer the simplicity of a .cgi script to other options. Since I use DreamWeaver extensively, what I needed was a way to open .cgi scripts in Dreamweaver. And I wanted to …
This article is very specific and is only intended to help if you are installing Dreamweaver 8 in a Windows 7 environment with Office 2007 installed.   I'm not sure why Microsoft tends to release OS' that should not be released but they do.  Windows…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question