在 PHP 中插入选择 2 标记 j查询数组

您的表单可能按如下方式发送：Array(    [selectname] => Array        (            [0] => brown,Green,Blue        ))因此，既然您希望将其格式化为，那么您可以和/或仅使用：brown, Green, Blueexplode()implode()str_replace()# Exploding, imploding$tags = implode(", ", explode(",", $_POST['selectname'][0]));# String replace would be$tags = str_replace(',', ', ', $_POST['selectname'][0]);如果您尝试拆分该字符串以单独插入每个标记，则应在逗号上使用，然后循环 .explode()explode()我可能会在那里使用删除空白空间，以防万一。另外，如果你想确保它们的格式都相同，你可能想确保每个单词都有一个大写字母作为第一个字母（你的默认值棕色全部变低，重置时第一个字母大写）。trim()ucwords()如果执行方法 1，则可以应用一个，如果在分解字符串上使用：ucfirst()trim()array_map()# A full combination of functions$tags = implode(", ", array_map(function($v){    return ucfirst(trim($v));}, explode(",", $_POST['selectname'][0])));会给你字符串：Brown, Green, Blue编辑：由于您实际上是按行存储的，因此可以使用：selectfunction getColorTags($name, $con){    # Query by name, just return the color_name field though    $query = $con->prepare("SELECT `color_name` FROM `test` WHERE `name` = ?");    # Execute the query with bind value    $query->execute([$name]);    # Loop the results    while($result = $query->fetch(\PDO::FETCH_ASSOC)) {        # Store the tags        $row[] = $result['color_name'];    }    # Return the tags or an empty array    return (isset($row))? $row : [];}使用方法：# Fetch the tags by name, make sure to inject the database connection$tags = getColorTags('Some Name', $con);# Print out the arrayprint_r($tags);编辑 #2要在同一页面上同时执行此操作，您只需使用：json_encode()<?phpfunction insertTags($data, $email, $name, $con){    $stmt = $con->prepare("INSERT INTO `test` (`name`, `email`, `color_name`) VALUES (?,?,?)");    foreach ($data as $string) {        # Explode and filter the tags from the js        $arr = array_filter(array_map('trim', explode(',', $string)));        # Loop the "selectname"        foreach($arr as $tag) {            # Execute all the rows            $stmt->execute([$name, $email, $tag]);        }    }}# This fetches using the email as the primary keyfunction getColorTags($email, $con){    # Query by name, just return the color_name field though    $query = $con->prepare("SELECT `color_name` FROM `test` WHERE `email` = ?");    # Execute the query with bind value    $query->execute([$name]);    # Loop the results    while($result = $query->fetch(\PDO::FETCH_ASSOC)) {        # Store the tags        $row[] = $result['color_name'];    }    # Return the tags or an empty array    return (isset($row))? $row : [];}# Pull these out so you can use them in general$name = "Your_Name"; // Assuming this is from the session$email = "Your_Email"; // Assuming this is from the session# Here is where you insertif(isset($_POST['submit'])) {    # This will insert your tags separately on new rows    insertTags($_POST['selectname'], $email, $name, $con);    # This will pull them back from the database (helpful if they already have some in there)    $tags = getColorTags($email, $con);}# Here you check if there are tags already generated after submission,# if not, then pull them.if(!isset($tags))    $tags = getColorTags($email, $con);?><!DOCTYPE html><html><head><link rel="stylesheet" type="text/css" href="http://shashani-humanth.github.io/Notebook-AdminPanel/js/select2/select2.css"></head><body><form class="bs-example form-horizontal" id="formid" method="POST" onSubmit="return validate();">    <div class="form-group col-sm-6">        <div>            <input type="hidden" name="selectname[]" id="select2-tags" style="width:260px" value="brown"/>        </div>    </div>    <div class="form-group">        <div class="col-lg-offset-2 col-lg-10">            <button type="submit" name="submit" class="btn btn-sm btn-default" id="submit">Save and Publish</button>        </div>    </div></form><script src="http://shashani-humanth.github.io/Notebook-AdminPanel/js/jquery.min.js"></script>  <script src="http://shashani-humanth.github.io/Notebook-AdminPanel/js/bootstrap.js"></script><script src="http://shashani-humanth.github.io/Notebook-AdminPanel/js/select2/select2.min.js"></script><script type="text/javascript" language="javascript">    if ($.fn.select2) {        $("#select2-option").select2();        $("#select2-tags").select2({            // Now use this native function to echo the array back to JS            tags: <?php echo json_encode($tags) ?>,            tokenSeparators: [",", " "]}        );    }</script></body></html>

在 PHP 中插入选择 2 标记 j查询数组

1回答