close ad
Help us test the new Databridge BETA with MySQLi support
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

insert page not storing session variable

Thread began 3/05/2012 6:21 am by georgina_barrett_187762 | Last modified 3/06/2012 10:21 am by Jason Byrnes | 1036 views | 5 replies |

georgina_barrett_187762

insert page not storing session variable

I have an insert page but for some reason it is not storing the id in a session variable, so when it goes to the detail page nothing is being displays (even though it is inserting into the database correctly). I know the problem is on the insert page and not the detail page as I tried to post the session variable in the url on the redirect of the insert page but it just shows a 0. I have compared it to my other insert pages but I cannot see any difference. I have attached the file.

Attached Files
BookingRequest_Insert.zip
Sign in to reply to this post

Jason ByrnesWebAssist

on the insert page, change line 128:

php:
header("Location: ".$WA_redirectURL);



to:

php:
session_commit();

 header("Location: ".$WA_redirectURL);



if that doesnt work, to help troubleshoot, add the following code at line 1 of the detail page:

php:
<?php @session_start(); ?>




and the following code just before the closing </body> tag of the details page to output the session being created:

php:
<pre><?php var_dump($_SESSION); ?></pre>



post back the detail page and the session contents.

Sign in to reply to this post

georgina_barrett_187762

Adding session_commit didn't work.

I added the other code and when I loaded the page I got this at the bottom of the page

array(8) {
["loginlog_ID"]=>
&int(2397)
["EmpID"]=>
&string(2) "27"
["LoginLevel"]=>
&string(5) "admin"
["LoginGroup"]=>
&string(5) "admin"
["LoginName"]=>
&string(8) "Georgina"
["LoginFullName"]=>
&string(16) "Georgina Barrett"
["WADbSearch1_CustomerDetails_Results"]=>
&string(31) " AND (Surname LIKE '%barrett%')"
["WADA_Insert_BookingRequest"]=>
&int(0)
}

When I submitted the form it went to the detail page as before but didn't pass the session variable.

Sign in to reply to this post

Jason ByrnesWebAssist

what is the structure of the table.

What is the data type for the BookingRequestID? is it set to INT? Set to be the Primary key and to auto increment?

Sign in to reply to this post

georgina_barrett_187762

Yes it is an auto-increment int and it is the primary key. It does insert the record ok it is just the redirect that isn't working. It used to work but for some reason it has stopped redirecting. I have attached a screen shot of the table.

Sign in to reply to this post

Jason ByrnesWebAssist

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...