Registered-User

Table connected to Database ("UserData")
title50 | |||
title50 | |||
title50 | |||
title50 | |||
title50 | |||
title50 | |||
sdf | sdf | sdf | |
title50 | |||
title50 | |||
title50 | |||
title50 | |||
test | test | test | |
aaa | aaa | aaa | |
Koloti | Koloti | Koloti | |
fgf | fgf | fgf | |
title50 | |||
title50 | |||
title50 | |||
title50 | |||
title50 | |||
title50 | |||
title50 | |||
title50 | |||
title50 | |||
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 | |
title50 | |||
title50 | |||
title50 | |||
title50 | |||
title50 | |||
title50 | |||
title50 | |||
title50 | |||
title50 | |||
title50 | |||
title50 | |||
title50 | |||
fdsf | fdsf | fdsf | |
Wong | Wong | Wong | |
dummy | dummy | dummy | |
title50 | |||
ashvini | ashvini | ashvini | |
testing | testing | testing | |
title50 | |||
title50 | |||
title50 | |||
title50 | |||
title49 | |||
title48 | |||
title47 | |||
title46 | |||
title45 | |||
serkan arslan | serkan arslan | serkan arslan | |
serkan arslan | serkan arslan | serkan arslan | |
title42 | |||
title41 | |||
title40 | |||
title39 | |||
title38 | |||
title37 | |||
title36 | |||
title35 | |||
title34 | |||
title33 | |||
title32 | |||
title31 | |||
title30 | |||
title29 | |||
Jason | Jason | Jason | |
title27 | |||
title26 | |||
title25 | |||
test | test | test | |
ich | ich | ich | |
simon | simon | simon | |
simon | simon | simon | |
simon | simon | simon | |
simon | simon | simon | |
simon | simon | simon | |
s | s | s | |
simoj | simoj | simoj | |
Simon | Simon | Simon | |
title10 | |||
title9 | |||
title8 | |||
title7 | |||
title6 | |||
title5 | Vladimir | Putin | |
title4 | Angela | Merkel | |
title3 | Donald | Trump | |
title2 | Mark | Jones | |
title1 | russian | dima | |
title0 | John | Deer |

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()
}
