我已经看到许多关于这个问题的堆栈溢出线程，但我无法实现这一点，所以再次发表了这篇文章。我正在使用我想使用PHP在SQL中插入标签的地方。赞 [select2 jQuery pluginData, Data, Data]我尝试做我通过谷歌学到的东西，好吧，我在这方面是专业化的，我是PHP的新手。请帮助'我如何在数据库中插入这个，其中显示两个单词之间，如上所述，我在,Like'我的代码是if(isset($_POST['submit'])) { $name = "Your_Name"; $email = "Your_Email"; $stmt = $con->prepare("INSERT INTO `test` (`name`, `email`, `color_name`) VALUES (':name',':email',':color')"); foreach ($data as $row) { ':name' = $name; ':email' = $email; ':color' = 'MYStatus'; //I want mention here Select2 Tags Data and insert in DB where [, (space)] every two words. like [Green, Red, Blue, Pink] $stmt->execute(); } }<!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({ tags:["Red", "Green", "Blue", "Pink"], tokenSeparators: [",", " "]} ); }</script></body></html>
1 回答
holdtom
TA贡献1805条经验 获得超10个赞
您的表单可能按如下方式发送：
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
编辑：
由于您实际上是按行存储的，因此可以使用 ：select
function 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 array
print_r($tags);
编辑 #2
要在同一页面上同时执行此操作，您只需使用：json_encode()
<?php
function 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 key
function 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 insert
if(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>
- 1 回答
- 0 关注
- 120 浏览
添加回答
举报
0/150
提交
取消