Inserting Data Into Mysql Database

Question

im having the following code:

private void setCounter(String counter,String stName){


        HttpClient httpclient = new DefaultHttpClient();
        HttpPost httppost = new HttpPost("XXX");


        try{
            ArrayList<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>();
            nameValuePairs.add(new BasicNameValuePair("vCounter",counter));
            nameValuePairs.add(new BasicNameValuePair("StName",stName));

           httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs));
           HttpResponse response = httpclient.execute(httppost);

        }catch(Exception e){
            Log.e("log_tag", "Error in http connection "+e.toString());
        }
    }


class setCountertoDB extends AsyncTask<Void, Void, Boolean> {//kept


        @Override
        protected Boolean doInBackground(Void... params) {

            setCounter(StringCounter,streetName);
            return null;
        }
    }

PHP file:

<?php 
$con = mysql_connect("XXX","XXX","XXX");
if (!$con)
    {
    die('Could not Connect:'. mysql_error());
    }
mysql_select_db("a6241050_Stpeeds",$con);


mysql_query ("INSERT INTO DBNAME (vCounter) VALUES('".$_REQUEST['vCounter']."') WHERE StName='".$_REQUEST['StName']."'");

mysql_close($con);
?>

the application is running well and there's no error in the logcat, but when i check the database there's no data inserted, please help with that, knowing that i used almost the same code to select values from database and it worked, but it's not working with the insert !

As you can read in the docu, MySQL doesn't allow WHERE in an INSERT - what are you trying to do with that anyway? (You'd have known if you had an error check like mysql_query("...") or die(mysql_error());) — kero
– kero, Commented Dec 8, 2013 at 20:59
@kingkero thanks alot, yea the where is not allowed in insert, sorry for that, i'll just try to use the update instead :) — Izzo32
– Izzo32, Commented Dec 8, 2013 at 21:03

seven7 · Accepted Answer · 2013-12-08 21:02:39Z

3

hI if you have to make a new entry can not use the WHERE:

  mysql_query ("INSERT INTO DBNAME (vCounter) VALUES('".$_REQUEST['vCounter']."'));

answered Dec 8, 2013 at 21:02

seven7

664 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

akki · Accepted Answer · 2013-12-08 21:16:03Z

1

Try

mysql_query ("UPDATE table_name SET vcounter='".$_REQUEST['vcounter']."'WHERE StName='".$_REQUEST['StName']."'");

This should do the job.

answered Dec 8, 2013 at 21:16

akki

2,3422 gold badges26 silver badges39 bronze badges

2 Comments

Izzo32 Over a year ago

i just did so and it's work out like a charm :), thank alot :)

akki Over a year ago

@Izzo32 happy to know that I could help.

Collectives™ on Stack Overflow

Inserting Data Into Mysql Database

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related