I am trying to register a user as a manager or user(roles), for both roles i am using two different tables the data is registering successfully in database after clicking register button i have set the root page as home page which consisting of managers i used set root method on nav controller object but the data is not displaying after the page is navigated. But after killing the app and opening again the data is shown in the page any answers??
`register.ts file-
this.database.openDatabase({
name: “data.db”,
location: “default”
}).then(() => {
alert(“database Opened”);
this.database.executeSql(“INSERT INTO Managers(name,email,Password,Photo) VALUES(?,?,?,?)”, [name, email, password, this.base64Image])
.then((data) => {
alert(JSON.stringify(data));
alert(“Registered Successfully into Managers”);
this.navCtrl.setRoot(Page1);
}, (error) => {
console.log("Unable To Insert Data into role1: ", error);
alert(“Unable To Insert Data”);
})
}, (error) => {
console.log("Unable To Open Database: ", error);
alert(“Unable to Open Database”);
});
Page1.ts-
this.database.openDatabase({
name: “data.db”,
location: “default”
}).then(() => {
this.database.executeSql(“SELECT * from Managers”, {})
.then((data) => {
this.Managers = [];
if (data.rows.length > 0) {
let managerLocal = [];
for (var i = 0; i < data.rows.length; i++) {
managerLocal.push({ password: data.rows.item(i).Password, id: data.rows.item(i).id, name: data.rows.item(i).name, email: data.rows.item(i).email, photo: data.rows.item(i).Photo });
}
this.Managers = managerLocal;
}
}, (error) => {
console.log("Unable To Retrieve Data from Managers: ", error);
alert(“Unable To get Data”);
})
}, (error) => {
console.log("Unable To Open Database: ", error);
alert(“Unable to Open Database”);
});
Page1.html-
<ion-content padding>
Managers List
{{manager.name}}
{{manager.email}}
Delete<ion-label class=“display” [style.visibility]="((Managers == null || Managers.length==0)) ? ‘visible’ : ‘hidden’">No Data Available
`