[<?php ob_start(); //start output buffering ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/tizzo_pa_training_template.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<!-- InstanceBeginEditable name="title" --><title>Profile</title>
<style type="text/css">
<!-- InstanceEndEditable -->
<link rel="stylesheet" type="text/css" href="images/banners/template.css" />
</head>
<body bgcolor="#ffffff">
<?php
/// connecting to database ... (will be used to verify user/pass from admin table
//$dbCon=mysql_connect('localhost','root','');
$dbCon=mysql_connect('localhost','user','pass');
$selDB=mysql_select_db('db268275600',$dbCon);
if(!$dbCon)
{
exit("<br> error connecting to db server");
}
if(!$selDB)
{
exit("<br> error connecting to database");
}
?>
<div align="center">
<table border="0" width="750" cellspacing="0" cellpadding="15" bgcolor="#ffffff">
<tr>
<td><div align="center" style="width:auto">
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td bgcolor="#ffffff"><span class="style3"><!-- InstanceBeginEditable name="content" -->
<?php
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//if new graduate page forwards a user to this form, check if the password is correct
if(isset($_POST['submit_new']))
{
$pass=$_POST['prod_pass'];
//echo "<br> you're here from new graduates login page, pass is $pass <br>";
if($pass=="prod_2009")
{
echo "<br> You've logged in to PATS for the first time, please fill in the following form completely to create your profile<br><br>";
$authorized=true;
}
else
{
echo "<br><br>You have entered the wrong password, please go back and try again<br><br><br>";
$authorized=false;
}
}
//if update button clicked on this form
if(isset($_POST['update']))
{
//get all the data from the POST
$prod_fname=$_POST['prod_fname'];
$prod_lname=$_POST['prod_lname'];
$prod_comp=$_POST['prod_comp'];
$prod_address=$_POST['prod_address'];
$prod_city=$_POST['prod_city'];
$prod_state=$_POST['prod_state'];
$prod_zip=$_POST['prod_zip'];
$user=$_POST['prod_user'];
$pass=$_POST['prod_pass'];
$prod_email=$_POST['prod_email'];
$prod_phone=$_POST['prod_phone'];
$prod_phone2=$_POST['prod_phone2'];
$prod_fax=$_POST['prod_fax'];
$prod_website=$_POST['prod_website'];
$fprod_name=$_POST['fprod_name'];
$fprod_city=$_POST['fprod_city'];
$fprod_state=$_POST['fprod_state'];
$query=mysql_query("INSERT INTO producer SET
prod_user='$user',
prod_pass='$pass',
prod_fname='$prod_fname',
prod_lname='$prod_lname',
prod_comp='$prod_comp',
prod_address='$prod_address',
prod_city='$prod_city',
prod_zip='$prod_zip',
prod_state='$prod_state',
prod_email='$prod_email',
prod_phone='$prod_phone',
prod_phone2='$prod_phone2',
prod_fax='$prod_fax',
prod_website='$prod_website',
fprod_name='$fprod_name',
fprod_city='$fprod_city',
fprod_state='$fprod_state',
");
if(!$query)
echo "<br> problem creating profile, please hit the BACK button and try again !! <br>";
else
{
//SET cookies to keep the user logged in
//echo "<br><br> before cookies user name is: $user, pass is $pass<br><br>";
//write new data to the cookies
setcookie("prod_user",$user);
setcookie("prod_pass",$pass);
//echo("cookies created for prod<br>");
//echo "<br><br> After cookies in cookies user is".$_COOKIE['user']." and pass is ".$_COOKIE['pass']." <br><br>";
echo "<br> Congratulations, Your profile has been created successfully<br><br><a href=\"prod_done.php\"> Click here </a> to view or edit your profile";
}
}
//otherwise show the form below
else if($authorized==true)
{
?>
<p class="style2"> Producer Registration </p>
<div align="center">
<form action="
<?php echo $_SERVER['PHP_SELF']; ?>
