MySQL queries with HTTPS

sabien

I am trying to do simple database pulls from within secure pages and all the PHP code is working fine, but will not allow secure display of the mysql queries.

When I do something like:

$result= mysql("SELECT * FROM table WHERE column='$var'")

do I need to somehow reference the SSL certificate? I can input data into the database just fine, but cannot pull data from it.

I am using a shared SSL certificate on Unix.

mistcat

I would hazard a guess that the problem might have to do with the GRANT Table options for the mysql user you are using...

Check out:

http://www.mysql.com/doc/S/e/Secure_GRANT.html

sabien

PHP 4.0.6
MySQL 3.23.32

I have a shopping cart application that needs to call a MySQL database while inside secure pages. When in test mode using HTTP, everything works fine. As soon as I switch to HTTPS, it does not allow any data from the MySQL calls to be displayed. The pages are called using HTTPS - do I need to change the MySQL calls at all?

It does not return any errors! It just does not display the data. The permissions are all the same.

Currently I connect using:

$DBHost="localhost";
$DBUser="me";
$DBPass="mypassword";
$DBName="mydatabase";

Does the DBHost need to call to the HTTPS server to allow this? And if so, how do I reference it?