You are not logged in.

adanny08

Beginner

  • "adanny08" started this thread

Posts: 14

Date of registration: Mar 4th 2009

  • Send private message

1

Monday, May 11th 2009, 7:27pm

A login form that connects to a database

I need serious help on how to create a login form that verifies the user with login table in a database.I seriously need help before tomorrow 6.00.

Manuel

Administrator

  • "Manuel" is male

Posts: 256

Date of registration: Jul 16th 2008

Location: Erlangen, Germany

Occupation: Software Developer

Hobbies: Jabaco, game theory, text-mining

  • Send private message

2

Monday, May 11th 2009, 8:44pm

Ok. I'll help you. What would you like to know exactly?

adanny08

Beginner

  • "adanny08" started this thread

Posts: 14

Date of registration: Mar 4th 2009

  • Send private message

3

Saturday, May 16th 2009, 1:42pm

sorry for the delay in reply

I want the username and the password entered be verified with a login table in a database.

  • "WhatIsSoftware" is male

Posts: 21

Date of registration: Apr 28th 2012

Location: CyberVillage

Hobbies: Web Development. Android Development. Jabaco Development. :)

  • Send private message

4

Monday, June 18th 2012, 8:46am

Can an example on this be given? I have been having trouble creating a 'registration' for my client. i am trying to let the user pick a username & password, if username is taken then retry. but so far i am unsuccessful. :\

*edit* I am not sure how to use a textbox& comandbutton along with SQL statements. i am alittle lost on this. Sorry i am new to programming. :\ help?

JasonS

Trainee

  • "JasonS" is male

Posts: 65

Date of registration: Feb 17th 2010

  • Send private message

5

Wednesday, July 4th 2012, 3:15am

Simple databasing

Hi,

Is there a reason this has to be done via SQL? I think, that your applet, wherever it is loaded... would have to also have access to SQL... do what I do and just make a simple winsock server daemon program in VB that listens for connections, receives command(s), and spits out answers. Have your applet connect to that to do the dirty work. build in encryption if you want.. then let the VB app talk to SQL... or even easier, save your data in .dat files on the VB server. Seems safer in my opinion.. then your only opening the vb app to the public, and not SQL itself. Optionally, but may be a lot harder, you could also make the VB server program in Jabaco instead--but I have not got this far with any of my apps, yet. (:

I can give you some of the snippets of code you would need for the different pieces in VB server and Jabaco client if you want, let me know.

Regards,
Jason

  • "WhatIsSoftware" is male

Posts: 21

Date of registration: Apr 28th 2012

Location: CyberVillage

Hobbies: Web Development. Android Development. Jabaco Development. :)

  • Send private message

6

Thursday, July 5th 2012, 7:10am

JasonS,

Yes it has to be SQL DB because the forum (phpbb)/client will use the same user and password tables. Creating the backend in VB and connecting to that seems to be the simplest way. There are a few hundred users so i don't need top notch security, but a basic encryption will work nicely. thank you very much for taking the time to answer and give advice to my problems. I hope to message you if i run into any trouble

JasonS

Trainee

  • "JasonS" is male

Posts: 65

Date of registration: Feb 17th 2010

  • Send private message

7

Wednesday, July 11th 2012, 8:54am

Hey,

I should have a 'vbserver daemon and jabaco client' ready for you sometime this week. I will post a link for anyone to use for whatever they want when its ready. Eventually this will also be in the codebank on my site, but I havent implemented that into my site yet (soon), so I have just been posting zip links on the board for now. Its a bare bones login applet (and vb server daemon) screen where users can register, login, and provide an integer value (listbox items for what they wanna do once logged in, etc.) You can do whatever you want with it, morph it to your needs, please :) There is also a chat room feature built into it along with the ability to make commands. Several examples of how to do different commands for actions are in the code already so use that as a helper, you will just have to see. :)

Ill post as soon as the zip file is ready.

Regards,
Jason

JasonS

Trainee

  • "JasonS" is male

Posts: 65

Date of registration: Feb 17th 2010

  • Send private message

8

Thursday, July 12th 2012, 3:05am

AuthIT Demo

Hello,

Here is the sample I promised. There is a readme file included in the zip, along with the source code to the VB6 server daemon and the Jabaco client, and their binaries incase you do not have VB6. You will at least need the VB6 runtime environment to run the daemon, or have VB6 installed.

The link to the archive file is http://www.tecktronic.net/authit/AuthIt_…Client_Srcs.zip

There is also a working demo in the apps section @ www.tecktronic.net

This sample does not connect to SQL at all, but I have left comments as to where you would want to perform these functions. You could also rewrite the (in the VB6 server project), the way it stores, checks, etc usernames and passwords to use SQL for that instead of .dat (user defined types saved to disk) files.

I hope this helps you. Read the readme file it explains alot more. :)

Any questions, feel free to ask, Ill try to answer as best as I can. 8)

Sincerely,
Jason

JasonS

Trainee

  • "JasonS" is male

Posts: 65

Date of registration: Feb 17th 2010

  • Send private message

9

Monday, July 16th 2012, 1:21am

AuthIT Source Code Links / Jabaco(JavaApplet)-VBServer-B4A(AndroidDex) Connector Sources

Hey,

I also made a client for Android via B4A, that works with the same server that the java client. Here below is the link for the zips of the vb server source & jabaco client source, and another zip with the B4A client source.

http://www.tecktronic.net/authit/AuthIt_…Client_Srcs.zip
http://www.tecktronic.net/authit/AuthITAndroidClientSrc.zip

I feel this is a good demo of source code to show how to start off your multi user, interactive app, that offers a java (pc/mac) client and an android client, all using TCP.

You can see it working on my live server (www.tecktronic.net) in the apps section ... jabaco and android app are titled 'chat.tecktronic.net'.. click on eithr key icon to test it out via browsers and android browser.

Any questions, feel free to ask. I know the code isnt perfect but its a great working template set. :thumbup:

Enjoy (;

~Jason

This post has been edited 1 times, last edit by "JasonS" (Jul 16th 2012, 1:27am)


spysonic

Trainee

  • "spysonic" is male

Posts: 88

Date of registration: Jul 11th 2014

About me: A beginner programmer.

Location: ...Jabaco Academy

Occupation: i have some but still not enough...

Hobbies: Jabaco

  • Send private message

10

Friday, August 8th 2014, 6:15am

all the links you provided is dead already?
.
.
Spare me, im new to Programming

Rate this thread
WoltLab Burning Board