如何将数据数组插入数据库

发布于 2024-10-02 12:47:48 字数 480 浏览 5 评论 0原文

这是我的代码 -

$things = mysql_real_escape_string(implode(',', $_POST['things']),$link);

$q = "INSERT INTO tblslider(src) VALUES ('".$things."')";
print_r($q);
$result = $mysqli->query($q) or die(mysqli_error($mysqli));

但我的查询正在生成 INSERT INTO tblslider(src) VALUES ('4368122.jpg,5440051.jpg,1047428.jpg') 但应该是 INSERT INTO tblslider(src) VALUES ('4368122.jpg'),('5440051.jpg'),('1047428.jpg') 这就是为什么它将其视为一条记录而不是三条记录。

原文

here my code-

$things = mysql_real_escape_string(implode(',', $_POST['things']),$link);

$q = "INSERT INTO tblslider(src) VALUES ('".$things."')";
print_r($q);
$result = $mysqli->query($q) or die(mysqli_error($mysqli));

but my query is getting generated
INSERT INTO tblslider(src) VALUES ('4368122.jpg,5440051.jpg,1047428.jpg') but it should be
INSERT INTO tblslider(src) VALUES ('4368122.jpg'),('5440051.jpg'),('1047428.jpg') thats why it is taking it as one record not three.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

萌吟 2024-10-09 12:47:48

你可以这样做：

$things = array_map('mysql_real_escape_string', $_POST['things']);
$q = "INSERT INTO tblslider(src) VALUES ('". implode("'),('", $things)."')";

它生成（使用我的测试数据）：

INSERT INTO tblslider(src) VALUES ('a.jpg'),('b.jpg'),('c.jpg')

我忘记了：仅在真实数据上使用诸如mysql_real_escape_string之类的函数，而不是SQL字符串。在您的示例中，您将该函数应用于已连接的数据。

You could do:

$things = array_map('mysql_real_escape_string', $_POST['things']);
$q = "INSERT INTO tblslider(src) VALUES ('". implode("'),('", $things)."')";

It generates (with my test data):

INSERT INTO tblslider(src) VALUES ('a.jpg'),('b.jpg'),('c.jpg')

I forgot: Only use functions like mysql_real_escape_string on the real data, not the SQL string. In your example you apply the function on the already concatenated data.

回复收藏 0 原文

所有深爱都是秘密 2024-10-09 12:47:48

您已经内爆了现在是数组的东西，因此您需要使用 foreach 循环对其进行迭代，例如...

foreach ($things as $item) {

  $q = "INSERT INTO tblslider(src) VALUES ('".$item."')";
  echo '<br />'.$q;
  $result = $mysqli->query($q) or die(mysqli_error($mysqli));

}

您可以 echo $q 以确保您也获得了正确的每个项目的查询。

You have imploded things which is now an array, so you need to iterate over this with a foreach loop such as...

foreach ($things as $item) {

  $q = "INSERT INTO tblslider(src) VALUES ('".$item."')";
  echo '<br />'.$q;
  $result = $mysqli->query($q) or die(mysqli_error($mysqli));

}

You could echo $q to make sure you're getting the queries right for each item also.

回复收藏 0 原文

街角迷惘 2024-10-09 12:47:48

试试这个：

$formatVals = function($x){$rx = mysql_real_escape_string($x); return "('$rx')";};

$valString = implode(',', array_map($formatVals, $_POST['things']);

$sql = "INSERT INTO tblslider (src) VALUES $valString";

try this:

$formatVals = function($x){$rx = mysql_real_escape_string($x); return "('$rx')";};

$valString = implode(',', array_map($formatVals, $_POST['things']);

$sql = "INSERT INTO tblslider (src) VALUES $valString";

回复收藏 0 原文

~没有更多了~