How to assign value from loop to variable using php?

Question

I am making a program that generates monthly report from the weekly report that is save from database. I can fetch the data from database through loop but the problem is i want to use the value from loop and assign it to a variable.

here's my code:

$mon=$_SESSION['mot'];
    $query2 = mysql_query("SELECT * FROM keyper WHERE MONTH(date) = '$mon'");
        while($row2 = mysql_fetch_array($query2))
        {
            $tar1 =  $row2["target"];
            $hi = $row2["high1"];
            echo $tar1;
            echo $hi;
        }

After that query I got the result like this:

target1

high1

target2 

high2

target3

high3

I want to assign the result of the loop into a variable like this

$a="target1";

etc...

How can I do that? Can someone help me?

Thanks in advance.

add a counter variable($counter =1) and add counter to your $tar.$counter =$row['target'] and $counter++ in end your loop — Rakesh Sharma
– Rakesh Sharma, Commented Feb 26, 2014 at 5:42
Please, please take a look at en.wikipedia.org/wiki/SQL_injection. mysql_escape_string if you insist on using inline variables, or use prepared statements php.net/manual/en/mysqli.quickstart.prepared-statements.php — Daren Schwenke
– Daren Schwenke, Commented Feb 26, 2014 at 5:47

Shankar Narayana Damodaran · Accepted Answer · 2014-02-26 05:39:18Z

2

Instead you pass them into an array..

while($row2 = mysql_fetch_array($query2))
{
    $tar1[] =  $row2["target"]; //<--- The $tar1 variable is now an array
    $hi[] = $row2["high1"];     //<--- The $hi variable is now an array

}

So you access it like echo $tar1[0]; that prints target1 and echo $hi[1]; will print high2 etc and so on....

answered Feb 26, 2014 at 5:39

Shankar Narayana Damodaran

68.6k43 gold badges102 silver badges129 bronze badges

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

1 Comment

jrwebapps Over a year ago

Wow! that is just the code that i needed. thank you so much. you save my life. :)

Nishant Solanki · Accepted Answer · 2014-02-26 05:47:05Z

0

You can use array to store the value.. like...

$tar1 = array();
$hi = array();
$i=0;
while($row2 = mysql_fetch_array($query2))
     {
         $tar1[$i] =  $row2["target"];
         $hi[$i] = $row2["high1"]; 
         $i++;
     }
print_r($tar1);
print_r($hi);

answered Feb 26, 2014 at 5:47

Nishant Solanki

2,1283 gold badges19 silver badges32 bronze badges

Comments

Manojkumar · Accepted Answer · 2014-02-26 06:17:24Z

0

$count = 1;
while($row2 = mysql_fetch_array($query2))
{
    $tar[$count][] =  $row2["target"]; //<--- The $tar1 variable is now an array
    $hi[$count][] = $row2["high1"];     //<--- The $hi variable is now an array
    $count++
}

foreach($tar as $key=>$targets)
{
echo $targets[0].$key;
}

just keep count in keys

answered Feb 26, 2014 at 6:17

Manojkumar

1,3616 gold badges36 silver badges67 bronze badges

Collectives™ on Stack Overflow

How to assign value from loop to variable using php?

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related