capturedata.php

<?php error_reporting(E_ALL);
ini_set('display_errors', '1');
include('functions.php');    
include("connect.php");
/* This logic moved to update-profile.php and dashboard.php
$paid = 0;
$seeks = 0;
if (isset($_REQUEST['seeksmale']) && $_REQUEST['seeksmale'] == 'on')
    $seeks |= 1;
if (isset($_REQUEST['seeksfemale']) && $_REQUEST['seeksfemale'] == 'on')
    $seeks |= 2;

if ($_REQUEST['gender'] == 'm')
    $gender = 1;
else
    $gender = 2;
$nameFrags = explode(" ",$_REQUEST['name']);
$firstname = $nameFrags[0];
$lastname = $nameFrags[1];
$db = db_connect();
$stmt = $db->stmt_init();
if ($stmt->prepare("DELETE FROM `queue` WHERE `token`=?"))
{
    $stmt->bind_param('s',$_REQUEST['token']);
    $stmt->execute();
}
$id = 'flag';
if ($stmt->prepare("SELECT `id` FROM `profile` WHERE `email`=?"))
{
    $stmt->bind_param('s',$_REQUEST['email']);
    $stmt->execute();
    $stmt->store_result();
    $stmt->bind_result($id);
    if ($stmt->num_rows > 0)
    {
	$stmt->fetch();
    }
    $stmt->free_result();
}
if ($id == 'flag') // New user profile
{
    if ($stmt->prepare("INSERT INTO `profile` (`firstname`,`lastname`,`box`,`phone`,`email`,`gender`,`seeks`,`paid`,`bio`,`validated`) VALUES(?,?,?,?,?,?,?,?,?,'true')"))
    {
	$stmt->bind_param('ssissiiis',$firstname,$lastname,$_REQUEST['box'],$_REQUEST['phone'],$_REQUEST['email'],$gender,$seeks,$paid,$_REQUEST['bio']);
	$stmt->execute();
	if ($stmt->insert_id < 0){
	    $stmt->close();
	    $db->close();
	    die("Something went wrong");
	}
	$id = $stmt->insert_id;
    }
}else
{
    if ($stmt->prepare("UPDATE `profile` SET `firstname`=?,`lastname`=?,`box`=?,`phone`=?,`gender`=?,`seeks`=?,`paid`=?,`bio`=? WHERE `id`=?"))
    {
	$stmt->bind_param('ssisiiisi',$firstname,$lastname,$_REQUEST['box'],$_REQUEST['phone'],$gender,$seeks,$paid,$_REQUEST['bio'],$id);
	$stmt->execute();

    }


}
*/

if (!isset($_SESSION))
    session_start();
    
$id = $_SESSION['id'];

// First delete previous answers if any
$q = "DELETE FROM `response` WHERE `profile_id`= " . $_SESSION['id'];
$result = mysql_query($q);
if(!$result)
    die(mysql_error());
// insert question answers

foreach($_REQUEST as $key => $value)
{
	$pos = strpos($key,'question_');
	
	if($pos === false) 
	    continue;
	else 
	{
	    $questionFrag = explode('_',$key);
	    $question = intval($questionFrag[1]);
	    $answer = intval($value);
	    $q = "INSERT INTO `response` (`profile_id`,`question_id`,`answer`) VALUES ($id,$question,$answer)";
	    $result= mysql_query($q);
	    if(!$result)
            die(mysql_error());
	}
}
if(isset($_REQUEST['instant']))
{
	include("update-profile.php");
	header("location: saved.php");
}
else
{
	header("location: dashboard.php");
}
	
/*
if ($stmt->prepare("INSERT INTO `response` (`profile_id`,`question_id`,`answer`) VALUES (?,?,?)"))
{
    $stmt->bind_param('iii',$id,$question,$answer);
    foreach($_REQUEST as $key => $value)
    {
	$pos = strpos($key,'question_');
	
	if($pos === false) {
	    continue;
	}
	else {
	    $questionFrag = explode('_',$key);
	    $question = intval($questionFrag[1]);
	    $answer = intval($value);
	    $stmt->execute();
	}
    }
    $stmt->close();
    $db->close();
    header("Location: saved.php");

}
$db->close(); // Just in case */
?>