Is there a way to connect HTML login form to sqlite database?

Question

0.00/5 (No votes)

See more:

I am trying to connect my html form to sqlite database, so that it can store the registration/login information into the database. I have the html form and database, but I cannot get them to link together. If someone can please help me what I need or how is it possible or point me to some examples would be very much appreciated. I cannot seem to figure out a way and I have searched and searched and spent weeks now. I am reach out because I need this to be done for my project by this month.
Please Help

What I have tried:

I cannot seem to figure out a way and I have searched and searched and spent weeks now. I am reach out because I need this to be done for my project by this month.

Posted 19-Mar-21 6:16am

Member 15108664

Updated 19-Mar-21 7:44am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2021-03-19T06:51:00

Solution 1

You don't.

The login operation happens on the server, not the client. The browser just sends the username and password to the server for any login operation and the server handles all the database stuff, authenticating the user and returning an appropriate page for that user.

Posted 19-Mar-21 6:51am

Dave Kreskowiak

Comments

Member 15108664 19-Mar-21 13:14pm

So if I dont need to link the html form with sqlite database, then how does the credentials get stored in the database?

Dave Kreskowiak 19-Mar-21 13:15pm

Again, server-side code. Think of the HTML side as nothing more than a form you fill in and submit to the server. The server code handles ALL database work.

Member 15108664 19-Mar-21 13:27pm

Okay I see what you are saying, so for example my server is local server and if a user login, the credentials goes to that local server which communicates with the sqlite database and stores it there. Correct? (Everything is based on local network)
Thank you Dave for helping me understand this, I have never done anything like this before so its all new and learning process that I am going through. (:

RickZeeland · Answer 2 · 2021-03-19T07:44:00

Solution 2

See: GitHub - inloop/sqlite-viewer: View SQLite file online[^]

Posted 19-Mar-21 7:44am

RickZeeland