Filtering by session variable in PHP

Ask a Question related to Dreamweaver AppDev, Design and Development.

  1. #1

    Default Filtering by session variable in PHP

    Hopefully, this will be a simple question. I have recently switched over to a
    PHP/mysql platform from CF and am simply trying to filter a recordset with a
    session variable. I have the session set up (on a login page) and I know it is
    carrying over to the next page but I am obviously making an error in syntax
    when I add in the filter because it will come up with no data returned. In CF
    I can just filter in simple mode with seesion = username MM_username, obviously
    in PHP this does not work as it flips to advanced mode with a variable called
    'colname' (I believe - I am not on my DW computer right now). So, if someone
    could tell me what I need to change in the advanced recordset to make the
    session variable filter work it would be greatly appreciated. Thanks!!

    griffin2001 Guest

  2. Similar Questions and Discussions

    1. #39634 [NEW]: session variable and normal variable
      From: erhanbaris at gmail dot com Operating system: Win Xp SP1 PHP version: 5.2.0 PHP Bug Type: Variables related Bug...
    2. Cannot set session variable
      I created a simple login script a some time ago which worked like a charm until I recently switched to a new web host that's running ColdFusion MX. ...
    3. Datalist - how (if) to use a sub variable or session variable in the footer?
      Hi, sorry to be greedy with all my posts lately, but can you tell I'm doing new things this week? I've just done my first datalist (a simple...
    4. [SESSION] Session variable deleted prior to command?
      Hi all, I'm developing a database system on my local computer (OS/version details at bottom) with a simple user authentication using sessions. On...
    5. Recordset Filtering a Form Variable String
      what server model? joe "ID:UK" <webforumsuser@macromedia.com> wrote in message news:bejrua$2a4$1@forums.macromedia.com... a string (ie....
  3. #2

    Default Re: Filtering by session variable in PHP

    if the variable is on the next page, and not there later.. are you sure you are
    not looking at a Request variable and not a session variable. The Request
    object will be there in the next page but will dissapear after that.. You may
    need to do the PHP equivilant of Session('varname')=Request('varname') to
    persist it beyond the next page.

    RichMcCrea Guest

  4. #3

    Default Re: Filtering by session variable in PHP

    It does show as a session variable and when it goes to the next page you can
    see that it is carrying it over - if I do not filter it I can pull the records
    up on the next page. However, when I add in the filter to get only one user's
    information it comes back as no data returned. Thanks for your input!

    griffin2001 Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139