Seeting up and calling variables stored in sessions

hi,

i was wondering if anyone could help me. i'm new to php and i'm having problems setting up a session.

i have a login page (page1) where the user inputs their username and password and when they click the submit button they are brought to another page (page2) where they have two options. if they choose option to purchase a ticket they are brought to page3 where they choose the type of ticket. when they click submit on page3 it executes a php script that generates a ticket number and inserts it into the ticket table.

what i want to do is also insert the users AccID against the newly generated ticket number.

i want to get the AccID from the Users table when the person logs in at page1 and insert it when the person clicks submit oon page3.

i have tried some code but i am unsure where the session code goes and how to call variable stored in it.

can anyone help?

thanks in advanced,

scoobie

2

Contributors

2

Replies

1 Day

Discussion Span

8 Years Ago

Last Updated

3

Views

scoobie

Newbie Poster

20 posts since Jan 2005

Reputation Points: 10

Solved Threads: 0

Skill Endorsements: 0

8 Years Ago

0

I would suggest using <input type="hidden" name="AccID" value="$AccID"> in your forms so that the data is continuously passed from one form to the next.

Gary King

PHP/vBulletin Guru

Team Colleague

417 posts since Nov 2003

Reputation Points: 53

Solved Threads: 5

Skill Endorsements: 0

8 Years Ago

0

hi

thanks for that it worked.

would you have any idea how to do the same with a new user whose id is only generated when they register. i would like to use the same insert query though.

here is the qry that i have

$insert = "insert into tickettbl (AccID, ChrgID, TicketNo, TimeData, RecDate)
values ('$AccID', '$row->ChrgID', '$Random', '$OptionFrm', '$TodaysDate')";

it can be done if in the values section of query i change $AccID to LAST_INSERT_ID().

i need to somehow get the AccId from new record on store it in $AccID

scoobie

Newbie Poster

20 posts since Jan 2005

Reputation Points: 10

Solved Threads: 0

Skill Endorsements: 0

Seeting up and calling variables stored in sessions

This article has been dead for over three months: Start a new discussion instead