top of page
REGISTER NEW MEMBER
RESET

Registered-User

35-356806_blue-database-vector-clip-art-

Table connected to Database ("UserData")

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
002.png

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

}

Bad-Idea.jpg

Index

bottom of page