save MySQL rows in an array and save it in session variable

Question

I want to get rows from MySQL Database and save two specific values(row[0] & row[6]) in $_SESSION variable for comparison later on. The code looks like below:

        $sqlResult =mysql_query("SELECT * FROM questionbank WHERE quizName ='$quizNames' ORDER BY RAND() limit 6")

    while ($row= mysql_fetch_array($sqlResult)) 
            {
                $questionPkId = $row[0];                    
                echo $_SESSION['$questionPkId'] = $row[6];

            }

The Problem is I can't get this values in other pages. Can I make an associative array with session variable (though i tried array_push(), But it did not work).

Did you make sure to call session_start on every page that uses $_SESSION ? — Jim
– Jim, Commented Nov 18, 2013 at 21:13
Don't use mysql_* functions. They are deprecated. Also, a tip, don't SELECT * but write out the columns you need. — Bart Friederichs
– Bart Friederichs, Commented Nov 18, 2013 at 21:15
Learn basic PHP syntax. '$questionPkID' is not going to evaluate to what you think it is... — Marc B
– Marc B, Commented Nov 18, 2013 at 21:18
@BartFriederichs Instead of mysql_* what should I use? Also I will need the row values later on. because I am planning to store values in one array and another one to display my questions and finally compare them to get the correct answer. Please advise (Thanks in advance) — Samawat
– Samawat, Commented Nov 18, 2013 at 21:19

Jim · Accepted Answer · 2013-11-18 21:18:39Z

2

A couple issues with your code. First up, make sure you call session_start on any page that uses sessions. Without it, you will not be able to access the variables previously set.

Second up, when a variable is called inside single quotes it is taken literally, meaning your session define statement is always assigning the variable to same thing, and hence overwriting what it should be.

$_SESSION[$questionPkId] = $row[6];

And that will assign the value to the actual value of $questionPkId. Aside from those issues, your session items should work, and if they are not you will need to provide us with more of your code.

answered Nov 18, 2013 at 21:18

Jim

18.9k5 gold badges51 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

AbraCadaver · Accepted Answer · 2013-11-18 21:19:48Z

0

Try without single quotes:

$_SESSION[$questionPkId] = $row[6];

answered Nov 18, 2013 at 21:19

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

Collectives™ on Stack Overflow

save MySQL rows in an array and save it in session variable

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related