Databases
StackOverflow2013
Postsdbo
POAJAX script stopped remembering session
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POAJAX script stopped remembering session
    primarykey
    data
    text
    <p>I little while back I posted <a href="https://stackoverflow.com/questions/9769795/using-same-session-id-in-ajax-cant-connect-to-mysql-db">this question</a>. I have updated that question with the AJAX script that worked for about 1 week. Basically I can use <code>session_start()</code> from the AJAX script, and then I could access the session variables that I needed. </p> <p>It is really strange, but I came in after the weekend, and this morning this script does not work anymore. It is very simple, here:</p> <pre><code>&lt;?php session_start(); $ajax_connection = mysql_connect('10.X.X.X',$_SESSION['username'],$_SESSION['password']); $result_set = array(); while ($result_set[] = mysql_fetch_assoc($results)){ // do nothing } echo json_encode($results); ?&gt; </code></pre> <p>Last week this worked flawlessly, and now in my error log i get the <code>Undefined index: username</code> and <code>Undefined index: password</code> warnings. And of course the MySQL connection is not established. So this script is not running the same session as the original connection. I used <code>error_log(session_id())</code> to check the IDs of the parent page and the AJAX script, and sure enough they are different. When i reload the page and try every again, the IDs stay the same for the page and the AJAX script respectively, but they should be the same ID, not 2 different ones. </p> <p>Anyway, does anyone have any idea why this wouldn't be working anymore, after working well for over a week?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USjeffery_the_wind
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POAJAX script stopped remembering session
      1. USMiles M.
      1. VTFavorite
    2. VO
      singulars
      1. POAJAX script stopped remembering session
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWhy would you store mysql connection info in a session variable?
      singulars
      1. POAJAX script stopped remembering session
      1. USN.B.
    2. CO@N.B. Well because it works. How else would I get the connection info to the AJAX script?
      singulars
      1. POAJAX script stopped remembering session
      1. USjeffery_the_wind
    3. COWhat prevents you from including a file that holds db credentials into your AJAX script? For 10 000 users, you'd fill in sessions with the same information. It's not really feasible, is it? It also, apparently, produces problems for you. Therefore, it implies a bad design decision. I could go on how it's unsafe on shared hosting etc. but I won't, it's simply bad design decision to have db info stored in session.
      singulars
      1. POAJAX script stopped remembering session
      1. USN.B.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload