Save Feedback Form in Android Apps With PHP MySQL

<?xml version="1.0" encoding="utf-8"?>
<ScrollView xmlns:android="http://schemas.android.com/apk/res/android" android:id="@+id/scrollView1" android:layout_width="fill_parent" android:layout_height="fill_parent" android:background="@drawable/background">
    <LinearLayout android:layout_width="match_parent" android:layout_height="match_parent" android:background="@drawable/background" android:orientation="vertical">
        <TableLayout android:layout_width="match_parent" android:layout_height="wrap_content" android:layout_gravity="left" android:background="#518CA3">
            <TableRow android:id="@+id/tableRow2" android:layout_width="match_parent" android:layout_height="55dp" android:background="#518CA3" android:layout_gravity="left">
            </TableRow>
        </TableLayout>
        <TableLayout android:layout_width="match_parent" android:layout_height="wrap_content" android:layout_gravity="left" android:layout_marginTop="1dp" android:background="#c1c1c1">
            <TableRow android:id="@+id/tableRow1" android:layout_width="310dp" android:layout_height="wrap_content" android:background="#ffffff" android:layout_gravity="left">
                <ImageView android:id="@+id/imageView2" android:layout_width="wrap_content" android:layout_height="wrap_content" android:src="@drawable/feedback1" android:layout_marginTop="5dp" android:layout_marginBottom="2dp" android:layout_marginRight="200dp" />
            </TableRow>
            <TableRow android:id="@+id/tableRow1" android:layout_width="310dp" android:layout_height="wrap_content" android:background="#ffffff" android:layout_gravity="left">
                <ImageView android:id="@+id/imageView2" android:layout_width="wrap_content" android:layout_height="wrap_content" android:src="@drawable/feedback" android:layout_marginTop="6dp" android:layout_marginBottom="2dp" android:layout_marginLeft="1dp" />
            </TableRow>
        </TableLayout>
        <LinearLayout android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="horizontal">
        </LinearLayout>
        <LinearLayout android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="horizontal">
            <EditText android:id="@+id/tvName" android:layout_width="match_parent" android:layout_height="wrap_content" android:layout_alignParentLeft="true" android:layout_alignParentRight="true" android:layout_alignParentTop="true" android:ems="10" android:hint="Your Name?">
                <requestFocus />
            </EditText>
        </LinearLayout>
        <LinearLayout android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="horizontal">
        </LinearLayout>
        <LinearLayout android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="horizontal">
            <EditText android:id="@+id/extEmail" android:layout_width="match_parent" android:layout_height="wrap_content" android:layout_alignParentLeft="true" android:layout_alignParentRight="true" android:layout_alignParentTop="true" android:layout_marginTop="10dp" android:ems="10" android:hint="Your Email?">
            </EditText>
        </LinearLayout>
        <LinearLayout android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="horizontal">
            <EditText android:id="@+id/extContact" android:layout_width="match_parent" android:layout_height="wrap_content" android:layout_alignParentLeft="true" android:layout_alignParentRight="true" android:layout_alignParentTop="true" android:layout_marginTop="13dp" android:ems="10" android:hint="Your Mobile No ?">
            </EditText>
        </LinearLayout>
        <LinearLayout android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="horizontal">
        </LinearLayout>
        <LinearLayout android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="horizontal">
            <EditText android:id="@+id/extMessage" android:layout_width="match_parent" android:layout_height="wrap_content" android:layout_alignParentLeft="true" android:layout_alignParentRight="true" android:layout_alignParentTop="true" android:layout_marginTop="15dp" android:ems="10" android:hint="Your Message">
            </EditText>
        </LinearLayout>
        <LinearLayout android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="horizontal">
        </LinearLayout>
        <LinearLayout android:layout_width="match_parent" android:layout_height="wrap_content" android:orientation="horizontal">
            <TextView android:id="@+id/tvCurrentDate" android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="Curent Date" android:textAppearance="?android:attr/textAppearanceSmall" />
            <TextView android:id="@+id/tvGetID" android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="Get ID Phone" android:textAppearance="?android:attr/textAppearanceSmall" />
        </LinearLayout>
        <LinearLayout android:layout_width="match_parent" android:layout_height="40dp" android:orientation="horizontal" android:layout_marginTop="30dp" android:gravity="center">
        </LinearLayout>
        <LinearLayout android:id="@+id/linearLayout1" android:layout_width="match_parent" android:layout_height="wrap_content" android:layout_alignLeft="@+id/editText1" android:layout_below="@+id/editText1" android:layout_marginBottom="8dp" android:layout_marginTop="8dp" android:orientation="horizontal">
            <Button android:id="@+id/button2" android:layout_width="0dp" android:layout_height="wrap_content" android:layout_weight="1" android:background="@null" android:text="Cancel" android:textColor="#f39c12" />
            <Button android:id="@+id/button1" android:layout_width="0dp" android:layout_height="wrap_content" android:layout_marginRight="10dp" android:layout_weight="0.60" android:text="Submit" android:textColor="#FFF" />
        </LinearLayout>
    </LinearLayout>
</ScrollView>

Second page code

package com.serviceprovider; // its your packeg name
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.List;
import org.apache.http.NameValuePair;
import org.apache.http.message.BasicNameValuePair;
import org.json.JSONArray;
import org.json.JSONException;
import org.json.JSONObject;
import com.serviceprovider.JsonParser;
import com.serviceprovider.SessionManager;
import connectiondetector.Category;
import connectiondetector.ServiceHandler;
import android.app.Activity;
import android.app.ProgressDialog;
import android.content.Context;
import android.content.Intent;
import android.net.ConnectivityManager;
import android.net.NetworkInfo;
import android.os.AsyncTask;
import android.os.Bundle;
import android.provider.Settings.Secure;
import android.util.Log;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.AdapterView;
import android.widget.ArrayAdapter;
import android.widget.Button;
import android.widget.EditText;
import android.widget.ImageView;
import android.widget.Spinner;
import android.widget.TextView;
import android.widget.Toast;
// its make by mukesh kumar
// 12/06/2016
public class Feedback extends Activity
{
    TextView empId, CurrentDateTxt, updateDateTxt, getDeviceidTxt;
    private EditText tvName, extEmail, txtContact, extMessage;
    String tvNameText, extEmailText, txtContactText, extMessageText, CurrentDateText, GetIDText;
    private Button btnAddNewCategory;
    final Context context = this;
    //  private Spinner spinnerFood,spinnerFood2;
    //
    JSONObject jsonObject, data;
    JSONArray dataArray;
    SessionManager session;
    JsonParser jsonParser;
    ArrayList < NameValuePair > postParameters;
    String uId;
    //private ArrayList<Category> categoriesList;
    //
    ProgressDialog pDialog;
    /
    private String URL_NEW_CATEGORY = "http://yourweb site link/ServiceProvider/Service_api/AddFeedback.php";
    @Override
    public void onCreate(Bundle savedInstanceState)
        {
            super.onCreate(savedInstanceState);
            // Get the view from singleitemview.xml
            setContentView(R.layout.feedbackform);
            btnAddNewCategory = (Button) findViewById(R.id.button1);
            CurrentDateTxt = (TextView) findViewById(R.id.tvCurrentDate);
            CurrentDateTxt.setVisibility(View.INVISIBLE);
            getDeviceidTxt = (TextView) findViewById(R.id.tvGetID);
            getDeviceidTxt.setVisibility(View.INVISIBLE);
            tvName = (EditText) findViewById(R.id.tvName);
            //
            extEmail = (EditText) findViewById(R.id.extEmail);
            txtContact = (EditText) findViewById(R.id.extContact);
            extMessage = (EditText) findViewById(R.id.extMessage);
            ///--------------------code show data time in textview---------------------------
            //
            // //Toast.makeText(this, formattedDate, Toast.LENGTH_SHORT).show();
            //
            //
            //
            long date = System.currentTimeMillis();
            //
            SimpleDateFormat sdf = new SimpleDateFormat("dd-MM-yyyy HH:mm:ss a");
            String dateString = sdf.format(date);
            CurrentDateTxt.setText(dateString);
            //
            //
            //--------------------------- get phone id--------------------
            String android_id = Secure.getString(this.getContentResolver(), Secure.ANDROID_ID);
            Log.d("Android", "Android ID : " + android_id);
            getDeviceidTxt.setText(android_id);
            //  // Add new category click event
            btnAddNewCategory.setOnClickListener(new View.OnClickListener()
            {
                //
                @Override
                public void onClick(View v)
                {
                    switch (v.getId())
                    {
                        case R.id.button1:
                            if (isOnline(Feedback.this))
                            {
                                tvNameText = tvName.getText()
                                    .toString();
                                extEmailText = extEmail.getText()
                                    .toString();
                                txtContactText = txtContact.getText()
                                    .toString();
                                extMessageText = extMessage.getText()
                                    .toString();
                                //
                                CurrentDateText = CurrentDateTxt.getText()
                                    .toString();
                                GetIDText = getDeviceidTxt.getText()
                                    .toString();
                                //
                                //
                                //
                                if (tvNameText.trim()
                                    .length() == 0)
                                    Toast.makeText(getApplicationContext(), "Please enter your name ", Toast.LENGTH_SHORT)
                                    .show();
                                else if (extEmailText.trim()
                                    .length() == 0)
                                    Toast.makeText(getApplicationContext(), "Please enter your email", Toast.LENGTH_SHORT)
                                    .show();
                                else if (txtContactText.trim()
                                    .length() == 0)
                                    Toast.makeText(getApplicationContext(), "Please enter your mobile no", Toast.LENGTH_SHORT)
                                    .show();
                                else if (extMessageText.trim()
                                    .length() == 0)
                                    Toast.makeText(getApplicationContext(), "Please enter your message desciption", Toast.LENGTH_SHORT)
                                    .show();
                                //  else if (extcontactText.trim().length() == 0)
                                //  Toast.makeText(getApplicationContext(),"Please enter Your Mobile No", Toast.LENGTH_SHORT).show();
                                //  else if (extcityText.trim().length() == 0)
                                // Toast.makeText(getApplicationContext(),"Please enter Your City", Toast.LENGTH_SHORT).show();
                                else if (!isOnline(Feedback.this))
                                    Toast.makeText(Feedback.this, "Please check your internet connection.", Toast.LENGTH_LONG)
                                    .show();
                                else
                                ////////    // Call Async task to create new category
                                    new AddNewCategory()
                                    .execute(tvNameText, extEmailText, txtContactText, extMessageText, CurrentDateText, GetIDText);
                                tvName.setText("");
                                extEmail.setText("");
                                txtContact.setText("");
                                extMessage.setText("");
                                Toast.makeText(getApplicationContext(), "Sending Successfully", Toast.LENGTH_LONG)
                                    .show();
                                break;
                            }
                            else
                            {
                                // Internet connection is not present
                                Toast.makeText(getApplicationContext(), "Please check your internet connection.", Toast.LENGTH_SHORT)
                                    .show();
                            }
                    }
                }
                //code to check online details
                private boolean isOnline(Context mContext)
                {
                    ConnectivityManager cm = (ConnectivityManager) mContext.getSystemService(Context.CONNECTIVITY_SERVICE);
                    NetworkInfo netInfo = cm.getActiveNetworkInfo();
                    if (netInfo != null && netInfo.isConnectedOrConnecting())
                    {
                        return true;
                    }
                    return false;
                }
                //Close code that check online details
            });
        }
        //  //-------code for Insert in php main-------------
    private class AddNewCategory extends AsyncTask < String, Void, Void >
    {
        boolean isNewCategoryCreated = false;
        //
        @Override
        protected void onPreExecute()
        {
            super.onPreExecute();
            pDialog = new ProgressDialog(Feedback.this);
            pDialog.setMessage("Please Wait..");
            pDialog.setCancelable(false);
            pDialog.show();
        }
        @Override
        protected Void doInBackground(String...arg)
        {
            //-------code for Insert in php 4-------------
            String newName = arg[0];
            String newemail = arg[1];
            String newcontact = arg[2];
            String newmessage = arg[3];
            String newmessagedate = arg[4];
            String newDviceID = arg[5];
            //  // Preparing post params
            List < NameValuePair > params = new ArrayList < NameValuePair > ();
            //table name
            params.add(new BasicNameValuePair("name", newName));
            params.add(new BasicNameValuePair("email", newemail));
            params.add(new BasicNameValuePair("contact", newcontact));
            params.add(new BasicNameValuePair("message", newmessage));
            params.add(new BasicNameValuePair("messagedate", newmessagedate));
            params.add(new BasicNameValuePair("deviceID", newDviceID));
            //  //-------Close-------------
            ServiceHandler serviceClient = new ServiceHandler();
            String json = serviceClient.makeServiceCall(URL_NEW_CATEGORY, ServiceHandler.POST, params);
            Log.d("Create Response: ", "> " + json);
            if (json != null)
            {
                try
                {
                    JSONObject jsonObj = new JSONObject(json);
                    boolean error = jsonObj.getBoolean("error");
                    // checking for error node in json
                    if (!error)
                    {
                        // new category created successfully
                        isNewCategoryCreated = true;
                    }
                    else
                    {
                        Log.e("Create Category Error: ", "> " + jsonObj.getString("message"));
                    }
                }
                catch (JSONException e)
                {
                    e.printStackTrace();
                }
            }
            else
            {
                Log.e("JSON Data", "Didn't receive any data from server!");
            }
            return null;
        }
        //  //-------close-------------
        //
        @Override
        protected void onPostExecute(Void result)
        {
            super.onPostExecute(result);
            if (pDialog.isShowing())
                pDialog.dismiss();
            if (isNewCategoryCreated)
            {
                runOnUiThread(new Runnable()
                {
                    @Override
                    public void run()
                    {}
                });
            }
        }
    }
}

<?php
    /**
    * Database configuration
    */
    define("DB_HOST", "localhost");
    define("DB_USERNAME", "Your user name");
    define("DB_PASSWORD", "your password");
    define("DB_NAME", "your data base name ");
?>

2. file dbConnect.php.

<?php
class DbConnect
{
    private $conn;
    // constructor
    function __construct()
    {
        // connecting to database
        $this->connect();
    }
    // destructor
    function __destruct()
    {
        // closing db connection
        $this->close();
    }
    /**
     * Establishing database connection
     * @return database handler
     */
    function connect()
    {
        include_once dirname(__FILE__) . './Config.php';
        // Connecting to mysql database
        $this->conn = mysql_connect(DB_HOST, DB_USERNAME, DB_PASSWORD) or die(mysql_error());
        // Selecting database
        mysql_select_db(DB_NAME) or die(mysql_error());
        // returing connection resource
        return $this->conn;
    }
    /**
     * Closing database connection
     */
    function close()
    {
        // closing db connection
        mysql_close($this->conn);
    }
}
?>

<?php
include_once './DbConnect.php';
function createNewCategory()
{
    if (isset($_POST['name']) && isset($_POST['email']) && isset($_POST['contact'])) {
        // response array for json
        $response    = array();
        $name        = $_POST["name"];
        $email       = $_POST["email"];
        $contact     = $_POST["contact"];
        $message     = $_POST["message"];
        $messagedate = $_POST["messagedate"];
        $status      = $_POST["status"];
        $deviceID    = $_POST["deviceID"];
        $db          = new DbConnect();
        //mysql_query("SET CHARACTER SET 'utf8'");
        // mysql query
        $query       = "INSERT INTO serviceprovider_feedbackdata(name,email,contact,message,messagedate, status,deviceID)
VALUES('$name', '$email', '$contact', '$message', '$messagedate', 'Active','$deviceID')";
        $result = mysql_query($query) or die(mysql_error());
        if ($result) {
            $response["error"]   = false;
            $response["message"] = "Thank You for Feedback!";
        } else {
            $response["error"]   = true;
            $response["message"] = "Failed To Send Data!";
        }
    } else {
        $response["error"]   = true;
        $response["message"] = "Values name is missing!";
    }
    // echo json response
    echo json_encode($response);
}
createNewCategory(); // its name of java code
?>

create a table in mysql
CREATE TABLE `serviceprovider_feedbackdata` (
    `id`
    int(100) NOT NULL,
    `name`
    varchar(200) COLLATE utf8_swedish_ci NOT NULL,
    `email`
    varchar(200) COLLATE utf8_swedish_ci NOT NULL,
    `contact`
    varchar(20) COLLATE utf8_swedish_ci NOT NULL,
    `message`
    varchar(500) COLLATE utf8_swedish_ci NOT NULL,
    `messagedate`
    varchar(100) COLLATE utf8_swedish_ci NOT NULL,
    `status`
    varchar(100) COLLATE utf8_swedish_ci NOT NULL,
    `deviceID`
    varchar(100) COLLATE utf8_swedish_ci NOT NULL
) ENGINE