将变量结果用单引号括起来

Question

你好，我有以下php代码：

$singlequote = "SELECT `Email` FROM `exped_contacts_req`"; // define your SQL
$stmt = ExecuteQuery($singlequote); // execute the query
$emailtodoc = ""; // initial value
if ($stmt->rowCount() > 0) { // check condition: if record count is greater than 0
    while ($row = $stmt->fetch()) { // begin of loop
        $emailtodoc .= $row["Email"] . ", "; // in case the result returns more than one row, separated by comma
    } // end of loop
    $emailtodoc = rtrim($emailtodoc, ", "); // don't forget to remove the last comma after loop finished
} //end of check condition`

现在，我的变量结果返回为：

[e-mail]，[e-mail]

但我需要这份申报表：

'[e-mail]'，'[e-mail]'。

所以每封邮件都附在一个报价单上，问题是我找不到如何在我的代码中实现这一点，

任何想法，提前感谢

Answer 1

您的单双引号和单引号需要替换为双双引号和双单引号。所以“需要变成”和“需要变成”围绕着你要包装的内容。或者，你应该转义这些字符。

示例“转义文本看起来像这样”“转义文本””

Answer 2

方式一：

$singlequote = "SELECT `Email` FROM `exped_contacts_req`"; // define your SQL
$stmt = ExecuteQuery($singlequote); // execute the query
$emailtodoc = []; // initial value
if ($stmt->rowCount() > 0) { // check condition: if record count is greater than 0
while ($row = $stmt->fetch()) { // begin of loop
    $emailtodoc[] = $row["Email"]; // in case the result returns more than one row, separated by comma
} // end of loop
$emailtodoc_str = implode("','",$emailtodoc); // don't forget to remove the last comma after loop finished
} //end of check condition`

方式二：

$singlequote = "SELECT `Email` FROM `exped_contacts_req`"; // define your SQL
$stmt = ExecuteQuery($singlequote); // execute the query
$emailtodoc = ""; // initial value
if ($stmt->rowCount() > 0) { // check condition: if record count is greater than 0
while ($row = $stmt->fetch()) { // begin of loop
    $emailtodoc .= "'".$row["Email"] . "', "; // in case the result returns more than one row, separated by comma
} // end of loop
$emailtodoc = rtrim($emailtodoc, ", "); // don't forget to remove the last comma after loop finished
} //end of check condition`