dprlv04662 2013-11-07 20:50
浏览 21

通过PHP写入数据库 - MySQL - Android

I want to write into my database which is located on my server. Select-Statements work totally fine, but I want to create a new entry in the table. I use the INSERT for this and did it this way:

Java Code (of App/Client):

        //the year data to send
    ArrayList<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>();
    nameValuePairs.add(new BasicNameValuePair("id", idNumber.getText().toString()));
    nameValuePairs.add(new BasicNameValuePair("name", nameText.getText().toString()));

    //http post
    try{
            HttpClient httpclient = new DefaultHttpClient();
            HttpPost httppost = new HttpPost("http://olli130.myds.me/sqlcreate.php");
            httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs));
            HttpResponse response = httpclient.execute(httppost);
            HttpEntity entity = response.getEntity();
            is = entity.getContent();

            Log.i("Sent to Server", "name: " + nameText.getText().toString() + ", id: " + idNumber.getText().toString());
    }catch(Exception e){
            Log.e("log_tag", "Error in http connection "+e.toString());
    }

}

And the PHP Code:

<?php
include 'sqlcon.php';

    $connection=mysql_connect($mysqlhost, $mysqluser, $mysqlpwd) or die
    ("Verbindungsversuch fehlgeschlagen");

    mysql_select_db($mysqldb, $connection) or die("Konnte die Datenbank nicht
    waehlen.");

     $sql = "INSERT INTO Testtable (id, descr)
     VALUES (".$_REQUEST['id']", '".$_REQUEST['name']"')";

     mysql_query($sql) or die (mysql_error());
     mysql_close($connection);
    ?>

Am i doing something badly wrong? Why is it not working?

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥20 软件测试决策法疑问求解答
    • ¥15 win11 23H2删除推荐的项目,支持注册表等
    • ¥15 matlab 用yalmip搭建模型,cplex求解,线性化处理的方法
    • ¥15 qt6.6.3 基于百度云的语音识别 不会改
    • ¥15 关于#目标检测#的问题:大概就是类似后台自动检测某下架商品的库存,在他监测到该商品上架并且可以购买的瞬间点击立即购买下单
    • ¥15 神经网络怎么把隐含层变量融合到损失函数中?
    • ¥15 lingo18勾选global solver求解使用的算法
    • ¥15 全部备份安卓app数据包括密码,可以复制到另一手机上运行
    • ¥20 测距传感器数据手册i2c
    • ¥15 RPA正常跑,cmd输入cookies跑不出来