SQL database and log in page

Jack Ruby · Post by **Jack Ruby** » Tue Jul 19, 2005 6:58 pm

I have to make a secure log in page for a job im doing at work.

I have php running on the webserver.

I got a dreamweaver extension pack, PHP Login Suite, http://phploginsuite.dreamweavermxsuppo ... upport.php

I have no clue how to make a database, I have microsoft access but I dont think thats the tool for the job, I want an sql database.

Anyone know how I make one ?

HDL_CinC_Dragon · Post by **HDL_CinC_Dragon** » Thu Jul 21, 2005 1:33 pm

Download MySQL Database

Download MySQL for free here: http://www.mysql.com/downloads/index.html

Jack Ruby · Post by **Jack Ruby** » Thu Jul 21, 2005 9:31 pm

I almost got it worked out, been spending a lot of time on it.

I downloaded an open source login thing, I have it logging in now and it redirects you to a secure page, now im trying to get it to send different usernames to different pages. Just as I typed that I realised we have another problem that we need to work out, once they logged in only letting them see certain pages not the whole site( if they know the other urls).

I will work it out hopefully

HDL_CinC_Dragon · Post by **HDL_CinC_Dragon** » Fri Jul 22, 2005 3:13 am

hmmm im not the best at this kinda thing but maybe you can set hidden, secure links to the other pages that only appear if certain values are true such as like (and this is VERY VERY general, its for idea purposes only, this wont work on any programing i know of lol)

{

if (login.name.Jack-ruby = true)
link.unlock = 1 ; 2 ; 3
}

{

if (login.name.noob-dragon)
link.unlock bullet-to-nade ; nade-down-throat

}

and i know itd be a ***** to make all these threads for every new member login so you can have you submit form kinda create it for you? ya know what i mean?... ya i know totally noobish idea right? im only reading a little bit on this PHP stuff so im not the best at it. but you get the idea right? Just thought id post this idea, i figured it couldnt hurt to try and help right?

lizardkid · Post by **lizardkid** » Fri Jul 22, 2005 9:05 am

SQL is not like MOH scripting dragon

Jack Ruby · Post by **Jack Ruby** » Fri Jul 22, 2005 10:17 pm

I got it working.

I register people and add a url to the form I submit.

Now when they login it redirects them to whichever url I submitted when I registered a user.

Very cool

Such a simple request but a big mission to make it work ( maybe thats cos im stupid )

Anyways problem solved, if anyone wants to make their own version I can now help them out

HDL_CinC_Dragon · Post by **HDL_CinC_Dragon** » Sat Jul 23, 2005 7:02 am

lizardkid wrote:SQL is not like MOH scripting dragon

hahaha i know i was just trying to get a point accross using a language i half understand lol