supercala

Code: Select all

<?php
	//set these to an empty string
	$username="";
	$password="";
	//check if the variables in $_POST were set
	//
	if(isset($_POST['username']))
		{$username=$_POST['username'];}
	//
	if(isset($_POST['password']))
		{$password = $_POST['password'];}
	//
	if($username!=""&&$password!="")
		{
		$connect=mysql_connect("localhost","root","bonjour")or die("Could not connect to database.".mysql_error());
		mysql_select_db("test")or die("Could not select database.".mysql_error());
		$query=mysql_query("SELECT * FROM users WHERE username='$username'");
		$numrows=mysql_num_rows($query);
		//
		if($numrows>0)
			{
			//there maybe multiple names entered but we just need a hit on the table for a good n:p
			for($a=0;$a<$numrows;$a++)
				{
				$row=mysql_fetch_assoc($query);
				$db_un=$row['username'];
				$db_pw=$row['password'];
				//
				if($username==$db_un&&$password==$db_pw)
					{
					echo "<a href=admin.php>ADMIN AREA</a>";//always end your anchors with <a href="link">text here</a>
					}
				}
		mysql_close($connect);//always close the mysql connection when you don't need it
		}
		//
		else
			{
			/*
			format your lines of output so it looks good to you when you VIEW SOURCE with newlines
			no need for a form, you can use a submit button with a simple anchor (a) remmber to end your anchor </a>
			single quotes for things needing quotations inside of double quote php output
			*/
			echo
				"
				<h3>Incorrect Name and Password</h3>
				<a href='index.php'><input type='submit' value='Try Again'></a>
				";
			}
		echo "ok";
		}
	//no name and password was sent, just show the login data this way instead of a different page
	else
		{
		echo
			"
			<h3>ADMIN LOGIN AREA</h3>
			<hr />
			
			<form name='login' action='index.php' method='POST'>
				<table>
					<tr><td>USERNAME</td><td><input name='username'></td></tr>
					<tr><td>PASSWORD</td><td><input name='password'></td></tr>
				</table>
				<input type='submit' value='LOGIN'>
			</form>";
		}
?>