Support says the change to PHP5 caused the failures (this is, of course, without them even looking at a speck of my code or what is happening with it).
To put this into context a brief overview:
All pages use an include file to open the connection to the server and set the SQL server variables. This is what is in the include file:
$hostname_conn_snoopy = "snoopy.some_server_somewhere.com";
$database_conn_snoopy = "snoopy";
$username_conn_snoopy = "username";
$password_conn_snoopy = "password";
$conn_snoopy = mysql_pconnect($hostname_conn_snoopy, $username_conn_snoopy, $password_conn_snoopy) or trigger_error(mysql_error(),E_USER_ERROR);
This gets called on the top of my orders pages, orders1, 2 and 3 with this command:
<?php require_once('Connections/conn_snoopy.php'); ?>
On page 1 this works, and when a branch is selected from the pulldown list, and the name of the person is entered, when submit is clicked, the data IS posted to the SQL server (I looked in the database, and the new record is created with the new data).
The code for the submit button on page 1 is as such:
The code for the submit button on page 2 is as such:
A hint to me that something isn’t right in China on the orders2 page is the fact that data that should be showing up on the top of the page isn’t showing up. Here are the calls that are supposed to display the data:
[color=#FF4500]<?php echo $lastid;?>[/color]
|<?php echo $today; ?>
||[color=#FF4500][b]<?php echo $row_orderDetail['branchNumber']; ?>[/b][/color]
||[color=#FF4500][b]<?php echo $row_branchName['branchName']; ?>[/b][/color]
||[b][color=#FF4500]<?php echo $row_orderDetail['name']; ?>[/color][/b]
The really wild thing about the first variable called, $lastid, is carried from page to page in the URL, and it shows up correctly in the URL.
The connection calls to the server are exactly the same on all three pages, however it seems that after posting the data from the initial page, PHP seems not to be communicating with the SQL server any more.
Has anyone had this problem or does anyone have a suggestion? This is absolutely maddening, since this php/sql solution has been working flawlessly for over 4 years and suddenly overnight it is broken and I’m having to rewrite it.