php - 数据库插入用户 : Put plus (+) symbol instead of space. MySQL/PHP

Question

有没有办法找到放置加号而不是空格的方法。

例如:

if (isset($_POST['user'])&&isset($_POST['server'])) {
//Prevent SQL injections
$user = mysql_real_escape_string($_POST['user']);
    $server = mysql_real_escape_string($_POST['server']);

//Check to see if email exists
$sql = mysql_query("SELECT user, server FROM users WHERE user = '|$user' AND server = '$server'");

if (mysql_num_rows($sql)>0) {

    die ("Name already in use with this server combination.");

}else {

    //query the data
    $query = "INSERT users SET user = '|$user', server = '$server'";
    mysql_query($query);
    echo '<META HTTP-EQUIV="Refresh" Content="0; URL=data-insert.php?success=1&server='.$server.'&user='.$user.'">';

 }
}

如果 $user 输入了一个，我希望他们有一个 + 符号而不是空格。可能还是不可能？

感谢您的帮助。

Answer 1

您可以在 INSERT 时进行简单的字符串替换:

$query = "INSERT users SET user = REPLACE('|$user', ' ', '+'), server = '$server'";