SQL Server发送状态到电子邮件

大家好。我需要你的专业知识。

我有一个html表单里面有一个下拉选项用来选择状态

<select name="State">
    <option value="0" selected="selected">Select a State</option>
    <option value="AL">Alabama</option>
    <option value="AK">Alaska</option>
    <option value="AZ">Arizona</option>
    <option value="AR">Arkansas</option>
       etc.....
</select>

每当客户选择一个状态并提交表单时，它就会进入我的SQL Server数据库，并在html表单中提取与他们选择的状态相关的ip地址。

+-----------+-------+---------------+
| stateip_id| state |   user_ip     |
+-----------+-------+---------------+
|      1    | AL    | 67.100.244.74 |
|      2    | AK    | 68.20.131.135 |
|      3    | AZ    | 64.134.225.33 |
+-----------+-------+---------------+

例如，假设他们选择阿拉巴马州(AL)，当他们提交表单时，我希望代码连接到php文件，然后显示与州相关的ip地址，在本例中为(AL)。我有一些php代码，感谢这个论坛和另一个

<?php
// visit http://php.net/pdo for more details
// start error handling
try 
{
$Server = "00.00.000.000,0000";
$User = "username";
$Pass = "password";
$DB = "dbname";
//connection to the database
$dbhandle = mssql_connect($Server, $User, $Pass)
  or die("Couldn't connect to SQL Server on $Server"); 
//select a database to work with
$selected = mssql_select_db($DB, $dbhandle)
  or die("Couldn't open database $DB"); 
$state = $_POST['State'];
$query = "SELECT TOP 1 user_ip
              FROM state_ip
              WHERE state='$state'
              ORDER BY newid()";
//execute the SQL query and return records
$result = mssql_query($query);
$numRows = mssql_num_rows($result); 
echo "<h1>" . $numRows . " Row" . ($numRows == 1 ? "" : "s") . " Returned </h1>"; 
//display the results 
while($row = mssql_fetch_array($result));
}
catch (Exception $e)
{
  echo "sorry, there was an error.";
  mail("email@gmail.com", "database error", $e->getMessage(), "From: email@gmail.com");
}
if(isset($_POST['email'])) {
    // EDIT THE 2 LINES BELOW AS REQUIRED
    $email_to = "email@gmail.com";
    $email_subject = "This is a test";

    function died($error) {
        // your error code can go here
        echo "We are very sorry, but there were error(s) found with the form you submitted. ";
        echo "These errors appear below.<br /><br />";
        echo $error."<br /><br />";
        echo "Please go back and fix these errors.<br /><br />";
        die();
    }
    // validation expected data exists
    if(!isset($_POST['first_name']) ||
        !isset($_POST['last_name']) ||
        !isset($_POST['email']) ||
        !isset($_POST['what']) ||
        !isset($_POST['State']) ||
        !isset($_POST['comments'])) {
        died('We are sorry, but there appears to be a problem with the form you submitted.');       
    }
    $what = $_POST['what']; // required
    $first_name = $_POST['first_name']; // required
    $last_name = $_POST['last_name']; // required
    $email_from = $_POST['email']; // required
    $state = $_POST['State']; // not required
    $comments = $_POST['comments']; // required
    $error_message = "";
    $email_exp = '/^[A-Za-z0-9._%-]+@[A-Za-z0-9.-]+'.[A-Za-z]{2,4}$/';
  if(!preg_match($email_exp,$email_from)) {
    $error_message .= 'The Email Address you entered does not appear to be valid.<br />';
  }
    $string_exp = "/^[A-Za-z .'-]+$/";
  if(!preg_match($string_exp,$first_name)) {
    $error_message .= 'The First Name you entered does not appear to be valid.<br />';
  }
  if(!preg_match($string_exp,$last_name)) {
    $error_message .= 'The Last Name you entered does not appear to be valid.<br />';
  }
  if(strlen($comments) < 2) {
    $error_message .= 'The Comments you entered do not appear to be valid.<br />';
  }
  if(strlen($error_message) > 0) {
    died($error_message);
  }
    $email_message = "Form details below.'n'n";
    function clean_string($string) {
      $bad = array("content-type","bcc:","to:","cc:","href");
      return str_replace($bad,"",$string);
    }
    $email_message .= "First Name: ".clean_string($first_name)."'n";
    $email_message .= "Last Name: ".clean_string($last_name)."'n";
    $email_message .= "What: ".clean_string($what)."'n";
    $email_message .= "Email: ".clean_string($email_from)."'n";
    $email_message .= "State: ".clean_string($state)."'n";
    $email_message .= "Comments: ".clean_string($comments)."'n";
// create email headers
$headers = 'From: '.$email_from."'r'n".
'Reply-To: '.$email_from."'r'n" .
'X-Mailer: PHP/' . phpversion();
if (!mail($email_to, $email_subject, $email_message, $headers))
{
    echo "failed to send message";
}  
?>

<!-- include your own success html here -->
Thank you for contacting us. We will be in touch with you very soon.
<?php
}
?>

上面的代码工作得很好，我随机收集状态并将其与其他表单信息一起发送给我。我遇到的问题是，在电子邮件中，它向我发送信件，例如，它向我发送"AL或AZ或CA等"，而不是向我发送ip地址。我想这和这行

$email_message .= "State: ".clean_string($state)."'n";

主要是$state部分。我希望它选择user_ip部分，但无法找到如何做到这一点。我已经试过了，但它不工作

$email_message .= "State: ".clean_string('user_ip')."'n";

这是它在电子邮件中的显示方式

First Name: afdf
Last Name: sfgsdf
What: hellow
Email: sd@fd.com
State: AL
Comments: ali alabama2

我想让它是这个

First Name: afdf
Last Name: sfgsdf
What: hellow
Email: sd@fd.com
State: 123.456.1.21
Comments: ali alabama2