ssl won't load page with $_GET paramater coming from non ssl page

[john_6767]

ssl won't load page with $_GET paramater coming from non ssl page..

is this normal? how do i fix it?

cheers

[doni49]

more info please

I'll do what I can--IF I can.

[john_6767]

basically i have a page i just put over to ssl, and now this page won't work.. the page that links to it is not on ssl and it is passing a url parameter to the ssl page..

i assume that the the ssl page isn't working because it doesn't think the passing of a url from a non secure page is safe..??

i have put a series of echos on the page to see where it breaks and have found that it breaks around here

[code]$colname_rsOrderDetails = "-1";
if (isset($_GET['orderID'])) {
  $colname_rsOrderDetails = (get_magic_quotes_gpc()) ? $_GET['orderID'] : addslashes($_GET['orderID']);
}
mysql_select_db($database_connN, $conn);
$query_rsOrderDetails = sprintf("SELECT * FROM orders WHERE orderID = %s", $colname_rsOrderDetails);
$rsOrderDetails = mysql_query($query_rsOrderDetails, $conn) or die(mysql_error());
$row_rsOrderDetails = mysql_fetch_assoc($rsOrderDetails);
$totalRows_rsOrderDetails = mysql_num_rows($rsOrderDetails);[/code]

edit: it doesn't load past here.. but worked fine on the non ssl setup

[doni49]

So when you go from the non-SSL page to the URL page, do you still see the variables in the URL?

This WAS working and then you switched it over to SSL and there were NO other changes?  I can't say whether or not going from non-SSL to SSL will cause a problem like this, but I don't see why it would.

[john_6767]

yep the variables are in the url..

[john_6767]

just found out its not the get.. its something below it in that code..

[john_6767]

ok, the prob is in this line i think..
i get echos displaying on screen up until this one..

[code]$rsOrderDetails = mysql_query($query_rsOrderDetails, $conn) or die(mysql_error());[/code]

[doni49]

Try putting this above that line and see what the values are.

echo "<br />Query:  " . $query;
echo "<br />Details:  " . $rsOrderDetails;
echo "<br />Conn:  " . $conn;

[john_6767]

ok will try that now and let u know, in the mean time,

is there something different that has to be done when including files on a ssl page?

i just worked out that the include file for the connections doesn't seem to be working but works fine if i put the code in the page..

i am using the following code to include the connections file,

[code=php:0]
require_once('https://www.mydomain.com/Connections/conn.php');
[/code]

and here is the code in the file

[code=php:0]<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_conn = "203.00.00.000";
$database_conn = "databasename";
$username_conn = "UserName";
$password_conn = "Password";
$conn = mysql_pconnect($hostname_connN, $username_conn, $password_conn) or trigger_error(mysql_error(),E_USER_ERROR);
?>[/code]

[john_6767]

ok, i tried your tip and the variables all came back with no values..

[john_6767]

actually i got that wrong, the only one not set is connection.. which leads me to the include ([code=php:0]require_once('https://www.mydomain.com/Connections/conn.php');
[/code]) .. if i put the include code on the page it works..

[john_6767]

ok, thats the problem.. the files work if i put the code on the page, but i need to include them and they don't work by including them using:

[code=php:0] require_once('https://www.mydomain.com/Connections/conn.php');[/code]

the files are in the locations i am referencing..

[john_6767]

ok, well i got it going, i re made the recordset in dreamweaver and it started to work.. mm.. anyway thanks for your help..

also i found that sometimes [code=php:0]require_once('https://www.mydomain.com/Connections/conn.php');[/code] worked and sometimes [code=php:0]require_once(../Connections/conn.php');[/code] worked.. assuming the file your working on is in https://www.mydomain.com/folder

can anyone explain this so i know for next time?