如何在PHP中检索全名（两个单词之间的空格）？

Question

Here i am trying to store data into database,It will work successful but when i am seen into database then for Assigned To it will only store first name for example, Value of assign_to=Trilok Dethariya, then in database it will only store Trilok for assign_to field,How can i store full name into it.

<label>Assigned To</label>
<?php 
    $sqll="SELECT Full_name FROM user_master where Role='Project Manager'";
    $rows = $conn->query($sqll);

    echo "<select class='form-control' name='assign_to'>";
    echo "<option value=''>Select One</option>";  

    while($row= $rows->fetch_assoc() ) 
    {
        echo "<option value=".$row['Full_name'].">".$row['Full_name']."</option>";     
    }
    echo "</select>"; 

?>

</div>
</div> 
</form>
<?php
    if ($_SERVER["REQUEST_METHOD"] == "POST")  
    {
        $assign_to = (filter_input(INPUT_POST, 'assign_to'));
    }                       

Answer 1

You must quote attribute values in html:

echo "<option value='".$row['Full_name']."'>".$row['Full_name']."</option>";     

With string interpolation this can be written cleaner as

echo "<option value='{$row['Full_name']}'>{$row['Full_name']}</option>";     

Better yet, normalize your data, and use IDs instead of names:

$sqll="SELECT ID, Full_name FROM user_master where Role='Project Manager'";

...

while($row= $rows->fetch_assoc() ) 
{
    echo "<option value='{$row['ID']}'>{$row['Full_name']}</option>";     
}