Problem with remote page

Hi Ray
I have a page boatenquiry_insert.php
The page is supposed to pass details to confirm.php.

On my localhost this is carried out correctly.
I have uploaded local files boatenquiry_insert.php and confirm.php to a remote server but the confirm page does not open but the page boatenquiry_insert.php opens again when it should pass to confirm.php.

I have checked the localhost version against the remote version and can find no difference in the code. I am using an excellent app called Code Compare to compare the local and remote files and they are the same.

I wondered if you can see why confirm.php does not open on the remote server.

Remote
http://net100test.co.uk/index2.php
http://net100test.co.uk/boat-details.php?RecNo=12140
http://net100test.co.uk/Enquiries/boatenquiry_insert.php?RecNo=12140
Send Enquiry goes back to
http://net100test.co.uk/Enquiries/boatenquiry_insert.php?RecNo=12140

Localhost
http://localhost/boatsforsalenow_mysqli2/index2.php
http://localhost/boatsforsalenow_mysqli2/boat-details.php?RecNo=12140
http://localhost/boatsforsalenow_mysqli2/Enquiries/boatenquiry_insert.php?RecNo=12140
http://localhost/boatsforsalenow_mysqli2/Enquiries/confirm.php
localhost/boatsforsalenow_mysqli2/Enquiries/thank_you.php

Delete lines 22-54 that is not being used.

Does the insert take place on the live server just not the redirect?

Update the insert trigger to use the same button press trigger as the validation. Validation and actions should use the same redirect.

If it still doesn't work, please attach the new file in a reply.

Delete lines 22-54 that is not being used.
Done

Does the insert take place on the live server just not the redirect?
I checked the remote database and it is being updated with my tests

Update the insert trigger to use the same button press trigger as the validation. Validation and actions should use the same redirect.
Any hints on how this is carried out Ray?

Currently the blank line on line 22 would prevent the redirect. It could potentially be an issue with blank lines or errors in an include file causing the problem as well.

Remove line 22.

Open the Insert Record Server Behavior and then change the trigger in the list to use the "insert" button press.

Test that and let me know if you still have the problem. The next step in debugging would probably be to add this before the insert code:

<?php

if (isset($_POST["Insert"])) die("here");

?>

And see if there is any blank lines or errors that are occurring that might be preventing the redirect.

When I inserted
<?php if (isset($_POST["Insert"])) die("here");?>
in the code
a blank page shows only with the word "here"

I took out some blank lines inc line 22

Please find attached file I removed <?php if (isset($_POST["Insert"])) die("here");?>

If you view source with the word "here" are there any spaces or blank lines before it? They could be coming from one of the include files so I couldn't spot them in the source code provided.

I have now re-inserted
<?php
if (isset($_POST["Insert"])) die("here");
?> into boatenquiry_insert.php which I previously removed.
When the page is run the resultant page just shows 'here' as does the source code.
Please see attached.
Thank you
John

Add it right before the insert on line 30 to see if any spaces are added between lines 1 and 30.

Yes I did that and get similar
Connection to MySQL server successfully established.

here

Scrolling through boatenquiry_insert.php I get an error message in DW line no 179
<?> invalid markup
Marked invalid because its an over lapping or unclosed tag