# PHP & AJAX problem

**URL:** <https://forum.kirupa.com/t/php-ajax-problem/318557>\
**Category:** programming\
**Created:** [January 24, 2011, 2:52am UTC](https://forum.kirupa.com/t/php-ajax-problem/318557 "2011-01-24T02:52:25Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Drakash](https://avatars.discourse-cdn.com/v4/letter/d/b19c9b/32.png) [@Drakash](https://forum.kirupa.com/u/Drakash)\
**Post date:** [January 24, 2011, 2:52am UTC](https://forum.kirupa.com/t/php-ajax-problem/318557/1 "2011-01-24T02:52:25Z")

</div>

Hi folks,

I have an order form built in PHP which submits the data to an AJAX script for storage in a database, BEFORE it then goes to Google Checkout for the order to be prcessed.

It all seems to work just fine and well in IE 7 & 8, but not in Safari, Firefox in Windows.

cart.php code:

Here’s the AJAX part:

```auto
<script type="text/javascript">
<!--
function addBand(count, band){
    var count1 = count;
    var band1 = band;
    alert("BAND ID: "+band1+" & TICKETS: "+count1);
    if (count1=="" || band1==""){
      alert("NO BAND SELECTED");
      return false;
    }
    if (window.XMLHttpRequest){// code for IE7+, Firefox, Chrome, Opera, Safari
      xmlhttp=new XMLHttpRequest();
    }else{// code for IE6, IE5
      xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
    }

    xmlhttp.open("GET","addbands2.php?band="+band1+"&count="+count1,true);
    xmlhttp.send(null);
}
//-->
</script>

```

The form is as follows (a renderred version to save me having to post all the PHP include code):

```auto
<form method="POST" action="https://checkout.google.com/api/checkout/v2/checkoutForm/Merchant/326432977035812" accept-charset="utf-8" onSubmit="addBand(6,4968);">
<!-- Sell physical goods and services with possible tax and shipping -->
<input type="hidden" name="item_name_1" value="Adult Weekend Ticket (18+, Free Camping and Parking)"/>
<input type="hidden" name="item_description_1" value="GB 2011 - Entry Ticket (supporting Alice and Jono)"/>
<input type="hidden" name="item_price_1" value="58.00"/>
<input type="hidden" name="item_currency_1" value="GBP"/>
<input type="hidden" name="item_quantity_1" value="6"/>
<input type="hidden" name="_charset_" />
<!-- Button code -->
<input type="image" name="Google Checkout" alt="Fast checkout through Google" src="images/buttons/preceed.gif?merchant_id=326432977035812&w=214&h=59&style=trans&variant=text&loc=en_GB" height="59" width="214" border="0" />
</form>

```

Which when submitted called the addBand() AJAX script, which in turns calls the addbands2.php script before submitting the order to Google.

addbands.php script is as follows:

```php
<?php
$con = mysql_connect("localhost"," ****","****"); 
if (!$con) {
  die('Could not connect: ' . mysql_error());
}
mysql_select_db(" ****", $con);

$band_nid = $_GET['band'];
$query2 = mysql_query("SELECT field_tickets_sold_value FROM content_type_act WHERE nid = ".$band_nid); 
$result2 = mysql_fetch_array($query2);
$newCount = $result2['field_tickets_sold_value']+$_GET['count'];
$updateBand = mysql_query("UPDATE content_type_act SET field_tickets_sold_value = ".$newCount." WHERE nid = ".$band_nid);
$process = mysql_fetch_array($updateBand);
?>

```

So could anyone please help me with an answer as to why it is working fine in IE 7 & 8, but not Firefox or Safari?

Any help would be much appreciated, as I just can’t seem to see the wood for the trees.

Cheers,

Drakash