Simple question on arrays and sql
- From: sheldonlg <sheldonlg>
- Date: Mon, 31 Mar 2008 11:22:43 -0400
Given that I have a 2D array in php, is there a sql syntax to insert the entire array at once?
For example if I retrieve a set of data from one table in the database with keys A, B and C, and suppose there are 100 records, and I build an array $arr consisting of
$arr[$i]['A'], $arr[$i]['B'], and $arr[$i]['C']
where $i goes from 0 to 99,
is there a syntax to insert the entire $arr array at one time into fields A, B, and C of a new table?
I really would like to avoid having 100 sql insert calls.
BTW, this is for an Oracle DB.
In the past I have only had to insert a few records at a time, so i simply did multiple inserts. Of course for Oracle I could do the same and only do a commit after all are done.
.
- Follow-Ups:
- Re: Simple question on arrays and sql
- From: Captain Paralytic
- Re: Simple question on arrays and sql
- Prev by Date: Re: using meta http-equiv in php
- Next by Date: Re: Simple question on arrays and sql
- Previous by thread: Is Apache Needed w/IIS (Windows 2003) for PHP Install
- Next by thread: Re: Simple question on arrays and sql
- Index(es):
Relevant Pages
|
