pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: V S P <toreason@fastmail.fm>
To: pgsql-php@postgresql.org
Subject: [Q] PDO use to bind arrays for insert
Date: Sat, 15 Nov 2008 21:45:30 -0500
Message-ID: <1226803530.24888.1284994985@webmail.messagingengine.com> (raw)

Hi,
I appologize in advance, if this is not the right place
to ask (but I would appreciate then a pointer where I could ask)

I am using PHP 5.2.6 and Postgres 8.3 both on windows right now.

Wanted to know if there is a way to pass via PDO (because
that's how I connect now to Postgres)

an array of values to insert at once

for example:

I have a PHP class:

cwork
   $work_id;
   $work_desc;


I have, say, an array of 50 objects of type cwork

arr_work

I would like to insert all items in the array at once
so that I would do one trip to the database.

instead of performing insert SQL in a loop for each item.

In oracle such functionality is called array inserts or bulk
insert (sometimes).  And in C++/OCI the interface is to basically
specifying a character array of values (with byte offsets)
for eacho of the fields.

So there would be an array of work_id, and array of work_desc
and both of those of the same length would have been specified
and bound to the bind variables

Thanks in advance,
VSP



-- 
  V S P
  toreason@fastmail.fm

-- 
http://www.fastmail.fm - Or how I learned to stop worrying and
                          love email again




view thread (7+ messages)  latest in thread

Message-ID: <1226803530.24888.1284994985@webmail.messagingengine.com>
Permalink:  ../1226803530.24888.1284994985@webmail.messagingengine.com/
Also on:    postgresql.org/message-id/1226803530.24888.1284994985@webmail.messagingengine.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: toreason@fastmail.fm
  Subject: Re: [Q] PDO use to bind arrays for insert
  In-Reply-To: <1226803530.24888.1284994985@webmail.messagingengine.com>
  References: <1226803530.24888.1284994985@webmail.messagingengine.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox