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

<?php

$con=new mysqli("localhost","root","","taxi");
$st=$con->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);