提供带有数组的准备好的语句 [英] Supply a prepared statement with an array

问题描述

我可以在Postgres中使用准备好的语句来添加多个值吗？当我看到使用 array（$ val）将事情添加到准备好的语句中时，我突然想到应该可以提供一个值数组放在我的桌子上。这是完全不正确的吗？尝试时，我在数据库表中仅看到 Array 。我不知道它是否是一个实际的数组，但我想只是这个词，因为该列是一个简单的 character变量。

Can I use a prepared statement in Postgres to add multiple values? When I saw that things are added to the prepared statement with array($val), it sort of occurred to me that I should be able to supply an array of values to be put in my table. Is this wildly incorrect? When I tried, I saw in my db table only Array. I don't know if it is an actual array, but I'm guessing, just the word, as the column is a simple character variable.

$tag    =  array('item1', 'item2', 'item3');

// Prepare a query for execution
$result = pg_prepare($dbconn, "my_query", "INSERT INTO $table ($column) VALUES ($1)");

// Execute the prepared query.  Note that it is not necessary to escape
// the string "Joe's Widgets" in any way
$result = pg_execute($dbconn, "my_query", array("$tag"));

否则，为什么一个值作为数组提供？

Otherwise, why is the one value supplied as an array?

推荐答案

不是，您插入了文本Array ...如果$ column的类型是文本，则您的代码应读取

No it's not, You inserted the text Array... if the type of $column is text your code should read

$tag    =  array('item1', 'item2', 'item3');

// Prepare a query for execution
$result = pg_prepare($dbconn, "my_query", "INSERT INTO $table ($column) VALUES ($1)");

// Execute the prepared query.  Note that it is not necessary to escape
// the string "Joe's Widgets" in any way
foreach( $tag as $i )
    $result = pg_execute($dbconn, "my_query", array($i));
/// alternatively you could try this if you really wanna insert a text as array of text without using text[] type - uncomment line below and comment the 2 above
// $result = pg_execute($dbconn, "my_query", array(json_encode($tag)));

或者如果您将$ column定义为text []，在postgresql中作为数组是合法的，则代码应读取

or if you defined $column as text[] which is legal in postgresql as array the code should read

$tag    =  array('item1', 'item2', 'item3');

// Prepare a query for execution
$result = pg_prepare($dbconn, "my_query", "INSERT INTO $table ($column) VALUES ($1)");

// Execute the prepared query.  Note that it is not necessary to escape
// the string "Joe's Widgets" in any way
$tmp = json_encode($tag);
$tmp[0] = '{';
$tmp[strlen($tmp) - 1] = '}';
$result = pg_execute($dbconn, "my_query", array($tmp));

这篇关于提供带有数组的准备好的语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！