php - Android App not syncing with database -


the andriod app i'm developing using http gets/posts using php files on website perform transactions on mysql database.

on php side, wrap data json parse on java end of app when receiving response. modified 1 of tables , eliminated unnecessary values table. when poll using php scripts website, polls correctly. when use app, uses same php script polling, returns additional values removed database.

i've restarted eclipse, cleaned project, , restarted android vdm refresh it; however, continues find values removed. ideas going on?

here php script i'm connecting app:

<?php mysql_connect("localhost", "******", "******"); mysql_select_db("bouncet2_pogoapp"); $query = "select * event_table order event asc"; $sql = mysql_query($query); while($row=mysql_fetch_assoc($sql)) $output[]=$row; print(json_encode($output)); mysql_close(); ?>

as code in app using script:

try { string response = customhttpclient.executehttpget("http://www.*****.com/****/****/***/getevents.php"); //system.out.println(response); try { eventarray = new jsonarray(response); //log.i(selecteventactivity.class.getname(), "number of entries " + eventarray.length()); m_adapterforspinner = new arrayadapter<string>(this, android.r.layout.simple_spinner_item); m_adapterforspinner.setdropdownviewresource(android.r.layout.simple_spinner_dropdown_item); event_spinner.setadapter(m_adapterforspinner); (int = 0; < eventarray.length(); i++) { jsonobject jsonobject = eventarray.getjsonobject(i); m_adapterforspinner.add(jsonobject.getstring("event")); //log.i(addjumpersactivity.class.getname(), jsonobject.getstring("event")); } } catch (exception e) { e.printstacktrace(); } } catch (exception e) { e.printstacktrace(); }

the function executehttpget(url) part of class customhttpclient , follows:

public static string executehttpget(string url) throws exception { stringbuilder builder = new stringbuilder(); httpclient client = gethttpclient(); httpget request = new httpget(); request.seturi(new uri(url)); try { httpresponse response = client.execute(request); statusline statusline = response.getstatusline(); int statuscode = statusline.getstatuscode(); if (statuscode == 200) { log.i(customhttpclient.class.tostring(), "system status ok"); httpentity entity = response.getentity(); inputstream content = entity.getcontent(); bufferedreader reader = new bufferedreader(new inputstreamreader(content)); string line; while ((line = reader.readline()) != null) { builder.append(line); } } else { log.e(customhttpclient.class.tostring(), "failed download file"); } } catch (clientprotocolexception e) { e.printstacktrace(); } catch (ioexception e) { e.printstacktrace(); } return builder.tostring(); }

it looks response getting cached somewhere, ether in cache server between phone , server, or in phone itself.

if cache happening outside phone, adding appropriate headers disable caching trick. added headers of response server. there several ways this, think should work...

header("expires: tue, 03 jul 2001 06:00:00 gmt");

on phone side, depending on http client gethttpclient, client has caching turned on. in ice cream sandwich, google added caching httpurlconnection http client. caching has turned on according docs, many people seem have issues cache being on when unaware. i'm not familiar interworkings of various http clients on android, should start...

http://developer.android.com/reference/java/net/httpurlconnection.html

a quick , dirty check see if caching response add random, unused param url when calling server, like...

url += "?unused=" + uuid.randomuuid();

with in place, should not cached anywhere, can @ least determine if caching issue or else, , go there.


Comments

Post a Comment

Popular posts from this blog

javascript - backbone.js Collection.add() doesn't `construct` (`initialize`) an object -

<!doctype html public "-//w3c//dtd xhtml 1.0 strict//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-strict.dtd"> <html> <head> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script> <script src="http://documentcloud.github.com/underscore/underscore-min.js"></script> <script src="http://documentcloud.github.com/backbone/backbone-min.js"></script> </head> <body> <button id="cmd_create_event" name="cmd_create_event" type="button">create new `event`</button> <script type="text/javascript"> var eventmodel = backbone.model.extend({ initialize : function() { console.log("`event` initialized. id: " + this.cid); this.bind("change:status", function() { console.log(this.get("status") + " value `status`"); }); this.bind("error", function(model, e...
Read more

php - Get uncommon values from two or more arrays -

is there function in php give array of uncommon values 2 or more arrays? for example: $array1 = array( "green", "red", "blue"); $array2 = array( "green", "yellow", "red"); .... $result = function_needed($array1, $array2,...); print_r($result); should give output: array("blue", "yellow", ...); use array_diff , array_merge : $result = array_merge(array_diff($array1, $array2), array_diff($array2, $array1)); here's demo. for multiple arrays, combine callback , array_reduce : function unique(&$a, $b) { return $a ? array_merge(array_diff($a, $b), array_diff($b, $a)) : $b; } $arrays = array( array('green', 'red', 'blue'), array('green', 'yellow', 'red') ); $result = array_reduce($arrays, 'unique'); and here's demo of that.
Read more

Adding duplicate array rows in Php -

i create function in php adds rows of array shared column value. so input. $test = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); and output. $testduplicatefree = array( array("c", 7, 9), array("test", 5, 6) ) ); i'm thinking function combine_duplicates($array,$col){ ... ... return $duplicatefreearray; } where $col duplicate free array. so, in case, combine_duplicates($test,0); would me desired output. this. <?php function combine_duplicates($array,$col) { $index = array(); foreach ($array $row) { $key = $row[$col]; if (!isset($index[$key])) { $index[$key] = $row; } else { ($i = 0; $i < count($row); ++$i) { if ($i != $col) { $index[$key][$i] += $row[$i]; } } } } return array_values($index); } $array = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); print_r(combine_duplicates($array, 0)); try here: http://codepad.org/mdhesqhi
Read more