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
Post a Comment