Using an array to insert data into a table.

[Dynamo]

Hello again

Need some help inserting data into a table using an array.

This works:
$col1 = 2;
$col2 = 2;
$col3 = 2;
$col4 = 2;
$query = "INSERT INTO test (a,b,c,d) VALUES ($col1,$col2,$col3,$col4)";

and this does not

$col = array(2,2,2,2);

$query = "INSERT INTO test (a,b,c,d) VALUES ($col)";

Regards
Dynamo

[Michael Fesser]

.oO(Dynamo)

Need some help inserting data into a table using an array.

This works: [...]

and this does not

$col = array(2,2,2,2);

$query = "INSERT INTO test (a,b,c,d) VALUES ($col)";

Have a look at implode().

$query = sprintf('INSERT INTO test (a, b, c, d) VALUES (%s)',
implode(',', $col));

Micha

[Michael Fesser]

.oO(Michael Fesser)

Have a look at implode().

$query = sprintf('INSERT INTO test (a, b, c, d) VALUES (%s)',
implode(',', $col));

.... assuming that all the values are numeric, so they don't have to be
quoted.

Micha

[Gary L. Burnore]

On Mon, 22 Nov 2004 20:43:07 +0100, Michael Fesser <ne*****@gmx.net>
wrote:

.oO(Michael Fesser)

Have a look at implode().

$query = sprintf('INSERT INTO test (a, b, c, d) VALUES (%s)',
implode(',', $col));

... assuming that all the values are numeric, so they don't have to be
quoted.

If $col = "2, 3, 1, 4",

then %s would be:

2 3 1 4

no?
--
gburnore@databasix dot com
---------------------------------------------------------------------------
How you look depends on where you go.
---------------------------------------------------------------------------
Gary L. Burnore | ÝÛ³ºÝ³Þ³ºÝ³³Ýۺݳ޳ºÝ³Ý³Þ³ºÝ³ÝÝÛ³
| ÝÛ³ºÝ³Þ³ºÝ³³Ýۺݳ޳ºÝ³Ý³Þ³ºÝ³ÝÝÛ³
DataBasix | ÝÛ³ºÝ³Þ³ºÝ³³Ýۺݳ޳ºÝ³Ý³Þ³ºÝ³ÝÝÛ³
| ÝÛ³ 3 4 1 4 2 ݳ޳ 6 9 0 6 9 ÝÛ³
Black Helicopter Repair Svcs Division | Official Proof of Purchase
================================================== =========================
Want one? GET one! http://signup.databasix.com
================================================== =========================

[Michael Fesser]

.oO(Gary L. Burnore)

If $col = "2, 3, 1, 4",

then %s would be:

2 3 1 4

no?

No, why should it?

The OP wants $col to be an array:

$col = array(2, 2, 2, 2);

The result of implode(',', $col) will be the string '2,2,2,2'.

Whether you write

$query = 'INSERT INTO test (a, b, c, d) VALUES ('.implode(',',
$col).')';

or

$query = sprintf('INSERT INTO test (a, b, c, d) VALUES (%s)',
implode(',', $col));

makes no difference, the result will be the same.

Micha

[Dynamo]

"Michael Fesser" <ne*****@gmx.net> wrote in message
news:n8********************************@4ax.com...

.oO(Michael Fesser)
... assuming that all the values are numeric, so they don't have to be
quoted.

And what if the values are text?

Regards
Dynamo

[Michael Fesser]

.oO(Dynamo)

"Michael Fesser" <ne*****@gmx.net> wrote

... assuming that all the values are numeric, so they don't have to be
quoted.

And what if the values are text?

Strings have to be single-quoted inside a query, so the simple implode()
won't work.

Micha