How to interact flutter apk with PostgreSQL and external website?

Question

I created flutter app, it is using PostgreSQL as DB and opening external websites for product related info. This is working as expected in emulator. Created apk file with the command flutter build apk --build-name 1.0 --build-number 1 and installed in my mobile.

The app is not able to load data from database. Not sure I whether I missed any steps while creating the apk or other. Can someone help me?

Abdelaziz HADIAT ALLAH · Accepted Answer · 2023-03-24T17:35:21.623

1

try replacing your _launchURL with this :

  _launchURL(String url) async {
    final uri = Uri.parse(url);
      await launchUrl(uri, mode: LaunchMode.externalApplication); 
  }

In your android/app/src/main/androidManifest.xml add this line before <application

<uses-permission android:name="android.permission.INTERNET"/>

Like this :

edited Mar 24 '23 at 17:35

answered Mar 23 '23 at 18:36

Abdelaziz HADIAT ALLAH

360
1
4
11

thanks @Abdelaziz , able to interact with DB but not able to open external website. – anilraj Mar 24 '23 at 16:07
can you provide more informations ? – Abdelaziz HADIAT ALLAH Mar 24 '23 at 16:33
try adding this line inside ` – Abdelaziz HADIAT ALLAH Mar 24 '23 at 16:37
My intention is to redirect to https://www.amazon.in upon user clicks on button. I added above line as below but no luck – anilraj Mar 24 '23 at 17:07
are you using webview ? – Abdelaziz HADIAT ALLAH Mar 24 '23 at 17:10
I have added complete code, please have a look – anilraj Mar 24 '23 at 17:15
I updated answer check it out – Abdelaziz HADIAT ALLAH Mar 24 '23 at 17:35

score 0 · Answer 2 · answered Mar 24 '23 at 17:15

This is the complete code,

class Authorize extends StatefulWidget {
  const Authorize({super.key});

  @override
  State<Authorize> createState() => _AuthorizeState();
}

class _AuthorizeState extends State<Authorize> {
  late Future<List<dynamic>> _custList;

  @override
  void initState() {
    super.initState();
    //_futureList = fetchListData();
    _custList = ModelsPositions().getCust();
  }

  _launchURL(String url) async {
    final uri = Uri.parse(url);
    if (await canLaunchUrl(uri)) {
      await launchUrl(uri, mode: LaunchMode.externalApplication);
    } else {
      throw 'Could not launch $url';
    }
  }

  @override
  Widget build(BuildContext context) {
    return Scaffold(
        appBar: AppBar(
          title: const Text('sample orders'),
        ),
        //automaticallyImplyLeading: false),
        body: FutureBuilder<List<dynamic>>(
          future: _custList,
          builder: (context, snapshot) {
            if (snapshot.hasData) {
              List<dynamic> custAPIs = snapshot.data ?? [];
              return ListView.builder(
                  itemCount: custAPIs.length,
                  itemBuilder: (context, index) {
                    String custID = custAPIs[index][0];
                    return Card(
                      child: Row(
                        children: [
                          SizedBox(width: 50),
                          Expanded(
                            child: Text('custID: $custID'),
                          ),
                          SizedBox(width: 15),
                          Expanded(
                            child: ElevatedButton(
                                child: const Text('check'),
                                onPressed: () {
                                  String url =
                                      "https://www.amazon.in/";
                                  _launchURL(url);
                                }),
                          ),
                        ],
                      ),
                    );
                  });
            } else if (snapshot.hasError) {
              return const Center(
                  child: Text('Failed to fetch Positions Summary'));
            }
            return const Center(child: CircularProgressIndicator());
          },
        ));
  }
}

I'm installed apk file in mobile and trying to open from mobile.(When I tried in emulator working fine but after generating apk and installing in mobile it is not opening the webpage).

How to interact flutter apk with PostgreSQL and external website?

2 Answers2