php+phpmyadmin+android studio database search 데이터베이스 찾기

php+phpmyadmin+android studio database search 데이터베이스 찾기

간단하게 데이터베이스 찾는 방법

package com.example.myapplication import androidx.appcompat.app.AppCompatActivity import android.os.Bundle import android.widget.Toast import com.android.volley.Response import com.android.volley.toolbox.JsonArrayRequest import com.android.volley.toolbox.JsonObjectRequest import com.android.volley.toolbox.Volley import kotlinx.android.synthetic.main.activity_joact.* import com.android.volley.Request as Request1 class JOAct : AppCompatActivity() { override fun onCreate(savedInstanceState: Bundle?) { super.onCreate(savedInstanceState) setContentView(R.layout.activity_joact) btn_find.setOnClickListener { var url:String="http://175.198.142.90/WebApi/find.php?id="+ et_id.text.toString() var rq= Volley.newRequestQueue(this) var jor=JsonObjectRequest( Request1.Method.GET,url,null, Response.Listener {response -> tv_name.text=response.getString("name") tv_mobile.text=response.getString("mobile") }, Response.ErrorListener { } ) rq.add(jor) } } }

find.php

prepare("select * from drivers where id = ?"); $st->bind_param("i",$_GET['id']); $st->execute(); $rs=$st->get_result(); $row=$rs->fetch_assoc(); echo json_encode($row);

from http://dargo.tistory.com/158 by ccl(A) rewrite - 2021-10-31 16:26:36