Jump to content

mikejarrett

New Members
  • Posts

    4
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

mikejarrett's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. It sounds like your issues are database related. I would recommend that you install phpmyadmin. It is an easy-to-use php app used for managing mysql. You can test your queries outside of the php and make sure that they are all working correctly.
  2. Ok, I'll post my own answer. What was happening was my session was timing out, and the $_SESSION['dbname'] was not set. If you call a pconnect without selecting a database, it will grab a database randomly (that is, it probably uses a connection that is pre-connected to a database). I have built a test case that proved my hypothesis. So, how to fix? I can either test the $_SESSION['dbname'] or probably a connect (not pconnect) would work. I think that I am going to go with the first -- but do you know the difference of connect vs. pconnect?
  3. if $exparray is the array that you've exploded into, you could: foreach ($exparray as $key=>$value) { if (empty($svar[$value])) $svar[$value]=1; else $svar[$value]++; } ksort($svar); At that point, the $svar would be an array with the keys that are the sorted, non-duped values, a the values would have the number of occurances.
  4. I have an application that, upon successful login, stores the name of the MySQL database and various other values in $_SESSION varibles. There have been several instances where it appears that a user in one database seems to connect to the session of another. The session process that I am using is simple: <?php session_start(); ... and my connections to the database are though: @ $db = mysql_pconnect(host, user, password); mysql_select_db($_SESSION['dbname']); Many of my databases have the same table names, so that a user may see data that should be seen only by another. I am not terminating my pconnect or database queries -- and it seems that the termination of the scripts should all end them cleanly, right? Is there anything that I need to be doing with my $_SESSION that would cause it to work incorrectly? The SESSION stuff has seems to work well, but it pretty much magic to me. Should I store the session values in local cookies rather then on the server (at least, that is where I think that I am storing them)? Do I have to worry about how the server points one session file to another? Is there something that I need to think about regarding the naming of session? Thanks for your help. Mike
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.