Registered-User
Table connected to Database ("UserData")
title50 | |||
title50 | |||
fff | fff | fff | |
title50 | |||
title50 | |||
title50 | |||
abc | abc | abc | |
HI | HI | HI | |
sam | sam | sam | |
test | test | test | |
test1 | test1 | test1 | |
Mr | Mr | Mr |
CODE-II-upgrade
import wixData from 'wix-data';
var dataLenght
var firstItem
$w.onReady(function () {
wixData.query("UserData")
.find()
.then( (results) => {
firstItem = results.items[0]
dataLenght=results.length
$w('#textBox1').value=dataLenght
})
});
//---------------------------------------------------------------------------------------
export function button1_click(event) {registerUser()}
//---------------------------------------------------------------------------------------
async function registerUser (parameter) {
var usersFirstNames=["John","russian", "Mark", "Donald", "Angela", "Vladimir"]
var usersLastNames= ["Deer", "dima", "Jones", "Trump", "Merkel", "Putin"]
await wixData.query("UserData").find().then((results)=> {dataLenght=results.length, $w('#textBox1').value=dataLenght, $w('#dataset1').refresh()})
let toInsert = {
"title": "title"+(dataLenght),
"name": usersFirstNames[dataLenght],
"lastName": usersLastNames[dataLenght]
};
wixData.insert("UserData", toInsert)
.then( (results) => {
let item = results;
} )
.catch( (err) => {
let errorMsg = err;
} );
}
//---------------------------------------------------------------------------------------
export function button2_click(event) {DELETE_DATA()}
//---------------------------------------------------------------------------------------
function DELETE_DATA (parameter) {
wixData.truncate("UserData")
.then( () => {
console.log("All items removed");
wixData.query("UserData").find().then((results)=> {dataLenght=results.length, $w('#textBox1').value=dataLenght, $w('#dataset1').refresh()})
} )
.catch( (err) => {
let errorMsg = err;
} );
}
CODE-I
import wixData from 'wix-data';
$w.onReady(function () {
ddd()
});
function ddd (parameter) {
wixData.query("UserData")
.find()
.then( (results) => {
console.log((results.length))
// if(results.items.length > 0) {
let firstItem = results.items[0]; //see item below
let dataLenght=results.length
$w('#textBox1').value=dataLenght.toString()
// } else {
// handle case where no matching items found
// }
} )
.catch( (err) => {
let errorMsg = err;
} );
}
function xxx (parameter) {
let totalDataCount=$w('#dataset1').getTotalCount()
var usersFirstNames=["John","russian", "Mark", "Donald", "Angela", "Vladimir"]
var usersLastNames= ["Deer", "dima", "Jones", "Trump", "Merkel", "Putin"]
let toInsert = {
"title": "title"+(totalDataCount+1),
"name": usersFirstNames[totalDataCount+1],
"lastName": usersLastNames[totalDataCount+1]
};
wixData.insert("UserData", toInsert)
.then( (results) => {
let item = results; //see item below
} )
.catch( (err) => {
let errorMsg = err;
} );
}
function DELETE_DATA (parameter) {
wixData.truncate("UserData")
.then( () => {
console.log("All items removed");
} )
.catch( (err) => {
let errorMsg = err;
} );
$w('#dataset1').refresh()
$w('#textBox1').value=$w('#dataset1').getTotalCount()
}
export function button2_click(event) {DELETE_DATA()}
export function button1_click(event) {
xxx(),$w('#dataset1').refresh(), $w('#textBox1').value=$w('#dataset1').getTotalCount()
}
