Login codes login codes

App Building
1

I have done some more work on my Log In screens but I have a syntax problem.

I hope there is someone around who understands this.

I am attaching a capture of my screen.

The login checking code is easier to see below:

DELIMITER $$

BEGIN
    
if email3 = {{localStorage.values.mpwemail}} and password1 = {{localStorage.values.mpassword}}
   goinvoice02b
else
   goLogIn02
endif
  
END$$

DELIMITER ;

Any thoughts would be most welcome.

Mike

pict1
pict11730×641 106 KB

2

First observation is it looks like you're running some SQL syntax inside a javascript query so that should probably explain the syntax issue.

3

Yes, you were right.

I have changed the code to a MySQL Query and the coding color is now green but it still doesn't work.

The new code is here:
DELIMITER $$

BEGIN
if email3 = {{localStorage.values.mpwemail}} and password1 = {{localStorage.values.mpassword}}
   goinvoice02b;
else
   goLogIn02;
endif;
END$$

DELIMITER ;

The error message is here:

CheckLogIn02 failed (0.502s):You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER $$ BEGIN if email3 = 'doncaster319@gmail.com' and password1 = ' at line 1
CheckLogIn02

I am also including a screen capture.

Any thoughts?

Mike

pict1
pict1896×457 45.1 KB

4

I thought I should report on this to finish off the topic.

The solution to a customer login is to click on the app that you want as your start screen, then click "Share" in the upper right. This will give you an URL that you can use for your 3rd part user.

I will build an app in HTML for the log in screen and when they enter the correct user name and password they will to directly to the app.

I will be creating separate apps with databases for each user.

This solves m problem so I will mark this as a solution to close it off.

Mike