[PHP-DB] Make history HOW?

2001-04-19 Thread Aleksey Yarilovets

Hi everyone !

The question is:

how to build a script that displays history of user clicks like:

Home  Setting  User Properties

BUT you can go into UserProperties from other locations so somewhere it will
be OK to get

Search  User Results  User Properties

Does enybody done it?

PS: www.geocities.com does but how? That is the question

Thanks, Alexey
--
--
LEA*D IP Systems
Phone: +972 4 999 1212 (ext. 213)
Fax: +972 4 999 1213
Mobile: +972 58 774 369
Email: [EMAIL PROTECTED]




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DB] Oracle session cursor

2001-04-16 Thread Aleksey Yarilovets


Hi !
I think the only way to do one query is DO one query into the sesission
variable array
and create index of current shown row and so you will get it works.

session_register ("storage_array"); storage_array = array();
session_register("curr_idx");$curr_idx=-1;

# your select here into storage_array, now you get
# storage_array["COLUMN_NAME"][0] = something

so in client's page you write:
echo storage_array["COLUMN_NAME"][$curr_idx];
$curr_idx++;

By, Aleksey

""Doug Schasteen"" [EMAIL PROTECTED] wrote in message
001d01c0c62e$4b7aace0$b1045ad1@doug">news:001d01c0c62e$4b7aace0$b1045ad1@doug...
As you all know, PHP is stateless. Meaning that once the script ends, all
connections are closed and the program is done.

I have a project where I need to do just 1 query to oracle, but only get one
row per page. So on the first page it does the query and says "20 results
total" and shows the first selected row. Then I click next and it brings up
the second row. I'm only supposed to show one row at a time. I can probably
cheat and parse the query on each page, but I'd like to find out from you
nice folks if its possible to do it with just one query. My guess is that I
would be using a persistant OCI connection and an oracle package/procedure,
but I'm not familiar with either of those enough to know if its possible or
not. Or maybe I could store my parsed query in a PHP4 session? Thats another
thing I am not very familiar with at this time.

Any info would be helpful. This project is due on wednesday so I need the
help ASAP.

Thanks.

- Doug Schasteen




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DB] sessions and page has expired warning

2001-04-16 Thread Aleksey Yarilovets

Hi!

I had exactly the same problem with back/forward and i found the script that
does the job:




""olinux""  wrote in message
000a01c0c0aa$2d465050$6401a8c0@amdk7">news:000a01c0c0aa$2d465050$6401a8c0@amdk7...
I am using sessions to store variables until all forms have been filled out.
at this point they are put into the db.
I would like to know how i can eliminate the problem that occurs when the
user presses the back button.  I receive a "warning, page has expired...
press refresh" I know that pressing refresh works fine, but some people do
not understand and get confused. How can i fix this?

thanks much
olinux




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]