How can I link a log in page on my website to MySQL?

Question

So that I can let users log in?

Answer 1

Depends on what you are programming in. I used PHP, so that is what I will answer in.

Code follows (This is the PHP code so be sure to include itt in tags):

$db=mysql_connect("MySQL Server Here","Username","Password");
mysql_select_db("Database Name", $db);


$recent="SELECT * FROM users where
username=$usernamevariable'";
$result=mysql_query($recent, $db);

while ($getrec= mysql_fetch_array( $result ))
{
$getid=$getrec["password"];

if ($getid == $passwordvariable)
{
Script to login page. Use cokies here or sessions to keep users logged in.
}


That is the end of the code. Mainly just the database connection code, a little on how to pull data out of the database. Therre is obviously a lot more to creating a functioning loggin page, but this should give you a basic idea on MySQL database connections.

Answer 2

You'll need some sort of back-end script to open a connection to the database, get the form's input values, and check them against the data in your database. Do you have php available? Here's a simple example:

http://www.phpeasystep.com/workshopview.php?id=6

Answer 3

Whatever programming language you are using on your website, just open the log file and read the file and place the desired contents it in your html code. Get the idea?

Answer 4

Erm i dont know www.ashleymckiernan.co.nr

Answer 5

I'm not sure.