if(!isset($_SESSION["sessionid"]))
session_start();
header("Cache-control: private"); //IE 6 Fix
include("../includes/config.php");
include("../includes/functions.php");
include("../includes/head.php");
$action = $_REQUEST['action'];
switch($action){
case "submit":
//set up database connection
$link = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD)
or die("Could not connect: ". mysql_error());
mysql_select_db(MYSQL_DBNAME, $link);
get_data();
//Insert user contact info
mysql_query("INSERT INTO user_info (fname, lname, sp_fname, sp_lname, street, city, state, zip, p_ac, p_pre, p_line, "
."f_ac, f_pre, f_line, email, considerations, completed) VALUES('". $_SESSION['fname'] ."', "
."'". $_SESSION ['lname'] ."', '". $_SESSION ['sp_fname'] ."', '". $_SESSION ['sp_lname']
."', '". $_SESSION ['street'] ."', '". $_SESSION ['city'] ."', "
."'". $_SESSION ['state'] ."', '". $_SESSION ['zip'] ."', '". $_SESSION ['p_ac'] ."', "
."'". $_SESSION ['p_prefix'] ."', '". $_SESSION ['p_ext'] ."', '". $_SESSION ['f_ac'] ."', "
."'". $_SESSION ['f_prefix'] ."', '". $_SESSION ['f_ext'] ."', '". $_SESSION['email'] ."', "
."'". $_SESSION ['reason'] ."', '". date('Y-m-d H:i:s') ."')") or die("Could not update table user_info: ". mysql_error());
$user_id = mysql_insert_id($link);
//Autos section
if($_SESSION['car_1_yr'])
mysql_query("INSERT INTO autos (user_id, year, make, model, miles, value, owed) "
."VALUES('". $user_id ."', '". $_SESSION['car_1_yr'] ."', '". $_SESSION['car_1_mk'] ."', "
."'". $_SESSION['car_1_mdl'] ."','". $_SESSION['car_1_mls'] ."', '". $_SESSION['car_1_val'] ."', "
."'". $_SESSION['car_1_owed'] ."')") or die("Could not update autos: ". mysql_error());
if($_SESSION['car_2_yr'])
mysql_query("INSERT INTO autos (user_id, year, make, model, miles, value, owed) "
."VALUES('". $user_id ."', '". $_SESSION['car_2_yr'] ."', '". $_SESSION['car_2_mk'] ."', "
."'". $_SESSION['car_2_mdl'] ."','". $_SESSION['car_2_mls'] ."', '". $_SESSION['car_2_val'] ."', "
."'". $_SESSION['car_2_owed'] ."')") or die("Could not update autos: ". mysql_error());
//Real Estate section
if($_SESSION['re_1_val'])
mysql_query("INSERT INTO estate (user_id, value, owed, description) "
."VALUES('". $user_id ."', '". $_SESSION['re_1_val'] ."', '". $_SESSION['re_1_owed'] ."', "
."'". $_SESSION['re_1_desc'] ."')") or die("Estate error: ". mysql_error());
if($_SESSION['re_2_val'])
mysql_query("INSERT INTO estate (user_id, value, owed, description) "
."VALUES('". $user_id ."', '". $_SESSION['re_2_val'] ."', '". $_SESSION['re_2_owed'] ."', "
."'". $_SESSION['re_2_desc'] ."')") or die("Estate error: ". mysql_error());
//Personal Property section
if($_SESSION['pp_1_val'])
mysql_query("INSERT INTO personal_prop (user_id, value, owed, description) "
."VALUES('". $user_id ."', '". $_SESSION['pp_1_val'] ."', '". $_SESSION['pp_1_owed'] ."', "
."'". $_SESSION['pp_1_desc'] ."')") or die("Property error: ". mysql_error());
if($_SESSION['pp_2_val'])
mysql_query("INSERT INTO personal_prop (user_id, value, owed, description) "
."VALUES('". $user_id ."', '". $_SESSION['pp_2_val'] ."', '". $_SESSION['pp_2_owed'] ."', "
."'". $_SESSION['pp_2_desc'] ."')") or die("Property error: ". mysql_error());
if($_SESSION['pp_3_val'])
mysql_query("INSERT INTO personal_prop (user_id, value, owed, description) "
."VALUES('". $user_id ."', '". $_SESSION['pp_3_val'] ."', '". $_SESSION['pp_3_owed'] ."', "
."'". $_SESSION['pp_3_desc'] ."')") or die("Property error: ". mysql_error());
//Creditors section
if($_SESSION['cr_1_name'])
mysql_query("INSERT INTO creditors (user_id, name, street, city, state, zip, acct_num, owed) "
."VALUES('". $user_id ."', '". $_SESSION['cr_1_name'] ."', '". $_SESSION['cr_1_address'] ."', '". $_SESSION['cr_1_city'] ."', "
."'". $_SESSION['cr_1_state'] ."', '". $_SESSION['cr_1_zip'] ."', '". $_SESSION['cr_1_acct'] ."', "
."'". $_SESSION['cr_1_owed'] ."')") or die("CREDITORS ERROR: ". mysql_error());
if($_SESSION['cr_2_name'])
mysql_query("INSERT INTO creditors (user_id, name, street, city, state, zip, acct_num, owed) "
."VALUES('". $user_id ."', '". $_SESSION['cr_2_name'] ."', '". $_SESSION['cr_2_address'] ."', '". $_SESSION['cr_2_city'] ."', "
."'". $_SESSION['cr_2_state'] ."', '". $_SESSION['cr_2_zip'] ."', '". $_SESSION['cr_2_acct'] ."', "
."'". $_SESSION['cr_2_owed'] ."')") or die("CREDITORS ERROR: ". mysql_error());
if($_SESSION['cr_3_name'])
mysql_query("INSERT INTO creditors (user_id, name, street, city, state, zip, acct_num, owed) "
."VALUES('". $user_id ."', '". $_SESSION['cr_3_name'] ."', '". $_SESSION['cr_3_address'] ."', '". $_SESSION['cr_3_city'] ."', "
."'". $_SESSION['cr_3_state'] ."', '". $_SESSION['cr_3_zip'] ."', '". $_SESSION['cr_3_acct'] ."', "
."'". $_SESSION['cr_3_owed'] ."')") or die("CREDITORS ERROR: ". mysql_error());
//Employment section
if($_SESSION['emp_name'])
mysql_query("INSERT INTO employment (user_id, name, street, city, state, zip, period, gross, net, ytd) "
."VALUES('". $user_id ."', '". $_SESSION['emp_name'] ."', '". $_SESSION['emp_address'] ."','". $_SESSION['emp_city'] ."', "
."'". $_SESSION['emp_state'] ."', '". $_SESSION['emp_zip'] ."', '". $_SESSION['period'] ."', '". $_SESSION['gp'] ."', "
."'". $_SESSION['np'] ."', '". $_SESSION['ytd'] ."')") or die("Employment error: ". mysql_error());
//Budget section
mysql_query("INSERT INTO budget (user_id, rent, electric, heat, water, sewer, cable, phone, food, clothing, cleaning, medical, "
."trans, insur, entertainment, child, car, charity) "
."VALUES('". $user_id ."', '". $_SESSION['rent'] ."', '". $_SESSION['elec'] ."', '". $_SESSION['heat'] ."', '". $_SESSION['water'] ."', "
."'". $_SESSION['sewage'] ."', '". $_SESSION['cable'] ."', '". $_SESSION['tele'] ."', '". $_SESSION['food'] ."', '". $_SESSION['cloth'] ."', "
."'". $_SESSION['clean'] ."', '". $_SESSION['med'] ."', '". $_SESSION['trans'] ."', '". $_SESSION['insur'] ."', '". $_SESSION['enter'] ."', "
."'". $_SESSION['child'] ."', '". $_SESSION['car'] ."', '". $_SESSION['charity'] ."')") or die("Budget error: ". mysql_error());
//Tax section
if($_SESSION['cur_agi'])
mysql_query("INSERT INTO taxes (user_id, cur, ly, py) "
."VALUES('". $user_id ."', '". $_SESSION['cur_agi'] ."', '". $_SESSION['lst_agi'] ."', '". $_SESSION['pre_agi'] ."')")
or die("Tax error: ". mysql_error());
$msg = "Name: ". $_SESSION['fname'] ." ". $_SESSION['lname'];
$msg .= " (Click to view detailed record.)";
$msg .= "
Contact: ". $_SESSION['email'] ."";
$msg .= "
Phone: ". $_SESSION['p_ac'] . $_SESSION['p_prefix'] . $_SESSION['p_ext'];
$msg .= "
Reason for considering bankruptcy:
". $_SESSION['reason'];
send_message("dhillier@gumandhillier.com","[Gum and Hillier] New Contact Information",$msg); //dhillier@gumandhillier.com
?>
Thank you for filling out out contact form. Someone will look over your information and be in contact shortly.
break;
case "personal":
?>