AJAX call
$('.updatecom .registercomplaint').click(function(){
updatecomplaints();
});
updatecomplaints()
function updatecomplaints()
{
var tno = $(".updatecom #tno").val();
var status = $(".updatecom #status").val();
if(status=='DONE')
{
$(".updatecom #con").val('');
}
var tname = $(".updatecom #tname").val();
var rg11 = $(".updatecom #crg11").val();
var rg06 = $(".updatecom #crg06").val();
var tvpins = $(".updatecom #tvpins").val();
var jointer = $(".updatecom #jointer").val();
var cquantity = $(".updatecom #conqty").val();
var nooftv = $(".updatecom #tvno").val();
var misc = $(".updatecom #misc").val();
var tcomments = $(".updatecom #tcomments").val();
var con = $(".updatecom #con").val();
//alert(tno+status+tname+rg11+rg06+tvpins+jointer+cquantity+nooftv+misc+tcomments+con);
$.ajax(
{
type: "POST",
url: "up_functions.php",
data: {ticket: tno , opt: 'upcom', status: status, tname: tname, rg11: rg11, rg06: rg06, tvpins: tvpins, jointer: jointer, cquantity: cquantity, nooftv: nooftv, misc: misc, tcomments: tcomments, con: con},
success: function(response)
{
alert(response);
}
});
}
up_functions.php
$tno = htmlspecialchars(trim($_REQUEST['ticket']));
$status = htmlspecialchars(trim($_REQUEST['status']));
$tname = htmlspecialchars(trim($_REQUEST['tname']));
$rg11 = htmlspecialchars(trim($_REQUEST['rg11']));
$rg06 = htmlspecialchars(trim($_REQUEST['rg06']));
$tvpins = htmlspecialchars(trim($_REQUEST['tvpins']));
$jointer = htmlspecialchars(trim($_REQUEST['jointer']));
$cquantity = htmlspecialchars(trim($_REQUEST['cquantity']));
$nooftv = htmlspecialchars(trim($_REQUEST['nooftv']));
$misc = htmlspecialchars(trim($_REQUEST['misc']));
$tcomments = htmlspecialchars(trim($_REQUEST['tcomments']));
$con = htmlspecialchars(trim($_REQUEST['con']));
$result=$ptr->upcomticketinfo($tno,$status,$tname,$rg11,$rg06,$tvpins,$jointer,$cquantity,$nooftv,$misc,$tcomments,$con);
echo $result;
upcomticketinfo()
function upcomticketinfo($tno,$status,$tname,$rg11,$rg06,$tvpins,$jointer,$cquantity,$nooftv,$misc,$tcomments,$con)
{
if($con!='' || $con!=NULL)
{
$this->query = "update `booking discription` set `STATUS`='$status',`CLOSED ON`='$con' where `TICKET NO`='$tno'";
$this->q_result = mysql_query($this->query,$this->conn) or die(mysql_error());
if($this->q_result)
{
$query = "update `tech detail` set `TECH NAME`='$tname',`CABLE RG11`='$rg11',`CABLE RG06`='$rg06',`TV PINS USED`='$tvpins',`JOINTER USED`='$jointer',`CONNECTOR QTY`='$cquantity',`NO OF TV`='$nooftv',`MISC`='$misc',`TECH COMMENTS`='$tcomments' where `BOOKING`='$tno'";
$q_result = mysql_query($query,$this->conn) or die(mysql_error());
if($q_result)
{
$response = "updated";
}
else
{
$response = "error";
}
}
else
{
$response = "error";
}
}
else
{
$this->query = "update `booking discription` set `STATUS`='$status' where `TICKET NO`='$tno'";
$this->q_result = mysql_query($this->query,$this->conn) or die(mysql_error());
if($this->q_result)
{
$query = "update `tech detail` set `TECH NAME`='$tname',`CABLE RG11`='$rg11',`CABLE RG06`='$rg06',`TV PINS USED`='$tvpins',`JOINTER USED`='$jointer',`CONNECTOR QTY`='$cquantity',`NO OF TV`='$nooftv',`MISC`='$misc',`TECH COMMENTS`='$tcomments' where `BOOKING`='$tno'";
$q_result = mysql_query($query,$this->conn) or die(mysql_error());
if($q_result)
{
$response = "updated";
}
else
{
$response = "error";
}
}
else
{
$response = "error";
}
}
return $response;
}
Question is that, this code is working just fine in IE8 that I am using, but it is not working in FF 3.6.3. I have checked everything. One thing is that the code works fine on FF too only when I debug the page with firebug debugger. Otherwise the alert in ajax success shows itself with nothing in it.
To see for yourself:
- Go to this link
- Enter 6628 in the Ticket No. box under Update Complaint Status section...
- A new form will open. In that form press update.
- IE8 shows the results as needed but FF does not.