<?php
ob_start();
//Step 1: create database connection
$connection = mysql_connect("localhost", "joenna", "joenna"); //name of host, username, password
if (!$connection)
{ die("Database Connection Failed" . mysql_error());
}

//step 2: select database to use
$db = mysql_select_db("joenna",$connection); //name of database and connection
if (!$db)
{
die("Database selection failed" . mysql_error());
}

// Define $myusername and $mypassword
global $myusername;
$myusername =$_POST['Username'];
$mypassword =$_POST['Password'];

$sql="SELECT * FROM information WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);



$count=mysql_num_rows($result);

if($count==1){

session_register("myusername");
session_register("mypassword");
header("location:products2.php");
}
else {
header("location:invalidpass.php");

}
ob_end_flush();
?>