Assigning array values to incremental variables with PHP to insert into mysql table

Question

I have the following results page from the previous form:

<?php
//Get the form results (which has been converted to an associative array) from the $_POST super global
$musicgenres = $_POST['music'];

//Sort the values by rank and keep the key associations.
asort($musicgenres, SORT_NUMERIC );

//Loop over the array in rank order to print out the values.
foreach($musicgenres as $music => $rank)
{
    echo "$music is your $rank choice";
   echo "<br>";
 }
?>

Here is an example of the output (without the bullets):

Rap is your 1 choice
Rock is your 2 choice
Jazz is your 3 choice
etc....

I'm thinking that putting this into a table will not be easy or clean. How can assign these values to incremental variables?

e.g.

$musicrank1 = rap
$musicrank2 = rock
$musicrank3 = jazz
etc....

What exactly are you trying to achieve here? Dynamically creating an undetermined number of variables looks like a hack. — patrys
– patrys, Commented Aug 11, 2015 at 9:44
make a music_ranks table and insert rank and music .Then do whatever you want to do. If it is dynamic then update the music_rank table using query. — Suraj Rajput
– Suraj Rajput, Commented Aug 11, 2015 at 9:47

syed suleman · Accepted Answer · 2015-08-11 09:42:34Z

3

Try this

$i = 0;
//Loop over the array in rank order to print out the values.
foreach($musicgenres as $music => $rank)
{
    ${ "musicrank". ($i) }  =   $music;
    echo "$music is your $rank choice";
   echo "<br>";
   $i++;
 }

after foreach you'll have your variables.

answered Aug 11, 2015 at 9:42

syed suleman

5422 silver badges6 bronze badges

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

Comments

Joonazan · Accepted Answer · 2015-08-11 10:10:08Z

2

Using a table is much easier than creating arbitrary variables. With the table you just have to say $musicrank[1] instead of $musicrank1 and you can iterate over the table if you want to.

As a rule of thumb, if you'd assign each value in the table manually, you should use variables instead. But you are using a loop, so it's a pretty obvious case for tables.

answered Aug 11, 2015 at 10:10

Joonazan

1,42610 silver badges19 bronze badges

Comments

Robert · Accepted Answer · 2016-03-22 09:15:23Z

0

use this script : for add array with comma

        `$no = 0;
        foreach($sql2 as $row2)
        {
            $row["store_name"] .= ($no != 0) ? ", " : "";
            $row["store_name"] .= $row2["store_name"];

            $no++;
        }

edited Mar 22, 2016 at 9:15

Robert

5,31843 gold badges70 silver badges115 bronze badges

answered Mar 22, 2016 at 8:55

fdyahk

453 bronze badges

Collectives™ on Stack Overflow

Assigning array values to incremental variables with PHP to insert into mysql table

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related