CODEWITHSUNDEEP
phpandroid
Meeh Be- Bear
Meeh Be- Bear

Reputation: 1

Adding information into the database

    private void AddGroupTasks(){
    title1 = tTitle.getText().toString();
    detail1 = tDetail.getText().toString();
    ArrayList<NameValuePair> b = new ArrayList<NameValuePair>();
    Tasks = new ArrayList<String>();

    try{
        HttpClient httpclient = new DefaultHttpClient();
        HttpPost httppost = new HttpPost ("http://203.209.111.88/AddGroupTasks.php");
        httppost.setEntity(new UrlEncodedFormEntity(b));
        HttpResponse response = httpclient.execute(httppost);
        HttpEntity entity = response.getEntity();
        is = entity.getContent();

        BufferedReader reader = new BufferedReader(new InputStreamReader(is,"iso-8859-1"),8);
        StringBuilder sb = new StringBuilder();
        String line=null;

        while ((line = reader.readLine()) != null) {
            sb.append(line + "\n");
        }

So, When I click add,the information is supposed to be added to database. However, it gives a null value. By the way, I'm writing a to-do list app. 

$Title = $_REQUEST['tTitle'];
$Detail = $_REQUEST['tDetail'];
$Group  = $_REQUEST['spin'];
$DueDate = $_REQUEST['tDueDate'];

$Title  = "'".$Title."'";  
$Detail = "'".$Detail."'";
$Group = "'".$Group."'";
$DueDate    = "'".$DueDate."'";
print $Title;

$database = "CloudList";

mysql_connect("localhost","root","1234");

mysql_select_db($database) or die("Unable to select database");

$q = "INSERT INTO message(group_name,message_title,message_details,message_due) VALUES($Group,$Title,$Detail,$DueDate)";
$result = mysql_query($q);
print $q;

mysql_close();

Here, This is my PHP Script.

Upvotes: 0

Views: 79

Answers (2)

fa1c0n
fa1c0n

Reputation: 1

Try to set quotes in your Values section. It should look like: 

$q = "INSERT INTO message(group_name,message_title,message_details,message_due) VALUES('$Group','$Title','$Detail','$DueDate')";

Upvotes: 0

user370305
user370305

Reputation: 109237

Try this code, replace with your code and let me know what happen,

private void AddGroupTasks(){
title1 = tTitle.getText().toString();
detail1 = tDetail.getText().toString();
ArrayList<NameValuePair> b = new ArrayList<NameValuePair>();
Tasks = new ArrayList<String>();

try{
    HttpClient httpclient = new DefaultHttpClient();
    HttpPost httppost = new HttpPost ("http://203.209.111.88/AddGroupTasks.php");
    b.add(new BasicNameValuePair("tTitle",
                "anyTitle"));
    b.add(new BasicNameValuePair("tDetail",
                "anyDetail"));
    b.add(new BasicNameValuePair("spin",
                "AnythingaboutSpin"));
    b.add(new BasicNameValuePair("tDueDate",
                "anytDueDate"));
    httppost.addHeader("Content-Type", "application/x-www-form-urlencoded");
    httppost.setEntity(new UrlEncodedFormEntity(b, HTTP.UTF_8));

    HttpResponse response = httpclient.execute(httppost);
    HttpEntity entity = response.getEntity();
    is = entity.getContent();

    BufferedReader reader = new BufferedReader(new InputStreamReader(is,"iso-8859-1"),8);
    StringBuilder sb = new StringBuilder();
    String line=null;

    while ((line = reader.readLine()) != null) {
        sb.append(line + "\n");
    }

Upvotes: 2

Related Questions