Explode error

[dcjones]

Hi all.

Can anyone see what is causing this error:

$data = explode(';', $ReturnString);
$Products = array();
foreach ($data as $value)
{
    $Product = explode(';', $value);
    $Products[$Product[0] = array(
        'product ID' => $Product[9],
        'coupon' => $Product[13]); // LINE 84
} 

ERROR
Parse error: syntax error, unexpected ',', expecting ']' in /var/www/vhosts/baggagepin.com/httpdocs/baggagepinm/sales_commission.php on line 84

Many thanks.

[Krik]

This line

$Products[$Product[0] = array(

[dcjones]

Good morning Kirk,

Thanks for your fast reply.

I am looking at

$Products[$Product[0] = array( 

and for the life of me, I can't see what is wrong. Can you explain please.

Many thanks

[NogDog]

You never close the first "[" on that line. I'm guessing what you want is:

$Products[$Product[0]] = array(

[djjjozsi]

your code is doing:

you explode a string with a separator: ;

Then you explode the separated string using a separator: ;

it has no sense 🙂

for example:
a;4;5;3;gb;xcvb;t;ert;qweqwe;e;e;;t;z

php has csv functions, such us:

str_getcsv

[dcjones]

Hi all.

I am having a problem with is explode code but I think my problem starts wth creating the ARRAY.

I have a query that brings back data, one of the data fields is serialised so I need to use EXPLODE to break it up.

This is my attempt :

mysql_select_db($database_baggageppin, $baggageppin);
$query_sales_commision = sprintf("SELECT p.payment_id, p.product_id, p.begin_date, p.paysys_id, p.data, p. amount, p.completed, p.coupon_id, p.processed,p. retail, c.coupon_id, c.code FROM amember_baggagepayments p,  amember_baggagecoupon c WHERE p.coupon_id = c.coupon_id  AND p.retail = %s  AND p.completed = %s   AND p.paysys_id = %s   AND p.coupon_id > %s   AND p.amount > %s   AND p.processed > %s ", GetSQLValueString($colname1_sales_commision, "text"),GetSQLValueString($colname2_sales_commision, "text"),GetSQLValueString($colname3_sales_commision, "text"),GetSQLValueString($colname4_sales_commision, "text"),GetSQLValueString($colname5_sales_commision, "text"),GetSQLValueString($colname6_sales_commision, "text"));
$sales_commision = mysql_query($query_sales_commision, $baggageppin) or die(mysql_error());
$row_sales_commision = mysql_fetch_assoc($sales_commision);
$totalRows_sales_commision = mysql_num_rows($sales_commision);

$data = $row_sales_commision['data']; 



$Products = array(); 
foreach ($data as $value) 
{ 
    $Product = explode(';', $value); 
    $Products[$Product[0]] = array( 
        'product ID' => $Product[9], 
        'coupon' => $Product[13]); 
} 

print $Product[9]; 
print $Product[13];

I am trying to extract the content of the 9th and 13th row of the $data content.

Its not working but I think its my inexperience in ARRAy work. Can anybody help and explain how I should be doing this.

Many thanks

[djjjozsi]

they aren't arrays! They're strings only...

$data = $row_sales_commision['data']; 
$data  is not an array!

PHP has unserialize() and serialize() functions. you should use them.

the normal version:

<?php
$data="1;234444;5345;sdfgsdfg;456;tzutzu;7567;1;&#711;;^;&#728;;°345345,13,24,35,666;werwer;ttt;ertert;vyxcvyxcv;hdfghfdgh6";

$Product = explode(';', $data);

/*  $Product[0] is     1*/
    $Products[$Product[0]] = array(
        'product ID' => $Product[9],
        'coupon' => $Product[13]);

print "<pre>";
print_r($Products);
print "</pre>";
/*print $Product[9];
print $Product[13];
*/
?>

Array
(
    [1] => Array
        (
            [product ID] => ^
            [coupon] => ttt
        )

)