javascript - Problems with getting data via ajax from mysql db -


im opening inappbrowser window payment service. after payment done , sucessfull entries in db updated.

user table - rows like

id - username - vipstatus - callstatus 

the vipstatus , callstatus gets changed "1" after payment.when inappbrowser closed want new data vipstatus , callstatus user , overwrite existing localstorage items callstatus , vip status. username saved in localstorage username. im guessing ajaxcode wrong, because dont work, dont load script.

my ajax code

$(document).ready( function() {                   $("#paybutton").click(function() {                                         var params = "projectpaymentoption=1195&id=",                                         usernamepay = window.localstorage.getitem("username"),                                         paymenturl = params + usernamepay;                                          $.ajax({                                                type: 'post',                                                url: 'http://www..de/phone/encode.php',                                                data: $.param({"paymenturl": paymenturl}),                                                success: function(result) {                                                var paybrowser = window.open(result,'_blank','location=no','closebuttoncaption=zurück');                                                 paybrowser.addeventlistener('exit',function(event) {                                                  $.ajax({                                                type: 'post',                                                url: 'http://www..de/update.php',                                                data: $.param({"username": username}),                                                success: function(data) {                                                window.localstorage.setitem("vipstatus", data[2]);                                                window.localstorage.setitem("callstatus",data[3]);                                       }                          });                   } 

my update.php code

<?php      $dbhost = "blabla";   $dbuser = "blabla";   $dbpass = "blabla";   $dbname = "blabla";   $tablename = "user";     print_r($_post);   $user = $_post['data']['username'];   print php_eol . $user . php_eol;    $con = mysqli_connect($dbhost,$dbuser,$dbpass);   $dbs = mysqli_select_db($dbname, $con);   $result = mysqli_query("select user$ $tablename");            $array = mysqli_fetch_row($result);              $conn->close();   ?> 

your javascript code not valid javascript. misses closing brackets. try this:

$(document).ready(function() {     $("#paybutton").click(function() {         var params = "projectpaymentoption=1195&id=",             usernamepay = window.localstorage.getitem("username"),             paymenturl = params + usernamepay;          $.ajax({             type: 'post',             url: 'http://www..de/phone/encode.php',             data: $.param({                 "paymenturl": paymenturl             }),             success: function(result) {                 var paybrowser = window.open(result, '_blank', 'location=no', 'closebuttoncaption=zurück');                  paybrowser.addeventlistener('exit', function(event) {                      $.ajax({                         type: 'post',                         url: 'http://www..de/update.php',                         data: $.param({                             "username": username                         }),                         success: function(data) {                             window.localstorage.setitem("vipstatus", data[2]);                             window.localstorage.setitem("callstatus", data[3]);                         }                     });                 });             }         });     }); }); 

Comments

Popular posts from this blog

android - Pass an Serializable object in AIDL -

How to provide Authorization & Authentication using Asp.net, C#? -

How to use Authorization & Authentication in Asp.net, C#? -