[Guide] MySQL User Login And Registration

Guides
#1

Asslam-O-Alaikum!
This is my first guidepost on kodular community.

By implementing this method you can create a user Login, Registration and also you can display user profile easily by using Post method.

Note
This Login System based on Email and Password

First You have to download zip file.

PHPLoginRegistrationProfile.zip (1.9 KB)

Extract this zip file so you will get 4 php files

Now open DatabaseConfig.php file and add your database details. Upload these 4 files on your hosting

Now come back to kodular and create a new project and take these components

Web component
Label
Button

Goto Blocks Section

Take 2 Variables
Login URL (Paste Your Database URL like This)
https://your-site.com/UserLogin.php

Register URL (Paste Your Database URL like This)
https://your-site.com/UserRegistration.php

blocks (7)
blocks (7)928×613 41.4 KB

Profile URL (Paste Your Database URL like This)
https://your-site.com/ViewUserData.php

Display User Profile by Email User Address

Kodular LoginHelp
Kodular LoginHelp718×378 24.7 KB

This Will Return Data in JSON Format.

Use Kodular JSON Component to parse the result.

Note: You can expand this code according to your need and if need any help regarding this just post your issue i will try to help you

Love from PAKISTAN :pakistan:

14 Likes
Firebase authentication with mysql database
Login system failed (using mysql database)
Discuss is there a way to create a profile
#2

Maybe you can attach the php files itself. Discourse can act strangely when pasting for instance html code or maybe even php.

2 Likes
#3

Your PHP script is not secured against SQL injection, Watch out.

you should use PDO to connect your database and prepared request for your queries

SQL injection

3 Likes
#4

Okay Thank you

1 Like
#5

How to protect from http captured?
I think this is the big issue…

#6

Yeah You’re right but maybe we can use google authentication to avoid this

1 Like
#7

I had tried, this is not the solution i am working on it. I am making a secure nodejs app for mysql database. Maybe this is helpful.

#8

I think the author is not going to use it as it is in the example, he just did an … example … :wink: :+1:

#9

Hey, What you think about this mysql_real_escape_string() is it helpful to avoid sql injection :syringe:

2 Likes
#10

Hello

no, you have to use prepared queries, only real way to prevent SQL injection :

1 Like
#11

can I have the aia files

1 Like
#12