java - Storing android checkbox state in SQL database -


i creating app allow users register names, ages, etc. storing of information in user class, looks this.

public class user {  string name, username, password, phonenumber; int age;  //constructor public user(string _name, string _username, string _password, string _phonenumber, int _age){     name = _name;     username = _username;     password = _password;     phonenumber = _phonenumber;     age = _age; } } 

i sending data php script store in sql database. code follows:

protected void doinbackground(void... params) {             arraylist<namevaluepair> datatosend = new arraylist<>();             datatosend.add(new basicnamevaluepair("name", user.name));             datatosend.add(new basicnamevaluepair("age", user.age + ""));             datatosend.add(new basicnamevaluepair("username", user.username));             datatosend.add(new basicnamevaluepair("password", user.password));             datatosend.add(new basicnamevaluepair("phonenumber", user.phonenumber));          httpparams httprequestparams = new basichttpparams();         httpconnectionparams.setconnectiontimeout(httprequestparams, connection_timeout);         httpconnectionparams.setsotimeout(httprequestparams, connection_timeout);          httpclient client = new defaulthttpclient(httprequestparams);         httppost post = new httppost(server_address + "register.php");          try{             post.setentity(new urlencodedformentity(datatosend));             client.execute(post);         }catch(exception e){             e.printstacktrace();         }         return null;     } 

now want create 10 checkboxes state (checked vs unchecked) can store. know create bunch of boolean values part of user class, seems cumbersome , bad practice. question is, therefore, how best store checkbox data in sql database?

for reference, php script follows:

<?php $con = mysqli_connect("localhost", "root", "", "is_clients");  $name = $_post["name"]; $age = $_post["age"]; $username = $_post["username"]; $password = $_post["password"]; $phonenumber = $_post["phonenumber"];  $statement = mysqli_prepare($con, "insert user (name, age, username, password, phonenumber) values (?, ?, ?, ?, ?) ");  mysqli_stmt_bind_param($statement, "sisss", $name, $age, $username, $password, $phonenumber); mysqli_stmt_execute($statement);  mysqli_stmt_close($statement);  mysqli_close($con);  ?> 

you pass array php, each element in array can check box value. in php can using variable brackets checkboxesarr[] can use same variable, , every occurrence element in array.

so, in java (checkboxxxxvalue can binary or boolean):

datatosend.add(new basicnamevaluepair("checkboxarr[]", checkboxonevalue)); datatosend.add(new basicnamevaluepair("checkboxarr[]", checkboxtwovalue)); datatosend.add(new basicnamevaluepair("checkboxarr[]", checkboxthreevalue)); 

php:

$checkboxarr = $_post['checkboxarr']; print_r($checkboxarr); 

is wanted?


Comments

Popular posts from this blog

toolbar - How to add link to user registration inside toobar in admin joomla 3 custom component -

linux - disk space limitation when creating war file -

How to provide Authorization & Authentication using Asp.net, C#? -