the following code working on localhost after hosting website. not returning accurate value. if use alert return default value on post code. value returned. instance:
$.post('sendingoffer.php',{id:id},function(data){ if(data=="true"){ currentbtn.html('<b>offer send</b>').css('background','#dce6f1'); currentbtn.html('<b>offer send</b>').css('outline','1px solid #dce6f1'); currentbtn.html('<b>offer send</b>').css('border','1px solid white'); currentbtn.html('<b>offer send</b>').css('mouse','cursor'); currentbtn.attr("disabled","disabled"); currentbtn.removeattr("href"); }else if(data=="false"){ alert('you have reached maximum number of 5 offers can send today'); }else if(data=="not null"){ alert("offer sent"); }else if(data=="assigned"){ alert('this job assigned person'); }else{ alert(data);// value returned } }); this jquery code:
$('.buyerrequest').click(function(){ var currentbtn=$(this); var id=$(this).attr('id').replace('id_',''); $.post('sendingoffer.php',{id:id},function(data){ if(data=="true"){ currentbtn.html('<b>offer send</b>').css('background','#dce6f1'); currentbtn.html('<b>offer send</b>').css('outline','1px solid #dce6f1'); currentbtn.html('<b>offer send</b>').css('border','1px solid white'); currentbtn.html('<b>offer send</b>').css('mouse','cursor'); currentbtn.attr("disabled","disabled"); currentbtn.removeattr("href"); }else if(data=="false"){ alert('you have reached maximum number of 5 offers can send today'); }else if(data=="not null"){ alert("offer sent"); }else if(data=="assigned"){ alert('this job assigned person'); } }); }); this php code
<?php require'set_session.php'; require'../../../php/connection.php'; $buyer_id=''; $order_id=''; $buyer_name=''; $user_name=getuserfield('user_name'); if(isset($_post['id'])){ $order_id=$_post['id']; $query="select `account_id` `place_order` `order_id`='$order_id'"; $query_run=mysql_query($query); while($row=mysql_fetch_array($query_run)){ $buyer_id=$row['account_id']; } } $query="select `inbox_id` `inbox` `seller_name`='$user_name' , `date` ='".date("y-m-d")."'"; $query_run=mysql_query($query); $query_num=mysql_num_rows($query_run); $queryexst="select `inbox_id` `inbox` `seller_name`='$user_name' , `order_id`='$order_id'"; $query_rune=mysql_query($queryexst); $query_nume=mysql_num_rows($query_rune); $queryid="select `inbox_id` `inbox` `order_id`='$order_id' , `buyer_name` != ''"; $query_runid=mysql_query($queryid); $query_numid=mysql_num_rows($query_runid); if($query_num < 5){ if($query_nume==0){ if($query_numid == 0){ $query="insert `inbox` values('','$buyer_id','$order_id','".date("y-m-d")."','$user_name','','unread','unread','')"; $query_run=mysql_query($query); echo'true'; }else{ echo'assigned'; } }else{ echo'not null'; } }else{ echo'false'; } ?>
Comments
Post a Comment