problem with php and google analytics

[gstorms85]

Hello, I am trying to implement google analytics to track ecommerce transactions for my site but i'm having some problems and hopefully someone can help me out.

On the analytics help site google gives this example for the format it should be in (without the brackets):

<!--
<form style="display:none;" name="utmform">
<textarea id="utmtrans">UTM:T|[order-id]|[affiliation]| 
[total]|[tax]| [shipping]|[city]|[state]|[country] UTM:I|[order-id]|[sku/code]|[productname]|[category]|[price]| 
[quantity] </textarea>
</form>
-->

This is the actual code I have on the thankyou.php page on my site:

<?php /* This is for the php parser .... ignore this line!! */?>
<!--
<form style="display:none;" name="utmform">
<textarea id="utmtrans">
UTM:T|<?=$ordernumber?>|<?echo number_format($gtotal,2);?>|<?echo number_format($tax,2);?>|<?=$delivery_city?>|<?=$delivery_state;?>|USA
UTM:I|<?=$ordernumber?>|<?=$rsitemdetails["item_name"]?>|<?=number_format($rsitemdetails["item_price"],2)?>|<?=number_format($rsitemdetails["item_qty"])?> 
</textarea>
</form>
-->

For some reason the strings after UTM:T are working just fine, but the ones after UTM:I aren't. I think that maybe the brackets have something to do with it.

Someone please help me out with this. If you need any additional info please ask. Thanks.

[ ModEdit - bpat1434 ] Please use [php] tags when posting PHP code, and code tags when posting other code.

[bpat1434]

Just for grins and giggles, try this:

<?php
$google = '<textarea id="utmtrans">
UTM:T|%d|%s|%s|%s|%s|USA
UTM:I|%1$d|%s|%s|%s </textarea>';

$google = sprintf($google,
                $ordernumber, // order ID in both UTM:T and UTM:I
                number_format($gtotal,2), // total in UTM:T
                number_format($tax, 2), // Tax in UTM:T
                $delivery_city, // City in UTM:T
                $delivery_state, // State in UTM:T
                $rsitemdetails["item_name"], // Item Name in UTM:I
                number_format($rsitemdetails["item_price"],2), // Item Price in UTM:I
                number_format($rsitemdetails["item_qty"]) // Item Quantity in UTM:I
);
echo $google;

Now, just echo $google in your form and you should be good. Now, if that doesn't show up right, there's something else awry.

[gstorms85]

Many thanks for the response bpat but i'm still getting the same results. This is what gets displayed in the source after the script is run:

<!----
<textarea id="utmtrans">
UTM:T|12999|134.80|0.00|Atlanta|GA|USA
UTM:I|12999||0.00|0 </textarea> -
-->

I also noticed that where the $rsitemdetails["item_name"] code is displayed properly on the page this comes before it:

<?
																$giftwrap="";
																$reitemdetails=mysql_query("select item_name,item_code,item_price,item_qty,item_message,item_wrap,subtotal from sun_order_details where  order_id=".$oid);	

															//echo "select b.item_name,b.item_code,b.item_price,b.item_qty,b.item_message from celebrate_item_details a,celebrate_order_details b  where  order_id=".$oid."<br>";
																//echo "select b.item_name,b.item_code,b.item_price,a.item_message mess,b.item_qty,b.item_message from celebrate_item_details a,celebrate_order_details b  where a.item_id=b.item_id and order_id=".$oid;

															if(mysql_num_rows($reitemdetails)>0){
															  $sub_total=0;
															   while($rsitemdetails=mysql_fetch_array($reitemdetails)){
																  $item_wrap=($rsitemdetails["item_wrap"]);

														?>

I tried putting the $rsitemdetails["item_name"] code elsewhere on the page just to see if it would bring it up, but it doesn't. It seems like it can only display once and that's the problem.

Sorry if i'm making this sound confusing, php definetly isn't my strong area

[bpat1434]

Umm.... inside the while() loop, do you have the code I posted above?

$google = '<textarea id="utmtrans">
UTM:T|%d|%s|%s|%s|%s|USA
UTM:I|%1$d|%s|%s|%s </textarea>';

$giftwrap="";
$reitemdetails=mysql_query("select item_name,item_code,item_price,item_qty,item_message,item_wrap,subtotal from sun_order_details where  order_id=".$oid);

if(mysql_num_rows($reitemdetails)>0){
    $sub_total=0;
    while($rsitemdetails=mysql_fetch_array($reitemdetails)){
        $item_wrap=($rsitemdetails["item_wrap"]);

    $google = sprintf($google,
            $ordernumber, // order ID in both UTM:T and UTM:I
            number_format($gtotal,2), // total in UTM:T
            number_format($tax, 2), // Tax in UTM:T
            $delivery_city, // City in UTM:T
            $delivery_state, // State in UTM:T
            $rsitemdetails["item_name"], // Item Name in UTM:I
            number_format($rsitemdetails["item_price"],2), // Item Price in UTM:I
            number_format($rsitemdetails["item_qty"]) // Item Quantity in UTM:I
    );
    echo $google;
} // end while()
} // end if()

[gstorms85]

Wow, thanks bpat that worked perfectly. Only one more problem....when there is more than one product displayed, for some reason it shows up as this:

<!---
<textarea id="utmtrans">
UTM:T|10691||247.80|0.00||Verona|NJ|
UTM:I|10691||3 Compatible Xerox 108R00660/108R660 Cyan Solid Ink ColorStix Cartridge||61.95|2
</textarea><textarea id="utmtrans">
UTM:T|10691||247.80|0.00||Verona|NJ|
UTM:I|10691||3 Compatible Xerox 108R00660/108R660 Cyan Solid Ink ColorStix Cartridge||61.95|2
</textarea>

Instead of showing two different products it's just showing the UTM:T and UTM:I repeated twice for the one product. I tried adding another UTM:I field but for some reason that causes the code not to display at all.

[bpat1434]

Ah, well, that's because of the format of the loop.... you have to define the structure per item. I'm not sure of what format that is though. But you can add it to the $google variable as needed.

Or you can use the LIMIT 0,1 statement to make sure only 1 row is returned....