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
Post a Comment