如何通过输入类型在一列中选择一个相同名称的值，然后提交按钮 - How to Select one of the same name values in one column via input type and then submit button?

How to Select one of the same name values in one column via input type and then submit button?

我想做的是将一个名称放入一个输入类型框中，然后按submit，提交后Id只显示数据库中所有相同的名称行，而不是所有名称？当我在PHP中尝试或||但只得到所有结果时，有人能帮我吗？

<form method="post" action="">
<label for="name">Name:</label>
<input type="text" name="name" id="name" />
<button onclick="refreshMap()">Refresh</button>
</form>
function refreshMap() {
var name = $('#name').val();
}
<script>      
$(function() {
$('#name').val(name);
});
</script>

PHP:

$query = "SELECT * FROM register WHERE name IN ('John' || 'Gina')";
$result = mysql_query($query);
    if($result === FALSE) { 
        die(mysql_error()); 
    }
if(!empty($_POST['name']))
{
while($row = mysql_fetch_array($result)){
echo $row['name'];
}
}

编辑：

$name = htmlspecialchars($_POST['name']);
if(!empty($name))
{
    $query = "SELECT * FROM register WHERE name LIKE '" .$name ."'";
    $result = mysql_query($query);
    if($result === FALSE) {
        die(mysql_error());
        exit(0);
    }
    while($row = mysql_fetch_array($result)){
        echo $row['name'];
    }
}