php - How to add points for users of my app and connect it to android? -
i have started working on 1 project, i'm stucked here need add points every users have stored in database. have created 1 database i'm storing username , password user , connected android. working, in case store points users when solved example in app, don't know how write methods , need little in php that.
these php files: register.php
<?php $con=mysqli_connect("localhost", "root", "", "geomondo"); $username = $_post["username"]; $password = $_post["password"]; //$username = "admin"; //$password = "admin"; $statement = mysqli_prepare($con, "insert user (username, password) values (?, ?)"); mysqli_stmt_bind_param($statement, "ss", $username, $password); mysqli_stmt_execute($statement); mysqli_stmt_close($statement); mysqli_close($con); ?>
and 1 more: fetchuserdata.php
<?php $con=mysqli_connect("localhost", "root", "", "geomondo"); $username = $_post["username"]; $password = $_post["password"]; //$username = "test"; //$password = "test"; $statement = mysqli_prepare($con, "select * user username = ? , password = ?"); mysqli_stmt_bind_param($statement, "ss", $username, $password); mysqli_stmt_execute($statement); mysqli_stmt_store_result($statement); mysqli_stmt_bind_result($statement, $userid, $username, $password); $user = array(); while(mysqli_stmt_fetch($statement)){ $user["username"] = $username; $user["password"] = $password; } echo json_encode($user); mysqli_close($con); ?>
so how include here points every user?
this java file connecting android php , mysql:
public class serverrequests { progressdialog progressdialog; public static final int connection_timeout = 1000 * 15; public static final string server_adress = "http://192.168.0.17:8081/project/"; public serverrequests(context context){ progressdialog = new progressdialog(context); progressdialog.setcancelable(false); progressdialog.settitle(r.string.progress_dialog); progressdialog.setmessage("please wait..."); } public void storeuserdatainbackground(user user, getusercallback usercallback){ progressdialog.show(); new storeuserdataasynctask(user, usercallback).execute(); } public void fetchuserdatainbackground(user user, getusercallback callback){ progressdialog.show(); new fetchuserdataasynctask(user, callback).execute(); } public class storeuserdataasynctask extends asynctask<void, void, void>{ user user; getusercallback usercallback; public storeuserdataasynctask(user user, getusercallback usercallback){ this.user = user; this.usercallback = usercallback; } @override protected void doinbackground(void... params) { arraylist<namevaluepair> datatosend = new arraylist<>(); datatosend.add(new basicnamevaluepair("username", user.username)); datatosend.add(new basicnamevaluepair("password", user.password)); httpparams httprequestparams = new basichttpparams(); httpconnectionparams.setconnectiontimeout(httprequestparams, connection_timeout); httpconnectionparams.setsotimeout(httprequestparams, connection_timeout); httpclient client = new defaulthttpclient(httprequestparams); httppost post = new httppost(server_adress + "register.php"); try { post.setentity(new urlencodedformentity(datatosend)); client.execute(post); }catch (exception e){ e.printstacktrace(); } return null; } @override protected void onpostexecute(void avoid) { progressdialog.dismiss(); usercallback.done(null); super.onpostexecute(avoid); } } public class fetchuserdataasynctask extends asynctask<void, void, user> { user user; getusercallback usercallback; public fetchuserdataasynctask(user user, getusercallback usercallback) { this.user = user; this.usercallback = usercallback; } @override protected user doinbackground(void... params) { arraylist<namevaluepair> datatosend = new arraylist<>(); datatosend.add(new basicnamevaluepair("username", user.username)); datatosend.add(new basicnamevaluepair("password", user.password)); httpparams httprequestparams = new basichttpparams(); httpconnectionparams.setconnectiontimeout(httprequestparams, connection_timeout); httpconnectionparams.setsotimeout(httprequestparams, connection_timeout); httpclient client = new defaulthttpclient(httprequestparams); httppost post = new httppost(server_adress + "fetchuserdata.php"); user returneduser = null; try { post.setentity(new urlencodedformentity(datatosend)); httpresponse httpresponse = client.execute(post); httpentity entity = httpresponse.getentity(); string result = entityutils.tostring(entity); jsonobject jobject = new jsonobject(result); if (jobject.length() == 0) { returneduser = null; } else { returneduser = new user(user.username, user.password); } }catch (exception e){ e.printstacktrace(); } return returneduser; } @override protected void onpostexecute(user returneduser) { progressdialog.dismiss(); usercallback.done(returneduser); super.onpostexecute(returneduser); } } }
this first time connecting android online database , i'm still learning android developing, appricieate here. :)
your question shows have problems basic terms. study it. when have created account, (incidentally database best not store password hash) same may log: sending username , password. if exists in database create session in php.
//here looking user in database. not know how work mysqli session_start(); $_session['name'] = $login;
(better use id store user's session)
now able determine user's request arrived (via sessions)
if ($_session['name'] != '')
and add data table.
id | login | score
this simplest solution. luck.
Comments
Post a Comment