Skip to content
Advertisement

pass the tablename to getData.php in flutter

I am making a flutter application using MySQL. In the home page I have a listview as shown below. The database has unique tables for each item in the list view.

What I want is that when I am calling http.get to get all the data from a particular table as per the query mentioned in getData.php, there must also be a procedure to send that table name to that php file so that the query should be completed.

This is getData.php:

<?php
include 'conn.php';
$Table = $_POST['Tablename'];
$query = "select * from ".$Table;
$data = mysqli_query($conn, $query);
$result = array();
while ($row = mysqli_fetch_array($data)) {
    $result[] = $row;
}
echo json_encode($result);
?>

and here is the code which I have written to fetch the data. What can I write to send the tablename to getData.php:

  Future<List> getQue() async {
    var response = await http.get(url);
    return json.decode(response.body);
  }

Advertisement

Answer

Use post instead of get for your http call;

Future getQue() async {
  var response = await http.post(url, body:{'Tablename': your-table-name});
  return json.decode(response.body);
}
User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement