session_start();
include_once("config.php");
if ($_GET["action"]=="1") {
include_once("error_Check_1.php");
if (!$badSubmit) {
if(!empty($_FILES["userfile"]["name"])) {
$target_path1 = "photos/";
$target_path = $target_path1 . basename( $_FILES['userfile']['name']);
$t=0;
while(file_exists($target_path)){
$pieces = explode(".", $_FILES["userfile"]["name"]);
$target_path = $target_path1 . $pieces[0] . "_" . $t . "." . $pieces[1];
$t++;
}
if(move_uploaded_file($_FILES['userfile']['tmp_name'], $target_path)) {
} else{
$uploadError_1="
There was an error uploading your photo - please try again";
}
}
if (!$uploadError_1) {
include_once("db_connect.php");
$sql="INSERT INTO " . $tblFan . " (myName, mySurname, myEmail, myMobile, myPassword, myAddr1, myAddr2";
$sql.=", myAddr3, myCode, myProvince, myVehicle, myVehicleOther, myYear, myPhoto) VALUES (";
$sql.="'" . $name . "', '" . $surname . "', '" . $email . "', '" . $mobile . "', '" . $password . "', '" . $street . "',";
$sql.="'" . $suburb . "', '" . $city . "', '" . $code . "', '" . $province . "', '" . $vehicle . "', ";
$sql.="'" . $otherVehicle . "', '" . $year . "', '" . $_FILES["userfile"]["name"] . "')";
$sql_result = mysql_query($sql, $connection) or die($sql);
$myID = mysql_insert_id();
$_SESSION['myID'] = $myID;
header("location:fans_signup2.html?fid=$myID");
}
}
}
if ($_GET["action"]=="2") {
$action="3";
include_once("db_connect.php");
$sql="SELECT * FROM " . $tblFan . " WHERE id = " . $_SESSION['myID'];
$sql_result = mysql_query($sql, $connection) or die($sql);
while ($row = mysql_fetch_array($sql_result,MYSQL_ASSOC)) {
$id = $row["id"];
$name = $row["myName"];
$surname = $row["mySurname"];
$email = $row["myEmail"];
$mobile = $row["myMobile"];
$password = $row["myPassword"];
$street = $row["myAddr1"];
$suburb = $row["myAddr2"];
$city = $row["myAddr3"];
$code = $row["myCode"];
$province = $row["myProvince"];
$vehicle = $row["myVehicle"];
$otherVehicle = $row["myVehicleOther"];
$year = $row["myYear"];
$doCertify="checked";
}
}
if ($_GET["action"]=="3") {
include_once("error_Check_1.php");
include_once("db_connect.php");
$sql="UPDATE " . $tblFan . " set myName = '" . $name . "', mySurname = '" . $surname . "', myEmail = '" . $email . "'";
$sql.=", myMobile = '" . $mobile . "', myPassword = '" . $password . "', myAddr1 = '" . $street . "'";
$sql.=", myAddr2 = '" . $suburb . "', myAddr3 = '" . $city . "', myCode = '" . $code . "', myProvince = '" . $province . "'";
$sql.=", myVehicle = '" . $vehicle . "', myVehicleOther = '" . $otherVehicle . "', myYear = '" . $year . "'";
$sql.=", myPhoto = '" . $_FILES["userfile"]["name"] . "' WHERE id = " . $_SESSION['myID'];
$sql_result = mysql_query($sql, $connection) or die($sql);
$newLocation="fans_signup2.html?fid=" . $_SESSION['myID'];
header("location:$newLocation");
}
if (!$action) {
$action="1";
}
?>