php - data not save to mySQL Hosted DB -

-

i want save data android app mysql database in server. make code php.. when run php file data saved db.. run form android application. data not save db.

save code in android 

 public void loadsave() {               string mydataurl = "http://xxxxxxxxxx/savedata.php";           //string type = params[0];          try {          string longi = "aaa"; // double.tostring(location.getlongitude());         string lati = "aare";//double.tostring(location.getlatitude());         string user = "a";         string lisence = "b";         string date = "c";         url url = new url(mydataurl);         httpurlconnection httpurlconnection = (httpurlconnection) url.openconnection();         httpurlconnection.setrequestmethod("post");         httpurlconnection.setdooutput(true);         httpurlconnection.setdoinput(true);         outputstream outputstream = httpurlconnection.getoutputstream();         bufferedwriter bufferedwriter = new bufferedwriter(new outputstreamwriter(outputstream, "utf-8"));         string post_data = urlencoder.encode("longi", "utf-8") + "=" + urlencoder.encode(longi, "utf-8") + "&" +                 urlencoder.encode("lati", "utf-8") + "=" + urlencoder.encode(lati, "utf-8") + "&" +                 urlencoder.encode("user", "utf-8") + "=" + urlencoder.encode(user, "utf-8") + "&" +                 urlencoder.encode("lisence", "utf-8") + "=" + urlencoder.encode(lisence, "utf-8") + "&" +                 urlencoder.encode("date", "utf-8") + "=" + urlencoder.encode(date, "utf-8");         bufferedwriter.write(mydataurl);         bufferedwriter.flush();         bufferedwriter.close();         outputstream.close();                 } catch (malformedinputexception e) {         e.printstacktrace();     } catch (ioexception ex) {         ex.printstacktrace();     }  }

php code

require "db_connection.php";  $longi =$_post["longi"]; $lati = $_post["lati"]; $user = $_post["user"]; $lisence =$_post["lisence"]; $date = $_post["date"];  $query1="insert mapdata (longi,lati,user,lisence,date)    values ('".$longi."','".$lati."','".$user."','".$lisence."', '".$date."' )";  mysql_query($query1) or die ('error :' . mysql_error());

calling loadsave()

    new asynctask<void, void, void>() {          @override         protected void doinbackground(final void... params) {             loadsave();             return null;         }     }.execute();


Comments

Post a Comment

Popular posts from this blog

python - Consider setting $PYTHONHOME to <prefix>[:<exec_prefix>] error -

-
Image
i getting same error when python manage.py runserver. there no such error when have ubuntu 15.10. got started when upgraded ubuntu 16.04. question might duplicate have tried solution provided question have applied command dpkg --configure -a, have done apt-get update,upgrade,dist-upgrade, clean, -f install. have reinstalled python2.7 , python3 no success though. here screenshot while trying run django application i got after re-installing python please me? bashrc file # ~/.bashrc: executed bash(1) non-login shells. # see /usr/share/doc/bash/examples/startup-files (in package bash-doc) # examples # if not running interactively, don't case $- in *i*) ;; *) return;; esac export pythonhome="/usr/bin/python" echo $virtualenvwrapper_python echo 'tushant' # don't put duplicate lines or lines starting space in history. # see bash(1) more options histcontrol=ignoreboth # append history file, don't overwrite shopt -s histappend # setting h...
Read more

php - Prepared Statement Inner Join Cannot Pass Parameter by Reference -

-
i've been trying figure out while , i've searched similar problems, can't find solution. i'm working on game setup application , i'm having issue prepared statement. if ($stmt = $connection->prepare("select pack.id, count(race.name) pack inner join race on pack.id = race.pack pack.id = ? group race.pack")) { $stmt->bind_param("s", $_session["id"]); $stmt->execute(); $stmt->bind_result($rsltid, rsltraces); while ($stmt->fetch()) { $racespack[$rsltid] = $rsltraces; } $stmt->close(); } this returns error: "fatal error: cannot pass parameter 2 reference". any help/advice appreciated! your $stmt->bind_result($rsltid, rsltraces); wrong. should $stmt->bind_result($rsltid, $rsltraces);
Read more

c# - Value cannot be null or empty.\r\nParameter name: name -

-
Image
when go cshtml page error occur: an exception of type 'system.argumentexception' occurred in system.web.mvc.dll not handled in user code in cshtml code : <div class="form-group"> @html.label("model", new { @class = "control-label col-md-4" }) <div class="col-md-8"> @html.editor("model") </div> </div> but on other hand if change code in @html.editor("propertymodel") it working no error occur . update: in model: public class propertyassign { public int propertyassignid { get; set; } public string propertyname { get; set; } public string model { get; set; } public datetime assigndate { get; set; } } in controller: public actionresult create() { return view(); } the reason exception thrown htmlhelpers inspect viewdata values bind to. viewdata typeof viewdatadictionary contains property mod...
Read more