doufuhuang6981 2019-02-21 02:36
浏览 37

如何使用php将适配器上的字符串解析为数据库

Hi i am new on here i got some stuck in my android programming which i can't insert data from shopping cart list to database using php.

pro.php

<?php require_once 'connect1.php'; if ($_SERVER['REQUEST_METHOD'] =='POST'){

$products = $_POST['products'];

$decoded = json_decode($products, true);

for($i = 0; $i < sizeof($decoded); $i = $i + 1) {
    $sql = "INSERT INTO product_table (product, price) VALUES (\"".$decoded[$i]['product']."\", ".$decoded[$i]['price'] .")";
    if ( mysqli_query($conn, $sql) ) {
        $result["success"] = "1";
        $result["message"] = "success";
    } else {

        $result["success"] = "0";
        $result["message"] = mysqli_error($conn);
        break;
    }

    mysqli_close($conn);
}

echo json_encode($result);}?>

my json : krnjfrag.class

private void placeorder() {
    final ProgressDialog pDial = new ProgressDialog(getActivity());
    pDial.setMessage("Loading...");
    pDial.show();

    Map<String,String> params = new HashMap<>();
    params.put("product", String.valueOf(title));
    params.put("price", String.valueOf(price));

    JSONObject parameters = new JSONObject();
    JSONArray products = new JSONArray();
    for(Product p:example){
        JSONObject prod = new JSONObject();
        try {
            prod.put("product",p.getTitle());
            prod.put("price",p.getPrice());
            products.put(prod);
            parameters.put("products",products);
        } catch (JSONException e) {
            e.printStackTrace();
        }
    }

   JsonObjectRequest keranjang = new JsonObjectRequest(Request.Method.POST,URL_pesan,parameters,  new Response.Listener<JSONObject>() {
        @Override
        public void onResponse(JSONObject response)
        {
            System.out.println();
            try{
                String success = response.getString("success");
                    /*Intent intent = new Intent(getActivity(),CheckfinalActivity.class);
                    intent.putExtra("product", title);
                    intent.putExtra("price",price);
                    startActivity(intent);
                    String title = response.getString("product");
                    String price = response.getString("price");*/
                Toast.makeText(getActivity(), "Tersimpan", Toast.LENGTH_SHORT).show();
                madapter.notifyDataSetChanged();
                pDial.dismiss();
                    /*Product product = new Product();
                    product.setTitle(jsonObject.getString("product"));
                    product.setPrice(jsonObject.getDouble("price"));
                    example.add(product);
                    total.setText((int) jsonObject.getDouble("total"));*/
            } catch (JSONException e) {
                e.printStackTrace();
                Toast.makeText(getActivity(), "Gagal", Toast.LENGTH_SHORT).show();
            }
        }
   },new Response.ErrorListener() {
       @Override
       public void onErrorResponse(VolleyError error) {
           error.printStackTrace();
           Toast.makeText(getActivity(), "Tidak dapat menyimpan", Toast.LENGTH_SHORT).show();
           pDial.dismiss();
       }
   });
    Volley.newRequestQueue(getActivity()).add(keranjang);

}

i just want data that got on recyclerview can be inserted to database, so if i open on admin side i can know user wanna buy which one.

i always got error on parse error

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 ETLCloud 处理json多层级问题
    • ¥15 matlab中使用gurobi时报错
    • ¥15 这个主板怎么能扩出一两个sata口
    • ¥15 不是,这到底错哪儿了😭
    • ¥15 2020长安杯与连接网探
    • ¥15 关于#matlab#的问题:在模糊控制器中选出线路信息,在simulink中根据线路信息生成速度时间目标曲线(初速度为20m/s,15秒后减为0的速度时间图像)我想问线路信息是什么
    • ¥15 banner广告展示设置多少时间不怎么会消耗用户价值
    • ¥15 可见光定位matlab仿真
    • ¥15 arduino 四自由度机械臂
    • ¥15 wordpress 产品图片 GIF 没法显示