mysql存储php数组_在MySQL数据库中存储PHP数组的内容

最新推荐文章于 2021-04-13 03:05:25 发布

Arsd

最新推荐文章于 2021-04-13 03:05:25 发布

阅读量115

点赞数

文章标签： mysql存储php数组

本文链接：https://blog.csdn.net/weixin_36202273/article/details/113213122

版权

I am having trouble storing array contents in mysql

I am using the code below

foreach($found_entry as $key => $sd) {

echo "$key => $sd
";

$insert_found_row = mysql_query("INSERT INTO myTable values ID = \"$sd[0]\" ,Folder = \"NULL\", Tsi = \"$sd[11]\", PT= \"NA\" ") or die(mysql_error());

echo "$sd";

If I echo the values I get

0 => ST10928

1 =>

2 => 2010-02-19 03:37:16

3 => \\fs1\

4 =>

5 =>

6 =>

7 =>

8 => M1

9 =>

10 =>

11 => LOG1.TXT

解决方案

Your query syntax is wrong. Use SET instead of VALUES. Also, you probably don't need the foreach loop at all, as you are referencing both $sd[0] and $sd[11]. Try something like this:

$query = sprintf("INSERT INTO

myTable

SET

ID = '%s',

folder = NULL,

Tsi = '%s',

PT = 'NA'",

mysql_real_escape_string($found_entry[0]),

mysql_real_escape_string($found_entry[11])

);

mysql_query($query) or die(mysql_error());