SQLite Forum

import React, {useState} from 'react';
import {DatabaseConnection} from '../database/conex';
import {DatabaseInit} from '../database/dbinit';
import { FlatList, Text, View } from 'react-native';

var db = null;

export default function viewAllUser(){

    db = DatabaseConnection.getConnection();
    const [users, setUsers] = useState([]);

    db.transaction(tx => {
        tx.executeSql('SELECT * FROM user', [], (tx, results) => {
          var temp = [];
          for (let i = 0; i < results.rows.length; ++i) {
            temp.push(results.rows.item(i));                               
          }             
          {() => setUsers(temp)}
        });  

      });
     console.log(users);
}