I'm learning this php daily (tyring to at least.)
I'm tryiing to create a login form.
But, before taht I need to add the info into the db.
<?
$db_host = "localhost";
$db_name = "database";
$db_user = "username";
$db_pass = "passwored";
mysql_connect($db_host, $db_user , $db_pass);
mysql_select_db($db_name);
if ($submit)
{
$encpass = md5($password);
$sql = "INSERT INTO users VALUES ('$username','$encpass','$firstname','$lastname','$email','2003-03-13');";
$result = mysql_query($sql);
if(mysql_num_rows($result))
{echo "success!";}
else
{
echo "Fail!";
printf ("<form type=post action=add.php>
<input type=text name=username><br>
<input type=text name=password> <Br>
<input type=text name=firstname> <Br>
<input type=text name=lastname> <Br>
<input type=text name=email> <Br>
<input type=text name=date><Br>
<input type=submit value=submit name=submit>
</form>
");
}
}
?>
<?php
$db_host = "localhost";
$db_name = "database";
$db_user = "username";
$db_pass = "passwored";
mysql_connect($db_host, $db_user , $db_pass);
mysql_select_db($db_name);
if ($submit)
{
if (!$username)
{echo "Username field blank!";}
elseif (!$password)
{
{echo "Password field blank!";}
}
else
{$encpass = md5($password);
$sql = "SELECT * FROM clients WHERE username='$username' AND password='$encpass'";
$result = mysql_query($sql);
if(mysql_num_rows($result))
{include ("success.php");}
else
{include ("loginfail.php");}
}
}
else {
include ("login.php");
}
?>
Why isn't this working?
Thanks,
PS< I'm a noobie!
