{source}

<?php

        require_once "DB.php";

        $db = DBopen();

        $GLOBALS['ErrorMsg']="";

        $firstname = $db->real_escape_string($_POST['firstname']);

        $lastname = $db->real_escape_string($_POST['lastname']);

        $email = $db->real_escape_string($_POST['email']);

        $zipcode = $db->real_escape_string($_POST['zipcode']);

        $country = $db->real_escape_string($_POST['country']);

        $reason = $db->real_escape_string($_POST['reason']);

        $service = $db->real_escape_string($_POST['service']);

        $query="SELECT * FROM signatures WHERE email = '".$email."'";

        $result = $db->query($query);

        if($result)

        {

                if($result->num_rows > 0)

                {

                        $GLOBALS['ErrorMsg'] = '<font color= "red">Email already in database.</font>';

                        $db->close();

                        include "index.php";

                }

        }

        $query = "INSERT INTO signatures (first_name,last_name,zipcode,country,email,reason,service) VALUES('$firstname','$lastname','$zipcode','$country','$email','$reason','$servi

ce');";

        $result = $db->query($query);

        if($result)

        {

                $GLOBALS['ErrorMsg'] = '<font color= "green">Petition signed sucessfully.</font>';

        }

        else

        {

                $GLOBALS['ErrorMsg'] = '<font color= "red">Unspecified error.</font>';

        }

        $db->close();

        include "index.php";

?>

{/source}