php & mysql - loop through columns of a single row and passing values into array

Question

I have a mysql table with columns id, f1, f2, f3, ..., f20 where id is productID and f1,...f20 are product features. Depending on each product, some might have all, none or only some columns filled.

Each column holds a delimited string like a#b#c#d where a,b,c,d are values in different languages (a=english, b=french etc)

I need to select a row by it's id, explode each column's value (f1,f2...) with '#' in order to get the language part I need and then pass the values to an array in order to use in my product spec page.

How do I loop through the fetched row (i'm using $row = my_fetch_array) and put the exploded value into a one dimension array like $specs=('green', 'M', '100', 'kids'...) etc? PS:I know, is complicated but I cant come up with a better idea right now.

At the moment all I have is my mysql table and a lot of sketches on paper! — bikey77, Dec 15 '11 at 16:49

score 7 · Accepted Answer · answered Dec 15 '11 at 16:51

7

Try this:

$result = mysql_query("...");

while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
    $arr = array();
    foreach ($row as $k=>$v)
    {
        $features = explode("#", $v);
        $value = $features[1]; // get the specific language feature
        $arr[] = $value;
    }
    $specs = join(", " , $arr);
}

answered Dec 15 '11 at 16:51

swatkins

13,530
4
46
78

1

This worked right away, thanks! I didn't know about the join function, nice. – bikey77 Dec 15 '11 at 17:00
Hello @swatkins...would you please help me in solving this http://stackoverflow.com/questions/28493201/how-to-find-the-total-distance-traveled-based-on-geo-points-stored-in-database related to same issue – Prabs Feb 13 '15 at 07:00

Lawrence Cherone · Answer 2 · 2011-12-15T16:58:36.953

Not sure this is the best way togo but you could define an array with your langs, then access the result by lang

<?php 
$langs=array('eng'=>0,'fr'=>1,'ger'=>2,'geek'=>3);


while ($row=mysql_fetch_assoc($result)) {
    $specs=explode('#',$row['f1']);
    $other=explode('#',$row['f2']);
    ...
}
//Get lang from cookie that you could set elsewhere
$lang=(isset($_COOKIE['lang']))?$_COOKIE['lang']:'eng';

echo $specs[$langs[$lang]];

?>

score 0 · Answer 3 · answered Dec 15 '11 at 17:02

My solution for how I understand you question:

// Make a MySQL Connection

$sQuery = "SELECT f1,f2,... FROM table WHERE id = ..."; 

$oResult = mysql_query($sQuery) or die(mysql_error());

//Fetch assoc to use the column names.
$aRow = mysql_fetch_assoc($oResult);

//Prepare the product properties array
$aProductProperties = array("English"=>array(),"French"=>array(),"Dutch"=>array());

//Loop over all the columns in the row
foreach($aRow as $sColName=>$sColVal){
//Explde the column value
    $aExplodedCol = explode("#",$sColVal);
    //The code below could be nicer when turned into a looped that looped over every language,
    //But that would make the code less readable
    $aProductProperties['English'][$sColName]  = $aExplodedCol[0];
    $aProductProperties['French'][$sColName]  = $aExplodedCol[1];
    $aProductProperties['Dutch'][$sColName]  = $aExplodedCol[2];

}

//Done, you should now have an array with all the product properties in every language

php & mysql - loop through columns of a single row and passing values into array

3 Answers3

Linked