mohsinuddin94
New Member
I am developing an android application where a user can purchase books from a list and pay using PayPal Sandbox test accounts.So far, everything seems to work pretty well and I can complete the whole transaction i.e. from browsing the list to check out and paypal payments.The only issue I am having here is that my Sales is not being recorded onto Sales Table in my remote sql database.I have three tables on remote SQL database and they are as follows
1) users - record new account details and check existing user for login purposes(2) books - fetching list of books and other details (works as catalogue)(3) sales - records a new transaction made by a userWell, users and books tables are working fine as my app uses them in right manner, however the only problem seems to be with sales table or sales.php API.JAVA CODE FOR POSTING SALES PARAMETERS TO SALES.PHP API IS AS FOLLOWS:\[code\]private void fillCartList(boolean boo){ // to delete the contents of the cartlists this.deleteCartLists(); TOTAL_QTY = 0; TOTAL_GBP = 0; int price, qty; // if is not 0, first will parse all the rows to arraylists from sqlite stored on the phone Cursor cursor = db.getJoinedTables(); if(cursor != null && cursor.getCount()!=0){ cursor.moveToFirst(); while(!cursor.isAfterLast()){ if(boo == false){ price = Integer.valueOf(cursor.getString(cursor.getColumnIndex(justdealsDatabase.KEY_BPRICE)).replace("
1) users - record new account details and check existing user for login purposes(2) books - fetching list of books and other details (works as catalogue)(3) sales - records a new transaction made by a userWell, users and books tables are working fine as my app uses them in right manner, however the only problem seems to be with sales table or sales.php API.JAVA CODE FOR POSTING SALES PARAMETERS TO SALES.PHP API IS AS FOLLOWS:\[code\]private void fillCartList(boolean boo){ // to delete the contents of the cartlists this.deleteCartLists(); TOTAL_QTY = 0; TOTAL_GBP = 0; int price, qty; // if is not 0, first will parse all the rows to arraylists from sqlite stored on the phone Cursor cursor = db.getJoinedTables(); if(cursor != null && cursor.getCount()!=0){ cursor.moveToFirst(); while(!cursor.isAfterLast()){ if(boo == false){ price = Integer.valueOf(cursor.getString(cursor.getColumnIndex(justdealsDatabase.KEY_BPRICE)).replace("