{\rtf1\ansi\ansicpg1252\cocoartf2706
\cocoatextscaling0\cocoaplatform0{\fonttbl\f0\fswiss\fcharset0 Helvetica;}
{\colortbl;\red255\green255\blue255;}
{\*\expandedcolortbl;;}
\margl1440\margr1440\vieww11520\viewh8400\viewkind0
\pard\tx720\tx1440\tx2160\tx2880\tx3600\tx4320\tx5040\tx5760\tx6480\tx7200\tx7920\tx8640\pardirnatural\partightenfactor0

\f0\fs24 \cf0 <?php\
// process-form.php\
\
// Conectar ao banco de dados\
$mysqli = new mysqli('localhost', 'username', 'password', 'database');\
\
// Verificar a conex\'e3o\
if ($mysqli->connect_error) \{\
    die('Conex\'e3o falhou: ' . $mysqli->connect_error);\
\}\
\
// Obter dados do formul\'e1rio\
$name = $_POST['name'];\
$phone = $_POST['phone'];\
$email = $_POST['email'];\
$purchase_date = $_POST['purchase_date'];\
$receipt_value = $_POST['receipt_value'];\
$user_ip = $_SERVER['REMOTE_ADDR'];\
$submission_hour = date('Y-m-d H:00:00');\
$is_first_submission = false;\
\
// Fazer upload do arquivo\
if (isset($_FILES['receipt']) && $_FILES['receipt']['error'] == UPLOAD_ERR_OK) \{\
    $receipt = file_get_contents($_FILES['receipt']['tmp_name']);\
\} else \{\
    die('Erro ao fazer upload do tal\'e3o de compra.');\
\}\
\
// Verificar se j\'e1 h\'e1 uma submiss\'e3o para a hora atual\
$stmt = $mysqli->prepare("SELECT id FROM submissions WHERE submission_hour = ? LIMIT 1");\
$stmt->bind_param('s', $submission_hour);\
$stmt->execute();\
$result = $stmt->get_result();\
\
if ($result->num_rows == 0) \{\
    $is_first_submission = true;\
\}\
\
// Inserir submiss\'e3o na base de dados\
$stmt = $mysqli->prepare("INSERT INTO submissions (name, phone, email, receipt, purchase_date, receipt_value, submission_hour, is_first, user_ip) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)");\
$stmt->bind_param('sssssssss', $name, $phone, $email, $receipt, $purchase_date, $receipt_value, $submission_hour, $is_first_submission, $user_ip);\
$stmt->execute();\
\
// Fechar conex\'e3o\
$stmt->close();\
$mysqli->close();\
\
// Exibir mensagem de agradecimento\
if ($is_first_submission) \{\
    echo 'Obrigado! Voc\'ea foi o primeiro a submeter nest\
}