Kimah
asked on
Dreamweaver error occurs when testing a PHP / MySQL connection
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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: https://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 :-)
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: https://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 :-)
ASKER
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